Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by paulharvey
-
Pocket PC
I assume that by now the problem you were having has been resolved. For anyone else that has this problem, you need to use the Application Install Wizard (Tools,Remote Tools, Application Install Wizard) to create the setup files. You then need to run the resulted Setup program to install the...- paulharvey
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Open a database \ form from a HTML link in a e-mail
CJTyo, What problem are you getting exactly ? Paul- paulharvey
- Post #14
- Forum: Microsoft: Access Modules (VBA Coding)
-
Using variables within field names
Apologies, I jumped the gun with that post before checking the help file. For anyone who has the same problem with the code, in the code viewer, click Tools, References and add the Microsoft DAO 3.51 Object Library. Works a treat. Thanks again Jeff for your code sample. Paul- paulharvey
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Using variables within field names
Many thanks for the prompt response Jeff. However, using the above code, I receive the error message "Compile error: User-defined type not defined" It appears to be highlighting the "rst As DAO.Recordset" portion of the code. Any ideas ? Paul- paulharvey
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Using variables within field names
Hi, I am currently working on a database that has 100 fields of the name meterx, where x is a number from 1 to 100. Is there any way i can increment the field name using a loop in order to access the fields in turn ? Thanks in advance. Paul- paulharvey
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Open a database \ form from a HTML link in a e-mail
Could be you need to enter the hyperlink in a HTML format. Try setting this: txtmessage = "<html<body><a href=\\prodcomp\d$\maindatabase.mdb>Click here</a>" Paul- paulharvey
- Post #9
- Forum: Microsoft: Access Modules (VBA Coding)
