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 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 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
...
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...
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...
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 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...
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...
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
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...
I am using a text box and a listview control on a form. The user selects an item from the listview to edit, this populates the text box with the text that can be edited. As soon as the user ...
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...
Hi guys.
Right i have a form with a tick box labelled [IN STOCK]
i also have a a field called [date packed]
using expression builder i would like to write an expression that when [in s...
I have an Access 2003 database form. In this form I have a subform. What I want to be able to do is when you click on a button in the subform it brings up a popup form to input information int...
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...
Hi,
I have table and form called CUSTOMER. when user want to add new cusomer they first need to go manually in CUSTOMER TABLE, Go to the Last Record, and get the available number as Cust_ID ...
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 ...
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 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...
I want to create a command button on my access form that when clicked opens a folder on my directory that relates to the record currently being viewd. The name of the folder is the same as one...
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?
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...
How can I force refresh form and 2 subforms in a MS Access 2003 with VB, I created a refresh btn with a wizard and it does not work. Access says "an action or cmd refresh is not available now"...
