Search results

Thanks for these solutions, but they are still not working. Because of [response] being an unbound textbox, it does not recognize [response] when I try to sum or count it. I desperately need help.

I have a form with a text box that has an input mask of short date. People can simply type 060101 and when they leave the box it appears as 06/01/2001. How do I get it so that it appears as 06/01/01.

This solution did not work because it does not recognize what theyes and theno is. Does anyone have any other ideas

I have an unbound textbox called "response" in my details section on my report inwhich I did some calculation in the format details section which gave me values of yes and no displayed in the textbox. I want to count the yeses and no, and put that value in the footer. I tried Count([response])...

When I try to save my report to excel it gives me an error that says "Subscript out of range". Does anyone knows what that means and how do I fix it?

When I run my report I get an extra blank page being created between each page. I have checked in the properties of the detail section and the force new page property is set to none.

When I publish to word and save as a word document I lose the lines that I had seperating the records and the pictures that I had pasted in the header and footer.

I have a form that has a "from date" you fill in and a "to date" as well as a "company section".When you hit the button it opens a report that is bound to a query.In the report properties under Format_Details Event, I loop through the records and do some calculations and fill those results in...

How do I get it so that the records have no spaces between them when my report is produced. I have hundreds of records being displayed so I want to get them as close together as I can.

I want to find out how many days are between two dates but I don't want to count the weekends. I know how to use DateDiff but I don't know how to test for Saturaday and Sunday and leave them out of my calculation. Thanks

I have a form bound to a table. After I have saved a record I can go back and make changes without hitting the save button and the changes are carried over to the table. I want to be able to make changes to a record on my form but I don't want the changes to be commited until I hit save.

I have a combobox that has values from two columns displayed. For example "A Active" "C Cancel" "E Expired" and so on. When you select "A Active", an "A" appears in the text box and is stored in the table. I want to be able to select "A Active" and still have "A" stored in the table but I want...

I have a form with 4 text boxes that are bound to a table with a save button. When I open the form and enter info into 3 of the text boxes and close without saving everything is OK and nothing is saved. My problem is that when I open the form and as soon as I enter info in the field that I...

I created a field in my table that has a memo data type because i want store several numbers, but on the form I can't find out how to draw a memo box to try to bound to my table.

I have a table full of info. I want to create a form that allows me to enter criteria about one or many fields and bring back all the results from that search.

I have one combo boxes that draws from a table to list all departments. My second combo box draws from another table to list all tasks involved with all the departments. How can I do it so that the second combo box will look through the table and only list the tasks related to the department...

When a form opens, I need the current date to appear in a text box but I also need to be able to edit the date if I want to.By just putting =Date() in the expression buider, the date shows up but I'm not able to edit it.

I am very new to trying to use VBA in access so my questions might be a little simple. What is the code for meking a button a form so that when you click it, it sets up the form to enter a new record while incrementing to the next id autonumber.