Recent content by jimmyspinner

Hi there, I'm trying to create a running totals or cumulative totals query based on the following sample query in Access 2000. I'm trying to use a Dsum function based on a query not really getting the answer I'm wanting which is shown in the column Cumulative QRY_DealsSummary is the query...

Sorry for the late reply and thanks both for your suggestions. Decided to go with Dave's suggestion and have made some good progress with this now. Cheers Dave (Jimmyspinner)

Hi there, Please help, I've trawled this site and others in an attempt to find some code to create a table in my database without success. The database is already split and therefore needs to be created in the back end and would happen when the user logs in for the first time to the front end...

I do in new databases but having started this database years ago when I didn't appreciate the naming conventions I now realise the problems I cause myself are sometimes down to this. I've got 80 stand alone users with this database so changing the existing naming conventions will be some task...

Thanks Mailman, I believe the term is you've delivered!!

Thanks regarding the first point. The list box is a combination of two tables Fame and Portfolio with different table structures so the link criteria will be the identifier but unless it knows which table to go to I would be in the mire. I think your solution would work and the combo box just...

Hi there, I'm new to Union queries and this forum has been very useful in providing solutions up to now but I've hit a dead end having tried to search through the forum without posting a thread. Here goes..... I have built a union query based on two tables to link common fields as below to...

Hi there, I've recently changed from Windows 2000 to a Windows XP build and although my version of MS Access is 2000 still I've had a problem with some code since the move. The code originally attachs a database within an email and then sends it to a mailbox. It fails at the code in red...