Search results for query: *

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

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

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

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

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

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

I am trying to get a value from a parameter table which contains many types of parameters differentiated by Parm_Type field. Select Members.StateCode, ParmTable.Parm_Desc From Members Left Join ParmTable on Parm_Code = Members.StateCode AND Parm_Type = 'States' Access is barking about the...

I have a form that displays information from a parent table and a 1 to 1 child table. In the forms Record Source I am using a select that pulls from both tables as shown below. SELECT Members.SSNO, Members.FIRSTNAME, Members.LASTNAME, Members.Address2, Members.CITY, Members.STATE...

I m looking for a way to string together report codes for a contact. There may be many report codes for the contact. I have been working with too many databases which have ways to do this but can't seem to find the way in access. This is probably obvious to someone working with access a lot...

I have a mail merge from an Access database to a form in Word 2010/2013. The form has a custom size of Width: 6" x Height: 3", and a margin of Top: .25, Left: .25, Bottom: 0, Right: 0. The orientation is set to landscape. This is then being printed to a dot matrix printer which has pin feed...

I am trying to build a routing that will process an aray of property names and obtain the property values from an object. If you examine the following code, the routine "BuildString_One" creates a string based on the propery values. I am trying to build the same string in the second routine...