I'm not much of a MS Access guy, so I may not word this correctly... Here's the rough situation:
I have a three tables (offices, users, trainings) that look something like this:
Offices...
Trying setup this filter on a form. I got this code from someone that was using an option group in a form to filter the data using a regular field. I am trying to setup the same type of filter...
Hello,
I have a form (TestApptDis) which the OnOpen event triggers the RecordSource property
to find the table that equals Date() (the tables for this form are titled with dates).
The form ...
I have a simple Access database with 1 form and 1 table. I want the table to have a field with a link to an image file and I want that image file to display on the form. How do I do this?
I have a standard continuous form(appears as a datasheet) with basically every property (record selectors, scroll bars, etc.) set to none/no. I have those turned off because I feel it creates...
I've been using this function for the longest time without any problems, only now has it been causing hiccups.
it works almost all of the time... the only time it doesn't work properly I've...
Message box from Visual Basic code includes the control box "X" so that uses can close the box without selecting "OK".
How do I remove or disable the "X"?
I have other pop-up boxes using "O...
I am attempting to create a switchboard in Access 2003.
This is what I have done so far:
I have manually created a table [ObjectList] in my Access database which includes a column for Obje...
Within a form, will be changing the record source of a combobox. I'd like to have the combo box set to the value in the first row of the recordsource. Is this possible, without opening the un...
I need to launch Excel from an Access form control and open a spreadsheet that has an Auto_Open macro attached to it without running the macro. I know I can do this by using the /safe command...
Would somebody be able to point me in the right direction?
I am in need of gabbing a vbcode to do the following:
I need to filter a listbox that will be contained in a form, over a ton o...
I have a split form (form at the top and datasheet subform below). I have a checkbox to mark which records to print. After printing I run an update query to clear the checkboxes. I can use a b...
I have a Form where I can enter the "UserID" in a TextBox so the related info will be displayed.
I want to add Validation Rule to this TextBox. If the UserID entered is not in the Field [User...
I have a problem with a pair of combo boxes that I am trying to use to query a table based upon the selections made in said combo boxes.
route_combo selects the distinct route from table In...
I think I have done this before, but I can't remember for sure. I have a long form that I would like to beable to use the mouse scroll ball to scroll through, but when I move the mouse down, i...
Hi Experts,
I have a form frmA. In this form I prompt the user to enter a caseID that will match to myTable.caseID.
When I click on Enter botton on frmA, another form frmB will pop up with...
When using access to work out the time difference between Start Time and End Time I'm using:
=DateDiff("n",[StartTime],[EndTime]) in the Control Source field in a form.
This returns the ex...
Hi,
I have table call Facilities. I have 4 Facilities for each customer. Fac1, Fac2, Fac3 and Fac4.
I want to create a New Form call FaciEdit.
I want a Combo Box for user to pick Fac1 to ...
Hey Experts, I am asking this on behalf of a friend.
She wants to change the color of a form in an access 2003 database if it is overdue?
we found:
if me.yourformfield > aCertainnumber ...
I have a multiple column list box. I need to iterate through each row and read the column values
What is the syntax?
For example:
Dim intCtr as integer
Dim strCol0Value as string
Dim ...
I have a form which has five different "areas" on it where the user enters information. The first 'area' is a combo box (created via the wizard) where the user selects a customer name and th...
I have a database that has multiple tables, (CUSTOMER, CATEGORY, MARKUP, TYPE, ZONE). The "CUSTOMER" table is the master table where the other four are category types of tables that help iden...
I have a working login form in Microsoft access. When the user logs in successfully, they are presented with a splash screen that will be the main menu for the database. When saving new record...
I have a simple Access 2007 ADP connected to SQL 2005 server. I created a main form with a single subform ( an order with order details). Each has their own datasource (tblOrder and tblOrder...
HI Experts !
I don't know why, but I am trying to use a very simple method here called "select case" and for a reason I ignore, it simply doesnt want to return any value.
I am changing the...
