Search results

I have a make-table query based on several other tables together with user input, and it works well. However, I don't think I can't use the query as it is. I think I need to create the same SQL text in VBA and add various WHERE values which the user creates by selecting values on a form. The...

I have a large, old application to handle biological recording which I've just moved from an old XP machine to Windows 7. The path on the new machine is different to the path on the old machine. The application is split into data and application parts, so the application contains a variable...

I'm not an Access professional, more of a tinkerer. I live near Reigate in Surrey and I started off as a physics teacher but became disillutioned after about ten years and looked for a similar job in industry. I'm now a trainer at a software and hardware manufacturer in the south of England...

Good afternoon, It's a hot day here in the UK, but I've promised to finish some Access programming for the database that handles bookings for our training courses at work, and I can't update a combobox one one form from a button on another form. Form A is a waiting list of people who want to...

I have a text box on a form that holds the date in UK format, e.g. 25/12/2012. The date defaults to the first of the month but can be altered. If I click in the text box all the text from the insertion point to the right hand end is highlighted, it is not possible to highlight and change the...

Hi, I'm writing an Access 2003 application for a society I belong to and the application needs to be robust. I have a form that displays locked member details and the user has to click an 'Edit' button to unlock the fields and make any changes; at the same time I disable other controls that find...