I have to prepare a form for inputiting a particular piece of information at various tables / fields. Previosely, I had used check boxes for multiple selection and thereafter retrieved the inf...
I have a Microsoft Access 2000 form that has an option group with radio buttons. I just want a 'yes' or a 'no' answer and I want it to be mandatory. So a checkbox won't work. I have the opt...
I need to set a filter on a query so I can run a report from a joined query. I want to do this from a form, since I already have selected a record with the [acct nbr] I want. I just can't fi...
Hi I am using the following code to add the table names of an Access database to a ComboBox
but for some reason the ComboBox remains empty
Private Sub Form_Load()
Dim lTbl As Long
...
Hi,
I have an access application that contains tables linked to an Oracle database. The ODBC driver I must use is the Microsoft ODBC for Oracle. When i sue the attached code to connect to Ora...
I have a form with the RecordSet set to table with an autoincrement field, ID, as the primary index.
I added an acCmdRecordsGoToNew command to the Form.open event. The new record for thi...
I know what is going on here, I just wanted an explanation why? I know the way it works is if a tab is clicked, the user has to actually click on the actual page, not just the tab, for the ev...
Would anybody happen to know of a way that I can have a form automatically display the "Default Value" on some text boxes in a Form?
The default value works like a champ, but the values are...
We have an access db that is growing. The issue we are having as we create more and more forms is a growing lag when switchin to design view on many forms. It also lags a lot when viewing the ...
I have a simple Access database with 1 form and 1 table. I want the table to have a field with a link to an image file and I want that image file to display on the form. How do I do this?
I need to launch Excel from an Access form control and open a spreadsheet that has an Auto_Open macro attached to it without running the macro. I know I can do this by using the /safe command...
Im having a problem with form filters in Access 2007. Ill try to explain it clearly&
- I have a form called Contact General whose record source is the table Contacts .
- On the f...
I'm not much of a MS Access guy, so I may not word this correctly... Here's the rough situation:
I have a three tables (offices, users, trainings) that look something like this:
Offices...
How do I use this input mask 99/99/00;0;_ with Date Time Picker. Whenever I set the input mask the date Time Picker no longer shows. Is there something else I can do.
Thanks
Hello,
I have a form (TestApptDis) which the OnOpen event triggers the RecordSource property
to find the table that equals Date() (the tables for this form are titled with dates).
The form ...
I've been using this function for the longest time without any problems, only now has it been causing hiccups.
it works almost all of the time... the only time it doesn't work properly I've...
Hi Experts,
I have a form frmA. In this form I prompt the user to enter a caseID that will match to myTable.caseID.
When I click on Enter botton on frmA, another form frmB will pop up with...
Trying setup this filter on a form. I got this code from someone that was using an option group in a form to filter the data using a regular field. I am trying to setup the same type of filter...
I have a standard continuous form(appears as a datasheet) with basically every property (record selectors, scroll bars, etc.) set to none/no. I have those turned off because I feel it creates...
I have a database where we store client issues and a data access page where we can view, edit and enter issues. There is a field for clinet name, account manager, account manager phone and ac...
Hey Experts, I am asking this on behalf of a friend.
She wants to change the color of a form in an access 2003 database if it is overdue?
we found:
if me.yourformfield > aCertainnumber ...
In the For VBA Statement below, you can count 1 to 10.
For I = 1 To 10
Next I
I wish to count from 10 to 9 using the for statement, is this possible.
I have a MSAccess VBA application that is querying multiple Oracle tables. I need to allow the user the ability
to update records which are displayed in a continuous subform. I am able to...
Access 2003, this is an easy one for you guys but I haven't done this in years. I have a small Access database and I need all of the records locked unless an Edit CMD button is clicked. Can so...
Hi -
I'm not so good with Access/VBA and need some help. I have a form that has a combo-box and a multi-select list box. I'd like the selected items on that combo box and list box to eac...
