Search results for query: *

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...

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 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...

Anyone know of a proprietry/shareware common dialog style control that allows an image file preview on the form?

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?

Does anyone have a procedure for prompting a user to select a back end to connect to with tables linking at runtime?

In a multiuser setup, I am getting write conflicts when users edit memo fields. When another user opens a record that has been edited an error is generated. The conflict also produces a #Error in the underlying table which renders the record unusable. I have seen the other posts with similar...