Search results

I have a form that I have created with a Tabstrip and a large Unbound subform control. Depending on which button on which tab is selected, different forms are bound to the Unbound control using VBA. No problems there. A series of other buttons (not part of the Tabstrip) appear / disappear based...

Just to let you know, I solved my problem. Apparently, the ORDER BY clause had nothing to do with Access not being able to save my code. (In my gut, I didn't see how it could, but it sure appeared that way.) One of my modules got clobbered and any reference to it from some other object would...

That's what I'm doing. A form pops up and the user checks / unchecks various radio buttons and check boxes. There are four groups of radio buttons. And to make matters worse, they kinda cascade, that is, what you choose in the first set of radio buttons causes buttons in the other groups to...

Aaahhh. Of course, you are right. But that's just my sloppy typing. I have the dots in this msg, but not in the actual code. I am afraid it's not going to be that easy.

Maybe I'm missing it, but I don't see a difference betwen my code and yours. Please advise. Thanks.

How complex can you get with the SQL ORDER BY clause? In the QBE, you can only put Ascending or Descending in the Sort cell for a field. But my query is too large for QBE and I have to use SQL. It's working fine, but now I want to add an ORDER BY clause. It needs to be conditional based on a...

Thanks for the comments. The details of my file are like this: I work for Internal Audit and we keep a database of all our projects. Each project has a status, such as 0=No Work Performed yet, 1=Complete with Report Issued, 2=Complete with No Report, 3=Closed, No Work performed, etc. 4=In...

Can a SWITCH command return two or more values from a single comparison? Ex: Switch([Field]=Val1, 1, [Field]=Val2, 2 or 3) If I use QBE, I can put 1 or (2 OR 3) on the CriteriaLine depending on the value of Field and it will work fine. But how do I implement this using a Switch command. I...

That makes sense. I'm going to try it and see what happens. Thanks for the heads up.

Can WITH statements be nested? example dim rst as Recordset dim btn as CommandButton dim i as integer With rst If .RecordCount > 0 Then .MoveFirst Do Until .EOF for i = 1 to 4 With btn .Name =...

I am always amazed at the depth of expertise out there. Thanks for your quick and accurate suggestions. Problem solved!

I have two tables, a Master table and a Details table. In the Master is one record per employee. In the Details table are multiple records for each employee. Each Details record is time and date stamped. If I query the tables, I get all the records from both tables. How do I query the tables so...