Search results

I want to use a variable on a DoCmd so that I can use DLookup to fund how to open each file in VBA. When I use the below snipit of code I get the error Method or data member not found for "DT" and Type Mismatch for "VO". Anyone have any idea's? Thanks, DT = "OpenQuery" VO =...

I am using a form linked to a query to pull a specific policy. In the query I have set the criteria to be [what is the policy number?] to pull a specific policy. What I am wondering is there a way to capture what was entered into [what is the policy number?] in VBA? I'd like to build some...

I am using a union query to pull policy numbers from two tables together for a search. What I would like to accomplish is to add a wild card to is so that the parameter for searching by the name will look within the field. In a standard query, I'd just set the criteria for the name to be Like...

I have a database that checks the userid that the person used to log into the PC to get into the database. It have worked for many people for many years, but all of the sudden it is failing on a new associate. Does anyone know where VBA actually pulls the users ID as I'm thinking IT set her up...

I know this should be simple, but I can’t seem to figure it out. I need to create a query counting the number of clients in each state. The issue is that the clients can be in the table multiple times if they have multiple policies. I have their SSN in the table so I am thinking I could...

Hello, I have a macro that runs each night to email files and do other misc things on the database. The only thing is that I have a query that it e-mails each night that very rarely has data on it. I'd like for it to only send the e-mail when there is data in the query so that I don't...

Hello, The following code will pull all of the funds that match to the product. The problem is I can not get them to sort by the FundName. Can someone show me where to add the order by into the following code so it sorts correctly as I just cant figure it out? Thanks!!!! SELECT...

Hello, I am using a form for rejections and want to add a check box so that when I click the command button at the end it will print a PDF file that is on our shared drive. I have searched the web for different document, but can't seem to find any code that works. Does anyone have any...

I am having problem with the below code. The form is used so that employee's can log each transaction they have processed. When I use the below code to exit the contract number it no longer allows the employee to tab back to a previous record. Private Sub Contract_Exit(Cancel As Integer)...

I have a database that exports letters for the team to be mailed each morning. The issue I am running into is that they have to sign each letter. I have a digital image of each of their signatures and would like to pull that signature on to the letter. Basically for the letter it does a...

Hello, I am working on a Financial trading platform and am getting a type mismatch error when running the below DLookup. What I am trying to do is find a fund number on the trading table were the fund name on the trade form matches the fund name on the trading table. I also need the product...

I am trying to set up a query were it checks to see if the user is in management. If he/she is then the Criteria field needs to be be blank. If the user is not in Management then it will populate that Users ID so they can only view their records. Unfortunatly based on the below formula it is...

Hello, I know this is an easy one, but for some reason it is not working for me. On the form the user needs to input the contract number, which he/she will also need to input into other programs. I want access to copy what user puts into the "Contract Number" text box after he/she tabs off...

Hello, I know this is a dumb question, but I have learned access through the school of hard knocks. There for I have missed some really easy things. I have a form that I need the "total" text box to update based on what is placed in the "other" text boxes. This update update each time you...

Hello, This is my first time posting so please excuse my ignorance. What I am trying to do is upon updating a form I need to check what was selected in the [FormTitle] “without space” combo box on the active form and look in the [Documents] table to link it to [Form Title] and when it finds a...