Search results for query: *

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

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

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

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?

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

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

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

Hello, I have a small question. I need to qritea query that searches for a DeptNo from 10 fileds. I am not sure how to specify for 10 fields. SELECT tblSubmissionForm.* FROM tblSubmissionForm where Dept1=[EnterDepartment]; In this above query it asks the user to specify the DeptNo and...

I have bulted a Access Database, now when all the users open it up its not allowing any body to save thier changes. Its giving a message saying "You don't have exclusive access to this database, if you try to save the changes, you will no longer be can use it" Please help me out how...

Hello, I am exporting data from table to excel sheet, and the number field is turning into date. Ex: In Access Table ID Ver 55 25 65 45 Appearing In Excel sheet as ID Ver 01/01/1900 01/04/1900 01/01/1900 01/04/1901 How to format it automatically...

Hi, I have a form which will have 4 text boxes where user will type ID,Version,Channel,Date and hit a search button which should open a form for instance "frmEmail" which is already in my database, but it should change the Recordsource query for form "frmEmail" based on my...

I have a Submission Form in Excel with Combo boxes, listboxes and Checkboxes. How to import it into Access table. I think i should use Named range, but i don't know how to create named range. I have checked in Ms_Access help, and Defined one named range which also not working as i needed. Please...

Hello, I have a submission form in Excel which i need to export it to Access Table. I don't know how to create a named range that i can specify in Macro for Filed Names. Please help.

Hi, Can any one tell me how to export three tables information in to same excel sheet. Thanks

Could any one help, How to insert the result of a Cross tab query to a table. What Sql statement will do that? Please help

I have a form with 3 flexgrid's, Chart and Some text fileds which are connected to a query. My form just works good. 1.The problem is how to email the form to other bussiness users. 2. Each grid holds 15 to 20 fileds of data, but i can see 7 fileds on scree and all others are visible by...

Be sure to keep the Width of the Report(or)Form to 6.5 and Length(or)Height to 8.5

Hi, I have a Form that has StartDate and EndDate textboxes. So, when the user enteres the StartDate and EndDate it will calculate the Weeks between those dates and adds data to my table. Always its about a week time and it should start on sunday and end on Saturday. With the Functionality...