Search results for query: *

Thanks again RiverGuy. Worked a treat!

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

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!

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

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

Thanks RiverGuy, it worked a treat!

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

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

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

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

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

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

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

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

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

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

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

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

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!

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