Recent content by dmullins

Got it, and thanks

I have a table that we assign license numbers to and enter them in the table. Over the years many numbers have been missed and skipped. So I made a table that compares sequentially and then looks at the ones missing as the next number. The problem is they can begin with MB or MBB with a total of...

Thanks for input, I totally agree that the db is very poorly put together, it's just a table, put together in a hurry, thats why the naming functions were not followed as well and the combo box was a last minute change. I will take your valued experience and use it, thanks. Once put together I...

I have not got a solution, if you downloaded all I have in the db, the queries and the forms is all I have. It works now by just selecting Y/N, and it monitors which date it is. You can select all the categories at once or one of them. It works but wont allow me to make a report that totals the...

Okay, there it is Sorry about that

I attached the form and report in xml. This is the code for the query on the report, no query on the form: SELECT qryCount.ID, qryCount.CSO, qryCount.SPA, qryCount.COLLECTIONAGENCY, qryCount.COUNSELINGCONSUMERS, qryCount.COUNSELINGCREDITORS, qryCount.PB, qryCount.RTO...

Okay I have attached the table in excel format. It is one table, I know design is everything and three would be better, but can't make it work yet, this works for monthly.

I am copying it into the visual basic window under click This is a 2003 db, but I am using 2007 access to work on it. We are converting next year to 2007

Error box "Method or Data Meneber not found' when pushed okay Debugger highlights in yellow Private Sub Command85_Click() , which is the button

Okay, cleaned it up and have runtime error '424', Object required

Private Sub Command85_Click() textBox83.Value = textBox83.Value + 1 End Sub Still get an error box The expression ON CLick you entered as a event property setting produced the following error: fixd length strings, arrays, user - defined typed and declare statements not allowed as public...

Right into the 'onclick',

Thanks ,tried it and got an error, "Access can't find the object 'Text84'

I need to be able to push a button an add 1 to any number field, I may have 10 buttons, but I need it to show a count in the box and everytime you push the button it goes up one. I am using this to collect times of a particular event that It will total every month and reset to zero. So ineed...

I have a query that runs fine in datasheet view but when attached to report it bombs. It has to be related to the expression field I put in to select to proper types from two different tables. (EXP1:) Hear is the code. SELECT Count(qryExamErrorsByDate.LicenseNum) AS CountOfLicenseNum...