Search results

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

Access version 2000 and the form is a form for my main parent table. The informaion in this form is used in several other tables but this form will be used by users and needs to have some field stick out more than others but only when the information in those fields has certain data. I know I...

I put the code in OpenForm and AfterUpdate and the code likes it there so well it travels to the next record. If I change the next record and go back to the previous record it changes that record also. There must be a way to keep it in one spot. I tried the breakpoint but came up empty...

I tried the code above and couldn't get it to work. So I tried my code in the exit event and it worked. It turned the field red upon exiting the field if the condition was right but I need it not to change unless someone puts in something different. Also when i went to the next record it kept...

I have a form that I want the text to change colors when a certain condition is met. such as: form_current footlights.forecolor = Iff(footlights.text = "xx/xx", 0, 235) I have several of these fields and can't seem to get it to allow me to do this. I would like the colors in the fields...