Search results for query: *

If i select the Multiselect to Extended then i should select the items sirially, i can't select randomly.

Hello, I have a List box on my form and i have kept it as Multi select so that the user can make multiple selections. But when the user wants to select all items in the list, how to do that, the Shift+Arrow Down key also not working. I want to add a button to the form to select all items in...

Thnk you for your response. Actually as i need to copy the whole record i have used the duplicate record, it worked out fine for me. But the problem is when i do that its saving that OfficeClipBoard too, so then when i close the form its giving me a message saying "There is large amount of data...

I got it. Use the Duplicate record of the command button wizard.

Hello, I have form for inputting data in to the table. Sometimes they need to enter same data with little changes. so the user want a copy button on the form which will copy the last record and pastes it so that they can make changes where ever necessary. How to do that?

Hi, This seems simple but not working for me. i have 3 tables that have relationship in between. I have created a Query out of those 3 and used that query as Recordsource to my report. And the report has all the fields that the query has. I should show the Total of "TotalSavings" filed. So i...

I got the answer. Right click on the Tabcontrol and click insert page.

Hello, I have a form with Tab control. Basically it has two pages, how to thrid page to it?

Hey Roy, I got it, it is working. The only problem is its not working for the old data that i have. But it is working on all records which i am entering after i wrote the event. Thanks a lot. Star for you.

Thank you Roy. It did worked for New records, its adding current date for new record and for existing record its releting the existing date in that filed but not updting it with current date

Thank you Roy. But its not working. Its not adding the current date t new records and also when i go to perticular record and change some thing in it, then also its not updating the existing date with this new modified current date.

Hello, I have a textbox in a form which will have the current date. But in future if user want to change a record then that filed should show up that date, so it should always hold last modified date. HOw to set that?

Thank you somuch. Star for u

Hello, I have table with Cause and CauseDescription. cause causeDescription BOM BOM errors COM Communication Errors In the Form only Cause(Dropdown) will be shown up, and based on that cause in the Table the causeDescription should fill. Like if the user...

Hi Everyone, I have problem in Sorting. I have a form where there will be 3 combo boxes like below Sort By ...... Filter By ..... or ...... For that i have wriiten a query like below, but this workes for Filter, How to write the order by SELECT tblProjects.OverallScore, tblProjects.Team...

Thank you so much, it worked for me.

Hi, I have a report for which i want to reduce the font size less than 8. Is it possible to do in Access 2000

I fixed it. In Module -> New -> Tools -> References There is some thing like Microst windows common controls checked, and i do need to uncheck it. Now its working fine.

Hello, I have a form with a chart in it. I have used the Format function in the Rowsource query of the chart. I have created that 2 months ago and it was working fine. Now all of a sudden its giving me an error saying the "Undefined function 'Format' in query expression&quot...

SELECT tblSubmissionForm.* FROM tblSubmissionForm WHERE Dept1=[EnterDepartment] or Dept2=[EnterDepartment] or Dept3=[EnterDepartment] or Dept4=[EnterDepartment]; This one worked out for me. Thanks. Star for you.