I need to change the background color of a continuous form, showing them in groups of five. Similar to the old continuous feed green and white printout I need to have the first five records co...
I have a list box whose recordset has been set to an ADODB.Recordset
What is the syntax or code for clearing the listbox items ?
Thanks,
I have installed Access 2007. In Access 2003 I built a db application that has alot of VB code and works great. I open it in 2007 and nothing works. I built a new db in 2007 with VB code an...
I have a form that uses two combo boxes to seelct criteria for a query. Then in a subform I use the query in a combo box to make a third selection. However, whenever I make my first two sele...
Hello. I want to create a form in MS Access that does not require the user to have access installed in order for them to enter data into the database. I heard this is called a runtime form b...
Hi,
I have designed a db in access that uses 2 popup split forms. I am having problems getting the popup split forms to keep their size properly. They seem to resize themselves at will. Even...
I've got tabs ("pages") that have data and/or subforms on them. All of them work great. Except when I want a subform to show up in datasheet view. I need them to show up that way. But when...
I have a main form linked to a subform (single form) with a one to many relationship. For example, My form and subform are linked only by orderID. The orderID number from the main form displ...
Hi Experts,
I have a table with several fields that need to be limited with how many places can fall to the right of the decimal. For instance, one field can have four (3.8969) and one fie...
I have a Microsoft Access 2003 database.
There is a table Customer that contains a field CustomerName that has data type=Text. In the table definition, the Format value for that field=> (d...
I am working on a pivot chart for a presentation next week. the problem that I am having is that I cannot find the place to change the legend captions.
On most charts the caption is not ...
I have a form with a subform that has 6 fields. I set the tab properties on each of the fields so it tabs through in the order we want to enter data. The problem is when I leave the subform an...
I have attached the basic relationship view of the relevent tables.
What I would like to have, is in a data entry form, have say a dozen check boxes (for a dozen different functions). The ...
Hi Again,
I am trying to append a unique invoice number into my an existing table. I have a tbl_InvoiceNumber and tbl_OrdersPlaced. I want the first order to start with the number in my t...
I have the following the following tables: tblCalls, tblCallers, tblProspectiveResidents, tblWorkOrders, tblResidentRequests. The last 4 tables are linked to tblCalls via a CallID foreign key...
I have a form that has several subforms. I am using a filter (cboContactTypeID) which works perfectly:
Private Sub cboContactTypeID_AfterUpdate()
'This code filters the Contacts form based ...
On a subform I fill in records.
I then click a button called 'Calculate' which does a Me.Recalc on the form.
However, when the subform recalc's it does not go back to the First Record, inste...
This database (attached) records how long a particular task has been 'active' and is indicated by the check mark in the frmTasks 'active' check box. Notice though in the screenshot (also atta...
Hi
I have a date time field updated by txtbox on a form.
To make it easy for the user i would like to have two txt boxes on the form
The first one shows todays date but when you select it...
In my Access database, the combo box is previously linked to tblOrders:
SELECT tblOrders.OrderNo FROM tblOrders
However, this table contains hundreds of orders, it's difficult to find the o...
I have a form that I programmed to change color when it is printed (to save on toner) then to change back to the original color after printing. The problem is I have a subform with the same co...
The contents of alll the drop down lists disappeared recently from a form in use for over 10 years. The form pulls the lists of items from different tables. The tables look OK and the items ar...
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).
It is a very stupid question, but I am running out of patience looking on experts and google because I don't know how to express myself well enough to find useful answers. Supposely this shoul...
Hello Experts,
I created an Options Group, with several radio buttons (option buttons).
I've been asked to add additional options to this Options Group.
Other then recreating the entire Opt...
