Search results

but then why when i run the passthrough query directly (which also needs a connection to the database) does it not delay?

Hi. I have a split form based on a pass through query with only 400 records. The form however has loads of controls (about 20). The passthrough query opens in less than a second, but the form takes nearly 6. this is too long as it's the main form of the program. Trying to find out what's...

Hi. I've got a form which is very similar apart from a few texts boxes, so I hide the relevant textboxes that I don't need dpending on the OpenArgs. E.g. Me.cmbHB.Visible = True Me.cmbHB.Height = 0 I want to make a function like this: Private Function HideControl(ctr As Control)...

:-( Made a type in my excel names and the control on the form with that name didn't exist. how stupid do i feel?

No Not quite. I'm trying to reference a range using the list of Names in the excel sheet. Slight improvement today: For Each oReference In ActiveWorkbook.Names MsgBox "Found " & oReference.Name oWB.Application.Goto Reference:=oReference.Name...

Hi. Ive got a template in Excel which has references in it that have the same name as the controls on the form that i want in the template. so far I have: Dim objExcel As Excel.Application Dim oReference Set objExcel = New Excel.Application Set oWB = objExcel.Workbooks.Open("Y:\RDN.xls")...

Hi. I've got a Word document which has an embedded Excel object. I am changing values of the word document and its excel object from VBA in Access. So far I have: For Each oIShape In .ActiveDocument.InlineShapes If InStr(1, oIShape.OLEFormat.ProgID, "Excel") Then...

Hi, I'm using a Access 2007 front end with a sql express server backend on a windows server machine. I have a form with a sql table as a datasource. I've got a problem where if i edit an existing record (doesn't matter whcih field), when i go to close the form it hangs for around 5 minutes...

found another way round it, i didn't realise you could put active objects in reports, so i added a tick box next to the comments field and made it's even on click: comments.displaywhen = 0 (displaywhen: 0 = always, 1 = print only, 2 = screen only). sorted!

Hi. I've got a report with a comments field. I want this to print out if the user wants it to, but otherwise hide it (i don't want the client to see the comments). At the moment it's set to display on screen only. Is there a way i can add a button that changes it to print only, prints the...

wait so i have to make the rollback commands myself? Or does DBfailonerror do that for me? I don't see how i can make the rollback commands myself as how would i know what's successfull and what isn't?

Hi. I'm trying to create an archive for my database. i'm going to append from multiple tables to another databse, adn then delete the originals. THis is fine, but I'm worried somehting will happen during append and then all teh originals will be deleted. what's teh best way to handle...

Hi. I have a query which has a tick box that i need to be able to change in a form. when the query only has one table in it, this works fine. However as soon as i add a second table to the query, i can no longer edit the tick box. I've tried changing the relationship but doesn't work. Is...

HI. I've got a form with a few records in it, and once you click on a record, a report comes up with the details. I need to be able to print say 20 of these easily and quickly. I've added a link to each record that when i click, will just print the report without opening it, but this still...

ah - thanks guys. I was trying to debug the code that's why i added the message boxes. didn't think it would be the message boxes causeing the error!

Hi. I have a form with a box on it that points to a currency field "Rent" on a table. In VBA, i need to use this value to find the Rent per day (the user enters rent per month in the form). at the moment i have: Dim RentPerDay As Double MsgBox Me.Rent RentPerDay = Me.Rent * 12 / 365 MsgBox...

Hi there. I've got a table called Issues, and a while ago i moved the backend to a server and linked the table into my front end. nwo i want to copy the backend to my pc so i have a local copy so i can edit stuff without being on the network. WHen i change the linekd table address it says...

actually this doesn't work as well as i thought it would. say a user is typing in the combo box to search if the name exists. once he realises that there's no name like that, he clicks on the "new contact" button, but because there's text in the combo box, i get the message "the text you...

that's what i need it to do because hte users keep changing one value and then leave the form with another value empty but required, and so they get loads of errors. thanks for this solution but is there maybe a macro way? rather than using a runcode command...

Hi there. I need to clear all the data from a form before requerying it. is this possible? at the moment i've found if i press Esc to remove all the data i've got so far, it's fine. is tehre anyway to "press esc" with a macro?