Search results

Dude, I totally used to look up to this site.

I know it's probably a difficult question, but ANY help always helps! :)

Hey guys, I just have a (probably) really simple question for you. I'm using a datasheet that can be filtered for certain fields. I have a macro that opens a form to the record that was selected (aka "current") in the datasheet. It filters this opened form to "1 of 1" which makes sense. How...

So the table that you are updating has the RowSource for the combobox, right?

Got it! Thank you yet again! :)

So, everything is resolved now! I feel more confident on how SQL works in VBA! Thank you SOOOOOO much!! This question is now RESOLVED! (I don't know how to mark that [if that's a thing])

I'm going to take an 8-hour nap, and I'll be back to debug/give thanks/show the issue is resolved in the morning! Thank you for all your help! So far, so good though!!

Now "Run-time error '3134': Syntax error in INSERT INTO statement." is being thrown for: PTECallerContactInfo = "INSERT INTO ExistingClientContactInformationTable([File Number],[Relationship To Client],[Last Name],[First Name],[Home Number],[Cell Number],[Email]" & _...

Ah, with the things that you added in red, it made it to where I don't have to have that condition right?

I got a "Run-time error '3021': Reserved Error" Is this because I don't currently have a record matching this ExistingClientMAX value?

Enter Parameter Value for ExistingClientAddressesTable!File Number.....what have I done this time? :confused: My RE-updated code for the lines throwing the parameter inquiry. PTEAddressInfo = "INSERT INTO ExistingClientAddressesTable([File...

So you're saying that: PTEAddressInfo = "INSERT INTO ExistingClientAddressesTable([Street],[City],[State/Province],[Country],[Zip Code])" & _ "SELECT Address, City, State, Country, ZIP " & _ "FROM [ProspectiveClientTable] " & _...

So, I tried it and it asked for ExistingClientAddressesTable.[File Number] parameter value. Does it matter if I use (.) or (!)?

OKAY! I got it to work up to it asking "You're about to append 1 row of data....blah blah blah" using my original code moved around. Do you think that my DMax would be appropriate for my setup?

Yeah, the existing client tables are all linked with [File Number] as the primary key. The DB is split and set up for multi-user but the chances that more than one user would be using this command are slim to none. So the .AddNew refers to controls on the loaded page right?

I may have not mentioned this before, but the Existing and prospective client tables are not linked in any way whatsoever. I still can't figure this out. It's driving me mad because I usually don't have this much trouble with any VBA code.

Also, the line on the Allen Browne code that says "!CustomerID = Me.CustomerID": Could I refer to my existing client table through that?

So, if I wanted all the "related" (linked) records moved, I'd have to create a separate button with the SQL/VBA behind each one?

This is the code that I have currently (attached). Sorry, the site would not let me use the ['CODE] portion of the (assuming BB-code) options. I think my syntax is off somewhere....

Thank you pbaldy for such a quick response. I believe that the Allen Browne link that you provided is for tables that have relationships to each other. My problem is occurring because I have two different, unrelated tables in which I am attempting to transfer data between. The tables not bearing...