Search results

that being the case ... wonder if unzipping a Word (/Excel/Ppt) document to get the source files would be at all useful ... maybe @isladogs can test that?

hi @alvesi re: "when I use the look up combo box on the table to select the “name text” it only show me the “id number”" You can fix that by setting the ColumnCount, ColumnWidths, and ListWidth properties Here's a short video to explain it: Combo Box properties in Microsoft Access (11:25)

my understanding is that use of the new web browser control is available publically for forms, with reports coming shortly. To respond to initial question asked by @mohsin ... in case this was missed ... re: "tips or tricks to make it work with local files" Referencing local files is...

hi Isac, you're welcome! wonderful, thanks for letting me now. > similar parameter configuration for a look up on a table? not exactly sure what you're asking ... to reference a column of a combobox value, use =me.controlname.column(#) in ControlSource of another control such as a textbox...

@Avoraightu, considering @The_Doc_Man's comments, it would be good to change the variable name for lngMin and lngMax -- and the declaration statements respectively too (which I think you've already done)

data type is so important! Thanks for letting us know how you fixed it

@isladogs, what Thomas has done is tremendous ... but still a candle to what Access already had with classic charts. Their big shortcoming was not better initial formatting and not being visually updated until rendering to the form view. Modern charts fixed bad look and the rendering issue ...

you're welcome, @Avoraightu ~ happy to help

thanks for letting us know that, @JoeJimenezMicrosoft. The web browser control has long been a great way to show the contents of local files in Access, especially pdfs and images -- you mentioned the 2 used the most ... although there are more .... Appreciate everything what you and the other...

actually, they were declared as variant ... but obviously single or double wasn't what was detected ... best to declare them to be what they are. I spent lots of time figuring out correct data types for each property, where it was possible to find out!

for instance, in Foxit:

re: "open PDF's in the browser control" my experience is that this has to do with settings in your PDF viewer, not Access.

hi @Avoraightu If this is a modern chart, I have a comprehensive reference here: https://msaccessgurus.com/article/Chart_Modern.htm it seems you need to set properties. It's a long page, so here's a direct link to that spot: https://msaccessgurus.com/article/Chart_Modern.htm#PropertiesChart...

-- Recent presentations posted On YouTube -- AL: Loop and Link CSV Files in Access using Queries, by crystal (strive4peace) (54:51) AEU - Optimizing Queries in SQL Server, by Maria Barnes (51:38) AP: Bad Data is Bad for Business with Pat Hartman (1:07:18) @Pat Hartman , @isladogs, @GPGeorge

If you missed Colin's (@isladogs) recent presentation, or were there and want to watch the video to better absorb some of the great stuff he shared, here it is: AL: Translation Tools using Access - Colin Ridington (isladogs) (1:10:34) Tomorrow, Tuesday, I will be presenting for Access...

-- Upcoming AccessUserGroup meetings -- Access Lunchtime – Loop and Link CSV Files - crystal (strive4peace) February 28, Tuesday, 12 noon Central, 6 pm UK https://accessusergroups.org/lunch/event/access-lunchtime-4-2023-02-28/ Access Europe – Optimizing Queries in SQL Server - Maria Barnes...

@isladogs, great session! Karl gave an outstanding presentation. I expect next month with Thomas and his clever graphs will be extraordinary too

a great reference to make APIs run in either 32 or 64 using VBA7 (Access 2010+) is by Peter Cole @petertheme . He's given a couple presentations and kindly shares information. AL: Updating API calls in VBA to work with 64 Bit, How To + API Viewer using Access - Peter Cole (45:41), Jan 2022...

Colin @isladogs did a presentation today for Access Europe about rendering Google maps in Access, and adding drawings. Every time Colin does a presentation, I am awed. He's a great teacher with a lot of knowledge to share. Being a participant of the meeting also provides camaraderie with others...

you're welcome and thanks, Colin @isladogs -- most excellent presentation. You're a great teacher. Glad I was there to get my questions answered (amazing how small those static images are) -- and also nice for camaraderie with you and others who love Access. Happy you're sharing your demo...