Search results

Thank you EVERYONE! I had expected email notification of replies; i was surprised to see that there were any! Time for me to chat with GoDaddy about forwarding my email (again), but i switched my email address here to the direct one. @theDBguy: When i try SQL = "INSERT INTO...

I forgot what i was doing and typed practically the entire dilemma into the title... Anyway, we have a table that has four fields, the first being a key autonumber field. In a form there is an area i provide for the user to select three values, which happen to coincide with those three...

I obtained the following SQL from an Append query in Access: INSERT INTO tblOrderEquipment ( IDOrderEquipment, IDEquipment, IDOrders, UnitCount ) SELECT tblOrderEquipment.IDOrderEquipment, tblOrderEquipment.IDEquipment, tblOrderEquipment.IDOrders, tblOrderEquipment.UnitCount FROM...

Aha! Got it! Now i "just" have to dig up the proper syntax for an append and i should be good. THANK YOU EVERYONE!!! (And yes, i am shouting that, y'all deserve a big thanks for reading through my long-winded request-)

May i ask, how do i address each of the fields in the combobox? In Excel i could do that in a heartbeat, but i think i've found out that this ain't Excel-

Many thanks! I will "fiddle around with that" (that's how i learn) to see what i can craft. Displaying and being embarrassed by my lack of accumulated and/or retained knowledge has become a common method to learning-

Thank you! I will work on that. As to not using the child form, because it is a continuous form and that seemed weird to me until i thought "Well, why not put the combobox, quantity textbox and command button in the form header??? I'm going to have to give that a try and if it works, we will...

I guess two reasons prevent me from doing so: I am embarrassed to expose my newbie hack method of putting it together - this issue i can overcome, but for the next item I have no clue as to how to provide you with that for which you have asked-

Probably very simple, but i've been stumbling for a little over a couple hours now due to my absence from Access for 12 years- We have a single record parent form, lets call it frmParent (innovative, no?) and on it is a continuous subform - frmChild. On frmParent is an unBound combobox -...

Thank you! Given the bad reputation i have repeatedly read concerning ActiveX when it comes to running on other computers, and the friends i am creating this project for are on a MAC while i am on a PC, i think i best forget about them!

I have noted several references to a supposed button within Form Design | Controls that is labeled wither "More" or "More Controls", but i sure as heck can't find it. Might this simply be that since i am using Access 2021 the references were from earlier versions and are simply referencing that...

I hope that title I gave this doesn't completely confuse everyone. I have a form based on a query. On that main form, it has a combobox so the user can select between ten different historical events (club meetings). In the first tab it shows all the people who were at the event in a datasheet...