Search results

Gasman, I create backups based on the amount of work that I do in between backups. Usually, after I create 20 or so new forms/reports, I back up the database. I figure that I can recreate that many objects if my PC goes belly up. Now that my memory has gotten bad, perhaps I should do backups...

Thanks, Pete. I understand some of what you are doing. But I need to study my Access books to better understand DLookups. I have been using .Visible statements for almost a decade. I used them first in my Sunset Crater graphic. I created it circa 2010 to show the competitive advantages...

Duane, are you sure? I remember attending the launch soon after I retired.

Gasman, my PC is locked down tighter than Fort Knox. I can't open zip files or PDFs. I would love to look under the hood of Pete's application. At least this one is connected to the internet. The one in the basement has never seen the internet. It's a lonely device for sure.

Thanks Duane, I forgot to reply to your post. I haven't touched PBI in more than a decade, maybe two. I am building my finance and health application for use by non-techies, most of whom do not use Excel or PowerPoint. The food recall map is one of about 500 forms currently in the database.

Pete, your solution is outstanding. I need to find someone whose PC isn't locked down the way that mine is, so I can look under the hood. My PC won't let me open a zip file. In the meantime, tell me how the line forms. Does it start with the first capitol and then display the others in a...

Yes, arnelgp. I purchase USB drives by the case. I have some that I bought decades ago. I usually back up database files every week. Thanks for reminding me that it is Friday.

Thanks arnelgp. I will try using that today. Can I get rid of the With and formatting? I have 50 states on the map. I may want to move all of the labels and checkboxes off the map if there are no recalls in a state. And with so many recalls being announced, I suspect the government will...

Thanks, Jack. I learned something new from your post #18. I read recently that the entire .Move statement is not necessary, but I haven't tried it yet. I use two objects so they can be controlled separately. I have one button on the form that hides the labels and another one that hides the...

Sorry about that Mark. My tables often have lots of fields, but some have more than 200 fields. If I fully normalized my databases, I would hit the limit of objects allowed by MS. I have one application now that has more than 4,000 forms, 4,000 reports, and almost that number of tables...

Yes, George. I am still working on the Food Recall form. I think of something new to add to it almost every day.

Thanks Pete. I am trying to have the labels and checkboxes for the states physically move to their normal positions on the map. It is like what you would see in a PowerPoint animation. I saw Alessandro do this in 2020 at DevCon. The label and checkbox for California would move from the...

Thanks, Below is what my .Move statements look like. This is for Georgia's label and checkbox. GA.Move 8.5417, 3.0833, 0.2083, 0.2396 ' Checkbox LGA.Move 8.5417, 3.0833, 0.2083, 0.2397 ' State label Determining the Top, Left, Height, and Width values for all 50 states will be a...

I have a form in one of my databases that has a map of the USA. The map shows the states where foods have been recalled by the federal government or the producer. I would like to know the most efficient way to physically move the state labels and checkboxes from the upper left corner of the...