Recent content by delaikhi

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