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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
2M records in in Acces 97
I have had an experience with a mdb with a single table with more than 1 million 800 thousand records, it was historical information of one year, i was importing it from monthly dbf file, but i couldn't store all the year in a single mdb, so i used two and then design a union query, that really...- FMAQ
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
If Record Doesnt exist, then add... else Exit Sub
Excuse me theres an error, With RS 'If RS![assignmentnumber] = assignmentnumber Then <<THAT BELOW IS WRONG IT MUST BE LIKE THIS>> << .FINDFIRST "ASSIGNMENTNUMBER = '" &...- FMAQ
- Post #9
- Forum: Microsoft: Access Modules (VBA Coding)
-
If Record Doesnt exist, then add... else Exit Sub
Excuse me theres an error, With RS 'If RS![assignmentnumber] = assignmentnumber Then <<THAT BELOW IS WRONG IT MUST BE LIKE THIS>> << .FINDFIRST "ASSIGNMENTNUMBER = '" &...- FMAQ
- Post #8
- Forum: Microsoft: Access Modules (VBA Coding)
-
If Record Doesnt exist, then add... else Exit Sub
With RS 'If RS![assignmentnumber] = assignmentnumber Then <<THAT BELOW IS WRONG IT MUST BE LIKE THIS>> << .FINDFIRST "ASSIGNMENTNUMBER = '" &" FORM![YOUR FORM NAME]!ASSIGNMENTNUMBER'" ** WRONG ==>> .FindFirst...- FMAQ
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
-
If Record Doesnt exist, then add... else Exit Sub
With RS 'If RS![assignmentnumber] = assignmentnumber Then <<THAT BELOW IS WRONG IT MUST BE LIKE THIS>> << .FINDFIRST "ASSIGNMENTNUMBER = '" &" FORM![YOUR FORM NAME].ASSIGNMENTNUMBER'" ** WRONG ==>> .FindFirst...- FMAQ
- Post #6
- Forum: Microsoft: Access Modules (VBA Coding)
-
Round in access 97
Well it's a way to do it, the other is using excel round function like this. dim ex as excel.application dim nn as long dim x as integer x = 3 set ex = createobject("excel.application") nn = ex.worksheetfunction.round(34567.65,x) debug.print 34567.65 & nn set ex = nothing x represent...- FMAQ
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Copy Of an MS Access and repopulate it
IT WOULD BE BETTER TO SPLIT YOUR DATABASE SO YOU HAVE YOUR DATA IN ONE AND FORMS MODULES, REPORTS AND SO ON IN ANOTHER, THEN EXPORT DEFINITIONS ONLY OF YOUR DATABASE CONTAINING YOUR DATA TO USE IT AS A MASTER COPY SO WHEN YOU NEED AN EMPTY DATABASE YOU COPY THE MASTER GIVING IT A NEW NAME (USE...- FMAQ
- Post #6
- Forum: Microsoft: Access Modules (VBA Coding)
-
Change Form Properties
ISN'T IT BETTER TO USE A QUERY TO SELECT THE RECORDS NEEDED, INCLUDING THE ORDER BY CLAUSE, MAYBE BY THAT WAY DEPENDING ON SEVERAL THINGS RELATED TO YOUR DESIGN AN YOU SYSTEM REQUIREMENTS YOU ALSO MAY NOT NEED SEVERAL TABLES INSTEAD A SINGLE ONE, USING THE APROPIATE FIELDS AS CRITERIA YOU CAN...- FMAQ
- Post #10
- Forum: Microsoft: Access Modules (VBA Coding)
-
Accessing a Form's function.
Ok, it's good what waldemar tolds us, but you can also called the function or sub like this, form_myform.updatedisplay or forms!myform.updatedisplay. Felix A.- FMAQ
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
-
passing parameter to query
THERE ARE SUGESTIONS TO NOT USE FRECUENTLY SENDKEYS, BUT I HAVE USED IT IN SOME SITUATION LIKE YOURS, REQUEST THE DATA YOU NEED TO PASS AS PARAMETERS TO YOUR QURY IN A FORM INCLUDING IN IT THE TEXTBOXES OR CONTROLS YOU NEED THEN USE SENDKEYS TO SEND THE VALUES, NUMBERS AND DATES MUST BE...- FMAQ
- Post #11
- Forum: Microsoft: Access Modules (VBA Coding)
