Search results

I have a newb question. I've never set up my own database before, just used what was there, and just finished linking tables into the new database from a SQL Server. Question, is protection needed on these linked tables so that users can mess up the original data from the server, or is this...

I think I'm approaching this all wrong. I'm just going to create a new make table query using the Union Query as its source. Much simplier.

That just gives me a syntax error...

Good Afternoon, I have the below Union Query that I want to turn into a make table query. But I can't figure out where to put the INTO clause. No matter where I stick it, I get errors. SELECT acct_num, br_id, fa_id, acct_pgm, acct_pgm_assn_end_dt, client_tr_dt, trade_date, trans, symbol...

What error do you get?

Where is "base_date" pulling from?

A follow up question, if you don't mind. There can be upto 3 email addresses to send the report to: FA_email, FA_email2, FA_email3. Would I then put it as: stToName = DLookup("FA_email", "Master");DLookup("FA_email2", "Master");DLookup("FA_email3", "Master") ?

Worked like a charm with some tweaking for my specific purpose - thanks.

Yeah, I've gone through that web site and couldn't find anything addressing this issue. It seems like it involves a simply solution - but I can't find it. Currently, I tried: stToName = Master.FA_email Master = the table's name, and FA_email = the field. But it doesn't recognize the object.

Thanks. I also am having trouble with the email's to address. I want it to populate from a field called "FA_email" from my master table - but I can't get it to recognize it. Any suggestions?

Fantastic thread. I have a problem though - I used the coding provided above, and it attaches the report as an excel file. How can I make it go out as a word doc or pdf?

Thanks, that worked. Simple solution.

Thanks for the quick reponse. I've ended up using a list box that has a query as the row source to populate it. Now the problem I have is that when I go to create the next record, the data from the previous record still populate the box. How do I get the query in rowsource to re-run on each...

Thanks for your help. Basically, the output from these DLookup populate fields for a table. Sometimes an account has one owner, other times, it may have four. So instead of the user having to manually look up and input the owners, I want the dlookups to put their names in the field (for...

Hmmm...I believe I am over my head. As an alternative, I set up combo boxes for each name - so in theory, the user can use each combo box to pick the name. A query is executed for each box that populates the name choices. However, when the user moves to a new entry, the names from the old...

So if I did the wrapper, would it look like this: Full_Name3.Value = Nz(DLookup("[Full_Name]", "[AMS_Accounts]", "[acct_num]='" & Account1 & "'" & "And [Full_Name] <> '" & [Full_Name1] & "And [Full_Name] <> '" & [Full_Name2] & "'")) ?

Good Morning, I am receiving the same error, and added the brackets to it (like above), however I still receive the same error. It seems like it will give me the error when it can't populate a value. Could this be it, and how could I fix it so the error does not show? Here is my code...

So I have a form, where values are populated via a DLookup function when you enter an account number. The problem is that I want to add a combo box, where a value in one table (where I will be getting the info) has to match the value of a form field that is populated by the DLookup function...

I'll piggy back on this thread - I am experiencing the exact same problem, but can not figure it out... Pgrm_1.Value = DLookup("acct_pgm", "[AMS_Accounts]", "acct_num='" & Account1 & "'") Any thoughts?

So I came up with this: Account2.Value = DLookup("acct_num", "[AMS_Accounts]", "acc_lnk_id=" & Link_ID & " AND acct_num <>'" & Account1 & "'") Which appears to work. However, if there is no record that matches this, would I get an error? After this running successfully on a number of...