Recent content by BugZap13

I agree with all you say regarding the split date in the database. Fortunately, the month is derived from a pulldown on a form. Your comment regarding the index makes sense and I do have more code in the where clause that will limit the number of records I am processing that will be Rushmore...

I have a table emphours which has two fields, month and year. The month is stored as "January", "February"... The year is stored as a 4 digit numerical value. I want to use the two fields and make a date from them so I can use it in a where clause of a query similar to below. where...

Century rollover docu

Combo your solution worked like a champ. I did not try the other ones but conceptually they should work also. Thanks everyone... Happy New Year!

I am trying to count the number of rows in a different sheet containing a value. In sheet 2 I have sales dates in column "A". In sheet 1 I want to count the number of sales for 2024. So I wanted to use YEAR() around the range which does not seem to work. I then tried using the range containg...

Has anyone gotten around the QuickBooks 64 bit versions (2022+) and their 64 bit SDK's (QBFC15_)? Desktop versions of Quickbooks versions 2022+ are now 64 bit. Their SDK's since QBFC15 are also 64 bit. This is explained in the following post in more detail...

In the date field you can intercept the key that has been pressed in the keypress event. For instance you can check for a "T" or a "t" being pressed and set the value to DATE(). Similarly, you can catch the keypress and if the "+" or "-" keys are pressed you can add or subtract a day from the...

I currently have 4 POTS lines hooked to a Dialogic 4 port modem. The setup is used for employees to clock in/out. Software running on a PC answers the call and prompts the caller for their employee number, etc. The POTS lines are supplied by the Cable company (COX) and are getting more...

Thank you Chris and Mike for your suggestions. The name collision was caused by a poor naming convention on my part. The all caps G_ prefixed names are from #DEFINE statements that correspond to columns in a spreadsheet used as input (example shown below). Unfortunately, the spreadsheet...

You hit the nail on the head. That is exactly what was happening. Good catch. Should have realized it was a pre compile directive that was causing the grief. Thanx

I am getting a compile error which has me confused. The following are the errors from the compile and stored to the .err file associated with the program. Note the datanames m.12 which does not match the lines in the program. What is odd is that the number portion corresponds to the field...

Chriss I used the underlying cursor of the employee table which was filtered to the selected employer as the driving table in a subsequent select used for the report. Originally I was expecting that the filtered cursor could be used. As you and Tamar pointed out the filtered technique will not...

Thanx for the input Tamar and Chriss. I am going to redo my thinking and set the controlsource of the two combobox's to a public variable and use those values to build the report cursor rather than rely on the underlying cursors used for the combobox's themselves. Again, Thanx for the input...

I have 2 DBF's, Employer and Employee. I create cursors which select the records to be presented in comboboxes on a form. Initially the employer cursor is positioned to a 'All' selection and the employees are not filtered showing all employees in their corresponding comboboxes. When a user...

Skip thanx for your example. There is more to the problem then was presented and if I were getting the data table from a database I think your solution would be the way to go. One sheet containing the data from all investments and one summary page like you illustrated. Sorry for the confusion...