Recent content by Jacob-Bushnell

Thanks Curious, but I was never ablr to figure it out. I ended up abanding the project... :( Thanks for the tip! I am sorry but I am not able to help you...

Hi CeeJay, I hav a simular problem and was wondering what you did to fix yours? Thanks, Jake

Thanks a lot every one! I fianly got my DB off to the printers. You all are a big help :cool:

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

Duh-Huh! :o Thank you, Fuga. I am not very good at databases yet! In fact, I've got a LOONG row to hoe! Thanks a lot

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

Right on Brad! I had a fragment of a vestigal On load Sub messing every thing up. Sorry about the messy code :o But Hey, everyones got to start somewhere! Thanks a Million Jake:D

Thanks Brad, Here you are.

Thanks Brad! It works! (well almost) it is now giving me a error message when I open the pop-pup form that says: " The expression MouseMove you entered as the event property setting produced the following error: Member already exsits in an object module from which this object module derives. "...

I am sorry but I still cant get it to work. :( This is what I have changed it to on the main form: Private Sub Command116_Click() If AdoptFam = True Then DoCmd.OpenForm "FrmFamAdopt = " & Me.LngFamilyID.Value Else End If End Sub And this is the Popup form code: Private Sub BeforeInsert()...

I understand what you are saying but.. I am not very experinced at this yet. What is the syntax for the WHERE aruguement? :o Thanks again, Jake

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