Hi Experts,
I want the matching value in a list to automatically fill the field area when the user is typing in a combo box field. I have autoexpand set to yes, limit to list set to yes, b...
Hello -
I've upgraded a 2003 database to 2007 and am attempting to change the background of a form depending on a filtering choice made in an option group.
My problem is that my BackColor P...
Hi
i have a field [ampm], this is a yes/no field; is the job was done in the morning, this field value is yes, if it was done in the afternoon, the value should be no.
in a form, instead of ...
In a Access 2003 FormProperty Event, I need the change a "Text" box value of the Form's current Record and save the Record. This will take place before other SQL copied the values of the open ...
In my system I want the user to be able to set the systemfolder so the database, templates and other files can be moved. Today I use only a textfield, but it would be nice if the user could ch...
I had a working subform pulling data directly from a table (vs. a query) and it was working fine. I decided to change the order in which data was displayed by basing it on a date field. Afte...
Hi Experts,
I need help with my filter to select a record from a list box. I have two separate command buttons that perform this task in different ways, one works (cmbEdit) which filters t...
Hi Experts,
Thanks for your time in advance.
I am having some trouble referring to a control on a subform. I am trying to set the row source for a combo on a subform using the value sele...
I used the Form Wizard to create a subform with an attachment field. The attachment field doesn't work in the form. Can anybody help me?
I have a query (below) where I need to create a text box on a separate form that will display the Sum of the "Count" field. I made a new text box with =Sum([Count_age]) as the control source ...
Need to know how to add a checkbox, and when the check box is checked, insert current date into the date
field box. How do I do the statement in the expression builder?
Hello Experts.
I am dynamically filling a combo box based on a selection in another combo box. On the first selection, everything works fine. However, if the user changes his mind, I want...
Hi everyone,
I just wanted to know how to limit entries in a subform... I was trying this:
Checking the amt from the main form and once it hits 3 then trying to turn off allow additions......
I have a for that has a drop down box and I have a qry the looks at the name that is in the drop down box and returns data based on the choice. I now need the qry to run when that box changes....
Hi,
I have form with a few search text boxes on. Also on the form is a sub form (frm_Contacts_Sub) which is a contiuous form with tbl_contacts as it record source. I have used a continuou...
Hi
I have an access file that includes names and addresses.
THe addresses are in separate columns ie 111 North Orange Street
I need to combine them into ...
Hi
I have a form with a combo box. This brings up multiple fields so that the user can select the appropriate record and then edit it.
The user may wish to access the data sorted by dif...
I'm trying to close the database after so much time in idle due to the amount of users wanting on the database. Here is a code I pulled from the Microsoft office website but there are some ad...
I have a code I have used to filter multiple things in my database. I am now trying to filter a check box. My table is set up as a yes/no check box and my form I'm putting a check box.
Ba...
Hello experts,
I have a list box that shows the result of a sql query. I also have a combo box where the user can pick a category and press a button. When the button is pressed, I want the li...
I am trying to prevent end-users from using the copy/paste function to enter data into an MS Access text box.
How can this be accomplished?
Working in Access 2003 .. I have a database that has a custom global menu bar that is displayed fine, available for any form that I open. But I also want a menu bar that will attach to a sing...
How do you set the tab control on the last record of a subform to go to the first control on the main form?
I want to open a popup form, however I do not want it to be visible at first. Opening it with the acHidden option, it will open visible then hide. The result is that the form flashes up on the...
I have a form with 5 subforms. The form is a heavy data entry form so the users want to be able to tab between all the fields and subforms without using the mouse.
I found some posts on EE...
