Search results

Hello, I have followed the very informative postings here on security and deploying a multi user access application and have started doing that myself. A lot has worked but there are a few things that are not working out right and I just wanted to get some clarification on that. Hopefully this...

Hello, I have designed a bunch of forms that the user will access through the Switchboard. Things are working fine except that when I deployed the application to a different machine from mine, the forms appear to not display properly in the sense that they are appearing too big and the user...

Hello, I have two questions related to deplying an Access project I have been working on. 1. I started developing the project in Access 2000, but midway upgraded to Office 2003 and so the remainder of the project has been developed in Access 2003. Things seem to be fine, except that in the top...

Hello, I have a quick question on how to enter the current date in a record automatically when the record is created. Here is the situation. Say I have a Products table that lists the products that have come into the inventory. There is a field that denotes the day the product was introduced...

I have a basic question. I am trying to put a button on a form I have created so that I can use Filter by Form feature on it. I used the toolbox commnad button wizard and chose the Form Operations -> Apply Form Filter option for the button. Unfortunately, this button does not work for this...

Here is my problem: Say I have a products table: PRODUCT ======== Prod_id Prod_name Dept Type : It is now possible that some of the products can also be a product group, and a product group would then consist of multiple products. (Note: if a product is a product group as well, both of them...

Hello, I have a couple of elementar level questions on Form creation process and standards invloving a schema with several M-M relationships. I have a highly normalized design (thereby producing several junction tables). I have attached a picture of my schema to give an ideal of the schema I am...

Hello, I have some questions about a schema design I am working on. After much trial, it appears to me that a particular table is not and probably does not need to be related to any other table in the schema. So my questions are: 1. Is it right or quite typical for schemas to have some tables...

Hello All, Beginner level question! I am working on a schema that might need outer joins for some of the queries and thereby reports I will need to produce. So, I wanted to get an idea from the pros about the following strategy: How about leaving all the joins in the Relationships to begin...

Hello All, I am working on designing an application in Access that produces reports of how the various Products/Projects in an organization are being planned out in terms of their launch. The products can be in the concept, engineering or complete status and for each status a regular (typically...

I am trying to save the schema dsiplayed in the Relationship window into a file (preferably Word) which I am later print edit etc. I am not being able to do so as Access seems to only provide the ability to Print from the Relationship window (I tried Print to File option in the Print dialog...

I have a simple question on the usage of an Access project by multiple users. 1. Is it possible to store and reflect information in the project about which user updated or deleted information to any field/record in the project? 2. What would be a nice way to communicate to other users when...

Hello. I have a simple modeling question. Lets say I have the following table structure: Table 1 ------- Cust_id Cust_name Phone City Supplier_id Dept Table 2 ------- Supplier_id Supplier_name phone City Table 3 ------- Dept Table 1 is M-to-1 with Table 3. Table 2 is 1-to-M with Table 1...

Hello All, I am new to this board and have a question about your opinion on creating an Access project that will be a project launch calendar for an organization. Basically, there are numerous projects with start and end dates and they need to be tracked every month and Gantt chart type reports...