Search results

Nevermind...I think I have something figured out.

I'm just not sure how exactly to set it up. How do I keep the unit history . For example a property with Units A, B, & C has a tenant move in that will be utilizing all three units and using only the address for Unit B. These are now a single unit, but I still need to be able to look them up...

I have a property management work order database with a table for properties, units and tenants. I need to be able to expand/split units. Will this require a many-to-many relationship and if so, what tables are in the relationship? Brian

My question involves three tables, tblAssets, tblITPropertySignOut and tblITPropertySignOutDetails. When an asset is to be checked out by a user the ITPropertySignOut table with the details table as a subform is used and the assets table is linked to the Details table. My question is this...

I have a form that displays a list box with all of the IT Property Checkouts (orders) and when a user clicks the list box, it displays the order details in a subform. The subform has two combo boxes, the first being AssetCategoryID and the second being AssetID. I have in the AssetCategoryID...

I am unfamiliar with DCount. Can you give me an example of how it works in this situation?

I am attempting to create a catalog number similar to the decimal system used in a library for the cataloging and organization of computer software. Each software title is organized into a category (applications, drivers, etc) and each category has sub categories. I want my catalog number to...

Thank you Pat! That worked perfectly.

The form in question is strictly for changing passwords. It is set up in the following way. The user logs into the database and after logging in the login form stores their username in a global variable in a module. The change password form is called in one of two ways. (1) The user...

I have set up a customized security system for my database. The problem that I am running into is in the instance that I ask my users to change their passwords. If the user uses a new password that has the same number of characters as the old password, the code rejects it saying that the...

thank you, i will try that

My database is set up with a company table that has all relevant addy info and then I also have a contact table with companyID and additional addy info as not all contacts in the db have a company that they are associated to. My contacts table has a checkbox to indicate whether or not to use...

Let me clarify. The attachment worked fine for me in the their database. When I used the code in my own database, it no longer worked.

I get it now, I misread it. Thank you for your help.

I have used the attached database to code my cascading combo boxes, but when I try to select a value from the first combo box, i get the error message "Data Type Mismatch.:confused: " Why would I get this mesage? My first combo box is selecting categories and my second is selecting...

What about residential contact that has no business info? Does the boolean field take care fo that? (I have never used a boolean number type before)

I see what you have done, but I don't see how that keeps the integrity of a datbase. If Company A has 3 contacts, I still only want Company A to have 1 company entry in the database with 3 contacts. If I follow your method I will have 3 Company A's and 3 contacts. I really want to have 1...

I am combining multiple types of Mailing Lists into one single table and using checkboxes to specify the list type. In addition, I have separated out businesses from contacts so that I can eliminate the duplicate data. My question is this; Since some of my contacts don't necessarily have a...

Thank you! That worked beautifully.

The startup form in my database triggers a macro to run that prints a report, then closes the form and opens the Switchboard. The report that prints is a report that shows pending unshipped urgent orders. But the only current problem is is that I don't always have urgent pending orders. How...