Search results

Hi All, I have a form that is bound to a table. on the form i have an unbound combo box which, when changed (onchange event), sets the value of a text box which is bound the the forms bound table ID field. The problem i have is that when i scroll with the mouses rollerball the text box ends...

Hi All, I am trying to lookup up a cell value from excel to a recordset in my db. Some of the cells in excel have values like 002I, 003T which are text fields but some are 002, 003. My rs field is a text field from a table. When the lookup happens vba sees 002, 003 as 2, 3 so the value is...

thanks bob, unfortunately it never worked which is a shame because it looked a much cleaner way than what i've come up with. i have got this working but it feels like i'm over complicating things???? Set rs = frm_INVOICE_TOOL_stages.Form.Recordset If Not (rs.EOF And rs.BOF) Then...

Hi all, I have a subform which is filtered by a combo box. if, when the filter is applied, there is no record returned i would like to turn allow addition ON. if there is a record returnd based on the filter i would like to turn the allow additions OFF. Can anyone advise me on how to find...

doh!!!! got it.... If Not IsNumeric(Left(lSht_invoice.Range(colRef & iRow).Value, 6)) And Mid(lSht_invoice.Range(colRef & iRow).Value, 7, 1) <> "/" Then

Hi All, can anyone see what wrong with... If Not IsNumeric(Left(lSht_invoice.Range(colRef & iRow), 6).Value) And Mid(lSht_invoice.Range(colRef & iRow).Value, 7, 1) <> "/" Then ... i keep getting an : object requires message. thanks, spin.

thanks again crake. i have since educated myself on the 10 commandments. :) Am i right in thinking then that if the db is split that the users no longer have shortcuts on their pc's to the db but actually have the FE db stored locally on their pc's. Isn't this a bit of a pain in the ass if you...

thanks crake, unfortunately you lost me at "First...". I haven't split the db into FE/BE. Is it always best practive to do this, does is cost more overhead/time when querying the back end??? can you help me understand "however the db is ported across the network" please?? thanks, spin.

Hi All, I have a button on a form which when clicked queries a lotus notes db. This places my db in a frozen state for a good 2/3 mins. My questions is.... If i have multiple users using the db and someone triggers the import will all the other users find the db in a frozen state?? i.e does...

haha, thanks bob. thats pretty strange/annoying that you can't use the cut option.

SOLVED IT WITH..... xlSht_invoice.Range("A" & rowRef).COPY xlSht_service.Range("A" & iLast_service).PasteSpecial PASTE:=xlPasteValues Thanks.

thanks, but unfortunately gives the same error xlSht_service.Range("A" & iLast_service).EntireRow.PasteSpecial xlPasteValues

Hi All, I'm doing some excel formatting from access. I'm trying to cut an entire row and paste it on another sheet. i'm trying... xlSht_invoice.Range("A" & rowRef).EntireRow.CUT xlSht_service.Range("A" & iLast_service).PasteSpecial xlPasteValues ...but i keep getting a: pastespecial method of...

that worked a treat. thanks. i should do some more learning on rs's by the looks of it. thanks.

Hi All, I am trying to create a variable array and fill it based on the selection from a table. This doesn't seem to work... Do rs.MoveFirst service_array(iCount) = rs!service_id iCount = iCount + 1 rs.MoveNext Loop Until rs.EOF .. it fails on the red section. can i use a variable to set an...

sorry to be a pain, am i right in thinking this isn;t going to possible?? thanks.

sorry must'nt have explained myself properly. I want excel to open with the results of my query so i can analyze the data but when using OutputTo the user is prompted to save the file on disk. I only want to open excel and then close without saving if i want. does that help?? thanks, spin

hi all, i have a form withj a button that when clicked should open preferably a query in an instance of excel, alternatively a report. Is there a quick, single line of code in vba that will do this?? i have.. DoCmd.OutputTo acOutputQuery, "my query", acFormatXLS but that tries to save the...

yeeehaaa, that's spot on. Thanks.

Hi, thanks for your reply but unfortunately it still gives the same error???