Recent content by mhtmarsha

expression/converting Tried it and it didn't work. :confused: It turned out to be only maybe 30 out of 600 records that this happened to.

expression/converting I couldn't find much on Format$ but did find something on manipuating text values and that is when i realized: I think I have figured out what is happening. In my orginal table the field of zip is a text field. It needs to be a number field. When I went to change the...

I have two tables I pull together to make labels in a query. In the query i made an expression to put the city, state and zip together in one field. exp1=Rtrim(city)&" "&Rtrim(state)&" "&Rtrim(zip) The zip code is formatted in the table it resides in 00000\-9999;;_ The problem is when the...

I am getting I can't get it to work. My relationships are as follows: ADDRESS_T-Address_ID-->DEPENDENT_T-Address_ID DEPENDENT_T-Childrens_Theatre_ID-->CHILDRENS_THEATRE_T-Childrens_Theatre_ID CHILDRENS_THEATRE_T-Childrens_Theatre_ID-->STUDENT_T-Childrens_Theatre_ID...

here we go again Boy you can tell i'm new. I am breaking up the databases to make smaller files and then attaching. If this works here is the first one

trying to post i zipped the database and saved it. Then when I pushed the browse button and found the file on my desktop. When I click it it show the path to the file but it after that i know not what happens. Am I not doing this right? is the answer somewhere on the forum? The file is a...

trying to post attachment I will try again:confused: i guess i know not what i do!!!! I tried to attach and can't seem to get it to work

got the zip Thanks for the site. I am going to try to post an attachment

I am very new at Access. I am just starting a very complicated system for my employer. I have a little knowledge but not much in coding. I have read some of the posts of the past but everyone's tables are different. The first thing i need is a mentor. I wish there was a little friend on my...

THANKS I'll try it and let you know. Once again thanks for your help.

I would like a message box to pop-up on the form load event that would aske the user for a last name then search the last name field for that name. I am using an application that allows the user to choose a form and then lookup a person by last name but they can not edit or change anything in...

I know I have probably asked this question before. How do I get more than one column from a combo box to fill in the forms fields. I have a form that is in a secondary table and I want the fields in the form such as: last name & Id number to be found in a lookup table and then pulled onto the...

Help me understand what you just said! Should i make a query using both tables then use the the query to make the form? Can i add new records to both table if i do that?

THANK YOU THANK YOU SO MUCH! I just knew i wasn't asking the right questions. All this time something so simple. Where have you been all my life. Once again thank you!

I was reading some of the other posts and saw that there is a way to post data from one table to another. If that's true how do you take data from one table(lookup) and place the data into fields of a form in another table. The reason being that we have a big parent table that has all...