Replies

Thanks! At least I have something to try!!

Leesha

What version of SQL Server Express are you using? 2008, 2005 or 2000?

The are using 2005.

>>And you may need to set permissions in the SQL Server side for the userID being used in the ODBC connection.

I haven’t had to do this for any of the other 3 users. The other users are in Access 2002 which is working fine. The are all using the same front-end for each workstation. The only difference between this workstation and the others is the Access version = 2007. I’ve tested the ODBC connection in Control panel and the test is successful. It’s not until I try to open the access database that I run into issues.

Leesha

Thanks Hans! I really appreciate it. Now on to investigate user error and winfax!

Leesha

Well, the bright side is at least I’m getting better at reading code! I couldn’t see anything wrong either. I’m convinced its something with the winfax retaining faxed history somewhere in memory.

The owner of the database is wondering if it has anything to do with the email portion of the code. Again, I don’t believe this is the case since not all duplicated faxes had email with them. Could you do me a favor and click the button labeled “RFQ Entry” and then code behind the button that says “Email RFQ” and “Email with Pic”. This also has been working fine till the recent problems and I just want to be sure there is no glitch here, since this my code that I added with your help a couple of years ago.

Thanks!
Leesha

OK, here’s the database. Click the big button that says “nightly fax list”. I’ve set it so that there are faxes that are due to go out.

Leesha

I’ll try to strip it down to a small enough size. My problem is that I don’t know the database that well and don’t want to miss giving you something you need.

OMG Hans! That sent a chill down my spine! If you can’t solve it I never will. Is it safe to say that the database looks OK from what I’ve sent??

This is my third attempt at responding to this since it doesn’t seem to be taking.

>>Does the record source of the form select only the records for which Quote Faxed is False? If it includes records for which Quote Faxed is True, a fax will be sent each time.

I’m attaching the sql for the query that the form is bound to. I’m not sure if the piece that is red is needed or what its doing, as I didn’t write this. However, according to the user its been working fine until recently.

SELECT DISTINCTROW First([Vendor List].[Vendor Name]) AS [FirstOfVendor Name], Count([Vendor List].[Vendor Name]) AS [CountOfVendor Name], [Vendor List].[Vendor Number], [Vendor List].Phone, [RFQ Details].emailsent
FROM [Vendor List] INNER JOIN [RFQ Details] ON [Vendor List].[Vendor Number] = [RFQ Details].[Vendor Number]
GROUP BY [Vendor List].[Vendor Number], [Vendor List].Phone, [RFQ Details].emailsent, [Vendor List].[Vendor Name], [RFQ Details].[Quote Faxed]
HAVING (((Count([Vendor List].[Vendor Name]))>0) AND (([RFQ Details].emailsent)=No) AND (([Vendor List].[Vendor Name]) In (SELECT [Vendor Name] FROM [Vendor List] As Tmp GROUP BY [Vendor Name] HAVING Count(*)>0 )) AND (([RFQ Details].[Quote Faxed])Yes))
ORDER BY [Vendor List].[Vendor Name];

>>Otherwise, could the Quote Faxed be set to False by someone else or by some other code? That would cause the fax to be sent again too, even if the form only shows records with Quote Faxed = False.

They can manually mark a quote as faxed but if they do they don’t come up in the above query, which is fine. At the end of the day they run the fax report and the records that are in the list are correct. The issue is that there are faxes that are sent that are old and were sent before and there is no pattern behind why this is happening. I can’t find anything in the database and unfortunately don’t know winfax well enough to know if it stores anything that has been deleted in old memory.

Leesha

>>BTW, are you sure it shouldn’t be InStr([visit_stat],’n’) instead of InStr(‘n’,[visit_stat])?
[/quote]

LOL! Hans, I’m the last person to ask this of. The report was set up for by by Francoise (sp) and worked wonderfully and I certainly never questioned it. At that time, the code didn’t even make sense to me. At least now I can understand it a little bit better.

So, here is where I’m at. I keep getting an error that there are no records. I wasn’t sure which new filter would be causing it so I took out the filter on [pay_unit]=’V’ and it ran. When I kept in [pay_unit and took out the PT and RN filter, it ran. There is something about having both filters in that results in no records error.

Also, to add to the confusion, I need to report to filter PT and RN [skill] that have [pay_unit] as “V”. If [pay_unit] is “H” then it should ALWAYS stay in the report. I didn’t catch that yesterday as I started working on this.

I’m uploading a stripped down version of the DB.

Thanks,
Leesha

Thanks to both of you! I can’t believe I missed that. I guess I was too tired to see the forrest for the trees.

Thanks,
Leesha

Hi Pat,

Good point, I’ll check this when I go back on site.

Leesha

I totally forgot to check these and although there are sorts set, none of them are for [date entered]. I did find the table that has this field however it is not in the query for the data in the report. I did not when I reopened the DB in 2000 that there was a filter on [date entered] in the properties. I removed it but will have to go back on site to see if that affects anything since I don’t have 2007 on my computer.
Thanks!
Leesha

Hi!

Thanks for the input. It ended up being a problem on the server end. I had to disable my FP extensions and then re-enable and then it worked fine.

Leesha

Gotta love the little things in life! That was perfect.

Thanks!
Leesha

Wow, who ever would’ve thought of “restore”. Anyway, that does the trick for that form but now what happens is all the forms restore. Basically I want this form to be like a popup window. All other forms should stay maximized except this form.

Leesha