Search results

I need to export data from an Access query to a QIF file so it can be used by a client who uses Quicken. Quicken does not appear to have Import facilities for database files or Excel either, so do I have to build it raw??

Many thanks, Rich. That will save me a lot of time!

I have completed a rather basic payroll system for a client and am down to designing the check-writing part. I suddenly realize I cannot find any functions that convert dollar amounts to English text as required on a check (i.e., $150 is translated into "ONE HUNDRED FIFTY & 00/100"). I realize I...

Unfortunately www.unsoftwareag.com seems to be out of business. I have been referred to this web site twice in the last few days and find nothing but a message giving the ownership of the domain name.

=iif(isnull([fieldname]),0,[fieldname])

You will have to supply some code before a reader can understand your problem. Are you getting the beginning and ending dates from a form, from calculated fields in a query, from a lookup, or how?

Problem is that you should not use the month function at all. Either =Format(Date(),"mmmm") or =Format(Now(),"mmmm") will produce what you want.

More... On second glance, maybe what you were trying to do was this: me!Text140 = DLookup("[febbudget]", "budgets", "[RegionCode] = " & GlobalRegionCode) I can begin to see some light in that...

First of all, your syntax may be causing various problems. Try something at least similar to ... If Month(Date) = 2 Then DLookup("[febbudget]", "budgets", "[RegionCode] = " & Me.Text140) End If I wasn't sure what you were trying to do since the criteria in DLOOKUP was not formatted as a string...

An amendment to clarify my initial post... I have no problem in using jpegs, gifs, and other formats for embedded unbound objects, so am I missing something since I seem unable to use bound objects in anything other than Windows Bitmap format?

I am completing a payroll module for a client and he would like to be able to print payroll checks from it. I don't see any choices available among Access 2000's report wizards and wonder if anyone knows of any special add-ons available to make it easier to design for standard business checks.

I have a report page one of which is a cover letter, the entire report to be e-mailed as a sendobject. I have stored images of several signatures in a table as OLE Objects, and on the report, the source for a bound object is the field containing that image. However, when the report is printed...