Search results

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

Sorry, I’m still struggling with this. I don’t know code, so it’s difficult. I find info on adding to cboBox, but not to also add to the form. I need code to allow tblProjPlantList (table form is bound to) to create new auto ID number when I select a plant from the cboBox that is not already...

Okay, it's working now - the combo box brings up the correct records (I had "Select from tblPlantList" instead of tblProjectPlantList). But I want to be able to add a record. When plant is selected in cboPlant and is not already on tblProjectPlantList, I want to add the plant and add...

Thanks for replying. I made the combo box a filter for the form using: Me.RecordSource = "SELECT * FROM tblPlantList WHERE Plant_ID =" & Me!cboPlant Me.Requery The Plant_ID from tblProjectPlantList is now filtering and showing up correctly on the form, but the other fields read "#Name?" Could...

Hi - I would like to add a new record, selected from tblPlantlist, to tblProjectPlantList using a combo box (linked to tblPlantList) in a form. Once the new record is added, I then want to add additional information relevant to the Project in the form. It seems simple, but it's sure not...

Hi - I’m can’t seem to get the order of records in my combo box to work. The control source is PlantID from tblPlantCharacteristics. The rowsource is tblPlantList and the order is set to ascending by BotanicalName in the rowsource query. The order is correct when I run the query and in the...