Recent content by BLUDEV

I tried updating my VBA code as follows and still no luck: Function UpdateIssuesDatabase() Dim dbs As Database Dim qdf As QueryDef ' Path to database to update Set dbs = OpenDatabase("\\MACSERV8\Company\Customer Service\Issues FE File\090314\Issues.accdb") '...

Thanks MarkK; I haven't changed the original query nor changed to destination table. I reviewed some other sites and decided to just do a temp table to contain the data that will be used to update the table in the other database. It's a work-a-round for now until I can figure out why it can't...

I became so frustrated that instead of doing an "append" VBA code, I went ahead and did an append query which works just had to make a unique value table to only have the 1 record with the three items which needed to be added to the other databases table. Thanks everyone.

Hi MarkK, this is different; for the IN clause in the other, I'm coming into a glitch still but will update my other post with that. For this, it was working and just stopped. I went into the query design to do a basic update so can you advise a solution to avoid the sometimes working...

@ jdraw, still working on it but almost there. Will post the completed code I've finished testing. Thank you again.

"Thank you for the tools mention, I will download these"

Trying to perform a basic update query; tables reside in two different databases. Has been working for weeks and today, it doesn't work. As of today, I get a "Enter parameter value" which does not make since to me. :banghead::banghead::banghead: See below I've attached screen shots. Is there an...

I am still running into a brick wall, I'm not an expert and need help as I keep getting a "Compile error" Syntax error for the following: Function UpdateIssuesDatabase() Dim con As Object Set con = CreateObject("ADODB.Connection") On Error GoTo UpdateIssuesDatabase_OpenError con.Open _...

Thanks MarkK, "IN" totally slipped my mind. I will update my module and provide the outcome.

I want to thank June7 for all the help and putting up with my questions

Hello, I am yet again in need of assistance. The goal I am trying to accomplish using VBA within Access 2010 is to append/add certain records to another database (Customer Service) from my database (Client Request). I tried using a macro to append then update records in my database but...

Update: I tried to go another way and entered a "GoHyperlink" module to open Excel from Access (running 2010) and it opens Excel but now I have hit another wall. :banghead::banghead::banghead:..the "DataLink Properties" window appears and stops my Excel from opening and halts at the first macro...

I need help, :banghead: my brain has melted and I hope someone can assist. I am trying to run the following code as a function in Access 2010: Public Function OpenAMZOrder() Dim xl As Object 'Step 1: Start Excel, then open the target workbook. Set xl = CreateObject("Excel.Application")...

Help, I have a table that has various information for my functional participants; in this table, each persons email is stored. Is there a way for me to send this taqble using the DoCMD or Send Object method that will "automatically" send to the email addresses listed in the table? I'm sure...

Thank you, this worked great