Recent content by lovett10

I have a report which i need to display two databases of information on one page, one under the other. The first "T1" has 5 records, whilst the Second "T2" has 10 Below is a link to a picture which will hopefully explain what i mean http://imgur.com/S8uXrnQ Thanks in advanced for any help.

I have a text box and a button.. lets say (Text1) and (Button1) I have a folder on the server (\\Server\Projects) What i want to happen is when the user presses the button it will search in the folder on the server and its sub folders for the text in the textbox.. However the text may only...

I have a button (Command5) on form "Homepage", I want when i press it for it to open the report whilst also changing the caption on (Label34) on the report, to the same as (Text72) that is on the form. Thanks in advanced

Anyone got any ideas?

Here is my code [CODE]Function CreateWonJobFolders() Dim fs, cf, QJobNum, pd On Error Resume Next If [Forms]![QTender Edit]![Won] = -1 Then Msg = MsgBox("Create Project Folders?", vbYesNo, "Folder Creation") If Msg = 6 Then '(yes) QJobNum = [Forms]![QTender Edit]!

Hi, i have a textbox called "Text88" which is labelled Client Contact. What i want to happen is this automatically fills in information from the table "Customers". All the other text boxes and combo boxes write to the table "VisitSheetTable". VisitSheetTable and Customers have one field in...

I found the problem it was the saving to C drive when i just leave the pathfile to "" it works... ofcourse i still need to figure out how to choose the file :P

Me.Combo16 is just a text box which currently has "CP002 Field and Plant" which is the name of the table and reports

I didnt originally have that it was just a test because the table and reports have the same name so i thought it may be geting confused so i added the " R" to one of the reports as a test... still gave me an error

There is a _ but when i take out Me.Text18 i still get an error

Hey thanks for the help. Im getting the same error over and over... Run-time error '2059' Microsoft Access Cannot fins the object '|1' Heres my code: Private Sub Command6_Click() Dim strFile As String Dim strDestPath As String Dim strDestFile As String Dim blnShowPdf As Boolean strFile =...

Ah ive figured out the problem it is because of invalid characters :) thanks again.. oh and is there a way of specifying where it saves too?

Hi thanks for the reply Heres what i have... Dim stDocName As String Dim DocName As String stDocName = Me.Combo16 DocName = Me.Combo16 & Me.Text18 & ".pdf" DoCmd.OutputTo acOutputReport, stDocName, acFormatPDF, DocName, False i get Run-time error '2501' The OutputTo action was canceled.

Im looking to temporarily change the name of a report to the contents of Me.Combo16 & Me.Text18 Then change it back after PDFing to just Me.Combo16 Here is my code to PDF (which works perfectly atm) Private Sub Command6_Click() Application.Printer = Application.Printers("Adobe PDF")...

Thanks guys it works now :) And Pat in the code before it wipes it clean it archives them so they can refer back if needed :D