Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kshanes

    Problem With Join

    ...to mimic what the other posts are doing, I still get syntax errors. The query is below. Any help would be greatly appreciated. SELECT COUNT(*) AS Total, GC.goalType AS [Goal Cat], CGR.ACL, DATEPART("yyyy",G.startDate) AS [Year] FROM ((dbo_t_goal as G left...
  2. kshanes

    Missing Operator Error in Update Statement

    Good morning, I'm trying to update a column in 1 table based on information in 2 other tables. No matter how I format the SQL I keep getting the error: "Syntax Error (Missing Operator) in Query Expression 'UsersAndGroups.ACL FROM ConsolidateGroups'. The actual statement is below. Any help...
  3. kshanes

    High quality Javascript editor

    I also use Textpad and it's great. A coworker of mine uses Homesite (I believe it's by marcromedia).
  4. kshanes

    how to get multiple records into one

    SleepingSand, I too have a similar problem as mwa. Your suggestion works great if there is no need for a where clause. I've tried different things to get your solution to work with a where clause without success. Do you happen to know how to get it to work with a WHERE clause? Thanks in...
  5. kshanes

    Excel file list (dir)

    faxof, I just want to make sure my last post answered your question. I don't want to leave you hanging. If it didn't answer your question please let me know. Thanks
  6. kshanes

    Excel file list (dir)

    faxof, just add the following line of code under the .Application.Cells(iCnt,1) = m_File.Name line: .Application.Cells(iCnt, 2) = m_File.DateLastModified This will put the last modified date in column B for each file in column A. ~Kevin
  7. kshanes

    MkDir - "File/Path Access Error"

    can you post some of the code that you're using. I want to help, but don't want to take things out of context. thanks
  8. kshanes

    scroll through xls file??

    It looks like you're just trying to loop through a directory on your machine and pull the file names into excel. If this is the case try the code below: ------------------------------------------------------- Dim m_FSObject Dim m_Folder Dim m_File Dim m_Files Dim iCnt Set m_FSObject =...
  9. kshanes

    Excel file list (dir)

    faxof, Try this code in VBA: ----------------------------- Dim m_FSObject Dim m_Folder Dim m_File Dim m_Files Dim iCnt Set m_FSObject = CreateObject("Scripting.FileSystemObject") Set m_Folder = m_FSObject.GetFolder("m:\apps\usage\ad") Set m_Files = m_Folder.Files For...
  10. kshanes

    VB and MS-Word

    Doug, Rather than having them type directly into word, why don't you also provide a text box for them to enter their comments. Then you don't even have to visually open word for them to enter the information. you can just create an invisible instance of it and everything will be passed...
  11. kshanes

    FlexGrid -- Turning off Gridlines

    There's a property called "Gridlines". One of the options is "0-flexGridNone". It can be set at design time (and I'm assuming run-time as well). Hope this answers your question. ~Kevin
  12. kshanes

    copy form

    The only way I've figured out how to do it in the past was as follows: Go to the directory where your original form resides. Copy the form file (.frm) and paste it into the same directory. Rename the .frm file to whatever you want. Then double click on the file to open up a new project. In...
  13. kshanes

    Rename File

    Kelly, Here's some code to get you started: ----------------------------------------------- Dim m_objFSO As Scripting.FileSystemObject Dim dtToday As Date Dim oldFile1 as String Dim oldFile2 as String Set m_objFSO = New Scripting.FileSystemObject dtToday = Now() oldFile1 =...
  14. kshanes

    Where can I learn SQL ?

    When I first started working with SQL, I picked up the book "SQL For Dummies". It turned out to be a valuable and inexpensive reference.
  15. kshanes

    Open ASCII file

    Assuming your record length(s) are fixed, you could place the following code in a module: ************************************ 'Define a custom data type Public Type timeCardData sVal As String * n 'where "n" is the record length for 'each line of the flat...
  16. kshanes

    number

    Workshop, Try this formula in cell c1: =CONCATENATE(B1,CONCATENATE("0000",A1)) Hope this accomplishes what you were trying to do. Thanks Kevin
  17. kshanes

    List Box to support multiple selection

    What do you have the "STYLE" property set to? If it's set to checkbox, that could cause a problem. There may be some other property that's causing the multiselect to revert back to 0 but STYLE is the only one that I know of that could cause a problem.
  18. kshanes

    List Box to support multiple selection

    In the listbox properties window, all you need to do is modify the multiselect property. You can change it to "1-Simple" or "2-Extended". The simple setting lets you choose multiple entries without holding down the control key. When set to extended, you need to hold the...
  19. kshanes

    Can word link to a directory?

    Bobby, I'm not sure if I totally understand your question, but if I do, here's what you can do: In your word document, type in a name for your link. Highlight the text you just typed and choose "Insert" then "Hyperlink" from the menu. In the resulting window, just type...
  20. kshanes

    excel menus

    using VBA you can manipulate the menus. If you wanted to prevent the users from touching any of the main menus you could write some code similar to below in the Workbook Open even: ------------------------------------- Dim cb As CommandBar Dim cbControl As CommandBarControl 'Loop through all...

Part and Inventory Search

Back
Top