Search results

Heck, because of how extensive and time consuming it would have been (the code is in a form module and the form takes about 3 other forms and a fair amount of input to get to the point of running the procedure), i've been running it over and over in the Immediate window, each time adding another...

I first was assigning it Now(), then tried Date(), then tried #11/30/2024#. Kind of have run out of options!

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

I have also, i don't know why this one does but i will have to check settings of it as i have been using Excel for decades but only recently started using Access after about a 12 year lapse. And tell me, why the heck do they name controls the same as in Excel that look the same, but have...

Outstanding! I will check and advise. Unfortunately (haha) i have to get back to business right now, the messages are starting to pile up and as i support other businesses, if i intend to keep putting bread on the table, i best jump. Look forward to trying everything all you good people have...

THANK YOU!!! -and the way i feel right now, yes, i am shouting a great thanx to you!

Uhg. I REALLY like that one when i am working on Excel! Maybe it is just a setting i can fix... Wish it could have been contained to Excel-

The multiple addins are because: MZTools: Installed strictly for use in Excel. Unfortunately i can't tell it that... RubberDuck: Installed because i like to have an addin that will sweep all code and reformat. It had many other functions that i didn't need but i was hanging on to it for an...

Forgive me folks, specifically typing VBA in the VBE.. I'm afraid i get into a mindset and think everyone else is in my little world... And three addins are running- Rubberduck (the most likely culprit) MZ Tools Access Developer Tools Since from what you're telling me i doubt it has anything to...

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

Thank you very much, all is working well!

Interesting and thank you. I find lately when my mind gets an idea i frequently do not consider the alternative methods of achieving the result until i run into a brick wall. I get those values from the file picker, i store them in a table along with the order number. Every time the form comes...

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

Just had to get to a "real" computer! (OK, phones are amazing these days, heck, i started on the good old black desk corded dial phones, having missed the "Andy Griffith" phones by but a few years, but when it comes to using a browser and keyboard, i kinda prefer my desktop-)

Exactly! I just now am using the square brackets instead of curly as was advised above- Gives an excellent distinction from perhaps coming by the same letter sequence when using the"replace" function. I've also learned that despite many people out there starting that the field is actually not...

Funny you should write that... In all my cramming trying to get up to speed after not touching Access for about 12 to 14 years, Colin is one of the people who has given me a hand on several occasions, and yes, i downloaded his rich text app just earlier today! Thank you!

OK, that is progress!!! An excellent idea, even outstanding. Believe it or not, i am excited that i'm being rescued! But you folks have been far too complimentary on the deck i'm playing with. Not only have i forgotten how to write HTML, but i can't even recall the name of the WYSIWYG editor i...

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

Many thanks - Though i find i do have memory problems (me, not my computer) i want to learn to do this right. This is simply an gratis program for some friends; sooner or later i want to convert an Excel monster that that accounts for my personal business which i have been adding to since its...