Search results for query: *

I just hard coded it with each possibility and it is accomplished. Thanks!

Because user forms are neat and the users of these forms aren't used to looking at lengthy excel sheets full of numbers. And by several different excels, I meant several different excel workbooks, several .xls files if you will. Several differently named files in different folders across a...

Hello, I have an worksheet that contains a chart with Max Vertical, Max Horizontal and Pump Size. There are 37 combinations of vertical and horizontal that determine pump size needed. Right now, the user enters vertical and horizontal length needed in cells R13 and S13. The column to the...

Thanks for your advice!

The reason I want to do it this way is the Collect Data Via Email Part. I have tables: Office, Estimating, Safety, and Meeting. Meeting has the Primary Key MeetingID and all the others have MeetingID as the foreign key. In order for me to use the Collect Data Via Email and restrict it to only...

Hello, I have a database I use for weekly company meetings. I have different tables for each department so I can use the "Collect Data Via Email" wizard to send the employees their forms. I only allow them to "Update Existing Information" so they don't reply several times (which they do) and...

Yes, I have to figure in the NumberOfRows and then copy down each row that was added. I just hoped there was an easier way - I don't understand why it works on the Concrete Sheet and not on the Pump Sheet. Thanks for your help.

They are 2 different sections of cells I have set aside to copy and paste into the new rows. That part works fine.

I know that the ClearContents Part is not there. I did that on purpose - it doesn't matter either way. There is still a skip the formula if I add it back in. I've tried every combination of Offset I could think of to fix the problem too. Even if you make the 2 identical, the Pump Sheet does...

I am doing this because it's what my boss wants - he set up the formulas and data validation. The workbook is to track Concrete and Pump on a project. The information will only be input when a project first starts. There can be up to 30 Areas and both Pump and Concrete sheets are identical as...

I have a Form for my excel with Text Boxes BelowRow and NumberOfRows that I use to get values for which cell the user wants to insert below and how many rows they would like to insert. The formulas must be included in the new rows so I copy the "BelowRow" and insert it above the row beneath it...

Spoke too soon - I cleared everything out then went into Format Cells instead of choosing General from the ribbon and it worked. Thanks so much!

I did that on both Worksheets and it's still not working. I know I'm not selecting the wrong cell because I'm literall putting = then navigating to the other sheet and clicking the cell I want. Anything else that it could be? Thanks

Hello, I have an excel with 5 worksheets: CONC SUMMARY POUR ENTRY PUMP SUMMARY PUMP ENTRY PRICING On the POUR ENTRY Worksheet Cells in Column B I use Data Validation from a list on the PRICING Worksheet. On the PUMP ENTRY Worksheet I want the cells to automatically populate with the same...

Hello, I'm using a navigation form to contain my various forms. I can't seem to figure out how to "wake up" the Navigation Tab I was on after closing a report called from a button. Specifically, my Information Navigation Tab contains the form Information. On that form I have a button that...

Thank you both for the reply! My text box was named WAGE and that was the problem - thanks so much!! I don't really have "NAME" as a field, I was just trying to be brief. I really appreaciate the help.

This is on a report not a form, but hopefully someone can help me. I have a report that has fields: NAME, CLASSIFICATION, and WAGE. The report's Record Source is a Query called qryDISTRIBUTION. I want the WAGE field to be blank if the the CLASSIFICATION = "Superintendent" I tried setting...

Thanks for the suggestion!

MaterialTransferTable DetailTable MaterialTransferID ProjectTo ProjectFrom InventoryItem Quantity MaterialTransferID 1 222 755 Hammer...

Hello, I have been struggling this for a while now so hopefully someone with a little more expertise can help me. I've created an inventory database but I am having trouble getting the reports that I want out of my data. I have a Projects table with all pertinent info relating to each...