Recent content by Jimused

Unfortunately this is my last day at my current job and I will be out of touch for a week or two. I would suggest that you perhaps begin a new thread and ask for help setting up your database. Try to be clear in your description of what it is exactly that you want to do with your database, what...

IF the recordset is empty the form will be blank. Check your join properties in your query....they need to be set to select all records from the tblTenant and only those that match for all the other tables. That way, at the least your form should populate with the Tenant name. The way they...

You could create a query that uses the input from the first combo box as the criteria for selecting records then make the query the row source for the second combo. More details if this sounds like what you want.

You need to create a query using the tables you want the data to go to then make that the RecordSource for your form. Hope this is of some help.

I don't know if this will help but I had some problems with converting 97 to 2000 and by opening the converted db in 2000 and then compiling it right away, the errors stopped. Access should stop at any line of code that is in error and you can then edit/fix it. Hope this helps.

I copied this from the MSAccess 2002 Help file..... Import menus and toolbars You can import custom menus and toolbars from a Microsoft Access database or Microsoft Access project. However, Access won't import a toolbar, menu bar, or shortcut menu if it has the same name as one in the Access...

Have your form based on a query that uses the input from “A” as the criteria. Then it will return B & C respectively.

If you use the Control/Tab key combination you should go to the next tab from the last field on the first tab. This may not be what you want but it does work!

This may be obvious but all I can think of at the moment: Are you sure that the Record Source for the form is the correct query? I have had 2 queries that were similar in name and function and accidently assigne the form to the wrong one? Just a stab in the dark!

I did this once by having the second combo box base on a query who's criteria was linked to what was chosen in the first combo box. In my case, the second combo box simply displayed data that was linked to the item chosen in the first. For example, a caller calls, you choose him in the first...

Also check this link..... http://support.microsoft.com/default.aspx?scid=KB;en-us;q209137

As far as what MS says, I find the "...in most cases" the most interesting! I have recently been involved in converting a db created in 2000 and then going to 2002. And IN MOST CASES things seem to be working ok. However, I have had some strange errors occurring and sometimes I am not able to...

I have a db with many forms, reports and vb code. I work on 2 pc;s one with OfficeXP the other Office2000. When I go from XP to 2000 I get error reports that state certain reports will not load. The db does eventually load however I am concerned about stability. I also noticed that the size of...