Search results

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

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

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

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