Search results

Bob, after changing the code all I get is out of stck space followed by type mismatch errors...

So you're saying it should be like this: Public Function copyFile() Dim SourceFile As String Dim DestinationFile As String SourceFile = "C:\PCPICSW\CAPTURE.BUF" DestinationFile = "C:\INVESTMENT_REPORTS\CAPTURE.TXT" FileCopy SourceFile, DestinationFile If Err.Number <> 1000 Then...

I have a file called CAPTURE.BUF. I am trying to convert it to text. Here is what I ahve done, but I get the message box ever time. Can someone tell me what I am doing wrong? Public Function copyFile() Dim SourceFile As String Dim DestinationFile As String SourceFile =...

here is a skinned down version of the DB with 2 queries. 1. Expiring 2. Expired The clinet report is what I would like to see. The yellow area is just additional text I would like on the report so they can print the report and make notes. Thanks! Greg

I was able to have the query pull in data for fileds that are between date() and Date =45 with this query. SELECT Clients.Client, IIf(([date1]between Date() and Date()+45),[date1],"") AS [Date 1], IIf(([date2]between Date() and Date()+45),[date2],"") AS [Date 2], IIf(([date3]between Date() and...

And I want the report to look like this: User Name: BOB Date Expiring Date Date3 10/1/12 Date4 9/11/12 User Name: Sam Date Expiring Date Date2 9/11/12 Date5 9/12/12

SELECT Clients.Client, Clients.Date1, Clients.Date2, Clients.Date3, Clients.Date4, Clients.Date5 FROM Clients WHERE (((Clients.Date1) Between Now() And Now()+45)) OR (((Clients.Date2) Between Now() And Now()+45)) OR (((Clients.Date3) Between Now() And Now()+45)) OR (((Clients.Date4) Between...

My attackment show up just above your last post.

When I group it, the reports shows me all of the dates, not just the dates that expired, because in the query date2 may only be expiring for User1 and not user5 but is shows up for all users. Not sure if I am making since....

forgot to upload

Sorry for not replying earlier, I have been away. I think I am making this sound more complicated than it is. 1. I have a table that tracks 5 date fields that expire on that date. 2. I have a query that shows me dates that are going to expire in 45 days for all users. 3. I want to create...

If you can see the picture I uploaded, all I want is a report by user name that only shows me the date fields in yellow. Thanks

thanks, I am still trying to ficure this site out...:) Did you see the picture I uploaded?

Sorry, the spreadsheet did not import, this is what the query result looks like:

Thanks for the reply. I already have a query set up based on the criteria of "between Now() and now() +45". I get the following data...

I have a table that has multiple date fields and a name field. Name, Date1, Date2, Date3, Date4..... I need a report by name that tells me which dates are going to expire within 45 days. I would like the report to print the date filed that is expiring followed by text that says "New...

I have been working with access for a few years and really enjoy what it can do. Enery now and then I just need to bounce ideas off others who may have a simple answer for me. I live in the Denver area. I am looking forward to using this site. I appreciate everyones help in advacne! :)