Has anyone noticed a problem with AutoComplete now being case sensitive when using a combo box? We started to get this behaviour after installing IE7. To...

Hi, I want to use a macro or code to do the actions as: Open a open file dialogue, select the file, then transfer that file to a table, open an...

I working with the TreeView control in MS Access for the first time and going through some examples. Right off the bat, I do not show any styles under the...

Hi. I need to change a datasheet view row color based on a value of field of that row. I've got a field, it's a Yes/No. If the value is set to Yes I want...

Either in my access table or a form based on that table i would like to prevent duplicate address entries. I want the user to be stopped right after they...

I need to limit date entry to a value not more than 9 months later than another date field in the same form. I tried many options but they didn't work. can...

Hello! I have an interesting problem. I have a Unbound control on a report and the control doesn't grow if the data is more then the box could fit. But when I...

I have Access 2000 and Excel 2000...when I try to create a pivot table using the Wizard it says "The PivotTable Wizard can't find Microsoft Excel 97 or...

I have a form that allows the user to run a variety of reports by using a check box to select which to run. The report runs but then I am unable to click on...

Hi! With help, I created a coding to duplicate a booking record. Now I need to duplicate a booking record by a number of frequency. In other words, if I...

Hello, I would like to save documents on the server and link them to the appropriate record on my form. What is the best way of doing this? There can be...

I'm working on a project and i have my forms built in VB and the database is implemented in Access. I have trouble figuring out how to get VB to pull the...

I've been using vb6 to develop front ends for Access databases for some time now. Now I have a client who would like to have their app written using Access...

I have a form created w/ over 280 records. I want to export a single record into Excel exactly how I have the layout in my form. How do I do that? ...

I’m attempting to filter data in my subform according to data obtained form a combobox in my main form. My query filters on this: !! and works fine in...

With your settings the way they are, the user can still enter a decimal, but once the focus on the textbox is lost the value they entered will be rounded to...

Hi I have a report, which if a query does not return any data, I then need to write some text on to a report (passed in from the form), is it possible...

Is it possible to change the format of a cell or cells within a subform when it is displayed as a datasheet. I have only been able to format the entire...

hello all I want to sort my form (by default) by lastname. And my subform by Period ending date. How to do I do that? Thanks

I have a field set with a Data Type of Yes/No. I am using a combo box to to check. If checked i would like the another field populated with todays date. I...