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 Chriss Miller 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: *

  1. AndyHorn

    Self Join Issue - Including previous month value, value or not

    Thanks again RiverGuy. Worked a treat!
  2. AndyHorn

    Self Join Issue - Including previous month value, value or not

    I'm stuck on one last thing and hope you can help. In the results of my query I have a DespatchValue field and a PrevMonth field amongst others. The PrevMonth field should show the DespatchValue from the previous month, against the current month. I nearly got this to work by using this in the...
  3. AndyHorn

    Self Join Issue - Including previous month value, value or not

    Thanks RiverGuy, you're a legend. The Cross Join was exactly what I needed. I'd heard about them before but had never read how they worked or seen one used so it didn't even cross my mind to look at using it. The name of it makes perfect sense!
  4. AndyHorn

    Self Join Issue - Including previous month value, value or not

    Thanks for your suggestion RiverGuy. I have already created a Calendar table which my first query references in order for every date to be returned. What I can't achieve is to get every Category returned with every date and to display the values or nulls if a value doesn't exist for that...
  5. AndyHorn

    Self Join Issue - Including previous month value, value or not

    Hi, This is a bit long, sorry. I've been stuck for days trying to get a specific result set and I hope somebody can help. The results I'm after look simple: Category, OrderValue, PrevMonth, Date I need the results to show ALL categories for ALL days and populate a value in the OrderValue...
  6. AndyHorn

    How to return records from one table that don't exist in another

    Thanks RiverGuy, it worked a treat!
  7. AndyHorn

    How to return records from one table that don't exist in another

    I want to show all records from my stock table that are members of a specific parent category but not members of a specific sub category. The stock table contains the parent category field but any sub categories the item is a member of are stored in a seperate table. There will only ever be one...
  8. AndyHorn

    Select customers who've purchased two types of product in same order?

    Hi, I'm struggling to write a query that will return all customers that have purchased product A and product B in the same order. Any suggestions how I might acheive this? Thanks
  9. AndyHorn

    Amending database query reference in Excel 2000

    I've just replaced an old server. The new server has a new name but all the data has been kept in the same folder structure. I have many excel spreadsheets that get their data from access databases on this server. Is there an easy way to change the UNC path of the queries within the...
  10. AndyHorn

    Displaying results of a query in another query

    Thanks PHV. I've never used a CrossTab query before. It's done the trick. Cheers
  11. AndyHorn

    Displaying results of a query in another query

    I have a query with the following fields: AccountNumber, AccountName, NetTotal, Date ----------------------------------------------- 1234, ABCD, £1, 20064 5678, EFGH, £2, 20064 1234, ABCD, £3, 20065 5678, EFGH, £4, 20065 ----------------------------------------------- The date field is a...
  12. AndyHorn

    referencing explorer.exe considering different OS's

    Indeed it was that simple Crowley16. Have a star. Thanks
  13. AndyHorn

    referencing explorer.exe considering different OS's

    Hi, How would I go about referencing windows explorer in VBA for a multi operating system environment? The problem being that explorer lives in C:\WINNT\ on Win2K and in C:\WINDOWS on WinXP. The code I am currently using is: Private Sub CmdOpenBrochureDir_Click() On Error GoTo...
  14. AndyHorn

    DoCmd.SendObject - Email wont send

    Yes, the standard attachment types are as you've suggested but don't really work for me, a snapshot is preferred. I previously had a macro doing a very similar task. In the macro it let you choose a snapshot as the attachment. Because this isn't available as a standard command in the sendobject...
  15. AndyHorn

    DoCmd.SendObject - Email wont send

    I've amended the code as suggested but the email still wont send. Office 2000 is up to date with service packs etc. Thanks for the tips on the code. I'm learning all the time. I did have the 'objects' as 'strings' at one point but had an error message so tried them as objects and the error...
  16. AndyHorn

    DoCmd.SendObject - Email wont send

    Hi, I've written the following code to grab information on the open form in access and put it into an email with a snapshot attachment. This works fine but when I click the send button on the email it doesn't do anything. The only way to get it to work is to save the email, open it again and...
  17. AndyHorn

    DoCMD.Hourglass True does not work within module!

    Try: DoCmd.Hourglass (1) to turn it on, or: DoCmd.Hourglass (0) to turn it off. Cheers Andy
  18. AndyHorn

    TransferText / Schema.ini Text Qualifier Problem

    Hi, I'm using the TransferText method along with a Schema.ini file to export records from an Access Table into a .csv file. However, it creates the file with double quotes, " , around each Text field to Qualify that data as text. This is a problem when importing the .csv file into Sage as it...
  19. AndyHorn

    DB size after Upsizing / Importing to SQL Server

    Thanks BNPMike I'll have a look at that. It hasn't caused a problem, I was just curious as to why they were so different and wondered if I'd done something wrong. Thanks for the tip!
  20. AndyHorn

    DB size after Upsizing / Importing to SQL Server

    Hi all, I've tried two different ways of converting my Access 2000 MDB to SQL Server 2000. 1.) Using the built in Upsizing Wizard in Access. 2.) Using the DTS Wizard to Import the data into SQL Server. Once upsized from Access, the DB is 75MB in SQL Server, but when Importing the Access DB...

Part and Inventory Search

Back
Top