Search results

Thanks guys, i will try these options. I appreciate the help.

Is it possible to have a report (based on a query) to show different colours for different values? For example I have a report that shows different reasons. I would like any line with the value "System Down" to be in Bold Red. Not just the word System Down, but the whole line. Thanks.

I have an Access database that sits on a folder on our network. Only three users have access to it, so there is rarely any conflicts with it. However, one of the guys using it is generating different results when he views only one of the reports. We all access the database using a shortcut on...

I FOUND IT!! It was in the switchboard all right. Thank you, Rich. I had the command in the swithboard table set to '2' which is add. I changed it to 3 and now it allows the recordset to show in the tables. Again thank you Rich!

i have a stripped down copy but the file is still too big.

ok as i was making the stripped down version something strange occured. I could open the form and it would work fine!! Make me angry. So I went back to the original and it still would not work. It seems that if I open the form right from Access window it will work, but if I open it from the...

i have deleted it and recreated it numerous times. I have thought about deleting the form and recreating it as well. ...also, the requery did not work so it is not being used.

tried that one too! I have used this same type of combo box on other forms and they work fine. This is the only one that doesnt show the recordset unless you go back to design view and then return to form view.

Tried that, but it didnt work. I have also tried me.requery hoping that maybe that might work.

I have a combo box that is supposed to find a record on my form based on the value that i select. However, when I choose the item from the combo box, the rest of the fields do not fill with the information. when i go back to design view, then immediately go back to form view, make the...

Thank you Pat, I kinda figured it out right when i got the email stating your response. :)

I have been searching everywhere on this site about refreshing a subform, but it seems like they are with forms that open with a command button. How do you make a subform that is embedded in a form refresh or requery? I have included a picture of my form, just to make it easier to understand...

if you want to calculate the average of a group of records then in the group footer create a text box and in the control source use the expression builder. use a formula like: =AVG([yourTextBox]) if you want to average the entire report, then put the textbox into the report footer. If all...

nevermind, I found it. Amazing how those help files work so good !!

How do i make a footer for my report. I have made a report based on a query and one of the headings is Last Name, but I don't have a Last Name footer. I need one. Please Help!! :)

ok, just to let you know, I'm not by any means an expert here! I myself have just learned access. I think you will need to create a sub in the form that will insert the date(today's), then you need to use the datediff function. I am not sure at all how the code will work, but you can look up...

Dude, I don't think I really understand the question. Could be that you need to use datediff or dateadd functions.

HELP!! I have a form that is used to input the data for fishermen. The form is for their personal information (company,address, city, prov, etc). The table that holds this information uses an autonumber. The PK is irrelevant to any paperwork that is kept on the fishermen, so the FishermanID...

I need an input mask on my field for a watershed code. The code including dashes is 54 characters long. But.... I can only get 38 characters on the input mask. So.... Any ideas?

here is what is going on... i have a form to enter new fishermen. the form works fine getting new data into the table. the only thing is that if a user partially fills out the form, then either clicks the 'exit' button or the close form (X), there is a partial record that sits in the table...