Search results for query: *

Hi, I have a similar problem to a closed thread 700-1354784. Where the tables in my relationship window have moved off of the screen and i cannot move the scroll bars any further to the left. There are 15 or so tables that have done this. Does anyone know how to access/move these tables into...

The Missinglinq Quote: "The technical issues aside, I think you're missing a very important point here" No i think you are, i asked a technical question. Can you help?

ok, but does anyone know if you can set the password via vb on a form/ module? They have to have full rights initially that's the problem i've got

The thing is i need the third party people to be able to look at the structure of the database initially, but after a period of time they should have looked enough and then i want it to effectively stop working, i don't think they'll be good enough to crack the password once it's set

Hi, I've got a database which I’ve been working on for a few years and as such it's got quite large and useful for the company I work for and they want it to be assessed by a third party, which I’m not too keen on as I can see it getting used by the third party elsewhere (you know what I mean)...

Already checked the references, all seems fine

Hi, I've made a database that incorportates the Date() function in serveral queries and vba coding and it all works fine on my machine. I copy the database over to someone else's machine and when they try and use it an error message keeps popping up saying the Date() function cannot be found...

Thanks for advice zionman4 and payback, i gave up with printing the query directly and found a useful bit of code for defining text boxes on a report at runtime and hiding the ones not used, so i can print the report in landscape no problem

thanks Zionman4, unfortuantly i'm getting 'Method or Data member not found' run time error, do you know what libary i should reference for this method?

Hi, I'm trying to print out a report automatically after a sequence has run and the code below works fine except the report really needs to print out in landscape and not portrait, the code below opens the query in preview mode, prints it and then closes preview mode and the display then...

Sorry tried a few things but didn't consider the setFocus that seems to work fine whoops!!

Hi, I want to navigate through tab control pages using buttons that i have placed on the form and not the standard tabs can anyone help. thanks

Hi i'm running the following sequence and i keep getting 'Object invalid or no longer set' coming up at the points indicated, for some reason access keeps forgetting that the MyCurrentValues table is open, or am i just missing something really obvious here.... Set MyDatabase =...

Hi, I'm using an input box to get passwords and therefore control who has access to certain areas of my database, the problem is that when the password is entered any one else can see it. Is there away of using **** to denote the characters entered

sussed it just have to use the doEvents command

Hi, I'm looping 2 fairly large tables say 10000 records in one and 3000 in the other and when it runs windows says access is not responding -which it isn't windows just thinks so. But the problem i've got is i want to run a progress bar which consists of a box which grows in width and a label...

Hi, I'm trying to undo changes on a sub form if the property 'Dirty' has been triggered but as soon as you move from the sub form back to the main form the 'Dirty' property is reset and the undo on the docmd is no longer usable, any suggestion?

Hi, I'm trying to export some fields to a text file as a string and the data is getting "" around it in the text file can i stop this from happening?

Thanks Bob what an excellent form that is

Hi, I've got an access database which is used by multiple users and on occasion i need exclusive use of it and have to do a bit of chasing around to get all other users to log out, does anyone know of an easy way to do this?