Search results

I also notice in VBA when I am typing the ctl.Tag, the Tag property is not in the list.

I am familiar with the tag property. My screenshot is too big for the forum. I am positive it is in the right place, but it just doesn't appear to be working as you say it should. I put the word "reset" in the tag property (without the quotes), then I modified my code to read exactly as you had.

That doesn't appear to work. This is Access 2007, would that have something to do with it?

I have just one more question. Suppose you have more comboboxes on the form than just the sort fields. How do you keep from clearing those with the code you specified, Bob?

Perfect!!! Thank you very much, Bob.

Any ideas on this one?

Here is a test database I whipped up in 5 minutes.

I have a form with selection to create a report. Everything works fine except the sorting part. I have a series of 8 combo boxes to choose the sorting order of the report. The users will probably never use all eight, but I gave them the option. Anyway, as you open the first box and choose a...

This is not an Access database. I believe it is an Oracle database.

The date fields are indexed, however they are down on the list of indexed fields. Somewhere in the 5 or 6 range. That would make quite a difference, wouldn't it?

I have a huge table that I am trying to query for a date range. Is it faster to do a select on just the fields I need as opposed to a SELECT * FROM (tblname)?

How can I program to use the Cancel on the InputBox? I have a form that has a copy button on it. When I copy the record, it prompts for a new Equipment number. If the number exists, a msgbox pops up telling the user to enter another equip number. It then goes back to the InputBox to enter an...

Is anyone else having a problem creating charts in Access 2007? I don't know if it is some kind of bug or what, but every time I try to create a chart based on a query, I either get an error that kicks me out of the database, or it won't close and save. Is this a known problem?

Is there a way to put a record back into a table with the same autonumber it used to have? For instance, I accidentally deleted record # 8 and I need to reinsert it with the same number, which happens to be the Work Order ID field. Is that possible?

Is there an easy way to put some descriptive text inside a textbox, have it grayed out, and when you enter text in the box, it overwrites this text? For instance, I have an Issues database. In the text field, I want to put the text as follows: Enter your issue here. Then when they type in...

By jove, I think you've got it!! Thanks very much for all the help.

EquipID is not a numeric field. I'm not having a problem with the dlookup, except when it is supposed to loop and check again. When it loops back, it gives me an invalid use of null error. I should have been more specific in my explanation. What I am wanting to know is if this is the proper...

I am trying to copy a record on a form, but when I do I need to put in a new equipment id number. I have some code to check for duplication, but it does not appear to be working quite correctly. Can anyone see anything obvious? I know this should be an easy solution. Thanks. newID =...

I'm getting a "data type mismatch in criteria expression" error on that line. My EquipID field is a text field and the newID is a string data type.

I'm getting an error in the following line of code: Private Sub cmdCopy_Click() Dim oldKey, varRV As Variant Dim strBookMark, newSerial, strMsg, newID, varID As String txtCopy.Value = 1 oldKey = EquipKey 'On Error Resume Next DoCmd.RunCommand acCmdSelectRecord...