Search:

Type: Posts; User: todd.kauffman

Page 1 of 3 1 2 3

Search: Search took 0.02 seconds.

  1. MsOf10 How to Loop linked excel sheets as tables in Access and relink

    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...
  2. Re: Run .sql text script using ODBC connection to SQL Server

    Perfect, did that and it is working! Thanks a bunch :-)
  3. [RESOLVED] Run .sql text script using ODBC connection to SQL Server

    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...
  4. Get an access table field description value in query

    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: ...
  5. Re: VB6 Stored Procedure Syntax to get values of 2 tables with same fieldnames

    OK, thats what I thought, time to get to renaming :-) Thanks!
  6. Re: VB6 Stored Procedure Syntax to get values of 2 tables with same fieldnames

    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...
  7. VB6 Stored Procedure Syntax to get values of 2 tables with same fieldnames

    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...
  8. Re: Communicate with VOIP phone connected to PC

    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...
  9. Communicate with VOIP phone connected to PC

    I am wanting to know if it is possible to control/send aux codes to a VOIP phone connected to my PC.
  10. Re: how can I automate the writing of text value into rows and columns that can vary

    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 =...
  11. Re: Access macro find and replace in a query help!!!! pleaseeeeee

    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.
  12. Re: Converting mm/dd/yyyy hh:mm to iCal format

    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...
  13. Re: Converting mm/dd/yyyy hh:mm to iCal format

    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...
  14. Re: Sort Msaccess values by Jan Feb March April etc

    Format as YYYYMM instead is one way
  15. Re: Calling Excel from an Access vba app not working?

    You can just use the TransferSpreadsheet method if you are just wanting to export the query results to an excel file.
  16. Re: How to Best deal with importing strings

    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
  17. Re: How to Best deal with importing strings

    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...
  18. Re: How to Best deal with importing strings

    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?
  19. Replies
    12
    Views
    1,587

    MsOf07 Re: MACRO LOOp

    Do a For Loop. For i = 1 to textbox2.value ..... Next i
  20. MsOf10 Re: [Excel] How do I remove a leading space

    Take a look the TRIM function which removes leading and trailing spaces.
  21. Replies
    5
    Views
    662

    Re: Sub-routine is not getting called

    Is the mail.subject actually equal to "Prep" or is is "prep" or "PREP" because case matters I believe. Just a thought.
  22. Replies
    6
    Views
    916

    Re: VBA Help - Access to Excel

    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.
  23. Re: update powerpoint graph with excel data IN WHICH EACH SLIDES HAS MANY GRAPHS WITH

    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.
  24. MsOf10 Re: taking DOW if any of 4 cells contain date

    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...
  25. Re: *** Help with Refreshing Data between VBA and SQL via ADO! ***

    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...
  26. Replies
    15
    Views
    9,397

    Re: Calculate gratuity in excel VB

    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.
  27. Replies
    15
    Views
    9,397

    Re: Calculate gratuity in excel VB

    function calc_gratuity(y)

    End function
  28. Re: [Excel] Suddenly, a wild name error appears.

    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...
  29. Replies
    0
    Views
    434

    Reset Task Scheduler Passwords

    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...
  30. Re: Getting info from an Access Database to create a pivot table

    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...
  31. Re: Login Control in Visual basic 6

    Wrap an error handler around it and pop up a message box if an error occurs.
  32. Re: Login Control in Visual basic 6

    Doh! Ya beat me to it Hack :-) Go Lions!!
  33. Re: Login Control in Visual basic 6

    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...
  34. Re: Write Query Loop on Excel worksheet in VBA module

    I figured out what was wrong. I was getting a primary key error, once I added in the error checking. Marked as resolved.
  35. Re: Write Query Loop on Excel worksheet in VBA module

    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...
  36. [RESOLVED] Write Query Loop on Excel worksheet in VBA module

    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...
  37. Re: DoCmd.TransferSpreadsheet acImport In Access

    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:
    ...
  38. Re: Excel VBA - adding rows and copy and paste from another sheet

    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...
  39. Re: How To Use Excel File/Range as Recordset and Run SQL on it

    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.
  40. [RESOLVED] How To Use Excel File/Range as Recordset and Run SQL on it

    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...
Results 1 to 40 of 94
Page 1 of 3 1 2 3



Click Here to Expand Forum to Full Width