Search results for query: *

Does VBA allow the following... IF x or y and z then Dog = true end IF x or y , either one can be true, and z must be true... I can't find the syntax in HELP. This is used in Excel, but I can't use cell formulas for this task. Thanks Robert

I have a form with several subforms. To jump between subforms, I have an event triggered from the last text box of the subform telling it to set focus on the next subform. It works for tabbing around the form. The next step I took was to enter test dat in a subform, when I did so, then tabbed...

I have a subform and a main form. The sub is a datasheet view of the main. I have coded so that when I click the record selector(not the navigation button) in the subform, the main form sets itself to the same record number. There are 842 records. When I click the subform it works fine, until...

I have a main form - I want to put a button on the main to jump ahead 10 records in a subform which is in datasheet view, the main form is called "trans_table" the sub is "main3" I'm trying this code I got from the Access HELP files. DoCmd.GoToRecord acForm...

I have a text box in a form, whose contents are calculated in a VBA module. The same form has a button to print a report. I want the button to fire some code that feeds a text box in the report with a value in a text box in the form. How to refer to the textboxes in the code ? Thanks a million!

I used GetRows to fill an array with the contents of a table, now, using vba, I'm doing some math, and want to put the results into the last column of the table, I know how to do it in an array, or in Excel VBA, but how in an Access table? What is the name of the intersection of a row and a...

I have a form with 2 subforms. each subform has a table. In relationships, as far as I can tell, the relationships of the 2 "sub" tables to the main are the same. when I open the form, subform 1's behavior is: it shows the PO number which is shown on the main form, and if there are...

Ok, I've got the code below working, but I need to add some data from other tables. The select statement can have multiple from clauses? I can't find it in ACCESS help, and the book I ordered from Amazon is in the mail ! Private Sub Command13_Click() Dim dbs As DAO.Database Dim qdf As...

the following code works, no errors, but the query it creates doesn't open, instead, when opened it puts up a dialog box asking for a value. I am trying to tell it, in line 8, that the criteria value is the contents of a text box in the subform which contains the button that fires the code. I...

I would like to have a button toggle on/off the visibility of a subform in a form - in Access. in Excel VBA I would say "object.visible = true" , but that doesn't seem to work here.