Search results

Thank you. It has to be that way because it is utilising inputs from 15 users each one having separate mediums to add images (HDDs, DVDs, memory cards, mapped drives, etc.) and all storing images in a predefined cloud service.

The DB is installed as a client in Program Files. If someone moves it to a different folder, then all sorts of issues arise, not just with this. It is inflexible by design.

Got this one to work as well...quite a tricky one in the end, but couldn't find a more elegant solution. I ended up creating arrays of values for the bound IDs of the combo fields prior to designing the SQL string for filtering the record source. If someone finds a more elegant solution, I'd be...

Got it to fully work without ActiveX! It's a drag-and-drop utilising the Hyperlink field's capacity to accept drag-and-drop objects in MS Access and trigger the After Update event. The relevant portion of the code for handling the address is found in the text attached. It would not allow me to...

Thank you for the idea and code. I will try this and report on results.

Thank you for the links. I will take a closer look at FAYT's classes, as they may contain some interesting ideas to adopt/adapt. Generally, I don't really need a search as you type, more of a type and filter the current recordsource of the form to display records with the term contained in a...

I would be interested in the solution, but the link to the post was not attached. Could you send it again? I'll post my solution too once back to the office on Tuesday.

Thank you for the reply. I tried it but worked only for files under relative folder from the frontend. I used the workaround in Note II eventually. I'll post the relevant part of the code when I'm back at the office.

Thank you for the comment. In regard to the questions: - I am filtering a clone of the currently displayed Recordset of the form to get only records that have a certain value contained in select fields. Note that the form currently has about 7500 records [e.g. if a user searches for the term...

Hello to all, I have a form in an MS Access 64-bit frontend with some text fields, some integer, and some combo boxes (the backend is in MySQL). The combo boxes have queries in their row source that are bound to the form based on ID, but contain text data in the second column of the row source...

Hello to all...I have run into an interesting issue and if someone is able to help, it would be much appreciated. I have constructed a MySQL database for the backend and an MS Access frontend in 64-bit. The issue is the following...I have been trying to create a drag-and-drop feature for the...

This confirms my suspicion that editing the contents of the show/hide column selection box is indeed impossible. Thank you for your time and information.

I understood that from the article and it is indeed useful, but even if I do a Detail+Datasheet combination to imitate the traditional split form division, I would still not be able to control the contents of the Column Chooser box for the Datasheet form, right?

I thought about disabling right-clicking altogether and creating a custom pop-up modal form that would allow the user select columns and then use VBA to hide/unhide them in the datasheet section, but it is too much hassle and not much to be gained. We need a split form cause I'm using a tab...

It is indeed a useful reading and documents aspects not found elsewhere.

Mainly removal of options/columns from the list. For example in the screenshot I would like to remove the AttachmentPath and AttachmentAddress options.

Useful reading, but I did not find anything related to the question. As far as I gather, the split form and datasheet Column Chooser control is not documented, therefore my hopes for being able to edit its contents are rather limited.

Hello to all, I've been trying to figure whether something is possible and trawling the web has not helped. The question is quite simple: When you right click on the column header in the datasheet part of a split form and select Unhide Fields, a box pops up with the available columns to...

All the above are very informative and unfortunately a great deal of this knowledge is not in manuals or even knowledgebases for Access, so thank you for sharing these. To address a few worries, the user never sees queries, as the interface hides everything and locks users out of all the Access...

This sounds like a workable idea. Thank you, I'l ltry it!