Recent content by forkEP

Well now... If only I had realized that BEFORE wasting my time looking to make a batch file ahhaha. Oh well, thank you much for the information, and I will definately look into utilizing that program in the future.

Thx for the option. I wanted to avoid any new programs on my server. Thats why I was trying so hard to find a batch file option. ;)

I surfed around the net and really wasn't able to find any batch files to delete IIS log files. The closest I was able to come was to delete all files in the log folder based on the file age. This batch file will delete all files in the named folder that are over 1 day old: @echo off forfiles...

I realized late last night that I forgot to list that I have a subreport, which I realize is a HUGE thing to leave out :( Yes i am seeing duplicates for invoice number, one for each ticket that is attached to that invoice number. For the Subreport: Link Child Field =...

SELECT tblCustomer.*, tblJob.*, tblTickets.*, tblInvoiceNumber.FuelSurcharge, tblInvoiceNumber.DateCreated, tblInvoiceNumber.JobNumber, tblInvoiceNumber.WeekEndingDateShown, tblInvoice.TicketNumber, tblInvoiceNumber.InvoiceNumber FROM ((tblInvoiceNumber INNER JOIN (tblCustomer INNER JOIN tblJob...

Im having a small problem with my invoice report running over multiple pages for each invoice entry I have. I have a query based on 5 tables: tblInvoiceNumber (which I am setting the criteria to the text box of the open form [Forms]![frmInvoice]![tblInvoiceNumber_InvoiceNumber]) tblCustomer...

Well, good news. After wrestling with it for about two hours, I got everything to work together. For anybody else, here is the code I used: Dim strSQL As String strSQL = "SELECT tblCustomer.*, tblJob.*, tblTickets.*, tblInvoiceNumber.*, tblInvoice.* FROM ((tblCustomer INNER JOIN...

Thank you very much for the assistance. After making a tweak or two to my actual setup, your code worked perfectly. Now I get to deal with updating the bookmark. I posted another question concerning that also, if you were interested in that also ;)...

oops, sorry for mistake, the title should be "Form" ;) thanks again.

I have a form "frmInvoice" which has two combo box's "cboDate" and "cboJobNumber". Based on the selection of these two pieces of data, I want the form to populate with the corresponding information. The Form is based on a query which has tables (tblInvoice, tblInvoiceNumber, tblTickets...

I have a form/subform based on querys. The query which the form is based on has 4 tables attached, with all related relationships. I have two combo box's pulling their information from tblInvoiceNumber: "WeekEndingDateShown" and "JobNumber" through the query. What I need to accomplish is...