Search results

Thanks for the help all. I can't belive it can be completed in 1 line......awesome! Boz

Hi all. Just a quick question..... I have a database which is constantly filling up, and a unique "Customer Complaint number" field. mad up from "CCN-xxxx/06" (where xxxx is the identifier.) I have written a bit of code that accepts claims for different companies via email by searching...

Hi there, Im not sure where you are calling strReportName.ps from. I can't find details on naming a report to generate a postscript. I think this is where Ghostscript comes from (searching other output PDF threads) Can you explain this part please. Jon

You are a God..... Cheers!

Hi all. This is more than likely to be real simple, but I can't get it to work.... I need to add a string into a Form! line. Here is what doesn't work Dim rs As Object Dim frm, fld As String Set rs = Me.Recordset.Clone rs.FindFirst "[ID] = " & Str(Me![Combo16])...

Thanks, I'll remember that!

Afraid you have lost me there Mile-O-Phile.......

This looks a little daunting but here is an example with a lot removed. The basics are that quotes inside strings are changed to " & stquo & " and that I used a line per SQL option. In the end, I joined the strings together, and created a query. Been as you are so close to taste it, you should...

This may be simple, but I just can't get it to work!! I have 2 tables; a) A list of standard document tiltles b) A list of documents for a project There are 20 standard documents titles in table a) which never changes, and there are only 10 of them in done so far in b). If i make a query to...

You could have a combo box that selects the data you want to query, then open a new form with: [Whatever]='Whatever' in the filter property. this will limit that form to the data selected, and on the onopen or onload property, you could build code to print and close it automatically. Dunno if...

You cold also use this.... IIf(Len(Format([Date],"ww"))=1,Format([Date],"yy-" & "0" & "ww"),Format([Date],"yy-ww")) I have used IIF statements in SQL before.....

You could use a crostab query to generate the frequency (amount) of data between set range. If you used COUNT in the columns, and set your headers it should work. The data will be in a table that has columns for whatever frequency / range you use and the single line of data will be a count of...

Got caught out myself on this little issue, but used this to work around it : Format([Fieldname],"ww/yy- ",0) or if you want to make it so it appears in the right order: Week: IIf(Len(Format([Fieldname],"ww"))=1,Format([Fieldname],"-yy-" & "0" & "ww"),Format([Fieldname],"-yy-ww")) The...

Hello all, I'm a bit green with VB so appologies up front!!!! Does anyone know of a way to stop the pop-up boxes for make table and append queries, and to default to OK??? I would like to run this little bit of code automaticly without having to click OK a million times!!!! Here is a snippet...