Search results

This works with a minor tweak, but the combobox rowsource is not formatted correctly. Titles are shown with the names of the fields, instead of their aliases, and the first column is the id instead of the text that it represents. See attached figure.

Sorry about that. FilterSelector is the name of the combobox, hence it takes the rowsource property. :) The plus/minus 2 is for the Left and Mid functions to extract what is necessary for the SQL string, as Access puts spaces in between the Filter function. I've checked this with Debug.Print.

Hello everyone, A question on combo-boxes this time. I have a modal and pop-up form that loads and gets filtered when you click a button on another form. The pop-up/modal form contains an unbound lookup combo-box for quick navigation between the records. However, I want to set the row source...

For anyone looking into this, after researching for a while I have come to the conclusion that it is not possible. Therefore, for the virtual keyboard solution, the only possibility was to copy-paste the caption of the key.

Hello everyone, Just a simple question: Is there any way to insert Unicode characters outside the basic multilingual plane (BMP) in MS Access? I've already tried ChrW and does not work, because it is limited to decimal integers up to 65536 or hexadecimal up to FFFF. I'm looking to introduce...

The Citation will indeed be a lookup field, but all rules of normalization and proper relationships will be in place. Also, no multi-select or MVF used. The Description field will not be named after reserved words, I'm aware of the issue, it is for the sake of clarity in this post that I've...

In other words it is most likely in the sphere of imagination. :) Thank you for the clarification.

Hello everyone, Just a quick question to see if something is actually doable. I plan to create a table called Citations with four fields: "ID" --> autonumber primary key, "Citation" --> This will be a drop-down list drawing records from the Table Bibliography, "Citation_Content" --> This will...

This is an exploratory question rather than one that help is needed. The title pretty much covers the question, but an example might help: The situation is one where I have box numbers/names stored in a table (e.g. Box 1, Box 2, Box 3, etc.) and the spatial relationships between boxes in...

Thank you all for the answers! I increased some time-out values in the Client Settings of the program and it seems to have done the job! I knew it was somewhere in there. Provisionally, I increased the limits for file locks and disk buffer too, as in the near future I'll need to get an output...

Hello, I'm coming across a strange issue that I suspect may have to do with Access 2016 limits or time-out settings that I don't see. I have a report that is quite complex (1 report, 5 sub-reports, 1 image field feeding from images relatively linked to the report via VBA) and long, as the...

It is not a continuous form, it is single record, but it prints continuously. I wanted to make it this way, so that the interface for the user is also the final product. It's for a micro-task, not something big, hence no need to produce reports. Thank you for your thoughts!

Entirely correct! I did not think of the simple solution and went for the hard one. :) Thank you!

I'm certain that the solution to this one is rather simple...but I just can't figure it out! I have a form with a subform which need get printed as a PDF. There is a textbox on the subform which gets its backcolour property set based on the value entered in a combobox also on the subform. I...

Since the video solution was much simpler for what I wanted to do (autopopulate 5 mvfs and some other checkboxes with a specific value - saves the user about 15 clicks in the db), I followed that solution! The INSERT INTO alternative was more complex and I was not certain whether it would...

I already had in mind the Microsoft resources, but didn't want to go for a DAO approach (already have a quite complex database and didn't want to fiddle around with recordsets), but the video provided an excellent and very functional alternative, so thank you for the resource!

And I think I might have a case of too late at night to think...it was a type mismatch issue... Dim qst As String qst = "INSERT INTO Table1(Field1.[Value]) Values ('C')" & "Where ID= " & Me.ID & ";" DoCmd.RunSQL qst Me.Refresh

The title pretty much says it all. Assume we have an MVF on an Access form with some values in the list behind it (either Value List or Table/Query). Is it possible to have a button that when clicked can populate the MVF for the current record with a value that is already in the list of the...

Having solved the issue of populating multiple comboboxes (see here), I have now run in another issue, which is how to delete the records in three comboboxes that are linked to multi-valued fields (MVFs) in the same table. At the moment the solution I've tried and kinda works (sometimes it...

I may try again in the near future, as part of an improvement project, but for the moment I'm satisfied that it actually works.:D