Option Compare Database
Private Sub Combo9_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[Stor...
Lets say I have a form frmMain, with a Subform subFrmInfo. Lets also say that the link child/master fields are appropriately filled out. When something on frmMain changes (causing the subform ...
I have a main form with a subform. The subform shows related records using a query. Each record that shows in the subform also has a unique ID. This unique ID is also shown on the main form re...
I have a form, that is linked to a table, the table is correctly structured. I wanted to have the form AutoComplete when I selected an Item from a Combo box. When I made the field a combo, not...
I have a form which has a tab control (TabCtl0) with three tabs on an Access 2007 form. There's a peculiar behavior which I can't control.
When the form opens the tabs themselves are just ...
Hi Experts,
I want to make sure the user selects an item from the list box because if he/she does not, the debugger will pop up. I want to make a message box pop up and tell the user they ne...
The main form has a field called JobClosed. When the keyer chooses YES, I successfully disable and lock the other enterable fields on the main form. But how do I update the fields on the subfo...
I want to have the functionality of the Edit|Replace command that brings up the Find and Replace dialog box when viewing a table of data by using a pre-made query executed inside a form inste...
I need to have an edit form be in read only mode so no changes are allowed until a user presses an edit button then the form unlocks and allows the user to edit. Otherwise the user will use a...
Greetings:
Is it possible to write code that will indicate what network a user is connected to WAN or LAN or both? It would need to be displayed on an access form maybe using a label.
Hi -
I'm creating a budgeting/forecasting function. I've got the actual set of values in one table and the budget values in another table (didn't make sense to put them in the same table ...
I have attached a test database. Please open New_frm_IDem. When I add a new record and use the tab key to move off of the A Number field (within the main form), the A Numbers within the subfor...
Which property turns off the black highlight on the control of the form having Tab Index of 0? When the form opens, I don't want this cursor (black cursor) to cover up the field.
Thanks.
I have a maximized form (electeds) that contains a ListView control containing a list of contacts. On the double-click event of the form, another form is opened (contacts).
1. I want the con...
I have a form which I maximize upon opening (in order to clearly see all command buttons on the form). One of the command buttons, when clicked, opens up a query which displays a total. I have...
Hello,
I closed few minutes ago this question:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_23543724.html
Everything is working well except one feature....
Hello,
I need setup "relation" between data in combo boxes in access.
I have to sections on my form: Customer and Distributors.
I filled up all data for new customer (name, address, etc.)
...
I have a form that is used for two different things. For one purpose i want certain function to be disabled. For one purpose it is opened in acDialog mode and the other normally. Is it possibl...
hello ....
I use the following code to create a unique form to the current logged in user. This works, however, in a multi user environment I get this run time error (2501): the copyobjec...
I need to make a search form for two different query's. The first one is for a query with these headings: First, Last, Account#, and RMA_Number. Ive tried multiple ways but for some reason...
How can I group items together with a single total in frmEditableTaskReport ?
Please look at the actual form in the attached db before responding.
Hi Experts,
I have a form where the user should choose a value in a combobox field and then after clicking the add button another form will open up. I want this field to be mandatory, the ...
Hi,
I am inquiring for expert opinions of which method is best suited for an Access application that is remotely accessed via a shared drive?
Currently, there is enough rework to be done...
How can i unable right click on reports, so users can not go on design view, or how can i set up a protection, so users can not modify sensitive objects
best regards
I created a database in MS Access. The user states that when they update a record after the update the system goes back to the first record. So for exmaple, in access the user is entering info...
