Hello I'm using Microsoft Access 2003 and wanted to know how to get my "Control Panel" form to come up when you open the database. I would like for it to work like the Northwind example datab...
I have a dropdown combo box. A user can either select a date from the list or type on in. The problem is when I start to type in a date, the box auto fills with the bound column which is not...
Dear experts,
I have a web page that I display with an MS access form.
I have done this by inserting a Microsoft Web browser Active X control and placing the following code on click of a...
I have a table that holds three dates (Stored as Short Date in UK date format). When the record is created, the date fields are blank, however depending on events, one or more of the dates are...
I have a popup modal form that incorporates a subform used to search records. Once a record is clicked on the subform, the subform filters a form called frm_LoanClosing. Then the code in the s...
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...
Have the following VBA, built from the wizards. Can I easily add a message box to indicate when input is not found. Thank you
Private Sub Combo32_AfterUpdate()
' Find the record that...
It's been asked before but just in case any one has any bright ideas. Is there any way to hide the Office Button - Access 2007.
It's causing me a problem because I want to allow the edit fo...
I have been pulling [what's left of] my hair out trying to reference a fourth-level-down Sub-Form in a Form using VBA and keep getting road-blocked. Can anyone give me the correct syntax? I ...
I am trying to clone a subform's recordset. The forms recordsource is set through code depending on a combo box.. I want to clone this recordset.
When I use the following:
Dim rst As DAO.Re...
In Access 2000 I created a Tab Control from the Toolbox. It has about a dozen tabs. Each tab has the same exact controls in it (theyre all text boxes with labels). Ive bound the tab to the f...
I've attached my code. I'm trying to findfirst using ado.
On the 'rs1.find' line of code I get the error...
Operation is not allowed when the object is closed.
Can anyone tell me what I'...
Dear expert!
I am stumped on this one - I have a continuous form, and users happily use the right-click on a given field to sort Asc/Desc on that field.
However, there is a combo box on ...
I have a database GUI that I am building for order entry. There are 3 main screens.
Customer SWX: F(x) >> Search for customers, create customers, view their details, and start an order.
...
I'm having an issue with an MS Access (2003) front-end to a MySql database.
Under certain circumstances, I will get the errors
Write Conflict- The record has been changed...
Microsoft ...
I have an checkout form for an Item. The user can enter an item number to select an item. Once they select an item, the "after update" function fires and the "item inactive" field in the item ...
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...
How do I get a row count of records in a list box on an Access 2003 form? Data in the list box is filled by a call to a stored procedure.
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...
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 subform that is a datasheet view of the records in a table. I want to conditionally format the same field in each record depending on its value. I tried going into Design on the sub...
Hi
I have a table which, for this purpose, is accesses via a form. The form has a combo box for the surname (cboSurname), which is used to search the table for a matching entry. I've atta...
Hi
I have a table which has a custom form attached to it for data entry. The spec has changed and I have now had to add subdata into my table. I don't know how to create and attach a form...
I've got a combo box whose RowSource is set in VB, as the contents differ based on the calling parameters for the form.
The combo box is populated with the correct values,and I can pull it ...
I am creating an Access 2007 solution to enter information about Inventors and Patents. One Inventor can have multiple Patents. One Patent can belong to multiple Inventors.
I have set up th...
