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!

Register Log in
  • Congratulations Rhinorhino 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: EhWot
  • Order by date
  1. EhWot

    Crosstab Query Form

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

    Crosstab Query Form

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

    Crosstab Query Form

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

    Dubble values in Combo Box even with DISTINCT

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

    Log Users Without Setting Up - User Groups??

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

    Stop Permanent Conversion from 97 to 2000

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

    Sending Multiple Emails: Bypass Pause in code

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

    Programatically Copy Data from Excel and Paste to Access Table

    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!
  9. EhWot

    Truncation Problem: WOprefix: (Left([W#O#NUMBER],6))

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

    Truncation Problem: WOprefix: (Left([W#O#NUMBER],6))

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

    Programatically Copy Data from Excel and Paste to Access Table

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

    Programatically Copy Data from Excel and Paste to Access Table

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

    Get Bulk data from Excel into Access Table using VB??

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

    Query to Excel

    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!

Part and Inventory Search

Back
Top