Not sure how to word this question but here it goes... I have a Master Inventory form with a Serial Number combobox (The serial number is also the primary key in the table). When I select th...
I'm having problems requerying data in a combo box on a form in Access 2007. The form (its a "continuous" form) is based on a table that stores two particular fields among several--a "SchoolID...
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'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 ...
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'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...
Is it possible to change the color of a button in a MS Access form? I want to get away from the standard gray button....
I have a database where we store client issues and a data access page where we can view, edit and enter issues. There is a field for clinet name, account manager, account manager phone and ac...
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...
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...
Access 2003, this is an easy one for you guys but I haven't done this in years. I have a small Access database and I need all of the records locked unless an Edit CMD button is clicked. Can so...
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 ...
When I try to add the Microsoft ActiveX control - Common Dialog (Comdlg32.ocx) the message appears:
"You don't have the license required to use this ActiveX control"
I have registered the ...
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 select query (saved as a datasheet form) as a subform to be filtered on multiple fields based on one of 7 combo boxes that are placed on a form. I am trying to get it to select only t...
Hi,
I have trouble with an Insert command when one of the fields being inserted is a DateTime Field. Here is my code:
command.CommandText = "INSERT INTO Book (UserID, CardID, Gr...
Hi -
I'm not so good with Access/VBA and need some help. I have a form that has a combo-box and a multi-select list box. I'd like the selected items on that combo box and list box to eac...
Hello,
I have a user that created the attached Word drop down form. He then locks the form so his employees can only choose from the drop down options and not edit the form. He would like...
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...
The TextBox control in an MS Access form can have a scrollbar but does not recognize the mouse wheel for scrolling. I would like to scroll with the ctl-Up/ctl-Down keys, but can't find anythin...
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 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...
Tables: tbLImport(PK AutoNumber,FK GID), tblDataEntry(PK GID)
Relationships: All Records from tbLImport on GID and only records from tblDataEntry where GID is equal
Queries: select_tbLI...
I would like to "size-to-fit" the width of a textbox in a continuous subform. The maximum width is .75 inches (1440*.75 twips).
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 ...
