Recent content by beeorlando

Randy, Thanks for such a prompt reply! The label would look like this: Box#: IM-0001 I4-0001 Wetland Resource Report 3 copies I4-0003 Ownership Inventory Report 2 copies I4-0021 Engineering Study 8 copies ------------------ When I do a query, it lists the Box # three...

I have two tables: Librarytbl DeptBoxTbl The library tables lists all the reports we have in our project library and the unique field is LibraryID. The DeptBox table stores the box# for Archive Storage. Many reports in the library table can have the same dept. Box #. PROBLEM: I'm trying to...

I've been using Access for a few years and I'm pretty good but I'm lousy at relationships! Here's what I'm trying to do (I'll try to explain it...): I set up a database to track our report library. Each report has a unique ID#. I have to pack up some reports for archive leaving some copies on...

I have a field call BoxSize in my table. The data type is currently number. The only entries are 1.2 and 2.4. Everytime I try to change it to "text", this is what happens: It says it is updating the data types and then it just sits there and never finishes! I've tried this...

I have a LOT of project reports to list on a form for people to view. To cut down on the number of reports I list, I'd like to do the following: When a user selects a report such as: Sawgrass Expressway Acquisitions They will be prompted to select the field the report will be sorted...

I had the some problem and tried your code to fix it. Here's my result: Runtime error 424 object required What does this mean? Thanks!

I've been using Access for a few years but I've never put a database on an Intranet before and I'm a bit perplexed how to do it. Here's what I'd like to do: I created a form from which users can search & view reports generated from the database -- but they can't do anything else (like get to...

Thanks it worked like a charm!

I have a query in which you enter a key word to search a description field and it is supposed to return all instances of that word. My criteria is: Like[Enter Key Word]& "*" If I enter the word Contract ...my results include records with these descriptions: Contractor Record...

Thanks it worked beautifully!

I need an IIF statement to choose between 3 fields. Here's what it needs to do: Field 1 Field 2 Field 3 If there is a date in Field 3, display Field 3 If Field 3 is null, display Field 2 If Field 2 is null, display Field 1 I'm at my wits end and would really appreciate any help offered with...

I created a tab form and would prefer the tabs be on the side instead of the top of the form. Is this possible? Thanks! Carla

CosmoKramer, Thanks for your help - it worked perfectly!

I have numerous fields that calculate dates off one date field. the first field contains an "actual" date the rest of the fields contain a formula that adds days to the date, like this: DateAdd("y",+45,[Expr1]) Each date keys off one another to create a forecast report...