Recent content by lodgey47

No problem, sounds easiest to manually update the spreadsheet. Thanks

I have an access database with a linked table to an Excel spreadsheet. I have a form based on the linked table so the presentation of the Excel date is better. The spreadsheet is used by other staff in my office to record sales which I need to register with an external organisation. What I want...

Thanks Guy that worked a treat. What I have noticed is if I click on my backup button without the pen drive present I drop into the vba code. What I would ideally like is an error message saying something like 'Pen drive not available please insert now - click continue or cancel' Any suggestions...

Hi I have a small single user database that I want the user to be able backup periodically. I've a command button on the main form and have found the code below on here which is almost perfect for what I want. The only problem is the database I have is located on the c: drive and I want it...

Thanks for the replies. I'll let you know if the problem is resolved.

I'm developing a simple database with a number of tables, forms etc etc but for some reason a problem has developed with one of my forms. When I'm moving round the database working on forms, tables, queries, report etc as part of the development process sometimes the main data entry form fails...

Thanks Paul. That works exactly as I want it!

Hi, I have a problem that I need help with! I'm trying to find a way of automatically placing a 'tick' in a check box depending on a value in another field on the same form. The checkbox I want to update is called 'conditions met' and the other field on the form is called 'Total Score'...

Yes EMP solution does work however what I would like to do now is group together in a report all the invoice values for any year the user wants so I may have: Record 1: 2002 £50, 2004 £100, 2006 £10 Record 2: 2004 £125, 2005 £100, 2007 £50 Record 3: 2002 £100, 2003 £100, 2004 £125...

I changed my query to prompt the user as you suggested but when I put a value in the first year field the query runs and doesn't prompt for the 2nd and 3rd year fields. Can I prevent the query running until all 3 fields have filled in? Using a table to store the year values and then creating the...

I have records in a table that contain many fields 3 of which are text fields that I use for storing a year eg 2002,2003 etc. A record may only have a value in the 1st text field whereas other recods may have values in 2 or all 3 text fields. The problem I have is I want to select records that...

Cheers. Given I shouldn't use autonumbers for my order number can access auto generate one some other why? As I already have 100+ orders how will I ensure the order numbers remain the same?

I have a an 'Orders' table that records order details which has the order number field set as an autonumber. I also have a number of other tables which provide additional details for each particular order (eg Address details, invoice history etc) These each have a 1 to 1 relationship with the...

I have a main form to populate a table holding details on various projects I am working on. I also have separate tables/forms to hold costs and funding for each project. I had a problem earlier this week of being able to create these associated records which I have now resolved thanks to help in...

I have a form that list details of customer projects. I have 5 other forms I want to access for this customer eg funding, project costs each of which has its own table. I want to be able to move between forms for a particular project and add or amend records in the other tables. (ie related...