Search results

I have attached something similar to what I want. Would splitting the tables make a difference?

Ok so I thought I had this working but now I am having a problem. So I have 2 tables tblWorkOrderNew tblHotWork Main Form is frmWorkOrderNew. The primary key is WorkOrderID I have numerous fields say a,b,c. I have another form. subfrmHotWork. This is the form I am trying...

Worked great thanks

I have a main form with a sub form that works just how i want it to by linking the PK to display only records associated with it. The problem is my main form is full on my screen and i do not want scroll bars. I also do not want to use tabs. I have a button that i would like to click that would...

Hello. I have a Purchase order report that gets it PO# from the following code =Format([OrderDate],"mmddyy") & Format([OrderID],"00") The name of the text box the PO displayed is [Text49] (I know, i know....) I have a button that exports the selected report to an email Private Sub...

Hello, I have a form [Frm1] with a text box [ID1] I have a button [cmd1] that opens [frm2] On [frm2] i have a subform [subfrm1] My goal is to click on the button which opens [subfrm1] and displays [id1] from [frm1] on the subform. Basically i have a form with information on it and i click a...

Perfect thanks.

Hello, I have a form that i currently filter using a single combobox. A user makes a selection in the combobox and clicks ok. I then opens the next form with the filtered results. How would i do this to incorporate 2 comboboxes where the form would have to match both criterias when it...

Hello. I have 4-5 types of data i would like to store. Motorcycles - make, model, year, color. Cars - Make, model, year color, door numbers Trucks - Make, model, year, color, towing capactity Boats - Make, model, year, size, motor size What would be the best way to set this up. Should i put...

Wow, It looks like it does exactly what I need. Thanks :)

Hi all. I currently have a split database that i am constantly working on and releasing updated versions to my coworkers. The way i currently handle this is by using a version number in sequence. 1.0.1, 1.0.2 etc... I have tblVersion on the front end of the database which keeps track of the...

I got it figured using a different method then you suggested. I input this into my union query in SQL In the Onchange event for my combo boxes I put refresh record so that when I change either cboPlantNum or cboEquipmentType, cboEquipmentID is filtered accordingly. Thanks.

Hello, I am trying to filter a combo box based upon a union query. i have the following structure, My union query. The only problem i have with this is instead of showing row 1 (PlantNum or EquipmentType) it shows row 0 (ID). Can i fix this? These are my results (BOILERNAME) That i would...

So after some digging this is what I ended up using to fix my problem. It wasn't what I wanted but it got the job done. Private Sub NameOfButtonGoesHere_Click() Dim AttFilePath as String AttFilePath = "Your File Path Goes Here" Application.FollowHyperlink AttFilePath End Sub

Ranman, Thank you for your reply. How would I use this code to open a certain object. I don't see where I would put in my file path. (I'm a novice at VBA)

Hello, I have 2 Tables. tblOrder tblAttachment In tblAttachment i have 5 Fields. ID AttFile - Attachment field AttFilePath - A Short text field which stores the path on my C Drive AttType - The type of attachment .PDF .JPEG etc. AttName - The name of the Raw file as saved on the C Drive I...

I worked out my issue here. I opened the report first then had the form open to select recipients.

Can I select more then one recipient at a time using this method?

Hello, I am having a problem with a small work order system i created. I have an update form [frmworkorderupdate] that i enter data in and click cmdSubmitWO which opens another form [frmwoupdateemail]. Private Sub cmdSubmitWO_Click() DoCmd.RefreshRecord Dim Response As Integer Response...

Any other input on this or can someone see what I am doing wrong above? Thanks!