Search results for query: *

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

Tried that but EXCEL pops up "There's a problem with this formula...." when I add the greater than sign.

Tried the following wanting the minimum date value from column A but only if the Investment in column B is > 0. 'BP-101' is the sheet name, "A:A" is the "Check Date" column, "B:B" is the "Investment" column. =minfs('BP-101'!A:A,'BP-101'!B:B,0) Couple of problems. Assuming...

The summary sheet would look something like the following based on the initial data sheet: Invest Date First Payment Last Payment 3/24/2021 8/10/2021 9/25/2021 The column above "Invest Date" is MIN("Check Date") where "Investment" <> 0 The column above "First Payment" is...

I have a spreadsheet with a summary worksheet with subsequent data worksheets for various investments, 1 sheet for each investment. On the summary sheet I am trying to find the MIN() date of a column on the data sheet but only if a cell next to the date has a value. Below is a sample of the...

In a VBA module within an Access database I am trying to create a query which needs the schema information for a table. I can get the field names, type and size but cannot get the decimal places for the various numeric types. Anyone have a clue how to get the field properties as seen in design...

In a VBA module within an Access database I am trying to create a query which needs the schema information for a table. I can get the field names, type and size but cannot get the decimal places for the various numeric types. Anyone have a clue how to get the field properties as seen in design...

Andy your query works fine. So I started playing around with the query now that I am done with the task at hand and get more confused as I go. So I throw a twist at you again. The following works: SELECT Parm_Type, Parm_Code, Parm_Description FROM [Parameters] WHERE...

In an attempt to simplify my question I changed the table names and so on so the query made more sense. The underlining problem turned out to be the use of the reserved word "Parameters". In my examples above the actual table name is "Parameters", not "ParmTable" as shown in my examples. Had...

Single vs. double quotes made no difference. I use single quotes in other parts of queries without a problem, but I did give it a try. Does Access allow for a subquery as in: Select Members.StateCode, (SELECT Parm_Desc FROM Parmtable WHERE Parm_Type='States' AND Parm_Code=Members.StateCode)...

I spoke too soon. Adding the WHERE Parm_Type = 'States' gives me a "Syntax error in query expression..."

Andy, this is being used in the query builder not in code. Duane, I am sure that will work. I am used to MS SQL and this threw me and I assumed there was an easy way that I was not picking up on. Thanx, Mark