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. Godfrey

    hierarchy table(s)?

    Hi Dan, I appreciate you taking the time to read my thread. The hierarchy will look something like this: 1. ClientID - (A client has deparments) 2. ParentBuinessDeptEntityID - (Dept. may have sub Depts) 3. ChildBuinessDeptEntityID - (Sub dept. have job functions) 4. JobRoleFunctionID - (Jobs...
  2. Godfrey

    hierarchy table(s)?

    Hi, Please can you help me with db design? I have to build a table or tables that will accurately reflect a hierarchy. The hierarchy design is essentially the tree or file view we see on our computers file explorer. I plan on using a Tree List component from VB6 in a Client App to display...
  3. Godfrey

    Replace quotations in SQL Access Query/Insert Statement

    Hi, I need a function that will properly quote for insertion an SQL (for Access DB) statement. I currently have one that works for a single Apostrophe: Public Function ApostropheCheck(ByVal strIn As String) ApostropheCheck = Replace(strIn, "'", "''") Exit Function End Function...
  4. Godfrey

    Easy for Access person...Select By Month

    Thank you both for your help! SELECT * FROM tblTable WHERE Format(report_date, "mm/yyyy") = "12/2004"; ...Is exactly what I was looking to learn.
  5. Godfrey

    Easy for Access person...Select By Month

    Thanks so much for your help. Is there anyway to specify by month rather than a range? -godfrey
  6. Godfrey

    Easy for Access person...Select By Month

    Hi, Thank you so much for your help. I am trying to select record for an entire month: SELECT * FROM tblTable WHERE report_date = Format("12/2004","mm/yyyy"); It returns 0 records. There are definitely records for the month of Dec. 2004 in the table. Table data type for report_date is...
  7. Godfrey

    Click on a DataGrid

    Hi, You might want to give this a try, from the VB help files on the DataGrid: Returning Values from the DataGrid Once the DataGrid is connected to a database, you may want to monitor which cell the user has clicked. Use the RowColChange event — not the Click event — as shown below: Private...
  8. Godfrey

    how do you get list of windows that are loaded

    Hi, Try this by starting a new project add a command button and a module (form) to the project. This is currently set to work by looking for the Calculator program. Using a timer, you can set your program to look for the program you need to kill... or some other means. I have taken this code...
  9. Godfrey

    VB5 CAUSED AN INVALID PAGE FAULT

    Hi Andrew, Something to try... when you copied (if I understand you explaination) the old frmOptions.frm to your program to continue working on it you should also copy/paste a file called frmOptions.frx This may solve your issue.

Part and Inventory Search

Back
Top