Experts:
I have a table that contains data for schools. THe table structure is as follows:
buildingid
gradeid
teacher_count
student_enroll
year
My question concerns the form us...
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...
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 an Access database created in version 2000. I am now running it in 2007 and when I go to add records to a table in datasheet view there is a field with a numbering sequence... 1, 2, 3...
I currently have a main form 'frmBOMtest' that has two combo boxes. The first filters item classes, and the second box then would show the available parts with the class selected in the first...
I have an Access 2003 system.
I display a form with several large size text boxes on them.
I pre poluplate the objects with data from my database.
As you would expect only so mucjh of the t...
I have a list box with four columns. The first three are ID, Address and City. The fourth is a sales number that I would like to be right justified for ease of reading. Is this possible? T...
I'm currently working on a small custom database for some specialized auctions. The auctioneer may sell one, or multiple items at a single price. In fact, during the middle of bidding, he ma...
Need to display a new record in a subform after it has been added via another 'New Record Form'. When returning to the subform, it will appear if I press F9 or use a refresh button. Neither ...
In a recent update, I changed a command button to a Label Click as shown below. However, after the changes, I am now getting a Run-Time Error 13 - Type Mismatch with highlight on the message ...
I have a form with two subforms. Both subforms have the same Record Source, but they display different fields of the record source, and one subform is a datasheet view form and the other is fo...
Greetings,
I am using the DTPicker and I want to avoid the checkbox that is necessary if a null value is needed. I don't want any null values and so I try to turn the check box off in the pr...
I have an unbound list box that was populated by an ado recordset, then disconnected. When a row is selected, I would like the user to click an arrow button to apparently move the selected ite...
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...
I have a Pivot Table where I need to WRAP the text for one of the Column Headings. The full text needs to display and the length will change per Pivot. Anyone any idea please how to do this....
Hi i have a table called InvoicedCommDue and also have a form called InvoicedCommDue that displays certain fields from the table. Most of the table is populated from an append query but there...
This is simple but I can't figure it out. I created a form on MS Access, and I want to fix the AfterUpdate event of a control named UserID such that after entering a value in the UserID, the f...
I have a sub form in Access 2007 in a main form, its fun off a field called Part Numbers, when each of the same part numbers are entrered the sub from works well for me, however I would like a...
I have a form with 10 little subforms which are 9cm wide and 0.6cm high. They are placed on the form one after each other like the rows of a column. When the user clicks on a field in a subf...
Have a continuous form, given a field condition I want a bitmap to either show or hide.
The following works on a single form but not when I change to continuous:
Private Sub Form_Curren...
I am trying to multiply the two fields:
Private Sub gw2_AfterUpdate()
Me.gk2 = gw2 * 0.454 & "kgs."
Me.gw2 = gw2 & " " & "lbs."
End Sub
Shouldn't this work?
Hello,
On my MS Access form I'm creating an Unbound textbox which I'd like to count the number of check boxes selected in a subform (default view "DataSheet"). I thought if I do =Sum([table...
I have a MainForm (data from tblMain) & a SubForm (data from tblDetails, 'Continuous DataForm). tblMain has a 1-to-Many relationship with tblDetails through primary key PKMain. A field on Main...
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...
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...
