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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DLOOKUP type mismatch with date fields
Works perfectly! And thanks for the reference to Allen Browne's page, I'll check it out so I understand this better. Thanks so much, Derek- mrderekg
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
DLOOKUP type mismatch with date fields
I believe I understand the # symbols as denoting dates but why the Format? Thanks, Derek- mrderekg
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
DLOOKUP type mismatch with date fields
I'm using the following code to populate 2 text boxes with the fiscal year and week. The code runs on the After_Update event of an unbound text box called txtAuditDate which is formatted as Short Date and uses a date picker. tblFiscalWeeks is a cross-reference table that has the fiscal year...- mrderekg
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Spooled file staying in OPN status
That works perfectly! Thanks very much. I had a feeling it was something small and simple. Thanks, Derek- mrderekg
- Post #4
- Forum: RPG (Report Program Generator)
-
Spooled file staying in OPN status
Sorry, I should have thought to post the code the first time. * SET CONNECTIONS TO EXTERNALLY DESCRIBED FILES F*RPRT00 O E DISK FRPRT01PR O E PRINTER *...- mrderekg
- Post #2
- Forum: RPG (Report Program Generator)
-
Spooled file staying in OPN status
I'm trying to do some simple label printing using ILE RPG with an embedded SQL statement. The program compiles without errors and when I run it, the spooled file stays in OPN status unless I use a CLOSE statement in the file after the WRITE. If I use the CLOSE statement, the program runs fine...- mrderekg
- Thread
- Replies: 3
- Forum: RPG (Report Program Generator)
