I use a utility database and the following code to link from an
original backend to a temporary backend, in order to replace the
original with a newer version:
Dim dbs As Database

I have a combobox on a form in datasheet view that's
record source is tied to a another control on the form.
the combo box is set to limit to list.
When the other controls value is selected the values in

I have an application in which the data entry person first enters in key
info. about a patient record (e.g., 'Patient ID' and 'Patient Initials') on a
'Patient Info.' form, then clicks on a Command Button to go to a custom
Switchboard, from which she/he can open a number of ...

Hey all,
So here is what is going on. There is a button on a form that opens another
form. Now this form is based on several queries, and is kinda sensitive, so
through the day pressing that button to run a macro that opens it up, isnt

Using VBA to operate on an Excel spreadsheet from  Access, I need to hide
(or unhide) a range of rows. How can I do this? Also, is there a good
reference available that tells me what the Excel properties and methods are
for a spread sheet?

This is just an FYI for anyone who may have lost as much time as I did with
this set focus issue.  The case is this:
You have 2 list boxes and you want to update the 2nd one when a user selects
a row in the first one.  However, lets say for some reason you want to have

I would like to (using code) have text data from a table field be
automatically appended to the end of text data entered in another field.
Specifically,
Field 1: "123456"

I have a form (Form A) where the user enters customer information that
exists on one table (Table A).  Each customer is assigned a customer ID.  I
have command button that opens another form (Form B)that contains some
additional information that exists on a different table (Table ...

Is there any way to code the event procedure for a command button so that
when it is selected by a user "Report A" automatically opens in Excel?
Thank you for any assistance.
LB

Good Morning,
I have been using me.dirty = false to force a save. It seems to work well,
but I have a form, and after I am sure I have entered a record I want to add
records to another table. So I enter code into the AfterUpdate Event, but so

I want to copy records to a 'copy' table whenever a new
record is added in a 'source' table.
How to acheive this?
Thank you for your insights.

Hi guys, I have a tick box which when the user ticks I want to display a msg
box asking the user to confirm they have entered all details on a form
correctly. I have the following code which works to some extent.
This displays the msg box but if the user clicks cancel the box is ...

I have a continous form with labels on top.
The columns could be
Date            Customer
22.04.05     Pettersen

Good Morning All
I am quite a novice at coding for access, but am trying to learn as much as
i can in works time and they have let me loose on creating a company
database.

I am wanting to set up my invoice form/subform to be read only after
updating, but still allow for new invoices to be added without a password.
Thanks,
Brook