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

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

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

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

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 I have a form that for contact names and I have a button that when clicked will bring up the corresponding business's info on a different form. This uses the attached macro coding and works great. My issue seems to be... that when they go into the businesses info using this button...

I know apparently what the problem is but can't seem to figure out how to fix it. Let's see if I can explain what's going on coherently. I have a field in a table that we copy the text from an email into so they can be associated with a client. These could be many paragraphs. All is...

OK so I have a form where the user selects a company in a dropdown box and then the corresponding record is pulled up. (See the attached screen capture of the form detail.) This was accomplished with the following in the After Update Event: ="[File As] = " & "'" & [Screen].[ActiveControl]...

I apologize if this has been asked before. I have an Access 2013 database that I have saved on our SharePoint site. (https://xxx.sharepoint.com/_layouts/15/start.aspx#/Shared%20Documents/Forms/AllItems.aspx) The db works fine but when a user clicks and opens the db, a copy is saved on...

I am trying to create a macro for a double-click event on a subform. Where when I double click a record on that subform it opens another form to a record with corresponding information. What exactly I need is: Double-click a record on the [Correspondence Subform] Open the [Client_Info]...

OK So I'm not even sure this is possible but I thought I would start by checking with you guys. I am creating a database to keep track of client contact. Using the form Client_Info. What I'm trying to do is on the Correspondence tab. I want to be able to double click on a record and...

I am trying to do a macro to do the following steps. 1. Open "OpenClaims" Form 2. RunMenuCommand "Find" 3. If no search item found then Close "OpenClaims" form 4. Open "MRIClaims" Form 5. RunMenuCommand "Find" In layman's terms I want a macro to open the 1st form let me search...

OK, I tried to see if this was possible but not finding much of an answer. So I figured I'd check with our merry band of experts if it even is. I'm using Access 2013 and I have a database I would like everyone to be able to see but only those that have a password to be able to change data...

I've created a form in Access 2013 on my computer which has a screen resolution of 1280 x 800. Now when I look at it on another computer with lower resolution, which others also will once this goes live, it obviously gets cut off. So just wondering what is the best size to make this form so...

I’m pretty sure this possible but I’m just not finding a code that works. Here’s what I am trying to do: I have a form puling from one table and then a subform in that form pulling from another table. I have a field in the [FORM] called [GROSS REFUND] and a field in the [SUBFORM] also...

I may be overlooking the obvious. Here is the situation We are assigning Tablets to Vehicles based on their location. I currently have a dropdown box pulling the Tablet Numbers and their location for selection. [Combo182] I also have a text box where we type in the location of the...