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 have crated a database from new, I have picked Date Picker in the table and on the form, I have placed a date format in the table to 01/01/2008 format. How every my Date Picker does not come...
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 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 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'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...
Hi Experts,
I recently modified a form such that its record source used to reference only one table, now it references multiple tables. As soon as I did, I could no longer add or modify data ...
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...
My understanding is that in Access 2003, I should be able to create a table with all the drop-down options for various combo boxes on different forms. I'm assuming that in this table, I can c...
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 ...
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 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 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...
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...
Greetings,
I get a Write Conflict error that requires me to click the save option numerous times. The error indicates that "This record has been changed by another user...."
I think it is...
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....
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...
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 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 have a form with a text box control.
The textbox controlsource property is =MyColumn
The form recordsource is not set in design mode.
The form load event sets the form.recordset to a cr...
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...
This in kind of a long the lines of a bill of material database, but not exactly. We use Quickbooks enterprise. I am connecting to quickbooks via Microsoft Access via odbc for the purpose of...
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...
