Search results

Will need to add a dimension to thinking this through that i hadn't thought of before, as up until now it was strictly to solve for the output as presented, but now there is a new allocation that i must think through. It would not be hard to convert, but it would take some verification of...

@ Pat Hartman - Maybe the rattler did bite me... I'm afraid you might be asserting an understanding on how to do this more efficiently that is way over my head, or at least above my consideration of translating the final presentation to the tables thus far as cheekybuddha poignantly indicated...

I hope i can get comfortable with handling the quotation marks and octothorpes (you sure you didn't make that word up??? :) for string, long and date types-

I will keep that in mind - this is the first Access project i've done in over ten years. A lot of re-learning! And now going between Access and Excel really messes me up...

Last nite around 2:00am it came to me that i thought i once learned that an INSERT INTO did not use an ORDER BY; glad that was verified today, you saved me from going on another exploration. Had been using the DoCmd.SetOrderBy but kept thinking that this was because i wasn't getting the syntax...

I'm looking forward to working with this tomorrow when i can focus a little better (just tired), but you hit another nerve - for a while i was trying to format dtNow at the end of the VALUES group- & Format(dtNow, "mm/dd/yyy hh:nn:ss" & and after typing i looked at it again, saw the quotation...

My issue is that every time i try to then add "ORDER BY" to the SQL statement i fail. I can't make that work! I want to Order By TXDate ASC TXDate is "Date/Time" in the table by design If i run: DoCmd.SetFilter wherecondition:="CDate(TXDate) BETWEEN #" &...

Uhg. I just found my answer. Not setfilter, but SetOrderBy. Still, if anyone can advise how to correct that SQL i highly would appreciate the help!!!

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

Wow. Y'all are great! I am hoping to watch Pat's video and view some of the examples today (this is not my means of income, and it seems bills still need to be paid), but for a short bit i was figuring out how using the before update event would be effectively implemented in the record's fields...

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

@The_Doc_Man: Many thanks for the education! I had thought Text was simply a property of a text-oriented control prior to the text being written to a record, after which it became a "value". I truly appreciate learning what it actually is. Thank you, -Bruce

VERY NICE! Thank you, -Bruce

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 EVERYONE!!! Sorry i didn't get back sooner - daughter had a bit of a wreck on I--95 (thankfully no personal injury as it was stop-and-go traffic, but i suspect the car is totaled and without GAP insurance, a car that i just paid for a new rebuilt transmission for...). I will get on...

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

KISS was taught to me by my father when i was about 12. Unfortunately i learned SWAG in college and it would seem i adopted it-

Once i got it all working the way i envisioned and looked at it i remembered what you wrote and realized i basically invented a car with two steering wheels. My way of adding a record at it's most basic user related form was no easier than just using the continuous table display, which might...

It's ALIIIIVE! (Frankenstein) Thank you, everyone!