I have the following:
ReDim Preserve jobCodes(0 To jbMax) As String
and when I compile I get the compile error: Array Already Dimensioned
The message is true: my array *was* previousl...
Hello, I have setup a form with a continuous subform. The subform has 3 combo boxes Company, Address and Contact... As for our jobs companies can have multiple addresses and contacts. When yo...
Hi Experts,
I am currently working on a form in access.
I would like to have a combo box has row source based on the value of a check box on the same box.
for example,
if the check ...
I have set my Access Options to: Disable macros but everytime I close the application it reverts to Disable Macros so none of my buttons on my Main Menu work. How can I set this to stay in E...
Hi,
I try to select the first item in a listboxcontrol.
The procedure used is the following:
listbox1.itemsselected(0)=true
When i run the code i receive an error on the procedure:
Co...
I am creating a database that will send out emails to individuals depending on the alert needed.
I have three tables, one that contains alerts and associated IDs, the second contains the ...
I created a switchboard form in Access 2007. I save a copy in the Access 2003 format also, I changed nothing except but to save. When I go access my switchboard in the 2003 version , It prompt...
I am trying to create a command that will allow me to close out of a form without saving the data. There are multi steps to get into the forms and at two points you should be able to exit with...
I need a column in Excel that shows every 2nd Monday of every month. Does anyone know of a quick way of doing this?
I've got a simple Access table for a list of movies and I'd like to store "genre" information about each movie. Let's say a movie can be any one or more of a total of 16 different genres, for...
Is there a way to change a form's view form single to continuous with VBA Code?
I have a button on a form that opens a report. The report is off of a query that has a date field. I want an input box to ask for the date range. If the user does not select anything I do not ...
I have a table in which I have added an image and I used the OLE object data type. I have a form in which a user can double click the image field and the jpg image will display( in whatever d...
Hi
I'm pulling my hair out on what I thought would be a simple problem:
- I have an Access DB with a form
- in the DB, I have a table with 2 fields: image name, image ( of type OLE object...
Hello: When I calculate an extended total from number of hours multiplied by rate, where rate is coming from a value list, the summation feature doesn't work. The options are either COUNT or ...
Hi there, I need to move from one field [QTY] in a continuous form to the Next Recordset [QTY] field.
eg. as if you were in a Microsoft Excel column and you used the down arrow key to move do...
I have a form which contains a multicolumn combobox (cboGotoContact) which is used to select a specific record in table. The code on the AfterUpdate event on combobox is shown below.
When ...
What I want is to have a combo box on a main form that filters the information on my subform. Currently, my subform's record source is a query with a code: [Forms]![FBranchOrders]
