Search results

Hi Folks, I am working on a non-profit database for the county. I am pleased with the database, but have a problem that I cannot seem to find a remedy to. I have a access front-end database that is linking into SQL Server. A main form is used to populate the linked table. The table is...

Hi, I have been trying to get my check boxes to show up on my reports. ALl that shows up is a text box with 0/-1 for True/False. If I right click on the check box and select Change To menu, the check box is grayed out along with every other option except text box, label box, and combo box. I...

Hi Folks: I have created a form which contains checkboxes. The layout of the form is just the way I want the form to look on paper, when it is printed. Although I realize I should create a report to print the data input from the form, the report does not show the checkboxes. Instead, the...

Hi Folks: How can I force the <enter> key to do the exact same thing that the <tab> key does? I have a main form which has a certain tab order for input fields, then a save command button, then a print record button, then a new record button. When using tab, everything works fine and flows...

Hi, I have a main form which is used for entering records into a main table. I know how to use filter by form, that little icon, to filter out the records based on a certain criteria. However, my not-for-profit customer thinks too many steps are involved with this. She wants a command button...

Greetings, I have created a form which simply lists total counts for 10 different codes. As an example: Code A 10 Code B 0 Code C 5 and so on ... ... Each code has a proper name, for example; code A would be Dual-Funded Medicaid. I am trying to list...

Hi Folks, I have created a report based on a table. I am using the SUM funtion for a few fields. The problem is that the first page of the report is repeated for each account. If I have ten accounts, the same value is displayed ten times. Given the nature of my report, I do not need the...

Hello Folks: I am trying to use the Count function in a text box for a report. I have used the Count funtion before and it works fine; but here is my problem. I would ONLY like to count the field if certain criteria is met. For instance, let us assume that a combo box exists in which the...

Greetings: I have created a macro in which one of the append queries prompts the user for [START DATE] and [END DATE]. The macro uses these two values to correctly generate reports. The reports are perfect; however, I have a problem: On the header of each of the reports, I would like a text...

Greetings: Having created a form with the date format, the fields automatically provides an input mask of MM/DD/YYYY as you enter the data. But once the data is entered, its format changes to MM/DD/YY. Is it possible to force this field to display MM/DD/YYYY as oppossed to MM/DD/YY. The...

I FOUND IT OUT!!!! Cool. All I had to do was use [Forms]![MainForm2]![text101] in the equation.

Greetings: I have a form within a subform. I am trying to write an IIf statement that will set a textbox to a certain value if a certain condition is true. This works just fine when I do not have a subform and am only working with a mainform. But when I have a subform within a form, it does...

Thank you Abby!! I have successfully formated the text field to a text field that looks like MM/DD/YY. Much better. But the equation still does not work? Thanks to your help, I did manage to format the text formatted date field into MM/DD/YY format by using: =SDate(Left([SDate],2) & "/" &...

Greetings, I have created a front-end access form that pulls data from SQL Server. The form is working OK and users can add, modify, and delete data. However, one field on the SQL Server end should be calculated as a date. It is currently in the format of MMDDYY. I am trying to create a...