Search results for query: *

Thanks Jim, I'd never have though of that! I'll give this a go - I'll give you a shout if I get stuck. Many thanks! Greg

Hi, Not sure thats the problem as the Query works fine: it's just that I can't get the Form based on that (Crosstab) Query to show any 'New' Fields.

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...

I'm no expert, but have you tried DISTINCTROW instead of DISTINCT?

Craig0201's approach does exactly what it say's on the tin; and DOES with NT. V useful. Thanks

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...

Sounds like a plan, I guess you could save a .csv version, import it and then delete the .csv file so everything is nice and tidy. Will give this a go. Thanks for the advice Geoff, much appeciated!

Hey Martin, Thanks for responding so quickly much appreciated. Unfortunately as that didn't work either I think I have fundamental problems with the dB so will try copying the structure to a fresh instance and see if that works. Can't think of anything else to try. Thanks again for your help.

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...

Hey Geoff, Thanks for replying, I'll include the cutcopymode code to be on the safe side. In answer to your question the import process has to be automated as users need to be able to import on a daily basis at a click of a button; I tried linking the Excel file but the .xls file is...

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...

Hey Link9, I've been struggling to make GetObject work properly, that snippet of code was clean, concise and exactly what I needed. Thanks for posting it!