Search results for query: *

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

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

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

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

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

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

Hello, All of our company documents are stored on a local server in the office. This server is backed up to a cloud server. Whenever I am working on an Access document, after about 10 minutes or so I get the error: Your network access was interrupted. Please close down the database and...

I'm trying to figure out a query to get an itemized detail list so I can see what materials I have at which job, but I'm having trouble figuring out the right way to do it. I have a Material Transfer Table with "JOB_IN" AND "JOB_OUT" fields. The Material Transfer ID is linked to the Detail...

Hello, I have a table for my inventory with fields 1_CAT, 2_CAT, 3_CAT, and 4_CAT. I have a DETAIL table that I am trying to make a datasheet Form from that has all of these categories. I want the user to select an item from the 1_CAT category and have it filter the records that show up in...

Hello, I have a combo box with values "OPEN", "REVISED", " ", etc on a subform of a navigation form. I've tried to nail down the syntax to get to it from the navigation form, but have had so much trouble getting it right. I've tried to use Me.ActiveControl to get around the problem and it...

I’m having trouble getting my form to filter based on my WHERE statement and I would really appreciate any help. I have Tables 1_CAT and 2_CAT. 1_CAT stores the main inventory categories in the field M_CAT. 2_CAT contains the fields M_CAT (a look-up field to M_CAT in the 1_CAT table), S_CAT...

Hello, I have an RFI Log form and an RFI Full View Form that looks like the entire letter so people can adjust fields how they want in the letter format. Next to each record in teh RFI_Log, I have a "Full View" button that opens up the Full View form of that record only using this where...

Hello, I have my forms formatted to print without having to put them into a report first. Is there any way to get a specific record's attachment files to print with the form at the same time? Thanks!

I have an "RFI" and a "SUBMITTAL" form. Both of them have "TO" combo boxes connected to the "Contacts" table as a look-up field. On the "RFI" form, I made the "TO" combo box, added all of the fields from the "Contacts" table that I needed for the form so the Control Source is To and the Row...

I have an RFI and a Contacts table. I have an RFI form that has "To" and "From" look up fields connected back to my Contacts table. I am trying to add Title, Address, etc fields for the "To" and "From" fields using the Default Value property. I have created a text box with the Control Source...

I have an RFI and a Contacts table. I have an RFI form that has "To" and "From" look up fields connected back to my Contacts table. I am trying to add Title, Address, etc fields for the "To" and "From" fields using the Default Value property. I have created a text box with the Control Source...

I have this code to insert my pictures half size into a certain cell. How can I get it to give the option to choose another picture and insert it the next available cell? Here's my code: Sub EmbedPicture() Dim sPicture As String, pic As Picture ChDir "C:\Pathname\" sPicture =...

Hello, I have the following code that saves a message to our server with the Date/Time and Subject of the email then sends: Sub SaveAs828() Dim myItem As Outlook.Inspector Dim objItem As Object Dim EmailDate As Date Dim MyMail As MailItem Dim MailDate As String On Error...

Hello, I have a Code that inserts an embedded object (a picture) into an excel and puts a preview of the picture into Cell "D36". I want to find a way to Set the Object (which is just an icon when double clicked pulls up the full view of the picture) to a certain cell with that cell's...