Search results for query: *

I am trying to take a cell with a text format and add dots between each set of 2 characters for showing a NIC mac address. Thanks in advance.

I have looked, and could not find a solution for the problem I have. I was having problems with Windows XP Pro on my laptop. I decided to reinstall XP. During install, on reboot, I received an error message. Everytime it reboots, it reverts to install, then reboots, in a loop. I know I can...

Help!! A company I do work for has had a crash in the Domain server. Here is a brief background. This is a nursing home in a small town. Noone knows who set up the network. The system has a domain controller (W2000Server), and a database server (NT4 Server). They called me and said the computer...

I cannot get this to work. IIF([wholenm] = "," , 1, 2) also tried IIf([wholenm]= *","*, 1, 2) no luck always get "2". The field wholenm has this format (Smith, John), problem is some people at this company just entered (John Smith). I need to use instring and lenght to pull first name...

Help, I am a network and database consultant. Problem is that some of my clients are small, so I have to be everything. Hardware troubleshooting is my weak suit, and I normally tell my clients that they would be better off buying new equipment rather than paying me to fix older systems. I would...

I have a query which I use as a recordset for a report. In this report, there is a text field where the report needs to return only the items on the first line (ie. everything left of the first carriage return). I had created a field using x:= Left([fieldname],InStr(1,[fieldname],&quot...

Help! I manage a client server dbase with the tables split to the server, and each client with his/her own specialized application. One day last week, I came in to the office and someone informed me that there was a problem with the computers. I found corrupt data is one record in the table. I...

Help, I have a customers table with a related services table. I want to remove older customer records by using a make table query (arccustomers), and then do the same with the services table, but still maintain (or restore) the relationship. I have tried this method but cannot restore the...

I am having a great deal of difficulty in keeping a form's print settings the same. It is a service form which is printed on a dot matrix printer (Epson kxp-1091). This form's print settings never change (it is a custom page size(1/2 page), print resolution is 144x72, margins .25,.25,.25, .416)...

I need a way of making sure a data entry person does not enter more than 3 names in a field, ie (John Larry Smith) is ok, but (John Smith Mary Smith) is not. My thinking is to count the number of spaces on an exit_event, and produce an error message if there are more than 2 spaces. Currently...

I have read some answers for the split function, but do not understand. I need to take the first and last names from a full name field to create two separate fields. I have two empty fields in the table which I wish to fill. Thanks in advance. Jimdevon