How do I get a row count of records in a list box on an Access 2003 form? Data in the list box is filled by a call to a stored procedure.
I have a table that holds three dates (Stored as Short Date in UK date format). When the record is created, the date fields are blank, however depending on events, one or more of the dates are...
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 ...
This is simple but I can't figure it out. I created a form on MS Access, and I want to fix the AfterUpdate event of a control named UserID such that after entering a value in the UserID, the f...
hi there experts,
this is the second part of a two part question, the first part being here: http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22567060.html .
so i have s...
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...
Am I missing something, or is there no way to display a split form as a subform? When I do that, only the single form view is displayed. Is there any way to make it work?
Hello. I have a Microsoft Access that has a form and a subform. I want to be able to search by a field in the subform and link it to the main form and subform. So if I were to search by sub...
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...
I have a subform that I want to give the user the ability to change the view type of this subform via buttons on the mainform. What is the proper syntax to accomplish this task.
My current ...
How can I call an MsAccess form's subroutine or event from another module?
In VB6, I can declare a public function in a form, and call it from elsewhere. In MsAccess, I don't know a way to...
Hello-I am building a database in MS Access 2003. I have a main form, "frmMain", and a subform, "frmSubDash". The subform is in the main form and displays two items, "txtReportName" and "txt...
Hello,
I have an Access form with three checkboxes and multiple combo boxes. I am adding a reset button to 'clear' the form. All the code works fine until I attempt to set the value of the ...
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...
I have a form with several buttons on it. When the user hovers over a button I would like to have a window pop up to explain what the button will do if clicked. But then when they move away ...
I am trying to use the following error handling code so that if a user wants to enter a brand new client the code takes them to the first field and doesn't let them leave until they fill it ou...
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 list box whose recordset has been set to an ADODB.Recordset
What is the syntax or code for clearing the listbox items ?
Thanks,
I am trying to create a field that would be on the form header that if you type in a portion of the value you are filteringfor it would filter the form on the specified record based on the val...
I'm currently working on a small custom database for some specialized auctions. The auctioneer may sell one, or multiple items at a single price. In fact, during the middle of bidding, he ma...
Hello everyone,
I am working with Access 2007 (completly newbe, so please, answers for dummies) and I am trying to make a main form with a Subform and another within this one. Each of...
I am using the msflexgrid control. I have a grid setup with one column being fixed and one row being fixed. The coulmns are dynamic bases on how many records are in a table and the rows are ...
I use the attached code snippet to change field names and, optionally, to change the field's description. How can I modify the code below to optionally change the field's data type too? Assu...
How can I (manually, in design view) associate a label control with a textbox control, so that (in design view) they both move together?
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...
