Search results for query: *

What I have is a table with two fields First field is the Cust_nbr and the second field is Notes. My problem is that I have multiple fields to combine in the Notes field. Some records may have two fields that need combining and others may need as many as 10 fields; and still some cust_nbr...

I have a field that has information like this: MPN-B-AB184-9M I want the field to show up without the hyphens: MPNBAB1849M Is there some what this can be done? Thanks Art

Can anybody help, I’m trying to create an iif statement that would return a 1 if the number were anything but whole. For example: 1.333 = 1 9.5 = 1 3 = 0 Thanks Art

Only one record in a subform per main record. I have a form, with a subform The form is based off a linked table The main form shows a sales order number, with product number and product quantity ordered The subform is related back to the main form by the sales order number, product number...

It's monday so I got a strange problem, strange to me anyway I've got a XP Service Pack 2 machine on our Server 2003 network I can access the internet, I can ping other computers and devices on our network, but the mapped network drives cannot be accessed! The drives show the red X as though...

We recently installed Server 2003 and for the most part has been working great We have a combination of PC’s on the network running XP, ME and 98 There are 3 ME machines of which two of them, almost daily, once or sometimes twice,lose the connection to the network. The person needs to reboot...

In my database, I was looking at the properties on one of my forms. I then clicked HIDDEN How do I bring it back into view??? Thanks Art

I know I can use =Date() to add the date to a new record But is there a way to add the date and hour & minutes? Thanks Art

I'm trying to figure a way to change a field color say from white to red when a box is checked. I'm seem to remeber seeing this somewhere, but can't find it now Any help would be appriciated Art

We download our shipping information from the UPS computer system into a Access database This includes the UPS tracking number Our Sales department wants to be able to click on a link, which in turn would bring them to the UPS tracking site and display the progress of a shipment What I'm...

Does anybody remeber how to start Access and have it open to a specific form I recall doing it before. I don't want it to start Access,showing all the objects, then clicking on the particular form. I would like to just click on the icon and open to the form THANK YOU Art

I'm trying to count pages printed in a form. Basically I need to print a form but have multiple copies The first copy will say 1 of 5, then 2 of 5, etc. The next time I would run the report I will need to change the final count, perhaps to 10, or 6 or whatever Can this be done? Thanks Art

I need run a query where a negative number changes to zero, but any positive numbers are also shown. Art

Can text be rotated on a report or form? Does anyone know how to rotate text 90 or 270 degrees I need to generate a report where this or something close has to happen THANKS Art

I'm trying to count pages printed in a form. Basically I need to print a form but multiple copies The first copy will say 1 of 5, then 2 of 5, etc. The next time I would run the report I may need to change the final count to 10 Can this be done? Thanks Art