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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to create new document from template with @functions?
I'm thinking about to make agent to create new document and retrieve data with @Dblookup from different databases. I have different document types ready to get data but I would like to automate things as much as possible. How can I create new document from template (for example "Component...- t9914
- Thread
- Replies: 2
- Forum: Lotus: NotesDesigner
-
too many fields problem when importing
Hi, I have a problem when I try to import Excel worksheets. I would like to import more than one Excel file's different worksheets(/TABs) in time.(but I suppose it is impossible) So, I have to import those by TAB name. Problem is that when I use TAB name like this: DoCmd.TransferSpreadsheet...- t9914
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
-
Recordset problem
Hello, I have problem retrieving data from recordset. code sample: Sub TrialCodes() Dim R As Variant Dim record As Recordset Dim SQL As String Dim data As Database Set data = CurrentDb SQL = "SELECT DISTINCT Data.[TrialCode] FROM data WHERE Data.[TrialCode] Is Not Null...- t9914
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
