I have an Access 2007 form with three tabs and lots of checkboxes.
It works, but navigation between forms and the display of controls is very slow.
Is there a way to speed things up?
(the d...
I have a form with two subforms, "People" and "Donation History".
On the main form is a combo box ([statsel]) with which the user can select a "status".
After updating the combo box's va...
I've got a mainform + subform with an optional command button to bring up a datasheet view.
The datasheet form (no edits, no deletions, no additions) opens just fine but its closing has a n...
I have a Report and a sub-report that I would like to make certain fields visible when the report opens (loads?) depending on the results of a query.
So, I have this code OnOpen event in the...
Need assistance with the code to be attached to a command button on an Access Form:
The code could retrieve the email address field from a record set on an underlying form. I want it to loo...
Hello,
I have a Form named: "DATA-BARCODE_SCAN_HISTORY" with a few fields, in this form when you type a Barcode number into the entry field (or scan a barcode with a scanner) it should then...
I've got a unbound Access form with a subform based on an ODBC linked table. Users add records to the subform, all good.
But...if -for whatever reason- they've started to enter a record b...
Hello Experts
Old problem with the date formats. Just can't sort it out no matter what I try.
I have a cell on the form which will indicate the date, when you open the form cell will be t...
I have a form that I want to disable buttons when a new record is created. However, when I load the form it gives me an error "invalid use of property" while referring to disabling one of the...
Hi Experts,
A student designed a club.mdb (VBA), a teacher converts it as a frontend for the faculties to use and input the data, the school SQLServer would be the backend by using ODBC. T...
I have a form in MS Access with two text fields, I have tested this problem when they are bound and unbound and the same thing happens. I have included a screen shot of the error I get. The sa...
I have a form that has a subform. The subform is based on a query which is contingent upon the data of some combo boxes on the form. I want the subform to refresh every time the user changes...
I've referenced the datarepeater control (the old one not the new one for VS 2005 just released) in my Access 2003 VBA project. However after referencing it, I can not find the control in my ...
I have a main form that seemingly disappeared. The form name is still present in Access's main control/dialog box but when I double click on the form name or attempt to open in design view - ...
MS Access 2003 - I am creating a dashboard in a database and need an odometer or somthing of similar nature to display the following:
calculated value for three different values coming from...
I have an Access (client -server) database.
This database has a reference to a library:
Microsoft RIch Textbox Control 6.0 (SP3)
The location of this library is:
c:\Windows\Syste...
I have a table that stores a general date in a field. I have a form that I would only like to show the date portion and not the time. I have tried formatting the field in the query to short ...
Access 2003
This following code works. I would like to take out the on error command.
The problem is that the expression rs(Mid(ctrl.Name, 3)) may evaluate to a field name that does not ye...
I have a EXCEL file which contains a lot of calculations in multiple worksheets. But as the file gets bigger and bigger, the file runs slower and slower. I am thinking to convert it into ACCES...
I have an access db with the details of people who have applied to be interviewed. The details are all in one table, called Mailing List. All qualified applicants will be interviewed. I'd li...
I am a nurse trying to make a database for HIV clients in Zambia (IT is not my specialty!) I want a list of outcomes to appear in the 'outcome' field on my form - discharged, died, moved away...
I have a form that has customer information and a field for rental equipment to specify how many of each item the customer needs.
For example the booking person types in 15 of a certain item....
I have a form with a number of sub-forms.
When adding a record to the sub-form "frm_Sales_Sub1", a particular field "X" in this record should be automaticly filled - on the background - wi...
Dear Members,
I have a serveral backend databases in SQL-server and use Ms access to use de data from the diferent databases. I create forms and code from my developer envoirement and like ...
I have an Access 2003 form that has some unbound text boxes and some buttons. One of the Unbound Text Boxes contains a String that is based on another text box. The text box named perEndDate...
