Search results

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

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

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!! :)

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?

I have a form and it works fine...so far, but i have a variable that i would like to write into a table in the database. since i have no idea how to do this i was hoping someone could help me out!! ex: strName=me.txtName.text my table contains an autonumber ID and name field. How do i write...

another question.... in my form i have set up tab stops at all textboxes and then they go to the 'update' button, then the 'exit' button, if i tab past the exit button, the record gets added. is there anyway to stop this from occuring, kind of a pain to test when the form keeps clearing.

Any idea on how to show the first item in a combobox without clicking. Right now the combobox loads into the form with the textarea blank, I would like that to show the first value instead.

I currently have a form that is supposed to write new records into a single table. I have some validation set up so that if you click the 'ADD' button, you get a msgbox that notifies you if any information is missing. but if the user enters a few pieces of information into the form and then...

I am currently creating a report that shows the last name and first name of fishermen. In the table the fields are LastName and FirstName. On the report I would like to show the name kind of like this: Otis, Thehumble. Right now they just show up with the last name, a big space, and then...

I have looked almost everywhere on input masks for this one, but my access book doesnt tell me much on the subject. I have a textbox that names get entered into. I would like the first letter to be uppercase, regardless of the user entering it uppercase or not. Is there anyway this can be...

I am creating some reports that are based on an inner join with two tables. I have "Hide Duplicates" set to "yes" for those items that I don't want showing. When my reports print, there is a blank space on the row that is hidden. Any idea on how i can get rid of that extra space. Other than...

I have a form that has 2 combo boxes on it, one is named Waters and the other is named Year. I have also created a report from a query that shows fishermen, their licences and their company names. The query is a select query that asks for the Waters and the Year. My question is...how do I get...

I have a form that has two combo boxes on it, each one pulls information from a different table. The reason for this is that I want to be able to print a report based on data from those two controls. The problem is....I don't know how to send that information to the report.