Search results

Thanks. AccessBlaster. No one has suggested this approach. Can you recommend an Access textbook that has a step-by-step description for doing this? I need details so I can understand the process and if there are any gotchas. One need that I will have is to have public information in a...

Joan, yes I am signed up with the CDC, FDA, and USDA for food recalls. I also receive announcements from MSN. I load the information into my database so I can broadcast it to my family members around the country. Most of them do not track recalls of foods and medicines. They rely on me...

Jon, what's your Starbucks account number?

Arnelgp, that's an interesting use of an MVF. Arnelgp, that's an interesting use of MVFs. I would expand it to something like this, where the statements are longer. Both the country name and the policy are MVFs. The team would have to agree on the text. The team could add and delete...

My only purpose in starting this thread was to tell folks why I wasn't responding to them and that I wasn't being disrespectful. I appreciate every comment that those two threads received. Thank you, thank you, thank you. I am still interested in learning how folks add animation to their...

Dave, you are a lucky guy to have data when you start work on a database. I have always had to conceive of an application and compile the data. When I got started on my finance and health database in January, I only had a vague idea for what I wanted. I mentioned that to a user group, and...

Thanks, Pete and Colin. I was hoping that I could put live URLs into an MVF, but it won't work.

Colin, are the URLs still hotlinks in your example? Just having multiple attributes is not enough. When I viewed them in my form, they were text strings. The URLs were concatenated to the field name. Did I do something wrong? Please advise. Perhaps this is another time when MVFs do not...

That's the good thing about Access, you can do IT your way. When A2007 was introduced, I saw MVFs as something new to learn and use. I did a presentation about them at a local UG meeting. I started using Access in 1998. It was a good program then, even better now. It took MS a few years to...

Thanks, Colin. Your post above encouraged me to try something that I had not done before. I wanted to know if MVFs would hold several URLs. My test shows that they won't do that, at least not the way that I tried it. I would like to assign several URLs to records that store information...

XPS, as I stated in my post, the form and report that I showed may not work for everyone. But, it works for me. I take all of my meds and supplements in the morning at the same time. They are all for the same medical issue. I take a different med at night. It is not shown in the screenshot...

Remember, you can use both Combo Boxes and MVFs in the same database. When you conduct the needs assessment, learn how the users want to enter data and see the information in their reports. If the database has thousands of forms and reports, the multi-selections can be both types, especially...

Thank you, The-Doc_Man. The next time I read that an .Accdb file can only have 1000 forms, I will know that the author is using an ancient version of Access. I hit the 4,000 mark using Access 2019. I am running A365 now on a 64-bit system. I am one of the people waiting for MS to support...

My motivation for using MVFs is the visual effect in forms and reports. In forms, my MVFs use System Separator for Separator Characters. In reports, my MVFs use New Line as Separator Characters. I set Can Grow to Yes for MVFs in reports I put as many as ten MVFs in my tables/forms/reports...

Someone asked to see the message that AW sends when it blocks a post, here's what I just received when I responded to a reply in another thread. All I did was thank someone for his help. Perhaps he had something in his text. I removed his text, and it worked.

Thanks, Josef, perhaps that's why. I don't set the HasModule property because I don't use class modules. I attended a couple of UG presentations in the past two years about classes, but I didn't understand them. More to learn.

I came across this thread this afternoon. I have one easy question for folks. Where did the statement that an Accdb file cannot have more than 1,000 forms come from? Is this what MS says? I created one .Accdb file with more than 4,000 forms. I am working on another Accdb file now that...

It looks like the system quotes previous replies. I don't do it. I am happy to type "BlueSpruce #460". But Jon is correct, I didn't realize this for several days. I got it now.

BlueSpruce, I would ike to see both a form and a report for the same recordset. Here's a pair that I have in my Finance and Health database for pet care activities. When I opened the lookup form, I noticed that it has 126 items. That indicates that an MVF can have more than 100 items, which...

Yes, Mark. The last time that I worked on the manual for my proposal management system, the manual was more than 400 pages. That was several years ago. For each form, there was a screenshot and a page of text. For my Finance and Health manual, no one will print it out in hardcopy. I don't...