I have a database in Access 2000 format. It has a main form with two subforms. The data on the subforms comes from queries based on the values of two controls on the main form rather than by a Master/Child link. Everything works perfectly in Access up to version 2003. In Access 2007 one of the...
I have developed a split database for a client although there is currently only a single user. The path to the back end on the client machine is similar to C:\Program Files\Database\BE.mdb. This path can be recreated on my machine in my office so I can easily work on the front end and send it...
I have a form (MyForm) with many identical bound textboxes that all need the same OnDblClick event. I don't want to have code for each control but rather call a function. The function is very simple - enter a numeric value into the bound field and change the control's back colour. The function...
I am currently extending a ticket booking system to include seat allocation. I have a table which represents a block of (say) 676 seats. The first field column is called 'Row' and there are 26 records for the letters A-Z. I then have field columns for the seat numbers (1-26) making up a grid...
Hap,
Thanks for your help. Option 1 worked fine. I guess I should have thought of this but Access 2003 offers you to convert to 2002-2003 format so I assumed this format would be compatible with 2002. Thanks again.
I have an MDB on a development machine running Access 2003. The database is in Access 2000 format. I need to create an MDE to distribute around machines running Access 2002. In MDB format the database works fine on all the machines running Access 2002.
I understand that I cannot create an MDE...
I have 'got round' the problem by changing the generation of the autonumber in the main table from Incremental to Random. This avoids the clashes when the records are added into the gaps.
If anyone has any comments on the original problem they would be very much appreciated.
I have tried the Recordset method using .addnew and .update but it is still adding records into the main table into gaps in the sequence of autonumbers in the ID (primary key) field and not onto the end of the table.
I use a form to build a list of records into a temporary table, and when the user has completed the form I run an append query to add the temporary records into the main table. The idea is to be be able to delete all records from the temporary table if a user 'abandons' without affecting the...
I have an Access application which uses automation to send emails. This works fine with the Outlook 8.0 & 9.0 object libraries, but won't work on a client running Outlook 2002 and the Outlook 10.0 object library. I think this may have something to to with the MS Email security update. Anyone...
I have a split database. Before some complex operations I need to make temporary copies of two tables in the back-end as a backup in case the operation is abandoned.
I cannot use the CopyObject method as this creates a copy of the link to the back-end table, not a copy of the actual table...
I have a split database. Before some complex operations I need to make temporary copies of two tables in the back-end as a backup in case the operation is abandoned.
I cannot use the CopyObject method as this creates a copy of the link to the back-end table, not a copy of the actual table...
Thanks Aivars,
I know that this is a compromise, but as I understand it the dialog box 'view' cannot be set at design time. Also I would prefer to have a larger preview.
Thanks anyway.
Thanks, but this isn't quite what I mean. I am using the MS Common Dialog FileOpen control for a user to select an image file from their hard drive. It would be better if the image could be previewed on the Common Dialog form but the standard MS control cannot be customised in this way. I have...
I set the page setup settings at design time and save but when I use code to preview a report from a form, the page setup for the report returns to the default page orientation and margins. Anyone had this problem?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.