Search results

Ozzi, thanks Problem is the damned printed number started with 800. Damn the Headquarters! That's why I am worrying about loosing the sequence of number and avoiding using the Autonumber as the PK in Orders Table. Anyway, thanks guys. Probably, I'll try to redesign the database and return in a...

Originally, I did not think I'd give user the right to enter a new order number, CJ. Problem is we were given a kind of preprinted receipt with the numbers already there on the form, and each users would get a different bunch of them although the receipts are incrementally counting. That's why I...

CJ_London, Here is the sample database as you suggested,

CJ_London, please help, I change every thing in the suborder_code, adding an 'a' to the blank filed. but still stucked with question how to make users not to repeat an order twice. What Should I do next?

Thanks CJ_London, I have done as you suggested in your previous reply, put the code in to beforeupdate even on the form. But it still didn't work, stoped right at number 1000, although the order number is 1019 :( So, I corrected it by change all the Order_Code into Number, and subOrder_Code into...

CJ_London: where do you suggest me to put this code on? And besides, I do not realy understand your suggestion of "making primary key over two fields." Please explain a little bit more Thanks

Thanks for all the tips. Here is another question: I dont want my users to mess up with the new sequesce of Order_Code (Order_Code and subOrder_Code put together), more precisely, I dont want that the users may accidentally repeat the new sequence twice, let say twice of 1000b. Is there any way...

Yeah I start to see the problem: 1- I make the property for the Oder_Code in tblOrder as text instead of number 2- I also messed it up by mixing number and text together instead of make them in separate fields. Now, I'll try to do this: 1- Convert all values in the Order_Code to Number and...

@pbaldy: thank you sir! Is there any way to go around this situation?

@Ozzi, thanks for the tip. Actually I set the Order_code in table Orders as text, the reason behind it this: My people at the office has been issued with a kind of pre-printed receipts (the number on that crazy thing is PRE PRINTED). However, orders come in with diferent kind and with 1 check...

Hi this is what happening: 1- I created a field Order_Code and intended to make it increasing by 1 each time we add a new entry, it is a kind of simply counting like 1,2,3. 2- So that I put the above codes in the "afterupdate event" of the Order_Code. 3- At first, it counts ok from 1-999, but...

I put this on the form so that it can make number a new record. It stops at number 1000 and keep telling me No new record can be added because this would create a duplicate in indexed field . This is realy weird. Some one please help!!!! Private Sub Form_Load() Me.Order_Code =...

Not sure if this is can be done: I have a picture and I want to change its color in accordance with values in another textBox. Is that possible? if Yes, then what would be the procedure and the codes?

Yeah namliam, I am trying to do just that. Problem is not sure, how to go around with Null value on the form.

Thanks guys, any way that I can put in the query criteria a Part of the field? like all customer started with P? Moreover, I also want to put some thing like: if the user does not fill the name of the customer on the form, then by default ALL customers would be sorted out in the query

Paul, thanks a lot for your advice! :cool: One more question: It's OK with the form and query now, but how can I do with report? I have a report based on the Invoice Query and I want to print out this report with the date range in the DatePicker. Thanks again!

Paul, Here is what I've done: 1- I created a form as you suggested, named it DatePicker. And I put 2 Textbox: Date1 and Date2 in the form (both have control source with Order_Date) 2- Then on the criteria of the query I put Between Forms!DatePicker.Date1 And Forms!DatePicker.Date2 (under the...

Thanks, Paul. Not sure if I described it clearly! But situation is this: I have a query, say, Order Query, with Order_Date, Order_ID, Customer_Name etc. I want to enter a range of dates into the Order_Date, i.e 10/7-10/8, as a matter of course, I follow the MS instruction, put in a kind of...

I have a query and I want to make a certain range of dates for the query to run. For example: from 10/6 to 10/7. Can some one please tell me what would be a parameter for this range of date? Should I put it on a query? Thanks

Okay, here is the situation: On the form Order, I have a combo box called Customer Name (look up from Customer Name in tblCustomers). So that I put the codes as indicated above in NotInlist property box of the combo box Customer Name (I want it to open the Customer form whenever a new Customer...