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...

Yeah, I mean that's an option, and the one that I'm currently implementing. The real problem would be having to select all 100 people in the same department, one at a time. This could be a long time. I want a solution that will allow the user to add multiple people easily. Such as based on a...

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...

So the link you posted redirects to the microsoft home page, so I don't know which sample file you are talking about. I tried searching for some keywords and didn't find anything relevant (I tried this before). Maybe you could post the name of the file or the title so that I can find the...

That's amazing. So MSysObjects is just the table that holds the meta information on the database? Never knew about it. One more follow up question though. So now the user can select the query name, but how do I get to the SQL behind that? I found out how to show the system tables and it's...

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...

Great! Thanks a ton, works perfectly. Didn't even think about GotFocus. Seems like that might always be a good way to do it, because that way, when someone accesses the list, you can be assured that the contents of the combobox are up to date.

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...

Okay, I have sort of found a way to overcome this problem (at least from the time being, some suggestions would still be greatly appreciated) and I've encountered another problem. When a button is pressed, an SQL statment is run to insert a new piece of data based upon a combobox. The...

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...

Yes it does. That's a great idea, the only problem that I see would be the transfer of data between the two tables. For example, once the form is processed, it needs to be archived with the rest of the forms that have been processed, which would require moving the entry from a table in one...

Hmm, I don't think I quite understand what you're saying. Let me try to explain myself better. In order to automate the a paperwork procedure, I want to setup a system that allows users to fill out a form online. The user group is a large number of people, changing often. When the user...

Thanks a lot for your speedy reply. I searched the forums for my problem yesterday, and I can't seem to find anything relating to data access pages specifically or even anyone who wanted to setup their database like I want to. I think what makes mine different is that I don't want to require a...

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...

Okay, I think I've temporarily solved my problem. I've used a UNC to connect. This is sort of undesirable, I mean why put it on a webserver if you have to be on the same network to access it. But at least now I can do some more development before I find an answer. I've started a new thread...

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...

Yeah, I triple checked my spelling. I mean, I know that it's accessible, because I put the webaddress into firefox and it came up with the download prompt and I was able to download the database. Then I copied that same webaddress and put it in the open window, and it says not a valid file...