Replies

Dan and Jim do have seperate usernames.

Thank You

When I print from Excel 2002 SP3 I get all 7 pages.

But I do notice that the workbook uses some kind of Far Eastern font – could that cause the problem? You might try setting the font for the Normal style to a Western font such as Arial or Calibri and see what happens.

Thanks, I would have not thought about changing the font. Once the font was changed all 7 pages printed. Thank you both for such fast responses. Now I just have to wonder how many times an Excel sheet printed out and someone did not get thier pages and never thought about counting to see if they were all there.

I check and see if there are any updated drivers that fixes this issue.

Can you replace any sensitive data with gibberish and post the file?

Here is a copy of the excel sheet. All personal data has been removed.

Thanks

Winston

1. How did you determine that you need that 40 amps on the 12volt line?
2. That spec sheet is a little confusing to read as to the intent of total current capacity. I would read it as being 20 amps on each
line BUT……
3. Who is the manufacturer? I would double check with them. It just doesn’t look like a “standard” spec sheet and some companies do not always comply with standard coding for their products. That’s not saying that they aren’t OK, just depends on who wrote the sheets. Go to the source for the right info.

Sorry, about the long post back. I did not have access to a computer for a couple of weeks. My old power supply finally failed. I have a new one installed now. I decided since I was replacing my PSU that I would treat myself to a nice video card. I just wanted to make sure I got the correct power supply for it.

1. The video card maker list it in the specs, but they did not state that using two separate connectors at 20 amps each, if that would get the 40 amps that I needed.
2. You are correct, it is 20 amps on each, I was not sure if you used two separate rails would it equal the 40 amps needed. That would be a yes for me; the video card has two separate connecters for two different rails to connect too. Using those combined will cover the requirements for the video card.
3. Thanks, I did go for the source. I did not have a computer to see the posted back I had an idea and called the manufacture. The spec sheet for that power supply shown was OCZ, I ended up getting one from Kingwing.

Thank You for the input.

Winston

I can open the database with the shift key held down. That got me thinking, so I tried to open a table that was linked, the database crash again. Then a little light bulb came on inside my head. I went into my ODBC manager and looked at list of drivers installed and seen a new one. The short story is the IS Department had an outside vendor adding drivers for a new database. For some reason he had to go back and change some settings and went into the wrong driver. He had changed the network libraries type to VIA in the Client Configuration area for my normal set of drives to the SQL server.

Every thing is back to normal for now.

Thanks

Thanks, I have been in such a hurry to finish this project I overlooked that simple qualifier. The whole time it should have been less than 1. I am sorry for taking up your time. I should have caught that this morning. I feel so embarrassed right now. I knew this should have been something simple.

This is a very basic stripped down version of the database.

I did use the name of the controls for the subforms as they are shown on the main form. This did not work either. I have tried what I have posted along with a few other ideas I found but no luck so far. I will try to do some more research tonight when I get home from work

Thanks,

Sorry, for not being too clear. The person who asked for help keeps standing over my shoulder saying are you done yet every 10 minutes. I was rather rushed, let me ask him his logic on what this sheet is to accomplish. As I do not understand what he is, telling me what he needs fully myself.

First, create a function the calls the user name

CREATE FUNCTION fnGetUserName()
RETURNS varchar(16) AS
BEGIN
RETURN SUBSTRING(SYSTEM_USER, CHARINDEX (” , SYSTEM_USER)+1, 50)
END

Then in the UserID Criteria put = dbo.fnGetUserName()

I use this on several reports to only allow that user to see their information and not someone elses. I have a table that stores the user name and which information they are allowed to see.

I studied this most of the weekend. I finally tracked down on what was going on with the data. There were two mistakes being made. One was the wrong part being keyed. They were using the letter O instead of a 0 (zero). Second, the where used list that I got someone made a mistake on the list.

If anyone that spent anytime looking into this Thank You.

After posting I was wondering about the dteDate1 and dteDate2 between the quotes. Thanks for you help, working as attended now.

Thanks, I am new at using Record Sets in code. I added the loop and had an error in my strSQL. I had put the wrong table for the qtyper field in my SELECT clause. Everything works perfect.

Thanks again,

In your code the names do not match the controls on your form.

Example
Private Sub cboTCR4_AfterUpdate() Should BE
Private Sub TCR4_AfterUpdate()

Me.chkTCR_5a.Enabled = True should be
Me.TCR_5a.Enabled = True

Try changing these and see if that helps out.

I added the code to both On Print and On Format events of the report. I did not notice any performance difference. But this did not work.

What I found out is that I had the controls for the y-axis in another sub report. I changed my queries around to add it to the main report it in a text box. Now it works perfect with the code only in the On Format event.