Recent content by NellyC

I am trying to import one query into another but every time I try to add the query it comes up with the error 'Cannot open any more databases' Does anyone know why this might happen Thans in advance NellyC

Thanks for the advice. My problem is that I have a purchase Items Query which includes the fields 'Item ID', 'Order Number', 'Order Date', 'Product Code', 'Quantity' and 'Unit Price' but if I put any fields in the new query other that 'Product Code' and 'Order Date' then the results include more...

I need to produce a query in Access which finds a unit price for an item for the latest dated entry. When I try to do a summary it does not offer the option of Max on a date field. Does anyone know how I can overcome this

I have an access Database of component parts and I have been asked if it is possible to have a preview box on a form where an image of the part is shown. Does anyone know how to show an image based on a record key.

Excellent, Worked a treat Thanks NellyC

I have an Excel spreadsheet containing a link to an Access Database. Is there a way to set a macro that will refresh the records from the database based on a time frame (i.e. every 10 minutes) Thanks NellyC

Great Help. You have all saved me a lot of time Thanks NellyC

I am setting up a purchase order system in access and have set the purchase order number to Auto Number. Does anyone know how I can get the autonumber to start at 800001 without pasting in 800000 false records Thanks NellyC

Have you tried using the mailmerge function of word. simple click on Tools - Mailmerge and the wizard will take you through the process If you get stuck I can provide detailed instructions NellyC

Have you tried using the mailmerge function of word. simple click on Tools - Mailmerge and the wizard will take you through the process If you get stuck I can provide detailed instructions NellyC

I have a word template ready laid out with 2 logos and 2 text boxes grouped together to make up the header and footer of company headed paper. I have set the layout format of the combined object to 'in front of text' and in the advanced setting I have set the absolute position of the object in...

Thanks Skip that worked a treat NellyC

Can anyone help, I have an excel file which has a formula generated list on one of the sheets. I want to record a macro to resort the list (This is not a problem) but i don't know how to set the macro to run automatically when the file is opened. Any advice would be greatly appreciated. Thanks...