I have some tables that are set up as follows (these are not the actual names of the tables and fields, I'm using generic names so that I don't get a bunch of questions about the setup to begin with; I believe they are set up in the best possible way):
Table1 has a one to many relationship with Table2
Table1 has a one to many relationship with Table3
Table2 has a many to many relationship with Table3
Fields for Table1
Table1_ID
Field1Table1
Fields for Table2
Table2_ID
Table1_ID
Field1Table2
Fields for Table3
Table3_ID
Table1_ID
Field1Table3
Field2Table3
Field3Table3
Fields for Table4
Table2_ID
Table1_ID
Can anyone offer some advice on the best way to set up some forms for data entry with these tables? I think having Table1 be the recordsource for a parent form, having Table2 be the recordsource for one subform, and having Table3 be the recordsource of another subform would work for the one to many relationship between Table1 and Table2 and the one to many relationship between Table 1 and Table3. But I can't figure out how to then include the many to many relationship between Table2 and Table3.
I can no longer alter my forms in design view when I save them nothing happens i have to press no and then access shuts down. I have a feeling this is something to do with the VBA editor that i have been playing with, but don't understand VBA. It is not all forms. I have a split Database.
I now understand that when opening and saving crosstab queries Access (2010) runs that query to ascertain the column names. Unless you hard-code them. Running the query takes at least 20 minutes. I have hard-coded where I can, but one report takes arbitrary dates so I can't hard-code them.
I believe that turning off AutoCorrect might make a difference to whether the query runs - but I don't want to turn it off.
I have several standard tables and all is well. However the final one I have came to do I'm a bit unsure about.
I have a "Jobs_Type" table as a way to clarify certain information about the "Jobs".
All this needs to be is a few combo boxes and check boxes I believe, neither of which I have used.
Ultimately I want the user to be entering data for that job on one form. Then select the type and enter any other information. Based on the "Jobs_Type" Information, the reports may be different also.
Am I thinking this is more difficult than it actually is? I was wondering if there's anything I should consider at the stage I'm at, or just continue until I get to form design.
- Some things I am unsure about:
*I would like to use sub menus, SO, the user picks a "PROJECT" then under that project they may select "BATCH 1" or batch 2..3.. whatever they wish.
*The choice in "PROJECT" Should determine the sub menu. Some jobs may not be split into batches at all, or it may have a totally new format of delivery. The system needs to be flexible.
*What is the primary key? All my other tables are using auto numbers, BUT here I'm confused.
Here at work we have access 97. My idea is to present to my boss a new way to go about the database. I tell him we need a copy of access 2003 and I use the pages function in it to make html files for people to load on thier machine for the database. This should allow me to have the much needed user friendlyness of access 2003 and all its features without the whole company buying office 2003 for every computer (although they should...)
As far as this working...Whats your opinion about it? Would this way of running a database work well? I am not to bad at html so thats not an issue either.
If you know of any related threads, you can post the link also.
I can do anything(design/edit/add new) to my table & queries but unable to redesign/edit my existing forms & reports, i wonder why?. My Database attributes is not "read only".
I have a form which was locked down (ie Allow additions, allow edit and allow deletions were all set to no) on the Form property. I want to change this to allow edits so in design mode I changed the Allow Edits property to Yes.
I then went to Form view and was able to update fields on the form. When I exited the form it asked me if I wanted to save the changes so I clicked yes.
On going back into the form I can no longer update the fields I could before. Going into design mode I can see that Allow edits on the form property is set to no again.
What is happening here. There is nothing in the on load or other events to set this to no, besides this shouldn't change the form property should it?
I know I can get around it my setting the property in the form itself but why is the property getting reset in the first place.
I have a sub form in DataSheet view and I would like to lock the design so that the User should not change the layout
Even when I set the property of the Datasheet “Allow Design Changes: Design View Only” users are able to unhide the hidden columns and they can also change the size of the column by dragging the column end line
Does any one know how to lock the design of datasheet ( I am using this sub form datasheet for data entry but do not want users to change the layout)
I have a small access 2010 system. The database design was not good (replication of data all over the place) so I have been tidying up the design but have hit a few problems.I am using a form which contains amongst other things a customer name. The customer name used to be part of the enquiry table, and was picked up directly from there. I have replaced this with the key to the customer table.The only way I have managed to pick the customer name up is to change the control from a text box to either a list box or a combo box. I then have to set column count to 2 set the widths to 0 and 3 to hide the 1st one (the ID) and then set the bound column to 2 to show the customer description.
This is fine up to a point BUT the format controls on the list/combo are different from the text box so I can't replicate the back style and back colour (I had transparent and no colour respectively); the back style has disappeared and how to make the back color as "no colour".Also I end up with 2 little up and down arrows (for the list box) or ma bigger arrow for the combo.
I created a form through the form wizard in access 2007 and based it off fields in a table. the form is done but if I want to move the controls in the design view... I dont have the ability to move just one. I can either move all of them or none of them. Is there a way to change that?
I wish to request if it is possible to design an inventory where multiple shops or branches can be accessed from the same place.
or
multiple shops can use the same program with a centralized database, such that every user can only access his or her report from anywhere they login from.
I have a access form that has a text box that holds a search term. The search term is used as a variable in a query. The query results populate a list box. Selecting a result in the list box populates the rest of the form where the record can be edited. All of that works great...sort of. When first opening the form you cannot view any records. The search function works fine and the list box populates but selecting a record does not populate the rest of the form. Attempt to navigate (next, first, etc.) and you get a "You can't go to the specified record" dialog. There is a simple fix for this. Open the form as normal. Then switch to design mode. Do absolutely nothing. Switch back to form mode. All is well.
How to design a form for a table based all records to design in a single form without top to bottom list wise and without scroll bars. Need to form design for all record details are will show on a form as side by side only as horizontal list wise.
For Ex. I have attached the screen shot image as per horizontal wise records continues.
I am trying to design a subform to allow multiple records to be entered and then uploaded to a table. I've designed the subform but it is currently pulling all of the records from the table through and all I want is a blank subform for data entry.
I have tried putting a macro in the On Load and On Open events to get it to go to a new record but I keep getting error number 2046.
When I create a form in design view and then open it, the form fills the whole area. The Fit To Screen property is set to No, and Auto Resize makes no difference no matter what it is set at.
How can I reduce the form size (so it looks like an Excel form)?
Access 2013 on Windows 7 ..I have a Main Switchboard form which is Pop-up and Modal. Everything on it is working as required, but if I am in Design View and try to switch directly to Form view, the form disappears and the Access screen freezes - the mouse moves, but no menus or objects can be selected. If I have the VBA window open, I can carry on working in it, saving the modules and closing that window as usual. But the only way to open a form or do anything else in the main screen is to kill Access by closing the Access window in the system tray (or using the Task Manager).
If I close the Switchboard when in Design view and then open it in Form view, everything's fine.
The only recent change I can think of is upgrading from a 32-bit implementation of Access to 64-bit.
The code I am modifying looping through Me.controls collection to identify appropriate control types. Is there a way to influence the order (sequence) of that traversing? Or in different words, is there a way to assign by design certain item number to a given control?
I have a subform whose design I am trying to change. When I make changes such as moving fields or adding fields the changes appear in form view (and layout view), but not in datasheet view. However, if I delete fields, the changes appear in both form and datasheet view.
This situation results in behavior where I can have the subform open in design view and toggle back and forth between design and datasheet view, and they are different. However, toggling between design and form view shows the changes as having taken effect.
I have a form/subform that requires some fields from the Switchboard for its criteria. Last week due to no action on my part, it started asking for those values as Parameters instead (Forms!Data!txtInspDate), etc! The new form loads, but of course it is blank with no data. This happens if I load it from a command button or from the navigation sidebar... UNLESS I first load the switchboard in Design Mode, go to VBA window, then reload the Switchboard in Form Mode and press the button. From then on until I close the database, everything works fine!
I have a form and a report that will not save the changes nor close. I have done compact and repair, performed a restart and it is still happening. What could cause something like this. I have been working all day on other forms and reports without incident.
How to structure some MS Access 2007 Forms for the following scenario.
My table structure is as follows:
Product ++++++ ID (pk) ProductName ...
Tag ++++ ID (pk) TagName
ProductTag +++++++++ ProductID (fk) TagID (fk)
I want to have a main form that allows me to search for and displays a list of all products (and the dozen or so attributes for each product) that meet that criteria (I'm thinking a continuous form view of products).
So far so good. No problems.
Now I want a "tagging" form to the right of my continuous forms product list that is linked to the product which currently has focus. The tag panel should always show a complete list of all Tags. I want a checkbox next to each tag that I can switch on and off whether that tag applies to the currently selected Product. I also want to be able to add tags on the fly (without leaving the main form).
I think I have three forms in play :
Main Form Product Form (subform to Main) my product search criteria is probably on this form header. Tag Form (also subform to Main)
But with this approach I'm have trouble linking the two sub forms to each other. Actually, I'm having huge trouble figuring out how to display the list of all tags with a check box that when checked on and off creates / deletes a record in the ProductTag table and I really want Access to do as much of the CRUD as possible. I would prefer to avoid writing screeds of SQL INSERTS/DELETES on events. Am I asking too much of Access?
