Search results

Is there a way to delete the second worksheet from a workbook?? Thanks beforehand

I want to see the data in an unbound calculated field change after I've changed the value in one of the calculations. How can I do this??

I have data copied to an excel workbook. In the book I do some pasting of values. These are copied by formulas in another sheet. To get rid of the calculations I want to copy and Past the values on the same sheet. That's where things go wrong. Set sht = excelApp.ActiveWorkbook.Sheets(1)...

I'll prepare a small database as example

Hi, On an invoice I have a selection field Language referencing a table with Languages. I store the LanguadgeId in the field. While making the Query to print the Invoice I need to select the Select the The Invoice description from a table that has the translations in the fields. How do I...

I've been keeping on trying and found the lower one did work fine. Meaning the principle works. This also means there most be an error in the query mentioned above. Thanks very much for all the help. strSQL1 = "SELECT tblOrder.OrderId, tblOrder.OrderPrint " & _ "FROM tblOrder " & _ "WHERE...

I've decided to use this code: This gives you the ability to create a directory select is. Works fine for me! 'http://www.microsoft.com/technet/scriptcenter/resources/qanda/jun05/hey0617.mspx 'You must set a reference to the Microsoft Scripting Runtime 'to use the BrowseFolder_Scripting()...

Yep, I'm going to bypass all with a "Print Report" filed on the main table and add this to my query. That way I can determine what report I'd like to print at any time. Thanks all for the input, it's really appreciated!!

I'm 100% sure the tempvars is set and available the moment the query is made. Do you have a working example with tempvars in the query request?

Dim lgOrderId As Long Dim strCurrentPath As String Dim strFullCurPathFile As String Dim strCurrentOrderDet As String Dim strValue As String Dim test As String Dim strSQL1 As String Dim intLenstr As Integer StartUp [TempVars]![temporderid] = Me!OrderId.Value strFileName = Me!CAEJobNumber.Value...

no change unfortunately

Then it works fine!! Problem is I need to parse the value before running to transfer to excel, otherwise I get all records and heve to split. As you can see the query is not just a simple one, so writing the sql as string runs into problems with length and parts, so I prefer the Tempvars. If...

it provides: >>> 6 as my answer. (That's what I'm looking for!!)

Sorry, Same error!

I get the erro Object variable or block variable With not set??

Running the following recordset generates an error 3061, to few parameters. When I run the Query by inself it does run and generates the required single opject I'm looking for. What do I need to do to solve this one?The problem is in the Where clause with the TempVars. If I delete that, it runs...

This is it!! perfect and the point Thanks!!

Your're right again! This one works great, to find files and create directories, but it doen not let you SELECT a directory, it only let's you select files. I need to select Directories to put my files in. Did I miss something??

Hi, It comes back with an error on line: Dim fDialog As Office.FileDialog type is not defined

This worked. Thnks very much for the effort!