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

On the Load event of the form what would the paremeter equal so that it would pull the value in VB? I'd like to do different things with what they typed, but can't seem to locate its value. Ive made up an example of what I'd like to do below. If Len(What they Typed) = 0 Then Msgbox ("You...

That worked perfectly!!! Thanks

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

Hi Bob, I use the the modual below. Private Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" _ (ByVal lpBuffer As String, nSize As Long) As Long Declare Function clt_OpenClipboard Lib "User32" Alias "OpenClipboard" (ByVal hwnd As Long) As Long Declare Function...

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

That worked. Thanks for your help!!!

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

That will do it. I have the macro call the nightly cycle, but I can have it send the email through VBA so that works. Thanks, JS

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

That worked perfectly. Thanks!!!!

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

I tried to use the below link which looks pretty helpful. The challenge is I don't know the classname for the PDF so I tried using the code to locate the class name, but it won't print out the list. I will admit I am not very knowledgable in this area of access...

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

That was it. Thank you both for your help!!!!!!

The type for all of the fields is text. Sorry I am self taught so there could be something really stupid that I am doing that would cause this error. Thanks, JS

The type for all of the fields is text.