Search results for query: *

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

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

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

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.

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

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

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

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

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.