Recent content by chappy68

I don't think it is a non printing character. I deleted the offending record and re-entered. Same problem. I placed a dot in front of 007 and it worked also. Very strange situation. Still unable to determine WHY is didn't work.

Strange situation I have solved but don't know why I had the problem. Just want clarification so I don't have this happen again in the future. Using Access 2007. I have a table "StoreInfo" that stores the store number, store address, etc as text fields. I then have created a query...

I was leaning that way but I was hoping you wouldn't say that. I am not familiar with SQL Server at all. I know I can migrate to SQL Server through Access but since I don't know SQL Server I won't be able to tell if it did a good job.

We are trying to decide between reworking our FE/BE Access 2002/2003 database in Access 2010 or SQL backend and Access front end. My prior experiences with Access 2002 was when the database bloated to about 100mb, it started having problems corrupting records and became unstable. I spoke with...

I am now. The query only has 2 columns so that is why it would be null. I tried it and it worked. Thanks for the help. Hate it when I miss the small stuff. I can't tell you how many times I have read that and I still forgot it.

This seems to be a common question but I can't get it to work with any of the suggestions I have seen. Here is my problem. My row source is a query bound to the ID in column 1. I want the Client Name in column 2. In the red highlighted portion of the code, if I leave the .column(2) off, my...

I think I just need to start over. I have to much code going around that is mixed with the site you suggested and the one I found in the forum. Once I get it setup, I will see if the problems still exist. Thanks for the help so far. Will keep you informed.

Let me clear this up. When I say the the export to Excel is working, I mean the query is exported to Excel and the file opens and all my data is present. The problem is when I try to run the code to format the Excel file. The red hi-lited code is what comes up when the code bombs. I have also...

After more searching I found some code which I thought would do the trick. I am now getting a compile error: sub or function not defined. The export to Excel is working just fine. I just need help on the formatting issues. Here is the code behind my button: Private Sub...

I have a query I want exported to Excel. I then want to format the Excel file for column width, font, font size, bolding, etc. I created the macro in Access 2007 to export the query and then open in Excel. I then converted the macro to VBA. No problems there. Tested and everything is...

Perfect. Now I understand. Thanks for the patience.

When does it become an error? Your text box formula captured it at the form level. I made the assumption that since it can be captured as an error at the form level, it could also be captured as an error at the query level.

Just out of curiosity, why won't the IsError funtion work directly in the query as: =IIf(IsError(Count([QAsked])),0,Count([QAsked])) I tried it and it didn't work. BobLarson, I appreciate your response. I had not even considered the outer join. So far I was able to change the original...

That is not the answer I wanted. I can't believe how much time I can spend on items that won't change user behavior. I thought this was just a simple nz() function and I was off to the next issue. I appreciate the help.

If there are questions asked, the count is coming back correct. What I want is a "0" to appear if there are no questions asked on a selected task. Right now I get an blank instead.