Search results

I have several forms that I have put together on 1 form using tabs. They are linked using an OrderID. One of the subforms is linked using the OrderID as well as the CustomerID. The reason I did that was because the users need to see the customer data (Name, addr, contact numbers). The...

I have a form with customer info and a subform with details. I need certain fields to be filled in by the user before they can proceed to the subform. How do I set something up that will notify the user if a field is left blank on the main form?

I have a text field in a table containing ID's. The ID's look like this - 1234 R25466 RMA987456 C87546 I am trying to create a query to strip off the letters. Here is what I have right now - Expr1: IIf([test2]="A" Or [test2]="C" Or [test2]="F" Or [test2]="H" Or...

Let me explain a little more - I am creating a way to process RMA's. The table Customer_Order is a linked table from our MRP. The Order_ID is text. We need to use Access because of the unique way we ID our RMA's. An order has to be created in the MRP to process an RMA. So essentially the...

Here's what I'm doing - I have a series of queries that run to give me a unique number in text format. I would like that number to go into my ID field after I update the CustomerID. The CustomerID is a combobox. Is this possible? Here is the code I have to just run the query after the...

The field is set as text - would that make a difference in VBA?

I have an ID field that is text. Here are some example ID's. The number is generated automatically and the letter is added by the user. A10565 52073 C20633 RMA18941 I need to start numbering new id's automatically. I don't want to repeat numbers so I need to know which numbers have been...

I've never done a data definition query. Do you know of anywhere I can find some documentation on how it works?

Actually I do have the RMA_Type stored in a different field. I am only adding it to the ID after updating the RMA_Type. Sorry I should have mentioned that. Private Sub RMAType_AfterUpdate() Me.ID = Me.RMAType & Me.ID End Sub The ID field is a text field. The table is a linked table from our...

I've used the Dmax function in the past but since the ID field is stored as text I can't get the Dmax function to work. Here's what I have- Private Sub CustID_AfterUpdate() Text115 = DMax("ID", "Customer_Order") + 1 End Sub After I update the CustID I get a Run Time Error 13 and I click on...

I have a form to enter RMA data. I need to start my numbering at 4000 without using an autonumber. The ID field is text and cannot be changed. The Customer_Order table is a linked table. A letter is going to be added infront of the ID depending what the user chooses from a combobox. The...

I have a form that has a linked table as the record source. The linked table is in our MRP application. The ID field is text. I need to have all new records being entered start at ID = 4000 then go up by 1 each time a new record is entered. How would I do this? I know how to set the initial...

Ok, here's my issue - We need access to generate a unique number for RMA's. Then we take that RMA# and put it into our MRP system to finish the RMA process. I am trying to figure out a way to get the RMA# and some other data into our MRP without having to go to both applications. Here is...

Ok I have changed things a bit. My RMA# is now a number generated using the Dmax function. I was using an autonumber but after doing more research it sounded like the autonumber wasn't the way to go. I thought maybe the autonumber may have been causing issues. So I tried to append the data...

You are correct - the OrderID is the primary key in the Customer_Order tble. The OrderID field in tble2 is a combination of an autonumber (RMAID) and an RMAType (A,C,or R). The new OrderID for example - A4008 is not in the Customer_Order tble. I searched the Customer_Order tble and wasn't...

Harvy Keitel -- National Treasure

I have a form with a command btn on it that runs an append query. I am appending data from tble2 to Customer_Order. Customer_Order is a linked table from our MRP application. I'm only trying to append 5 fields right now. They are the fields that are required and won't accept a null in my...

I've been creating a new Access application and I've run into an issue. The form I created has 2 subforms on it. The data is stored on 3 different tables related by the RMAID. The data gathered from this form needs to go into our MRP application. I have linked the necessary MRP tables to my...