Search results for query: *

Hi Phil; OK Firstly a query is just a selection that comes from a table/s. The table is what you should be looking at. Somehow you need to be able the place another column in the table (it needs to be updateable). This is the place that holds the running total. This will allow diferent totals...

You could use a CD-RW (if you writer support them) as that will turn your CD into a slow (real slow) virtual hard drive. This is not recommended though :) On Win95,98, 2000 (ME ?) Copy your back up from your cd onto your hard drive & change the propertise from read to archive. XP you don't...

You can try password & click combinations to "unlock" a form for manipulation. If the form has been set (on load or default) for read only excepting a couple of buttons, controls etc. Type in your password in the control, press buttons in sequence - what ever - then by code unlock the...

It's true that the key cost $250. This is the key that activates the driver which is part of the $1000 SDK kit. Of -course I bet they didn't tell you about the $14.95 MYOB book that you can buy at "any good magazine shop" by Next Handbooks has the needed drivers (but no explanations...

Yep you can (stop being so negative :) ) Detail - if this includes the footer Put one in the "footer" part of the subform. In your controls "data" section use it as you would on a report ie =Sum([TotalAmount]) (if TotalAmount is in the main part etc etc) If not create a...

This happens when the transfer grabs all columns from your worksheet, blank ones too, all the way to az or what ever. Best learn how to code it - you've so much more control. There's a bit of code in "Copying Data from Excel to Access" that will head you in the right direction.

RE: ADOBC or DAO...ing what about .... Once you have all your cells loaded into the strDataItems(x) array. Why not just open a recordset of the appropriate table/s and just edit or addnew the variables in. The code to do this is exampled in the Access F1 (help). Also once I was importing from...

One client as a DB on a Win98 (everything standard ). Uses ID number to match hardcopy booking numbers. Now for some reason every so often (3 times last year) the autonumber would increment by two & throw the number system out of sync. Which meant I had to go and re-load the tables etc - not...

Here's a quick example but any good VBA book will explain it much better. Private Sub cmdZap_Click() Dim db As Database, pinset1 As Recordset, pinset2 As Recordset Set db = CurrentDb Dim b As Integer Set pinset1 = db.OpenRecordset("Select * from [your_table1] ) Set pinset2 =...

Hi Ryan I stay away from the AutoNumber because of it's undocumented feature of incrementing with out reason every blue moon or so. Finding out that there is another unusuality (new word?) is not surprising.

Dear mundia22 If your writing your own vba recordsets ... then it's not hard to create one based on your tempTable, add & update it with the records (selected fields) of your filter recordset. As your leave the form use a looped 'delete' for all the tempTable's records - ready for next time...