Search results

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...

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...

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...

In my Access database (2007), I set a password. Now, I can't for the life of me remember the password. Is there a way to override the dialog box that comes up in order to access the database?

Hello, I have two tables. One is a main table with a Primary key (001_SMCO...) other is a table container records I want to delete (P04...). In order to better see my issue, I'm posting the SQL view: DELETE DISTINCTROW [P04_MasterRecord_EOL ALERTS_comp info].* FROM [P04_MasterRecord_EOL...

Hello, I reside in the US, I'm a "moderate" Access user. I have designed several database applications to streamline processes in companies. Always looking to learn and love using Access. from BluDev