Search:
Type: Posts; User: todd.kauffman
Search:
Search took 0.02 seconds; generated 34 minute(s) ago.
-
Is it possible to loop thru Access tables that are actually linked excel sheets? I need to know how to relink those by looping thru them and resetting the file name year in the file instead of...
-
Perfect, did that and it is working! Thanks a bunch :-)
-
Anyone know the connection setup to run a .sql script file using ODBC connection to SQL Server database or if it is possible? I have a .sql file that I normally just run via SSMS and export to a...
-
I am trying to figure out how to loop a certain table field properties to get the fieldname and field description in a query result, anyone know how to to that, looking for basically: ...
-
OK, thats what I thought, time to get to renaming :-) Thanks!
-
Yes, here is a snippet: The result would have DPO.start_time and DPS.start_time field names so when i just put start_time it isnt showing a value just empty, if I rename the field with an AS in the...
-
How do I reference the field names correctly using the "!FieldName" method when my stored procedure is returning 2 joined tables with same field names other than table1.field and table2.field??
I...
-
Well lets see, since I'm posting to the VB 6 forum, common sense might prevail in deducing that I am trying to communicate with a VOIP phone using VB6..maybe..possibly? If it is possible, then...
-
I am wanting to know if it is possible to control/send aux codes to a VOIP phone connected to my PC.
-
After you are done copying to new workbook, create a script to run that will loop thru starting at 2 and going to last row with data in it.
Sample for you:
'Code to get last row
last_row =...
-
Change your query to an Update query with criteria = Date() - 1 in the date field and update value should be Date(). No inputs are required if that is all you are doing each time it is run.
-
Possible because you Dim the DelTStartTime variable as a Date, try to just put the field in the function like Format(rst!DelT_Start, "hhmmss"). Just need to play with it a little because it works...
-
Are you running query and outputting the results, if so you can use the Format() function to convert the date and time field to whatever format you need. Format([Datefield],"yyyymmdd"), for time...
-
Format as YYYYMM instead is one way
-
You can just use the TransferSpreadsheet method if you are just wanting to export the query results to an excel file.
-
Does each header row start with the same characters/word? If so you could do this:
If row > 1 Then
IF Left(UNEDITED$, 6) <> "HEADER" then
Print #3, UNEDITED$
End if
End If
-
You could open the text file, read through it skipping the first row and write each line to a new file with the name of your choosing. Try this code.
Open "C:FILEPATH_TO_READ.txt" For Input As...
-
To import a text file you will need to setup a file import specification and define how to import it. Is it delimited or fixed width?
-
Do a For Loop. For i = 1 to textbox2.value ..... Next i
-
Take a look the TRIM function which removes leading and trailing spaces.
-
Is the mail.subject actually equal to "Prep" or is is "prep" or "PREP" because case matters I believe. Just a thought.
-
You could also just create a form in your access db with a drop down populated with the players names, user selects a name, click a button that will run the query and output that query to excel.
-
Have you tried using Paste Special after copying the excel chart you want in the Powerpoint file, choose Paste Link and each time your excel is updated, the Powerpoint should update also.
-
Try using the excel OR() function. =IF(OR(AI9<>"",AO9<>"",AU9<>"",BA9<>""),"ONE OF THEM HAS A DATE","ALL ARE EMPTY").
If you need a specific Date value in there, try and reverse you logic and...
-
Look in your ODBC connections and see if there is one named "TempServer", probably need to update some values in there. Or look in the code/modules and see if there are any CONSTANT variables...
-
Oops hit enter too soon. I also meant to say, you pass in the years of service, then add some IF or Select Case code to calculate the gratuity based on the y value passed into the function.
-
function calc_gratuity(y)
End function
-
You might be putting the function code in the wrong place. Open your file and select Insert...Module and put the function code in a module, save and then try to use it again. I was getting same...
-
I have several items running in my Windows Task Scheduler and is becoming quite tedious resetting all of them when I am forced to changed my network password. Does anyone know if it is possible to...
-
As long as the database is named with the same naming convention each month, you could create a variable to hold something like: str_mdb_date = Format(Date(),"YY MMM DD") or whatever that format...
-
Wrap an error handler around it and pop up a message box if an error occurs.
-
Doh! Ya beat me to it Hack :-) Go Lions!!
-
So what you want to do is this to concatenate the ConnectionString with what the user types in the text boxes..correct or not?
cnConnection.ConnectionString = "Provider=SQLOLEDB.1;Persist Security...
-
I figured out what was wrong. I was getting a primary key error, once I added in the error checking. Marked as resolved.
-
I am getting an error when it gets to the oCm.Execute line for some reason. Can you please look at my code and see if I am missing something. I am using ADO 2.8 library refrences in the excel VBA...
-
Is it possible to set up and write SQL query on a worksheet? loop thru the record set and insert data onto another worksheet in the same file. If so, please show me a sample snippet on how to set...
-
Add another comma after the True parameter and put the Worksheet name "Summary!" or "Summary!A1:Z20" if you want to specify a range of the named worksheet. Will look like this:
...
-
First - you can remove all of the ScrollRow lines from the code. To make it dynamic and copy the ranges as they change, I use this line of code to get the last row with data in it.
'Get the...
-
Awesome, thanks for the quick reply, exactly what I need to make my life easier!! I knew it could be done. Now I won't need to import the worksheet into Access anymore.
-
I need to know how to set an excel range as a recordset so I can write some sql queries, then transfer my query results to another excel file for reporting. I know how to do step 2, just need to...
|
Click Here to Expand Forum to Full Width
|