Search results for query: *

With Windows XP, how can I hide a folder? how do I then access that folder? I currently do not use a user password If I can't hide it, can I password protect a folder?

In Access 2000, I copied a form and then edited the new form. This included deleting 2 command buttons. The database runs on three PC's. On one of the PC's when the new form opens the deleted command buttons are partially displayed! On the other two PC's the deleted command buttons are not...

In Access 2000, I have a table called "tblRecipe" I also have the following tables that are linked to tblRecipe: tblSupplierIngredient and tblOwnRecipe A recipe can be made by simply only having SupplierIngredients. However a recipe can also be made by having SupplierIngredients and a recipe in...

In Access 2000 I have a form with 2 fields, Quantity and Mass A third unbound control "TotalMass" = Quantity * Mass. Because Mass can be in various denominations, i.e Gram, Kg, Ton, I have a function that converts the mass to a standard unit (Kg) which I use in a query to provide the answer. I...

Forms![frmRecipe]![txtRecipeCost].Recalc gives me an error 438 - Object doesn't support this property or method

Sorry, the code is in the After Update event

In Access 2000 I have a form with a subform. On the main form is a control with a DLookup function. This works well. However if I change a record on the subform I want the control with the Dlookup to update. I put the following code in a field on the subform...

Thanks The rowsource does not appear to refresh when I move to a new record. I have tried to requery the combo box in the forms OnCurrent event, but then all values of the combobox, other than the current record, disappear!

In Access 2000 I have a combo box on a subform I use a parameter query to filter the records returned by the combo box. When I navigate to the subform and click on the combo box, the correct records are displayed. However if I go to another record the combo box returns the records relating to...

I did resolve the error by making a new database and importing all the tables into it, and renamed it to the original. However I will try your solution in future because it is much easier

I have an Access 2000 database that operates in a shared environment. I have a back-end database containing tables and a front-end containing forms, queries etc All user front-end tables are linked to the back-end This has worked well. I have just run the Compact & Repair utility to compact the...

I want users to be able to select a record from the combo box, but they must be able to edit the record.

In Access 2000 I have a combo box based on a table. How can I prevent users from changing the data shown in the combo box?

In Access 2000 I am using Dlookup in an unbound text box in a record on a continuous form However, this results in an "#Error" in the new record row. How can I suppress this?

Found the problem! The query of a combo box was looking for the field

In Access I have a combo box on a form The user may click on the down arrow to change the selected record, but change his mind and leave the original value. How can I determine this?

In Access 2000 I have a form with a linked subform When I open the main form it loads correctly. however the sub form does not finish loading and I am prompted to enter a parameter value for a field that does not exist (it used to, but I deleted it because it was no longer required). If I simply...

In Access 2000 I have a form what contains 3 numerical fields, Quantity, Price & Factor. Generally the result will be Quantity * Price, but I never know if the factor is to be multiplied or divided into this result. I have placed a combo box, called cboFactor, on the form whose row source is...

When installing software, users can change default settings - e.g. where files are automatically stored. How can I find out what the default settings are? I need to develop an app that will be installed on many PC's and I need know some of these settings.

In an Access 2000 form, I have a list box. The list box recordset is based on a parameter query. The parameters are text boxes on the form, e.g dates. When I edit VBA for the form and then close the form, I am prompted to enter parameter values. If I open the form and don't edit any VBA, the...