Search results

I have the following assignment in VBA though the Assignment itself probably doesn't matter (GECo is a declared variable. Trying to assign it the value in the textbox GrossEquipmentCost when that value exists) : GECo = Forms!frmOrderCreate!frmOrderAddEquip.Form.GrossEquipmentCost The issue is...

Stick a fork in me, i'm done. ALL day i have been trying to figure out how to make this work before pestering you folks. The actual SQL statement is much longer, but all of it works fine until i stick that last date field into it. I keep getting a syntax error and i don't know how many more...

OK, y'all have helped me with tough ones before. This one is like an annoying mosquito or fly that evades swatting and keeps coming back, annoying the heck out of me. When i type a quotation mark, Access puts another one immediately after it. Same with parenthesis. Same with square brackets...

Good Morning and thank you for considering my issue! On a form i have a combobox. From the combobox only one selection is made at a time. This, in turn, displays a picture. I wish to populate that combobox's values with the return results from calling a multiselect file dialog (Function...

I presently have a relatively small named table in an Excel sheet (that has many tables in the same sheet). Though i could input it from scratch as it only has perhaps 20 entries, in the future i suspect i will want to do the same with much larger (named) tables, so i figure this is a good...

OK! That pretty much sums it up and even though somewhere in the late 1980's i crafted a website using Notepad, i am these days so clueless that i've been looking for a straight forward "how to" and can't find one. I probably can't think of the right search terminology because i think i've found...

After reviewing some of the works out there i feel really stupid asking this question; i intend on going back and reviewing some of them because they provide amazing results. All i want to do is sort a continuous form by the date column in ascending order, probably because i am too new and too...

Thanks for considering my nightmare- I am using a continuous form for data entry where each record has only two user entry fields and a row of two fields constitutes a record. It is generally probable that when the user is inputting there would be five to ten records at a time to input. I...

Thank you for considering my confusion! I can't believe this is so hard, so that probably means there is a very simple solution i am too tunnel-focused to see. I am re-learning Access after a long time away, living in the land of Excel for the past decade or so. In the simplest example, let's...

Good Afternoon Everyone! Can anyone tell me what i am doing wrong with the following? sSQL = "SELECT ContactBilling, EmailBilling, BankAccount, FROM qryCustomerEmail" Set db = CurrentDb Set rs = db.OpenRecordset(sSQL, dbOpenSnapshot) As i am getting the following error...

Thank you for considering my issue! OK, i give- Just starting back with Access after 13 years not using it, and a real bad memory- We have a five field table named "tblOrderEquipment" (which was a lousy name as it suggests it is for equipment to be ordered, but instead it was meant to join...

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

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

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