Search results

Hi Paul, Sorry about I should have changed change it. I do have the code like that in my database. When I copied it and pasted it into the thread it went all jumbed. I still am not sure what to do to make the code run threw and check all 3 querys. As you see after it executes somthing it stops...

Hi, Can Someone help me. I have a form where on-load I want to have a code to check and see if there are Items in 3 querys. It should Bypass and no msgbox if none, but open a msgbox to ask whether to view these or not if there is one or more. The problem I am having is If the first query has one...

Hi Pbaldy, I was going to send this example of what I was doing. I just took this part out of my database. If you still wanted to look at it. Double click into the Item textBox in the 2nd dropdown. Thanks Bryan Hewitt

Thanks for your Help. I see how you would do that. I will try that. Thanks BBryan

Hi Pbady, I just returned. Something may be spelled wrong - Could it be that I am doing this from a sub form within a sub form? Do I need to state the Insert Into a the form Name and not the table name? when you say a saved query and execute it. I am not sure how to add the data from the query...

Sorry again, I lost the internet connection and it double entered the reply. I tried post 9 It also has a error 3061: ; too few parameters, Expected 1 My data base it 460 MB But I might be able to just put this part in another Database. I have to do somthing for a hour or so I will send after...

Sorry PBady, I just am not getting this right strSQL = "Insert INTO [Itp Piping tbl] ([SortOrder], [Item], [Description], [Sub Description], [InfoDescription], [2ndInfoDescription], [Documentation]) Select ([SortOrder], [Item], [Description], [Sub Description], [InfoDescription]...

Sorry PBady, I just am not getting this right strSQL = "Insert INTO [Itp Piping tbl] ([SortOrder], [Item], [Description], [Sub Description], [InfoDescription], [2ndInfoDescription], [Documentation]) Select ([SortOrder], [Item], [Description], [Sub Description], [InfoDescription]...

Hi PBady, Sorry - I noticed I had made some mistakes on the last statement I should have said this But this also has a syntax error. strSQL = "Insert INTO [Itp Piping tbl] ([SortOrder], [Item], [Description], [Sub Description], [InfoDescription], [2ndInfoDescription], [Documentation]) Select...

Hi PBady, Thanks I tried this and I guess I didn't have exacly the same feilds. I have more in the [ItpDescriptionInfo tbl] Table. Now I just tried from the [ItpTemplateTable tbl] the name of the cols Like this... "strSQL = Insert Into [ItpDescriptionInfo tbl] ([SortOrder], [Item]...

Hi, Can someone please help me I am selecting All the data from [ItpTemplateTable tbl] and coping it into the [ItpDescriptionInfo tbl] From double clicking in a textbox to copy the Data There is about 7 Cols - Both tables are exacly the same. I am getting a error on this - Expected End of...

Hi Kipcliff, Thank for your tip. Thats a good idea. I am going to use that BBryan

oh I see now. So you need to start off with the & ". and put the little bits together wioth the ". Thats where I made the mistake. Ok I am trying and learn from this. Thanks for your Help.

Thanks Pbaldy, That works great. Just a liitle note: Just so I understand - Why does a " & go in front of the DlookUp Thanks BBBryan

Hi Pbaldy, Thanks for you help. I did try this with DLookUp and I get an error. outputTestPackLabel = "\\llkna1-2\hewittb$\Welding Folder Structure\Job Packages - Welding Jobs\Maintenance\AdobePDFs\DLookup("[WorkOrder]", "WoTestPackLabelPdfQy") & TestPackLabelForAdobe (" & Format(Date...

Hi, If someone can help me. I have a button on my form that Outputs a PDF. I have got it to work and add Todays Date onto the file name. I also want to add a Work Order no from a Query but not sure how to. My Query name is [WoTestPackLabelPdfQy] I want the [WoTestPackLabelPdfQy] no to be the...

Thanks - Now I understand that (I was thinking it the wrong way) Thanks again

Just another question on this. If I wanted anther filter would I just add & " AND [another thing] Is Not Null" to the end Like this CombinedRRs: Concatenate("SELECT DISTINCT [No] FROM [RR tbl] WHERE RR =" & Chr(34) & [RR tbl].[RR] & Chr(34) & " AND [CompleteDate] Is Not Null" & " AND [another...

Thanks Bob Works Perfect!

Hi, I was looking for help. I am using Duane Hookom's Concatenate Module. I am using this in my query CombinedRRs: Concatenate("SELECT DISTINCT [No] FROM [RR tbl] WHERE RR =""" & [RR tbl].[RR] & """") this works good But I want to filter by another Column [CompleteDate] If the [CompleteDate]...