Replies

Hello Andrew:

At this point then, I should just import the table into an existing spreadsheet. Thanks to all who responded.

Dillon

Hello AndrewKKWalker, Pat, Genii:

First, I have a table, not a report or a form; could my highlight request still work with the info provided by Hans. In the “Response” column, I have set this column up a check box. “IF” I check the box in the response column, then it should highlight that particular connecting row. Is this possible?

Andrew, I took a look at Hans sample, that is exactly what I have created, but when checked, I need to show a specific colour.

In Excel I have the following in the conditional format =$L42=1, =$L42=2, =$L42=3 this small formula allows me to change the rows into 3 different colours; depending on the outcome from perspective clients.

I do not believe that the above formula can be recreated in Access.

Thank you so much for your help everyone

dillon65/Nottingham

Hello AndrewKKWalker, Pat, Genii:

First, I have a table, not a report or a form; could my highlight request still work with the info provided by Hans. In the “Response” column, I have set this column up a check box. “IF” I check the box in the response column, then it should highlight that particular connecting row. Is this possible?

Andrew, I took a look at Hans sample, that is exactly what I have created, but when checked, I need to show a specific colour.

In Excel I have the following in the conditional format =$L42=1, =$L42=2, =$L42=3 this small formula allows me to change the rows into 3 different colours; depending on the outcome from perspective clients.

I do not believe that the above formula can be recreated in Access.

Thank you so much for your help everyone

dillon65/Nottingham

Hello AndrewKKWalker, Pat, Genii:

First, I have a table, not a report or a form; could my highlight request still work with the info provided by Hans. In the “Response” column, I have set this column up a check box. “IF” I check the box in the response column, then it should highlight that particular connecting row. Is this possible?

Andrew, I took a look at Hans sample, that is exactly what I have created, but when checked, I need to show a specific colour.

In Excel I have the following in the conditional format =$L42=1, =$L42=2, =$L42=3 this small formula allows me to change the rows into 3 different colours; depending on the outcome from perspective clients.

I do not believe that the above formula can be recreated in Access.

Thank you so much for your help everyone

dillon65/Nottingham

Hello AndrewKKWalker, Pat, Genii:

First, I have a table, not a report or a form; could my highlight request still work with the info provided by Hans. In the “Response” column, I have set this column up a check box. “IF” I check the box in the response column, then it should highlight that particular connecting row. Is this possible?

Andrew, I took a look at Hans sample, that is exactly what I have created, but when checked, I need to show a specific colour.

In Excel I have the following in the conditional format =$L42=1, =$L42=2, =$L42=3 this small formula allows me to change the rows into 3 different colours; depending on the outcome from perspective clients.

I do not believe that the above formula can be recreated in Access.

Thank you so much for your help everyone

dillon65/Nottingham

Hello AndrewKKWalker, Pat, Genii:

First, I have a table, not a report or a form; could my highlight request still work with the info provided by Hans. In the “Response” column, I have set this column up a check box. “IF” I check the box in the response column, then it should highlight that particular connecting row. Is this possible?

Andrew, I took a look at Hans sample, that is exactly what I have created, but when checked, I need to show a specific colour.

In Excel I have the following in the conditional format =$L42=1, =$L42=2, =$L42=3 this small formula allows me to change the rows into 3 different colours; depending on the outcome from perspective clients.

I do not believe that the above formula can be recreated in Access.

Thank you so much for your help everyone

dillon65/Nottingham

Hello AndrewKKWalker, Pat, Genii:

First, I have a table, not a report or a form; could my highlight request still work with the info provided by Hans. In the “Response” column, I have set this column up a check box. “IF” I check the box in the response column, then it should highlight that particular connecting row. Is this possible?

Andrew, I took a look at Hans sample, that is exactly what I have created, but when checked, I need to show a specific colour.

In Excel I have the following in the conditional format =$L42=1, =$L42=2, =$L42=3 this small formula allows me to change the rows into 3 different colours; depending on the outcome from perspective clients.

I do not believe that the above formula can be recreated in Access.

Thank you so much for your help everyone

dillon65/Nottingham

