Search results

I have a form that contains a subform that displays a many to many relationship. The form is a change document that is related to people. So for instance, when a change affects three people, these three people should be reprsented in the subform. I have this working fine. There is a dropdown...

I have a database that has a many to many relaitionship between people and the reports these peolpe are related to. I am working on a form for one of these reports. So far, I have a subform on the report to list all the people associated with the report. There's a combobox that lists all the...

I would really like to populate a combobox with a list of queries. This would allow the user to add a group of data into a form's subform all at once. Although I have no clue how to use the pre-made queries from VBA or even how to get access to them via a combobox. Any ideas? If I didn't...

I have this form that contains a good number of bound fields. The behaviour I would like to add to this form is, upon the press of a button, a new form would pop open (same form) as a copy of the current. This would make entering in multiple items with very few differing fields much easier...

There's this problem that has been racking my brain all day. I have a form that contains a subform (modelling a many to many relationship). So a person and the applications he/she uses. I then have a combobox with a list of applications and a button below the combobox. When something is...

I have a combobox that displays information about a current record on a form (much like a subform would show all information related to a certain record). So for example, there is a user and the combobox would list all the users applications. Now, when the record is changed (via the navigation...

I want to use an unbound textbox on a form. And I want the user to be able to put a value in this textbox. I have a form that I want only to have a textbox and a button. When the button is clicked, the text in the field is used to do a couple things. When I try making an unbound textbox...

I currently have a form that contains a subform. The common many to many relationship that many subforms represent. The problem I'm having, is I want the user to be able to add, delete, and edit entries using the subform. I just added the subform and add/edit functionality was not the...

I'm creating a data access page that can be used over the internet to add information into the database. The database is password protected. The functionality currently is that when a user accesses the data access page, they need the database password in order to submit information. We don't...

I'm currently using a data access page web form in order for users to enter data into my database. The database is protected with a generic password. Whenever the form is opened in IE, it asks for that password. The functionality that I want is for the users accessing the database through the...

I am currently attempting to setup a database that will be used by many people. I have the database setup and it is split into a backend (tables and data) and a front end ( forms, queries, etc) which the users will download and use off their own machines. I'm attempting to house the backend on...

I'm creating a database that contains some information spread out over multiple tables. In order to enter information into the database there are a couple forms that the user can access to enter all the information, and these data will be placed in the appropriate tables. I am also creating a...

I'm working on a pre-existing form. When I open the form, I am able to enter new data and this data gets stored in the database fine. If I close that form and reopen it, I cannot view past entries or edit them. I know of a property (Allow Additions, Allow Edits, Allow Delete) which can change...

I'm creating an Access form and there are three sections to the form of which the user should only fill out one. So, they are controlled by a radio group and the desired action is as follows: There is a default choice (by far, the most common) and it will be selected when the form is opened...

I think I might have an easy question for people who have programmed with VBA before. I just started (about 2 hours ago) programming with VBA. I know other coding languages. And here's my problem, I wanted to write a user-defined function, that compartmentalized a common task and it required...

Thanks in advance for any ideas on my issue. I'm new to using VBA with Access so I don't quite grasp the power of what they can do together. But anyway, here's my problem: I have a form that contains a combobox. The values in the combobox are a result of a query to another table. If the...

I have a combo box in a form that uses a query to access values from a different table, and dispaly them as choices. This works great. The first problem I encountered was if the value that was needed to be entered was not in the list, then there should be an option to add it. I found a couple...