Search results for query: *

Hi All, Scratching my head somewhat over this one.. I've a Crosstab Query that sums Savings per month, so the column headings are: SavingID, TotalSaving then (E.g) 01/04/03, 01/05/03, 01/06/03 etc. These Date Column Headings will grow in number as the database gets used, which isn't a problem...

Hey all, can somone help me out on this?; Here's the deal: The company I work for runs Access 97 at some sites and 2000 at others and I have a database that has to be availiable to all. The db was developed in 97 and hence can be opened at all sites; if a 2000 user opens it, they get the...

Hi all, This is only a small thing but is driving me nuts as I can't seem to solve it. I've written some code that cycles through a list of names. For each curent name, a query is created using the current name as criteria and an Email is sent to the address associted with the current name...

Hi, can if anybody can help with this I'd really appreciate it as it's bugging the heck out of me! The above criteria worked fine until recently, however now it just gives ERROR! for each record. The dB is Access 97 and hasn't been changed significantly. I've been doing a lot of work in VB...

Hi all, I've had to resort to the above as I have some quite 'Dirty' data in Excel which doesn't respond well to the Access 97 import process, and I have to 'Import' fresh excel data daily. I'm guessing this is a really monkey way of doing things so does anybody know of any possible...

Help! Apolologies for the protracted nature of this.. I need to get a load of data from an Excel Spreadsheet into an Access table on a daily basis. The Excel Column headings remain constant thought the actual data will change. The Excel Column formats include Text, Date and Number types. I...