Hello AndrewKKWalker, Pat, Genii:

First, I have a table, not a report or a form; could my highlight request still work with the info provided by Hans. In the “Response” column, I have set this column up a check box. “IF” I check the box in the response column, then it should highlight that particular connecting row. Is this possible?

Andrew, I took a look at Hans sample, that is exactly what I have created, but when checked, I need to show a specific colour.

In Excel I have the following in the conditional format =$L42=1, =$L42=2, =$L42=3 this small formula allows me to change the rows into 3 different colours; depending on the outcome from perspective clients.

I do not believe that the above formula can be recreated in Access.

Thank you so much for your help everyone

dillon65/Nottingham

Hello AndrewKKWalker, Pat, Genii:

First, I have a table, not a report or a form; could my highlight request still work with the info provided by Hans. In the “Response” column, I have set this column up a check box. “IF” I check the box in the response column, then it should highlight that particular connecting row. Is this possible?

Andrew, I took a look at Hans sample, that is exactly what I have created, but when checked, I need to show a specific colour.

In Excel I have the following in the conditional format =$L42=1, =$L42=2, =$L42=3 this small formula allows me to change the rows into 3 different colours; depending on the outcome from perspective clients.

I do not believe that the above formula can be recreated in Access.

Thank you so much for your help everyone

dillon65/Nottingham

Hello Hans:

Sorry my last post was not written correctly, I am trying to omit the email, and phone number sections, yet, I find it difficult to do?

dillon

Hello Hans:

Thanks for your support I have followed and tried your instructions, however, I am trying to omit the email address and the phone number, it give you blanks and nonblanks, but I cannot seem to get rid of the two columns.

Thanks

dillon

[indent]

---

How could it possibly be installed upside down and still work? Why could it not be that the USB add-on card has the ports in another direction than the built-in ports on the motherboard?

And if you add an USB card with 2.0 support, why would older ports on the motherboard “convert” to 2.0?
quoted

---

[/indent]

Argus: I am not a techie of any kind, when I purchased my computer, I had a bluetooth usb that would always blink a blue light on top of the BT. Now I have to turn it upside down, so that I can insert the BT device.

There could be a great possibility that the “A-Byte Card” is made that way. Since I have no Techical experience with motherboards, I would not have known this, that it why I posted my questions on the board. It is called learning.

Viking: Thanks for your explanation.

dillon

Hello JohnGray:

No Red crosses seen, after doing some research I found that I could boot up in safe mode, and do some searching. I think the reality is with the IRQ my computer is about 4 years old, she running on a 1 gig up from 768.

I read some where today that once you install the 2.0 usb card, a lot of times the 1.0 card will not convert to the 2.0. It is a fact that I will just have to tollerate, but I just want to know why.

Also, can you confirm for me why the IT person would install the 2.0 card upside down. I spent hours trying to figure out why my Palm and other handheld devices would not work, I could not even insert them into the 2.0 slots. Unitl I turned the Usb cable end upside down, which did allow the USB’s to get inserted. Is this normal?

Thanks dillon

Hello JohnGray, Kaplinb:

JohnG: When I follow your instructions I see the following:

Sis 7001 PCI to USB Open Host Controller – I see this twice
USB Root Hub – I see this four times
ViA Rev 5 or later USB Universal Host control – I see this twic
VIA USB Enhanced Host controller – I see this once

I don’t know what to look for when looking at the Universal Serial Bus Controller.

Kaplinb: I have done just that, I have moved all USB cables to the 2.0, I was told that in the IRQ there is not enough sharing space, so that is why an individual would loose the connection to use the USB 1.0. All my device work in the 2.0

To anyone else who may stumble on the same situation, check out http://www.usbman.com, look for customer/retail section. I saw a lot of good topic about devices not working.

JohnGray: If you can get back to me about the Serial Bus controllers, that would be great. I just want to know why this has happend.

dillon

Hello Hans:

Good Morning, Thanks for your help, I noticed that 12 of 13 was blank with the words “section break on the top”
13 of 13 allowed me to resume typing the rest of the document.

Thanks so much.

dillon