Search results

Nevermind...I figured it out. I used the DMax function instead. I had never heard of it, and still don't really understand the difference between Max() and DMax(), but this works. Hope it helps someone else. Me.Project_ = DMax("[Project#]", "[10-Project Table]") It was very simple once I...

Hey Gang, I'm trying to pull a project number sequentially without using an autonumber field type. I tried to pull a recordset using a SQL string pulling the max of my project# field. All I really need is to take the result of the recordset and set the field in my form equal to it. It...

Hey Everybody, Does anyone know what the correct VBA syntax is to start columns at a certain field number? I know when using Debug.Print its Tab(24) to start at line 24. But it gives me an error when exporting a recordset into an email. Here is a subset of my string: strLtrContent =...

Hey Everybody, I wanted to see if I could get an auto-email created using the results of a couple queries. On a weekly basis I would like to send an updated email (automatically) pulling 4 or 5 fields from 4 separate queries. I can do a Make-Table and 3 appends to get them all in 1 Table...