I am using a text box and a listview control on a form. The user selects an item from the listview to edit, this populates the text box with the text that can be edited. As soon as the user ...
I am trying to create a Form using the Datasheet view were it will format each row depending on the value in on of the columns. I could use the Conditional Formatting feature within Access if ...
I have an Access 2003 database form. In this form I have a subform. What I want to be able to do is when you click on a button in the subform it brings up a popup form to input information int...
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...
Hi,
I have table and form called CUSTOMER. when user want to add new cusomer they first need to go manually in CUSTOMER TABLE, Go to the Last Record, and get the available number as Cust_ID ...
Hi guys.
Right i have a form with a tick box labelled [IN STOCK]
i also have a a field called [date packed]
using expression builder i would like to write an expression that when [in s...
I'm using ADP in access to sql server 2005, trying to get a button click event working. I think i'm missing a reference in the VB editor but i don't know which one. I'm getting this on any of ...
Hello Experts.
I have the following:
Set fso = CreateObject("Scripting.FileSystemObject")
fso.MoveFile "C:\Documents and Settings\pardoe2\My Documents\Blank Solution Tabs\Blank...
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...
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 use unbound forms to lookup records and it has worked well in Access 2003. I change the .recordsource on the subform using a sql statement and then do a .form.requery.
This no longer works...
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 have attached a screen shot with the relationships of the three tables that are included in my question.
So I have a Form 1 to enter data into the four Requirements Table fields (ID is an...
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 ...
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 an Access 2003 (SP3) database (front-end) with linked tables (via ODBC datasource) to a SQL 2000 database (back-end). Whenever I edit a form in design view that utilizes one particular...
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 have a mainform with two subforms...
Mainform (select case)
+---Subform1 (case's records)
+---Subform2 (datasheet for the case)
When the user selects a case in the...
I have a form with a subform.
On the main form (frmcases) there are two buttons. One filters the records in the subform (frmCare_Options) to show only those in the "Past Requirements" sect...
I wish to fill a listbox with vehicles, and let the user pick several of those vehicles.
The vehicles come from several different recordsets, so I just want to add values and not bind the lis...
I am creating a simple database and form in Access 2007. Can anyone offer me assistance in figuring out how to display a radio button or checkbox horizontally on the form.
Right now if I ha...
This is my third post for this topic. Think I'm almost there.
For those that have helped me get this far, thank you.
I need to add / modify the code below to check for international date ...
I need to get the value of a specific row from a combo box to be inserted in the following query. The value is for Expr6. I've tried this
"Forms!Booking_EventDetails![LastofBooking ID]!Row(...
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 ...
How can I force refresh form and 2 subforms in a MS Access 2003 with VB, I created a refresh btn with a wizard and it does not work. Access says "an action or cmd refresh is not available now"...
