Recent content by wchelly

I have the months as columns figured out, but what I can't figure out is how to get another row below the column totals that gives a running total for the year for each product type each month. If you need help with the months as columns issue without the other issue, let me know and I can...

A cross tab query worked perfectly. It creates a column for each month in which products were shipped. Is there a way to dynamically create columns for months where no products shipped? The problem is that since there are no shipments in there for those months (yet), it does not create a...

Is there a way to design a query so that the column names are January, February, etc, and include anything delivered in that month? And then have the Rows total the number of records for each product type for each month?

Are you storing the Dropdown items in a table or as a value list?

Make sure the "new" value is in the list. Is it a value list or a table? Then make sure your combo box is connected to the right list. :)

Well, I wouldn't mind but I think I've found the solution. I appologize, but I didn't see this thread before. It appeared at the bottom of the screen so I clicked on it and after I read through the solution, I then went to my form and started deleting text boxes. I found one hidden box that...

I set a breakpoint at On Error GoTo ErrHandler It steps through each line until If .ControlType = acTextBox Then Then skips to End If So, I guess what that means is that it doesn't recognize my textbox as acTextBox

Sorry, I don't know much about debugging...is this what you are looking for? When I set a breakpoint at For Each ctl In frm.Controls It highlights the following: If .ControlType = acTextBox Then Then it skips to End If

http://support.microsoft.com/kb/184664?wa=wsignin1.0 Well, I don't think this is a problem because my form is based on one query from one table with a project number parameter. I have several subforms that are based on other related tables however, but it doesn't seem like this is what the...

When I step through the code with f8, It prints the following bugs in the immediate window. Bug1 Bug8 Bug9 Bug10

OK..I used debug.print (see below). When Ran it, The immediate window showed it appears to loop through Bug9 and Bug10 repeatedly. And then it tripped the debugger at Bug2. What it means, I don't know? If .ControlType = acTextBox Then Debug.Print "Bug1" If .Value <>...

It compliles ...strange

Yes, that's how I figured out what was causing it. I just started deleting things. Here is the code in the Audit Trail module. Option Compare Database Const cDQ As String = """" Sub AuditTrail(frm As Form, ShipperID As Control) 'Track changes to data. 'recordid identifies the pk field's...

I don't get a message box like that. I get... Error x The expression you entered has a field, control, or property name that Microsoft Access can't find. OK That is all the text and the only option is to click oK or close the box.

Thanks for your response, and yes I did try debugging, and I just tried it again. It didn't find a bug.