Recent content by tMitch

Hi Pat, I’m still trying to get this to work. It’s not reading my global variable. I don’t know how to write code, so I’m sure there is more detailed code that is needed. I put the following in the Current event for each form that I want to be the current record in the 3rd form (FormX)...

Hi Pat, Thanks for replying. I did as you said, but get an Enter Parameter Value looking for ReturnProjectID(). Any suggestions on where I might have gone wrong? I'm not at all familiar with global variables, but it sounds like that is what I need to make this work. Thank you.

Hi, I have a form (say Form X) that opens based on the ProjectID criteria in the query, which is based on a record selected from Form1 [ProjectID]. I want to be able to open Form X using information from 2 forms - Form1 or Form2, both using ProjectID. What I've done so far works, but I get an...

Hi- I couldn't find anything on this in the forum, but maybe I'm not using the right words to search. My combo box in a subform isn't listing all the records. There are 347 records which list alphabetically. When I try to choose a record from the drop-down list, the records end in seemingly...

The problem (for me) is that the form is based on code which I copied from elsewhere (this forum probably). I don't know how to change that so that the list box is populated through queries where I can do what you suggested. Is there somewhere in this code where I can say poplulate list box...

Hi Wayne - Thanks for responding. I copied the code from elsewhere, so don't really know how to change it. The original was for a listbox in a form which lists all tables in the database (except "Msys", etc). The user then selects a table to view. Rather than having to select from numerous...

Hi - I have a form with 3 tab controls. Within each tab there is an unbound listbox that lists tables. I want each list box within the tabs to select only specific tables relevant to the tab heading, but can't figure out the correct code. I'm able to select the tables using "tbl.Name Like..."...

That was helpful. Thanks.

Hi - The same text is being entered into a textbox for multiple records in a form. Is there some code I can use to have the same data in the textbox as in the previous record - so that the same thing doesn't have to be retyped over and over? And then when it's changed again, it will keep...

Thank you Pat! That is the info I was looking for - replication and synchronization!

The problem is when I give 2 people (or more) copies of the database to use, they will be adding new info and new Autonumbers – which means they are both adding different info with the same Autonumber ID (i.e., they are adding new plants to tblPlantList). TblPlantList is connected to another...

Hi - I have a situation where multiple users need to use a database without being networked. Users will be adding and updating information. I will then have to append this data to the Main Database, getting rid of duplicate information (if different users independently add the same information)...

Thank you! Thanks for website Pat. And Mile-O-Phile the reason I want to change table name is because I'm inexperienced at designing databases, so it's always a work-in-progress as I keep needing/getting more info and then realize better ways to structure the database (hopefully better!)...

Hi - Is there a way to change a table name so that it automatically changes throughout the database - so that I don't have to change every query and form that is related to that table?? Thank you.

Trying again: I want to populate a table (tblMHDPlantList) with records from another table (tblPlantList) using a combo box in a form. I then want to update the new tblMHDPlantList records in the form. The combo box works if the record is already in tblMHDPlantList. However, when I select a...