Search results

Thanks for the feedback everyone. I just wanted confirmation that I wasn't using an incorrect approach, rather than verbosely explaining my exact situation. For clarity: Parent form opens a popup form. They have a 1to1 data relationship. If child record is found by link criteria, it is...

I've always been of the assumption that if you open a bound form (that allows additions) using linking criteria (eg DoCmd.OpenForm stDocName, , , stLinkCriteria) Access will: Display the matching record(s) if the linking criteria was found. or Move to a new record, ready for data entry, if no...

Wondering if anyone has a solution to the following scenario. Multi-user access app running in a Windows corporate environment. App on PCs, Db on server. The app uses images that are stored on the server file system. The db stores the path to the images. Permission to use the app is via AD...

It never ceases to amaze me that an Access app can: Provide all of the functionality required to meet a particular business need and the needs of users. Be easily modified to meet new/changing requirements. Be incredibly reliable when developed and distributed properly, often outperforming the...

... or just have 2 maps, one for start and one for end. Could put them side by side or in a tab ctl etc.

Not sure if this helps your situation, but to restrict access to my apps I have a licensing table in the shared backend db. This table contains a column that stores the windows name of computers that are licensed. Whenever the front end is started my login screen is the startup form. VBA code...

Hi George, I'm not seeing a link to the video you refer to.

Let's say we have a typical Access application setup - Access front end on PCs and back end on a network file server. Assume the app has 100 queries used on various forms (as the form recordset, for listboxes, combos etc). Queries are also used as recordsets for reports. When migrating an...

Thanks, appreciate the replies.

When I deploy my Access apps to client PC's I like them to look like I designed them. There is an Access property "use windows themed controls on forms". In my opinion this can make radio buttons (particularly) and check boxes look better. I've done some testing and while not drastic I am...

That's not the question I'm asking, but to answer yours... I'm converting 32bit APIs to 64bit APIs plus updating 3rd party ActiveX components to 64bit versions.

I'm in the process of converting a 32bit accdb front end to 64bit accdb. In my dev environment the backend (mdb) was copied from a 32bit environment and I haven't done anything to convert it to 64bit (such as save-as). So far I haven't encountered any issues with the 64bit front end interacting...

I'm not sure about "Access always being terrible at displaying images other than .bmp or .wmf". In Access 2003 I never had jpg issues with print preview or otherwise. When I jumped from 2003 to 2016 this issue was apparent. I think it was introduced with 2013 or perhaps with the accdb format...

Many of us know that the later versions of Access have an issue displaying jpg images in print preview mode... image quality is terrible. In my case the images are on the file system and just referenced by path. I know there is an Access property to convert all images to bmp on the fly and...

Thanks all for your feedback. Good to hear 64bit Access is reliable.

Hi, I have a number of Office 365 32bit Access apps that are used all day, every day in commercial environments. Accde front end on user PCs Mdb backend hosted on server. Heavily coded including Win APIs. 3 x 3rd party ActiveX components. I'm happy to say that these apps have been incredibly...

Hi, yes it's a great component but as far as I can tell doesn't allow markup of images. I've since found and am testing cxXImage by ChestySoft. So far so good with their 64bit ocx. Actual code samples are a bit lacking in their documentation but you can work it out by trial and error.

Hi, Looking for recommendations for a 64bit imaging activex component for use in my 64bit Access app. I've used a 32bit component called ImageX in my 32bit apps and it did everything I needed but alas the provider has gone AWOL and no longer lists this product in 32bit or 64bit options. I...