Recent content by mboyde

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?