Search results

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 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...

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...

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...

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...

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...

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...

I have a report for displaying materials that have beens shipped. It displays: tblRequests.RequestID tblRequests.DateRequested tblRequests.NeededBy tblRequests.Company tblRequests.Name tblRequests.Address1 tblRequests.SecondaryUnitName tblRequests.Address2 tblZipCodes_N.City...

I have a table that stores records based on a category and subcategory. SOme contacts may be stored in more than one subcategory and still be in the same parent category. I want to be able to print off a label report that will eliminate these duplicates within the category. I think I should...

How would I go about setting up a form with a combo box listing all of the available options to search for on a particular field and then have the user click on a button to display the results in a subform? FOr example, I have a table of Categories and I want the combo box to list all of the...

I am trying to use a form that displays two options to search for information and then display the results in a table format directly beneath. Any help would be excellent. Thanks. Brian

I have a form with two combo boxes that are related to each other. The first is a category list and the second is the subcategories. How do I make the subcategories drop down only display the entries that are related to the category drop down? Thanks in advance