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...
Hello all!
We have a form that contains a subform (in datasheet view). I would like to put a button control on the form that, when clicked, sets the sort order of the subform to a differen...
This is a strange one and I've tried everything I can think of to resolve it.
I've got a (simple) multi-select listbox that should display two fields, but it's only displaying the data in c...
I have a form that I want users to open from my switchboard when they click a button that says "Add / Edit Demographic Info". I have built the form and the form opens from the switchboard as ...
I have a report that I need to display the criteria used to compile the report. I would like to be able to show the criteria in a footnote in a format such as below:
Year(s): 2005, 2006, 20...
I am often frustrated by the lack of options on the access checkbox control -- the size and color are completely non-editable. Is there anything that can be done about this? Any third party ...
I have crated a database from new, I have picked Date Picker in the table and on the form, I have placed a date format in the table to 01/01/2008 format. How every my Date Picker does not come...
My Order form has a combobox called cboOrderStatusID.
The underlying table has 3 fields OrderStatusID, OrderStatus and OrderStatusType.
If the Order Status entered is not in the list, th...
I am creating a database using MS Access 2003. I created a data entry form with several command buttons. I am having an issue with the "Cancel and Close" button. What I want is even if some...
I currently have a main form 'frmBOMtest' that has two combo boxes. The first filters item classes, and the second box then would show the available parts with the class selected in the first...
I have a combo box that is pulling data based on another entry on a form. The only issue is that the values that it is pulling from a table are values separated by comas, (i.e. 9.1, 9.3, 9.7)...
How can I successfully get the IIF function to return, in a certain true condition, the is null criteria in a query so that the query in that particular case shows just the null records (and s...
I use activex Microsoft Forms 2.0 Spin Button to adjust dates in a calendar form via VBA. This works fine in access 2003 but does not work in 2007. Click on the control and doesn't go anywhere...
I have created a search form by which users can enter either an OfficeCode or employeeID number to open the frmOfficeMain to the appropriate office. When I search by OfficeCode the after upda...
Hi,
I am using the attached SendMail codes from in my Access database to convert report to a pdf file and then attach a new mail as attachement.
I would like to know if I can update it ...
Hello,
I am in the process of converting our MS Access 2003 databases to 2007 version, but I am having issues with the user's and permissions options. I know that 2007 does not support that...
I have an unbound list box that was populated by an ado recordset, then disconnected. When a row is selected, I would like the user to click an arrow button to apparently move the selected ite...
See attached picture. How can I get rid of that border around the form? I already hid the other controls...just need to get rid of this:
In MS Access how can I stop the user from losing focus on a text box if a condition is not met. For example if the box isnull I want a message box to appear and the user still be in the text b...
I want to a have a GUI in access that will have different buttons that will connect to different forms within the same .mdb. How might I go about doing this
I have a sub form in Access 2007 in a main form, its fun off a field called Part Numbers, when each of the same part numbers are entrered the sub from works well for me, however I would like a...
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 query named Qry_All_sAcctNum_For_Form_Unmatched with the following SQL
SELECT Tbl_Unique_sAcctNum.Unique_sAcctNum, Tbl_Unique_sAcctNum.Type, Tbl_Unique_sAcctNum.Discrepancy_Amount,...
Is there a way to change the rowsource of a subform?
I have an In/Out board subform whose rowsource is contingent upon a combobox in the parent form.
The records in the combo box are peo...
Hi,
Im trying to create an email form in my cutsomer contacts database. The form includes a [To] field, a [message] field and a group of tick boxes which will allow the user to select PDF ...
