Search results

Here is what I am trying to do. Open a table in design view, to change the data type in one field from “text” to “number” The problem is the table is “linked” and I can’t seem to figure out how to “unlink it” Help.

Hi, I am trying to import data from a MS DB to an Outlook contact file. I know it seems odd but I need this so several of my co-workers can store address on their Palm-Pilots. Any way, my problem is that it doesn't seem to recognize my Primary-Key (Auto-Number) field after I have imported the...

OK, I have gotten thru the first step. I have now updated fields with in the same table. I used the Expresion builder to make the following querie: UPDATE LORTON SET LORTON.ADDRESS = LORTON!COA_DELADR, LORTON.CITY = LORTON!COA_CITY, LORTON.STATE = LORTON!COA_STATE, LORTON.ZIP = LORTON!COA_ZIP...

I sent some of my data to a data processing company that updated all my address (14,200) using the National Change Of Address Data base. The data I sent is (The Unique ID #, FIRST NAME, LAST NAME, CITY, STATE, ZIP.) The data I got back is all the above plus new address, city, etc. for Some of...

Hi, I have this code I am using in one form to open a "sub" form in MS access 2002. It calls the ID from the sub-form and goes to the record that has the matching ID. My problem is when the sub form does not have that paticular ID it just opens the first record. How do I make it so IF there...