Search results

If you have a valid WinZip 9.0 license you can also use this: http://www.winzip.com/prodpagecl.htm

Are you sure you posted this in the right forum? You want to do this from Access using VBA?

I assume you mean the combo box in the form detail section. The combo box should feed directly off a table of equipment types, and you can set the combo box to accept new entries. After a new entry had been added you should requery the combo box in the form header so that it will now include all...

This is possible, but why do you want to do this? FYI: You can use the Me.NewRecord property to check if the current record is a new record.

There are many examples of search forms on the boards, but it sounds like you've already looked. I also keep an equipment database. What I do is put a combo box into my form header with the desired choices. Then I attach code to the combo box's After Update event. Something like this...

I haven't had this particular situation, but why not create a subform where you have a tab control on it? Then just place your controls onto the desired tabs? They would all be on the same single subform, thus there would be no question of which would be the current record.

Use the On Current event on the main form to change the display of related records on the sub form. You can use some code there to requery the subform.

Have you tried: Me.listBoxName.Requery

FYI: The character limit in Access 2002 has been increased to 32,786. See the following article for more info on list filling: New List-Filling Options in Access 2002

The official name is Microsoft Visual FoxPro, and the current version is 7, though the public beta of 8 is out. The program had it's roots in FoxPro, a dBase clone written back in the 80's when dBase was all the rage. Microsoft bought FoxPro, added a GUI environment to it, and made it "Visual"...

I could be wrong, but I don't think this is possible in a continuous form. The recordsource for a combo box would be the same for all records on the form. You could set it up where combo box would not accept values previously chosen by using code, but I don't think you can hide them from being...

Sounds like the relationship between your students and categories is many-to-many. Many students can be in multiple categories. You should have a student table and a category table. After all, why repeat each student's info on each category table? To match up students with categories, you'll...

Thanks Tim. We've got some casual FoxPro users/developers and we're thinking of moving the project to Access. It's a very simple app. The conversion wouldn't be painstaking, but I just wanted to get an idea of whether we'd take a speed hit by moving it to Access. They touted the FoxPro speed as...

When you have text that is enclosed within quotes, you need to close the quotes before using the _ character. You have it like this: DoCmd.RunSQL "SELECT field _ FROM table;" It should be like this: DoCmd.RunSQL "SELECT field " & _ "FROM table;"

Yes. First, let's assume the data types are compatible. Let's say you have two tables, A and B, and the field you'd like to join on is called "ticket". Create a query and add tables A and B to it. Add the ticket field from table B to the query. In the criteria for the ticket field, use something...

1 - Select the record you want to delete (if you have a record selector on the subform, just click it, else go to the Edit menu and choose Select Record) 2 - Go to the Edit menu and choose Delete Record

Hey everyone, I thought I'd reprise this thread since I've been given the task of potentially migrating a FoxPro 6 application over to Access XP. One of the big considerations is speed. I believe that Microsoft integrated Rushmore technology into Access when they put out version 97. Anybody...

Why not set up your customer table so that duplicates are not allowed? Of course, you could legitimately need two different Mr. Kirklands in your database, so make the last name and first name, or last name+ first name+address the primary key for the database. If you've got an autonumber that...

You can use the FilterName or WhereCondition parameters of the DoCmd.OpenForm method to open the form with the PPID you want. You can even use the OpenArgs parameter if that's better for you. Why are you using the Before Insert event of the form? If you must pull the value from that other form...

Honestly, I've never used the switchboard manager. I like to give my users a very specific set of options. I have used switchboards from the sample databases, though. They're useful if your options change often.