Search results for query: *

hi i would like to enter in information into a table via a form, i have everthing okm except for one thing: When i enter new informaiton i want to open the forma nd have a combo box with a list of names from a member table, when i click on that name it brings up that members corrosponding...

i am clicking on the file name through explorer

Hi Guy's, Lately I have been trying to access a file on my network drive. The prblem is when i try to open it a message box appears saying "Cannot access read-only document 'Central code lists.xls'" and when you press ok another box appears saying "Cannot access 'Central code list.xls"...

yes it is correctly mapped.

Sorry CC, but i downloaded the SR-1 and SR-2 and the jetsp 3.5 but that did not solve the problem. I think that the problem is taht i am trying to open a file on a different network drive on a different site, this database opens for their site but not for ours, i cannot figure out why though...

Guys and Girls, When i am trying to open up a link to my database this error comes up "The Microsoft Jet Database engine cannot open the file R:Budget Control. It is already opened exclusively by another user, or you need permissions to view this data." This has never happened before does...

thanks mate, i have done exactly that, cheers

Hi i have a customer table with 2500 entries i would like to somehow have a filter that say's which customre i want and for it only to show the results for that customer. can anyone help me with this ?

hi guy's thanks there is only one problem so far for some reason my spreadsheet is not uploading, their seems to a problem where the data is not matching. But i have checked and all the fields are the same so i am not sure what is happening. So far i have written the macro, it starts working...

Hi guys, what i would like to do is on my form create a button that uploads a excel spreadsheet that adds to an existing database table. Firstly i need the code that does this and secondly i need to know the format of the excess table, i.e. does it have to have the exact same titles as the...

Hi, I got the first message saying that i could not have duplicates. There was no second message. My message that i put in only kicked in when i tried to change to design mode, not when the actual error happened. ?

The message "the changes you requested tot he table were not successful because they would create duplicate values in the primary......" still appears even though i have added the code "if dataerr = 3022 then msgbox "your custom message" response = acdataerrcontinue end if " in the on error...

Thanks very much mate it worked. By the way is their anyway of putting a nicer and simpler message up their explaining why it did not save ? Thanks again that was a great help. Amrit

Hi, For some reason it would not let me save, Did you mean open up my existing table that i have already created. When i looked at the indexes the names were already filled in and their was no drop down menu for "NoDuplicates

Hi Also is there not an if or else statement i can assign to a button that say for example : If Name has more than two of the same applications, bring back an error.

Hi Yeah i am not sure what you mean by " putting a unique key" in the table, can you explain a little more, thanks Amrit

Hi I have a form that rights to a table called NameApps, this table has two fields : Name and applications. The problem that i am having is that what code can i put in the form to tell the user that a user can not have two of the same applications. The d count will not work becasue other users...

Thanks this code was very useful

By the way very helpful, thankyou. In the code though it will not compile, it says that there is a variable not define "mctlDate = ctlCalendar.Value" I don't know why, can you tell me what the problem is and what i have to change.