I often want to create modal forms in MS Access because I want to be sure that users do not move between forms and change data on more than one form at once - I want them to only make changes ...
I have a form that has its data coming from a query that has a "name criteria". I recently added buttons to the top of the field columns in the form that allow you to sort each field by clicki...
I have a simple entry form that has a "save record" button. Problem is is that when the save record button is clicked, the cursor is no longer in the first field (so the entry person can conti...
Hello Experts,
I've been working really hard on my first Access database.
Everything looked really good, until a few minutes ago. I just realized that my
combo box selections are not be...
I'd like to make some changes to the form's cosmetics. Any single fix will be accepted as a solution and I will post follow-up questions as required.
scaleability:
scale frmTasks to expan...
Hi all.
I have an access2003 form, the end user enters a value in a text box, I want to be able to search a query or table to see if what the end user entered is in the query or table. If i...
Please excuse me as I have very little, actually no exp. with Microsoft Access. This seems like it would be an easy question for you experts to answer, but a EXTREMELY difficult one for me. ...
Hello,
I have a 7 tabbed form that with the first tab being used to select a value from a field in it's subform datasheet view that will automatically populate the same field on the other t...
Hello,
I'd like send access report via email.
Now I'm printing my report. I use command button on access form. My code for printing:
Private Sub Command119_Click()
On Error GoTo Err_Com...
Hi Experts,
I have a form for data entry with a combo box that I would like to display "yes" or "no" from the drop down. When I click it, there is nothing in the text. I tried setting the ro...
My client requires small thumbnail pictures of his product (shoes) on labels that will go on the boxes. He has taken many photos of the shoes - in jpg. No I must link these images to a product...
I have a form based on a query. I also have a list box that lists all the items in the query. I want to create combo box or a list box that will choose a group of the records and just return t...
Hello,
I may have to ask a more specific question- but I am hoping when I explain what I am doing somebody will have an idea.
I usually- when I want a text box automatically filled on a form...
I have a form set up to collect information about a user. Once the user is done answering the questions, they hit a button that runs a macro. The macro is saving the record to a table, print...
Hello,
I have a subform with a query recordsource that I am now trying to allow the user to select multiple choices from combo boxes. Currently, it filters on only one combo box and disable...
Hi
i do not knwo what i did, but all my forms are showing page width, even if i change the format, it's still showing page size.
please give me a hint how to solve this issue
best regar...
i need to open a microsoft office access 2003 form from a button created with vba code in microsoft word document
so basically click on button in word and it opens access and then displays ...
Hi
I have a form which I'd like to use for finding and editing records in the appropriate table. I'd like to be able to display the form with combo boxes for certain fields and then, when th...
I rebuilt my database completely after this thread. http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_23611985.html?cid=748#a22143194
However I am still stuck ...
I am developing a database for my organization to help facilitate ordering parts from our main warehouse. The system works like this; any employee can order a part using a form (not an Access ...
In an Access 2002 database, if a user doesn't enter info into a required box they get a "invalid value" error box, which looks really bad. I would like to know how I can replace that with my ...
Hi Experts,
This one is messy. I have a form with a combobox (cboStaffMember) and a listbox (lstStaffOnCase). I want the list box to populate as staff members are added to the case. This ...
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...
Hello,
I have a subform that is filtered by combo boxes on the main form. This works fine. The subform is based on a query that returns a table.
I now am trying to reset the subform to o...
Hi,
I studied other member's questions that were similar but it's not happening for me.
I have a form (frmSlotRequest) that includes an option group (Slot Status) with three options (1-Appro...
