Search results

Hi, I have a Customer Form that is used as the 'List Items Edit Form' in the customer field of a Main Form, and I embed SetTempVar at Customer Form. In access 2007, If the customer name that I typed in Main Form is new to the customer data, the Customer Form will be called, and the name of...

I took off the default Admin from Admins group, and set myself as administrator, then log in, create new users and groups. But after I log out and try to use the user name to log in ( leave the password place blank as the book said), the Access just doesn't allow and pop up the message saying...

I am using Access 2007, but most people in our office use Office 2003. So I saved my dabase as 2003 version to share data with them. ** However, after struggling hours try to figure out how to set security in Access. I am surprised to find that on my computer, when I open the database in old...

I have a multiple criteria form, the criteria what I give to the form is the product category and a date range, is there a way that the criteria can be coverted to words and printed on the report the form generates? If can, this report will be easier to read and I bet my boss will be impressed...

:confused: just didn't get it. On form property sheet, I want to set Movable to Yes, but my form won't allow me to do so, everytime I set yes, it automatically go back to No. Can any one give me a clue? Thanks !!!

Hi, I am looking for a code that can allow me to enter a closing date on the Warehouse database, so the person who do the warehouse data entry (in Front End) can't change any of the figure that had entered before the closing date (unless I enter the password to change the closing date or release...

Hi, can anyone help me make a query so that the criteria for the parameters are a drop down list of the values in that field? For example, if the field is "Product model", the user can choose from the available models via a drop down list rather than type the specific model number like...

Hi, I am a newbie to Access (8-) just one week). Trying to create a report from the cross tab query for a warehouse report but got a problem: a blank group heading kept appeared on the top of the 1st page. I try to remove it by select function like "invisible" or "delete", but if I do so, the...

I am new to Access, and trying to set up a database for tracking warehouse inventory. Since we stock goods in different warehoue, what I am doing now is creating a crosstab query in which row heading shows the product model, and column heading shows the different warehouse name. The problem what...