Search results for query: *

Hello, I was wondering if I could get help on this problem I've been trying to solve for a while. I'm making a Service Order Entry Form for our Warehouse to use. I have a form with 2 subforms on it. The first subform is in datsheet view and contains about 8 fields. The last field in this...

Hello everyone, I'll try to be as clear as possible. I have two subforms attached to a form. The first one contains many fields, one of which is called "notes". The second subform is just made up of one field by the same name ("notes"). The first subform only shows a...

Hello Everyone, I was wondering how I could get a Save Prompt ("Yes" or "No") to come up on a form when a command button ("Close") is pressed. The button is already attached to a Macro that brings a prompt up if there is a change in the design view of the form...

Hello Everyone, I have two forms. The first is in datasheet view and has a column entitled WorkOrderNo. When you double click on one of the numbers in this column, the second form opens (form view) to the corresponding record. My question is: What code can I use to make the...

Hello! Hope everyone had a good weekend! My question is probably a simple one for most experienced Access users. I just need to know how I can print a specific report by pressing a command button of a form. I've already created the button, the only problem is that it prints all the records...

Hello Everyone, This is probably an easy one but I don't know it. I have a Service Order Report that is linked to a Service Order Form. The Form has two subforms. Basically, I just need to link the subforms to the report. I tried the expression builder in the appropriate fields' control...

Hello, I have a "Service Order Entry" Form that I'm making for the warehouse here at work. On this form I have a tab control with 2 tabs. Each Tab page has a subform on it. The subforms are called "MemoItems" and "Tasks". The field on the form just before tab...

Hi Everybody! I just finished searching the FAQ but I couldn't find an answer to my question. I have a form called "Service Order Entry" which contains one subform entitled "MemoItems". After I enter the subform by using "Tab", I am not allowed to tab out of...

Hello Everybody! This is Mattmeat. I have a form called "Memo" that has two fields. One field is the "Memo" and the other is Username. Upon pressing Enter in the "Memo" field, I need the "UserName" field to update the Environ UserName. So far, I have...

Hello Everyone! Mattmeat Here! Here's my problem: I have a "search" form and a "destination" form. The "Search" form haS A FILTER and the code looks like this: Private Sub WorkOrderNo_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As...

Hello Everyone!!! It's Mattmeat again... I have this code in a datasheet form: Private Sub WorkOrderNo_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String stDocName = "WorkOrdersWorkingTwo" stLinkCriteria = "[WorkOrderNo]=" & Me![WorkOrderNo]...

Hello Everyone, I am still making a Service Order Entry Form for our warehouse here at work. The last text field on the bottom of the form is called "Memo". Right under the "memo" field is a combo box with employee intitials. First, I needed to get the "memo&quot...

Hello Everyone! I have put a cmd.requery on a save button in my Service Order Entry Form. When, I requery, I am taken back to the first record. All I wanted to know was how to requery in this form and stay on the same record. Thanks, Matt

Hello Everyone, I am working on a Service Order Entry Form for our warehouse. I have a combo box called "CompletedBy" and next to it are to disabled text box fields: "Date" and "Time". All I need is for the Date and Time to fill-in the "now" time when a...

Hello everyone, I am trying to make a Pre-receive form for our warehouse. I have a combo box called "ITEM" that drops a list of of item numbers. The two fields that follow this combo box on the form are "Description" and "MFG". I really need the latter two fields...

Hello, I have two forms that I am working with. One is a form in datasheet view, and the other is a WorkOrderEntry in form view. In the datasheet, there is a specific column called "WorkOrderNo". This column contains the numbers I would like to use to open the other form, with the...