Search results

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...

Hi guys! I am trying to solve this for several days and i realy need your help 'cause i'm kind of lost.. This is the thing: I have a form with unbound textfields. I built a query that is the source for the textfiels and the form. the form is defined as "data entry=no" 'cause ir sepose to...

Hi! How can I get to the windows copy? Does it runs automatictly - once a night? Where does it keep the back-up file? I don't need the back-up to the db while it's open it can be done when it is closed. I realy realy need some simple instrauctions about using the windows copy- I'm a real newbee...

Hi! I've created an acesss.mdb file and after that i splitted the file to tables file and to the other objuects file. I know that I need to make a back up to my tables file but i've never done this before. I'm using Access 2000 - Is there anyway to vakup the data automaticly let say , once a...

hi! I didn't mentioned it before but the database is well splited, but still it doesn't alow me to open the file from the network drive. It does open word documents that are located on the same network drive but not the access- So i wonder what kind of a security property do i have to change...

Hi! my computer cannot open an access file that is located on a network drive and i don't know why. the file was build in access 2000 and so does my access version in my computer. the error messege is that is cannot open the file from where it's located. why? and how can i solve it. nt the way...