Hi Experts,
I have a situation where a cilent needs to print out a screen shot of the form. She has reports, but there are times she wants to print the form. I would like to do two things...
I have a form with a text box control.
The textbox controlsource property is =MyColumn
The form recordsource is not set in design mode.
The form load event sets the form.recordset to a cr...
Hello Experts,
I am creating a brand new database and my very first form.
It is a very basic form with only 2 fields displaying. For some reason the I can not get the page header to disp...
Ok so I have a form that currently has all the numbers on it i need to perform the "Look up" that I want to do. so here is the nuts and bolts of it. this for basicly came into existance becaus...
Hello. I want to create a form in MS Access that does not require the user to have access installed in order for them to enter data into the database. I heard this is called a runtime form b...
I have a very complex database that does not requrie explination. Within this web of database h-e-double-hockysticks is a very simple table with some simple forms.
The table is a notes tab...
I am coding a simple data-bound form in MS Access.
Two text boxes, one bound to a date field (txtDate1) in the underlying query, one unbound (txtDate2).
txtDate2 should set itself to txt...
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 don't understand what causes this, since I have not added any code yet, and it seems to be an issue with the sub-form or its detail properties, however I have attempted changing each by tria...
Hello I'm using Microsoft Access 2003 and wanted to know how to get my "Control Panel" form to come up when you open the database. I would like for it to work like the Northwind example datab...
Hello Experts,
I created an Options Group, with several radio buttons (option buttons).
I've been asked to add additional options to this Options Group.
Other then recreating the entire Opt...
I want to create a shortcut in Excel that will open a database to a form. I currently have shortcut that looks like this"F:\FrontEnds\Inspection - Front End\F824000.mdb" but I want the hyperli...
Hello,
I have a main form [frm_leads] that has a combobox [cboVoidlead]. This combo box has two values 'yes' and 'no'.
I have a subform [sFrm_leaddetails] that has a combobox [cboLeadout...
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'm sure this is easy just never done it before. I have a bound form and want to select a value from a combo box and have the form go to the record associated with the combo box value by way o...
As a relative novice I am trying to develop a solution in Microsoft Access 2003 and have now reached the limits of my capability and therefore require some expert knowledge.
The solution fu...
Hello Experts,
Okay, I am stuck on this one. Please see my attached code snippit.
Explanation:
Combo79 is populated from values in tblSET_STRATEGIES. This table has two columns: SET_ST...
I have a list box whose recordset has been set to an ADODB.Recordset
What is the syntax or code for clearing the listbox items ?
Thanks,
I have a combobox on a continuous subform. I would like the dropdown list to be different on each record depending upon another field in the record. I have a query that accomplishes that (see ...
Hoping this is simple
I have a field in a form and a record(string) in that filed and when I double click on the particular record in that filed (note it is a continous form) I want the stri...
I have installed Access 2007. In Access 2003 I built a db application that has alot of VB code and works great. I open it in 2007 and nothing works. I built a new db in 2007 with VB code an...
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...
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...
This is driving me bonkers! I have an Access 2007 database to track engineering requests. I've completed 3 sections and now the 4th section (other than storing different information, they al...
1. I have a query that has parameters on two fields - one is on a company field and another on a date field. The parameter on the date field is as follows:
Between [Forms]
