Recent content by KEKeogh

My apologies if this has been asked before. I have a table with a list of our reps for the company but for some reason over the course of working in other forms all the reps but one will delete. Not sure what form is causing this to happen but I'm thinking if I can lock the reps table then...

Thank you so much. It still doesn't save to the table field but I can make a query to work with now. Guess that syntax error was enough that I couldn't even do that. Kathie

Hi all! Need some help. I have the below DLOOKUP on a form in it's Control Source property and I need it to update the [Commission Due To] field in the "Invoice Master" Table with that same value. =DLookUp(" [Client_Contact_Info_Main]![FMCC Rep]...

OK I don't know if this has been asked before but I'm not finding anything obvious. I have a form which has three different subforms. The main form you select a Company_Name from one table and the subform call up all the records for that same Company_Name from 3 different tables. My...

THANK YOU SO MUCH!!!!! Sorry for the confusion. Should have put me being novice in my original post. Gains from the internet can definitely give the illusion of being an expert. That last bit of code got me closer but was still getting a different error but turns out I had a table name...

I apologize for my ignorance but then what is dbSeeChanges considered? I am a novice when it comes to code. What I have working I got from the internet and most likely all of you. I pasted it exactly like you had it. Kathie

Now I get "Error #3001: Invalid argument"

OH and the table is linked by an ODBC Database link through SQL

Morning! I had a database which I have recently switched over to use the data from a SharePoint site. On the one form I had VBA to add an entry to the table it looks up from in the entry is not in the list (code below) and it was working fine. However after making the switch to the...

There was a Save Password tic box when you added the ODBC Database tables into Access 2013. I just re-added the tables making sure to check that box this time. Just had to make sure I put all the relationships back they way they were.

OK So I setup linked tables using an ODBC Database and everything is working perfect!!! But when I set it up I forgot to click "Save Password" and every time I open the database it asks me for it. How can I get it to save the password after the fact? Thanks Kathie

I totally missed that line!!! This is why I should not make technical changes first thing in the morning. Thanks!!! Kathie

https://support.office.com/en-us/article/Enable-or-disable-macros-in-Office-files-12b036fd-d140-4e74-b45e-16fed1a7e5c6

I found the instructions on how to automatically enable all macros in Access 2013 but in reading them it looks like this will do it across all Office programs (ie Word and Excel) as well. Is this true? And if so, is there a way to get Access 2013 only to always enable macros? Thanks Kathie

The Query's SQL is: SELECT Client_Contact_Info_Alternate.DateUpdated, "Contact" AS Expr1, DateValue([DateUpdated]) AS DateCriteria FROM Client_Contact_Info_Alternate WHERE (((DateValue([DateUpdated]))=[Enter Date]));