Search results

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]));

Doesn't seem to work. Keep getting the errors "Data type mismatch in criteria expression" or "This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by...

OK So I have a Query that returns a date/time result. I'm sure this is simple and probably asked before but I cannot find or think of the solution. See the attached image What I want is the criteria for the query to prompt for the date and when the user only types in "12/17/2015" it...

I'm using Access 2013. What I need to do is get my one database to open with full rights when a person but if another user tries to open the database it only opens as read only. Anyway to code this into the specific database? Kathie

Hi all! I'm circling back to an issue I was trying to get help with but nothing was quite working but since one guy is having trouble remembering the procedure and keeps losing things. I thought I would try again. I have an Access 2013 database with tables, queries and forms and such on...

OK Now I do see that when the button on the contact form is clicked and opens the record in the business form it's only opening that specific business (shows only 1 record) I guess what I need that button to do is open the business form and go to a specific record. Still need to be able to...