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!
Search results for query: *
- Users: EndlessNights
- Content: Threads
- Order by date
-
Portability of References in Access
I have added a few Programming References, such as Microsoft Scripting Runtimes, to the module I am working on. The Access app I am creating will be used on a completely seperate computer. Will these references be ported with the saved Access file, or will I need to install and reference these...- EndlessNights
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
If record exisits then update, else addnew
What is the best way of handling this situation in Access via VBA? Currently I am planning on openning a recordset based on criteria that determines the unique record, check if a record exists, if it does update some data fields of the record (e.g. !field1 = field1 + 1), if it doesn't exist...- EndlessNights
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Nested SELECT with DatePart join
Hiya, I'm trying to run a nested query that will extract for each date a count on certain variables. I'm hoping to get something like this: TheYear, TheMonth, TheDay, count(Variable=whatever1), count(Variable=whatever2), etc... Below is a much simplified version of what I'm trying to...- EndlessNights
- Thread
- Replies: 0
- Forum: -General database discussion
