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 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 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...
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...
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.
Hi
How do you refer to a form if you have a string variable containing its name
Dim fld As Field
Dim strForm as string
strForm = "Customer"
For Each fld In Forms.strForm 'This...
Hi,
I have an access 2007 form containg drop downlist & inserting data for table.
how do I convert this form to web page
Thx
I am trying to create a Form using the Datasheet view were it will format each row depending on the value in on of the columns. I could use the Conditional Formatting feature within Access if ...
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 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...
I'm trying to apply a form filter using a combo box to my "Carrier Number" field. I'm using a table, not a query because I need it to filter out all the other data so the user can view the se...
I have an Access database with a single table containing 13 fields. I need to design a form which will update its contents when the user changes on of the input fields.
The form will have s...
Hello,
I have a form and a subform. I would like to create a one-to-many relationship, however when I create a new record within the main form, my subform won't allow new data to be entered...
I'm using ADP in access to sql server 2005, trying to get a button click event working. I think i'm missing a reference in the VB editor but i don't know which one. I'm getting this on any of ...
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,
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...
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...
Hi Guys / Gals
I am designing some Access 2007 Forms and when the form creates it defaults to a graphic of a form at the top left, or report etc...
Where can I find some similar icon example...
I use unbound forms to lookup records and it has worked well in Access 2003. I change the .recordsource on the subform using a sql statement and then do a .form.requery.
This no longer works...
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...
Hey All,
I am going to be running a simple DB in runtime mode so the user won't have access to the toolbar, therefore I need to create a button so they can sort by certain fields...
I wa...
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 am working on a tight deadline for this project and can not seem to find an answer to this one:
I have a sub-form where I want to use an IN clause to limit results to specific clients selec...
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 guys
Problem: Access 2007 does not appear to allow me to size forms in Form Design, so when I open a form modally it is those exact dimensions.
I have recently discovered Access 200...
