Search results

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

Thank you very much for the rearrangement idea, it really shortened and cleaned up my code. The problem that I was having was that I was using the words "yes" and "no" instead of "true" and "false." I was reading somewhere a statement about properties and the words "yes" and "no" were used...

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

Great. My problem was that I was using the parentheses when calling the function that didn't require arguments. Also thanks a lot for the sub vs function tip. I was trying to look up the difference online and I really couldn't find anything explaining it. Probably because they operate very...

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

Thanks for all your help. Like always, someone has had the same problem and it has been solved. I found the following thread to be very useful in solving this problem http://www.access-programmers.co.uk/forums/showthread.php?t=15931 which actually links to this page...

Thanks for your input. First of all, the main form and second form are both bound, so the information is automatically updated in the table. Secondly, when a word is typed in the combobox (triggering NotInList), it is NOT automatically added into the database as a new choice because there...

Thank you very much for the response. I added this function: Private Sub buildingPractice_OnActivate() buildingPractice.Requery End Sub to the buildingPractice form. And when I try it, I get no errors, but there is no update. I just close the second form and the combobox is the same as...

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