Search results

Pretend your setup is like the following: tblJools-01 ID txtCode tblJools-02 ID txtCode Relationship made between the tables with ID field. the update query would show both tables and use only one column. Field: txtCode Table: tblJools-01 Update To: [tblJools-02]![txtCode]

What have you tried to use for criteria so far? How is your current Update Query designed?

Check out http://www.access-programmers.co.uk/forums/showthread.php?t=22586&highlight=reset+page+margin and see if that helps.

What have you tried so far? A cross table query didn't work?

I think I would fix this issue by setting a default value of 0 (zero) to fields. Then the fields should never be null. Those I do not know. Sorry.

Seems like the long way is always the first to come to my mind recently. Making coding tediously fun. :( :p

Oops! We must have been writing the message at the same time. :D

In the macro, add a row before you run any of the queries. Set the command to "SetWarnings" with value "No". At the end of the macro, add the command again "SetWarnings" with a value "Yes" to turn back to default.

Sorry. Access Help refers to all those expression functions as worksheet functions. Date() DatePart() DateDiff() etc. It's probably just so they don't have to write a new Help file for the same function when it doesn't change much per application. Perhaps an actual touch-n-feel example will...

To help explain what this thread was mainly trying to get, I've mocked up this tiny example. The database has a form (Form1). On Form1, there are multiple command buttons: testMe0, testMe1, & testMe2. The OnClick procedures for these buttons: Private Sub testMe0_Click() Call testMe End Sub...

Perhaps try putting it on the On Activate. Otherwise, with VBA you can create an On Current event.. but I've never seen it done to a report (probably because the report doesn't have an OnCurrent). The order in which events trigger for a report are: Open -> Load -> Resize -> Activate -> Current...

Hey steve! In the query, you can use the DatePart worksheet function to solve this problem. I recommend having three combo boxes. One corresponding to pilotName, reportMonth, & reportYear. I'd have the pilotName combo box pull the names from a table. I'd have the months & year combo boxes have...

Yikes. No descriptions anywhere. Hard for me to figure out how things are connected to each other. The Relationships look like a spiders web. :p I'd totally fine with helping. I just need help to figure out what's going on. (Random thought: What does ICL stand for?) Can you provide any details...

Meaning not found under "Microsoft Access Class Objects" but under "Modules", right? Uh oh. Tedious or troublesome changes (from a person new to VBA)?

So I just put the word "Optional" in front of the arguement? :o (Wish VBA was more "technical" sounding.) so.. Sub cmdAddDate_Click(Optional countLoop As Integer) If IsNull(countLoop) countLoop = 7 End If 'Blah blah 'blah blah End Sub That's all the change to do to the procedure?

If it was myself, I'd create a second query (perhaps with the Find Unmatched Query Wizard) that is based off the table or query of the data you are currently using for the form. Then I'd switch the comboboxes row source to this second query. And if you don't want to use a query directly for this...

This way might be the more tedious route but it's something you can work with until someone else replies. You should be able to do this in your query in the Criteria rows. Just add the search field a couple times with various criteria for each field. Example, OptionBtn1 = 1 AND OptionBtn2 = 1

Hey hey, Does the form have a table set for it's "Record Source"? You can do this via a macro, VBA code, or query. Just depends on on what you want to do. Take your pick. Have experience with any of the options? If you want to use a query, you'll have to change the way you are going about...

*Note: I will be omitting the body of the code since it works as directed. Just need help with the idea/change. Currently, a button on a form runs a specific procedure. I want to have the option of passing a value to the procedure (something I have not done in VBA yet). Notice I said "option"...

Hm. What version of Access? I've downloaded it and ran it... every button off the forms except the main switchboard result in an error for me.