Search results for query: *

OK, I've added my original message, plus the section of my table at the bottom. I need to combine text fields into a memo field 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...

Here is an attachment with a snippet of the tablehttp://www.longbillduck.com/longbillduck/don/2010/062710/custinfo2example.xls

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...

Thank you, works perfectly

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

Perfect! Thank you so much

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

Thanks all for the information Sorry, I shouldn't have posted unless I knew I could get back sooner Anyway, I've got my subform to allow only one record by adding the following to my subform: If Me.Recordset.RecordCount > 0 Then Me.AllowAdditions = False Else Me.AllowAdditions...

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...

All the drives were mapped manually One policy for all is in use And I'll throw one more peculiarity to the mix I was informed that the person lost their connection again, sure I enough when I looked at it, the drives couldn't be accessed But we have a UNIX box that is accessed through the...

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...

Hi Roy-Vidar Well it turned out that I needed to go to TOOLS OPTIONS VIEW and then click the hidden objects, once they reappeared, I was able to un-check the HIDDEN Attribute on the property box Thanks Art

Roy-Vidar I tried your suggestion, that seems to hide the whole database

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

Thanks for the help! 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

Parkville I am using Access 2000 but could not find the FollowHyperlink in Help you mentioned in your post I'm a real novice at this, but do you mean & Me!txtUPS & is calling for the Label or the Text Box?

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...