Search results

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

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

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

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

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

Hi! Few days ago I wanted to change computer resolution to the resolution My form was builded so I was directed to a thread here that was talkin about the same thing. I managed to change screen resolution At the Application entrance. Now I want to return to the old computer resolution in on...

hi! I made an access aplication in my pc on my resolustion (1024X768) and then i put it on a shared network in the office. the problem is that each one of the users have a diffrent resulotion and they see it diffrently which doesn't look well. I know that there is a way to set the application...

hi! I made an access aplication in my pc on my resolustion (1024X768) and then i put it on a shared network in the office. the problem is that each one of the users have a diffrent resulotion and they see it diffrently which doesn't look well. I know that there is a way to set the application...

Hi! I have a form fthat contains 5 text boexes that are all bound to a table. When i open the form it is full with the details from the table - i would Like the textboxes to be clear when i open the form since the form goal is to insert data to table and not to represent data (at least at...

Hi! I have several fields on my form that are bound to tables. I would like them to be read-only on the form so that users won't be able to insert data from the form into the bound table. Does anyone know which property i have to change to do that? thanx!

Hi! My report always shows a specific record from a table double 20 than it should be (i want it to display the selected record only once -as it should be-and it make it appear many more ) What can I do tp prevent this duplication on the report? is it something that concern with the report...

Hi! I have two tables that each one of them have the same field and I would like one field in table 1 to get updates according to the field in table 2 You can say that I can use a relationship between them, but I have aleardt a one to mant realtion in these two tables so i can't make another...

Hi! In my serach form I have few fields and a button that calls a serach query after being clicked. The search results that appear after that are coming in the reguler table look- because they are being pulled from a table. I would like the results to look better on a report. but if i'm...

Hi! This is what i need to do and i'm not sure it's possible: I have two tables with a relation (one to many)between them. one is retrived directly to a drop down list. I have another drop down list which i want it to retrive the data from the other table according to the user's choise in the...

Hi! I have an excell file which i would like to export to an access table Is it posiible? How is it being done? thanx!

Hi I want my chief form(one of the forms in my aceess .mdb), to be open automaticly when user is pressing to open the access database file . does anyone knows how is it been done? Thanx