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

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

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

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

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

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?

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?

Hi, i'm using the following code to retieve a file name Set exApp = CreateObject("Excel.Application") strFileToOpen = exApp.GetOpenFilename("Picture Files (*.jpg), *.jpg") but i also want to copy the file to a new location i've tried to use the copyfile method but i'm not exactly sure how to...

Hi, I'm using the GetOpenFilename method of retrieving a file name see below: Set exApp = CreateObject("Excel.Application") strFileToOpen = exApp.GetOpenFilename("Picture Files (*.jpg), *.jpg") and i want to look in an initial directory/folder for these jpg files - any ideas?

Hi, I've got a form, which has a tab control on it. On one of the pages I had several text boxes and combo's which each had related code, I moved these from one page to another and for some reason their (text boxes and combo's ) associated code/ events do not run, the only way I’ve found around...

Hi, Is there a quick way to change the case of text in cells in an excel worksheet from lower to upper and vice versa?

Hi, I've got a form based on a table which i want to open for one record only in edit mode. However when i'm looking at the record and i move the mouse scroll wheel down, the form moves to a blank (i.e new) record. The only way i've stopped this from happening is to open the form in read-only...

Hi, I've got a form based on a table which i want to open for one record only in edit mode. However when i'm looking at the record and i move the mouse scroll wheel down, the form moves to a blank (i.e new) record. The only way i've stopped this from happening is to open the form in read-only...

Trying to use the create table example given in the access help files below CREATE TABLE FirstTable(FirstName TEXT,LastName TEXT); and i keep getting a compile error "Expected: End of Statement" Is this not the method to use to be able to create a table on the fly?

I'm trying to pass values from fields within a form to a function shown below; Function AllDataEnteredForTrade(blTradeSelected As Boolean, stTradePerson As String, dtWkStartDate As Date, intNumDays As Integer) As String If blTradeSelected = True And Len(stTradePerson) > 0 And stTradePerson...

Trying to apply a filter to a sub form - thats based on a query, by using the Docmd.applyfilter but access thinks i'm trying to apply the filter to the parent form which is not linked to any query or table and tells me of this, any suggestions?