My form (frmAccounts) has a control button which opens another form (frmCommissions) - see code snippet.
However, if in frmAccounts the user has not chosen Commissions (AccCategoryID = 1) I...
Hello,
I have a form in Access which has a textbox in it. I have already created some code in VBA to update the contents of the box when a combobox is changed. My question is, when the change...
I have created a Pivot Table in MS Access 2007, it looks wonderful apart from the Totals in the Column and Row fields (I cant get rid of the word TOTALS). I can get rid of the data by clicking...
This question does not relate to the funtionality of my database, but I believe that it will increase the level of professionalism in the database's appearance. I have numerous subforms, all ...
We have a particular form that reads from a table which stores start/due dates for production orders. Those dates change as the quanitty of the production order changes, either longer or shor...
Hi,
I've got a hyperlink field with a browse command button to locate a file. It all works dandy except when i click on the file link nothing happens. if i type in the file path rather than ...
I have an Access 2003 database. The main form has subform that pulls up dr. visits of a patient. In that subform that pullls up I have a list box that lists the dates of the visist so that you...
I have a form I want to display as a sub form on a parent. Things like font size, column widths and row heights seem to have minds of their own! How do I control those attributes of the sub ...
We have just installed office 2007 and are having problems with forms in Access 2007. The mouse scroll wheel will not work. The wheel scrolls everywhere else ie in quieries on tables. any idea...
I have an Access 2007 form. On the form I have a ClientID field. I would like to have a Select Client button that the user will click and open a Select Client form. On that form, I would ha...
I have an Access Form with a Tab Control. I need to run some code AS the user clicks on a given tab.
The change event of the Tab Control will not work but it only fires after the change ha...
Hi,
I have a form in Access. Everytime I need to open Access, then click on the form name to open the form.
How to make the form open automatically when I open Access?
I'm using MS Access...
Using an Access ADP, in 2000 format. I have several forms with check boxes.
These boxes are bound to individual fields.
All works well on each pc, and for nearly all the Terminal Server user...
I am making a form, on which I will have several fields. I am interested in receiving help on 3 of them in particular. Each of the 3 will be combo boxes (drop-down lists). I want to be able to...
I'm currently using MS Access 2000 and created a form with a subform. The subform contains a combo box (cmbTestingTypes) and a text box (txtDuration). When I choose a test type in the combo ...
I have a subform that is based on a query which looks to the value in the combo box.
Combo Box OnChange event contains subform.requery method
The combo box on the subform from a column...
If I did this stuff more than once a year I would not need to ask such elementary questions:
I have a subform listing records and the only field in each record that is enabled is a check bo...
I just found a flaw in my database. Luckily the project about to end so this senerio won't play out but the next project might be larger.
Table A
fieldOne and fieldTwo...
Is there a way to have a subform be hidden on the form, and create a button to show the subform when needed,
I have tried to make a subform a popup, but the parent child link just isn't there...
I am currently designing a set of forms for a quiz. The reason I am setting the quiz in separate forms is so that the person taking the quiz can't easily go back and change his/or her answer ...
i need a button on powerpoint slide to close powerpoint application and open an access form when the slide show is running
tried application.quit but doesnt work
Greetings,
I have a form that contains a subform. The form is generated by a query that pulls from several tables along with equations. This works great and the form and subform works fin...
I have a form. On this form there is a subform. On this subform there is another form that is a datasheet.
My problem is this: How can I force the width of the text box on this datasheet t...
I'm trying to create an order entry form that will ultimately update an order and order item table. What I want is for the user to enter order header details, then a number of order lines. W...
Hi
I have an Access database which I am trying to migrate to SQL Server 2000 for the back end, but keep the front end in Access 2003 for now. We have a query which runs and selects the las...
