Search results

I've got a TableA with lots of fields. Some are basic information and go into FormA. FormA has a command button that calls FormB that also uses TableA. This is more specific data that is optional for certain types of clients. I'm trying to keep my forms short/simple, so each form works with a...

Here is what finally worked for me (thanks to the comments), in the local class code for the form. I still need to move it, with a lot of other stuff to a generalized "form module" that the individual form can call through its class procedure. Without using global variables for lots of little...

Thanks. That was too easy. I missed that option in the documentation I read. I thought I was going to have to use an array and then pull it back out to individual variables. Much better your solution!

That is indeed a "nifty" little trick. I got it to work on the items I wanted, they have special names for this. But, I have another place it may be useful, I'll keep it in mind. Thanks.

Thank you, it seems simple, but I've had trouble finding good examples. It did the trick!

I added 123 to b to clarify I want the whole field between the "]" characters. My old BASIC had extract command for this purpose, but I'll be damned if I can find it in the VBA documentation (which I don't often have access to offline).

Thanks for the pointers, I'll check them out. As to the tag thing, it was being used for another purpose. So, I've been very careful to give the table box names a special format (used for other purposes like help and translation in multi-language). Hopefully it will work here for this purpose...

Newbie (again) to Access VBA and I am working on my template for forms. Since I don't want to repeat code in each class module, I try to move as much common code to a general purpose "form module". This often causes me headaches, not knowing exactly/properly what to pass to the generalized form...

I did, but I turned it off to see if that made a difference. Still failed but compiled fine before run.

I tried it several ways, with and without the ? in the immediate window. Same compile error. For grins I cut the middle two lines, deleted the function, created a new function, pasted the lines back in and it ran. I can't see what went wrong. Go figure.

I'm working my way through an old printed M$ manual on programming. It has some good examples. However some just don't work. Like this one: (I triple checked that I typed it in exactly as the manual says) I'm guessing that things have changed since M$ wrote the manual. Can anyone give me a...

You're right, but I would like to see what module and procedure I'm working in M$. Don't they test what they create?

When searching for variables (or other) in a VBA project, the search box sits in the top left corner. While there, it covers up important information in the title bar. I can move it down to the bottom right, but after the next or replace it snaps back up to the top left. Does anyone know how to...

I don't have a videographic memory. I bought a new laptop about six months ago. Did the standard updates and cleanups. Bought an on-line licensed Office Pro product key from a reputable source. Downloaded the install files. Microsoft did it's thing to install. All was done in an administrator...

What do you think? I was in a brand new db, none of the old code that I imported from forums was even in the db. If it was some install problem, or other issue, how would Access even know to look in a folder that isn't the standard location for Outlook files?

I try not to put words in the mouths of other people. But thanks for the tip on how to get the download files. I'll fire that up some evening when I can get a good wifi connection somewhere. But because I bought an online key, I'm not sure if it's in my M$ account, I give M$ as little of my data...

I'm not going to do that just yet. It's a big pain since it's all downloaded over the internet, and not on a DVD anymore. I've only got limited bandwidth. Some of the people that are saying it's impossible for Access to touch Windows, probably aren't running the same version of Office Pro 2021...

I was referring to the object tabs when developing. As to the users, after how many years of Windows, they get confused? I think I have about forty open at the moment if you want to count Edge tabs. At the very least, in an Access App, I expect to see the main form, perhaps it's sub form, a...

I was sidetracked by a little demo I got showing how to use function keys in a macro. It only had two tables, maybe ten lines of code. After playing around in the demo, I closed Access, and bang, the unauthorized changes blocked message. After that I couldn't download emails until I restarted...

It's a plan, after the nap.