Recent content by webcrab

Well.. That worked only now i can't browse back and forth (with customized buttons) in the older orders .. that is why i thought of catching the specific error (2105) Is there anyway I can fix this out?

Hi Rob! well, all the things you wrote are true but i have noticed two things: 1.At the last row of the code I have to use the control name for the undo and not the fieldname in the table so I think it should be: Me.Order_Id_text.undo instead of Me.OrderId.undo Because It doesn't...

Hi Man thnax! But the problem is that the MsgBox Pops in every number i Put in - including the ones who aren't in the table yet.. Am I doing anything wrong here? My field name is: OrderId My table Name is: Banks MytextBox name is" Order_ID_text I shell say that the order's number is a string...

Hi! In My Form , there is a textboxe that get's orders numbers. this textboxes is bound to a unique field so if the user writes a number that is already in use there is a pop messege that says: "you can't go to the specified record." The Pop up messge pops afetr clicking the "add Order" button...

And How do i write that in vba?

Hi! I have a form that contains bound textboxes to a table and "add record" button that subbmitting all the textboxes.text into the table. My problem is: every time i insert simple text in one of the text boxes by mistake the text is submitted to the form without clicking the "Add record"...

yes please..

Hi! Actualy, I just don't want the user to put the text in and when he click the submit button there is the error (you can't go to that record) I want it to happend after upadate the specific textbox

Hi! This is the thing: I have a form with bound controls to a table. One of the textboxes allow the user to put invitation number. I want to assure that the user doesn't submit a number that is already in the table. What can I write in vba that would look for the user input in the...

Thanx! Thanx! Thanx!

Hi! I'm using aform with bound controls that are bound to a tacle. I put this command on the open event of the form inorder to open the form with blank controls: DoCmd.GoToRecord , , acNext It worked but from some reasom it doesn't work anymore and every time I open the form I get all the...

Hi everyone! I realy realy nedd help on this case: I tryed to use the user leve security wizard and made some terrible mistakes... I've created new users in the useres group by mistake using this wizard and gave the user name and password and now when u'm opening the db i have to log on as one...

Hi Guys, From some reason, when I'm printing a report with recordes that come out from a search form , the report comes out like this: 1.report page 2.blank page 3.report page 4. blank page and so on. This thing apper also in the view-before-printing mode . I do not know why this problem...

Thanx guys your great- all i needed was the combox solution and i guess the form was bounded..

Hi Ray, well, this is the thing: I'm have 3 textboxes on the form 1. id 2. name 3. last name- I would like the user to write an id number in the textbox and that the name and last name will apear in the other text boxes as a response to that - they are all basicly coming from the same table...