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...
Hello,
I have a form and a subform. I would like to create a one-to-many relationship, however when I create a new record within the main form, my subform won't allow new data to be entered...
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...
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...
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...
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....
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...
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...
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 am trying to develop an interface for Access where Engineers can enter test data. They are currently using an Excel version that is very cumbersome and non-standardized. This makes it impo...
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).
I have a report form that gets called from 2 different forms, a new record entry form and an update an existing record form. There are 2 fields on the report that get filled in on the Load ev...
I am trying to filter a report based on criteria selected from a form. Here is the basic query I am using.
SELECT [Technician Table].[Tech ID], [WorkOrder Table].WorkOrderNum, [Services Ta...
Hi all.
I have an Access 2003 form that has a SAVE button, I would like to do the following:
When the user clicks the SAVE button, saves the data (already got it to do that) but I also w...
So I have a table called Requirements and in the table there is a field called Description which is type Memo. As listboxes can't display more than 255 char, I want the Description field to s...
Using MS Access 2007 as a front end to tables in SQL Server Express
In a previous question I asked how I could allow users to work on a list of records without the underlying tables being u...
I have a subform that is based on a query which looks to the value in the combo box.
Combo Box OnChange event contains subform.requery method
The combo box on the subform from a column...
Right now I am using a temporary table, but I suspect there is a way to do it with a recordset. I'm using Access 2007 DAO FE with SQL Server 2005 BE. I have datasheet subform based on a temp t...
I have a fairly good database set up with my entire inventory. The system allows my workers to look up parts, to determine whether we have them in the shop. I would like my Form to have some l...
I'm trying to apply a form filter using a combo box to my "Carrier Number" field. I'm using a table, not a query because I need it to filter out all the other data so the user can view the se...
I'm trying to create an Access 2007 form that allows a user to work on the content of an order (tables stored in SQL Server Express). Because I want to allow the user to "change their mind" an...
Hello All:
I've been running into the following problem; I have a MainForm which has a Tab Control, in it, there is a SubForm which is based on a Query which in turn gets its data based on ...
Hi Experts,
I have a calendar control I want to become visible when the date combo box is clicked. Below is what I have, nothing happens when I click the combo box. Thanks for your help. T...
I am trying to format a MS ACCESS form label or text box in the vertical position, with the text begining on the bottom and reading upward. The build-in property VERTICAL , sets up the label v...
