Search results

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...

Hello to everyone, Before asking, let me just say that I do have a solution to the question cited below, but I would like to understand why VBA won't work. I have been trying to automate a repetitive task in a quite complex database, but VBA keeps throwing a "too few parameters. expected 2"...

I've got a peculiar situation that for the life of me cannot figure out how to do properly. The situation is as follows: - I have two subforms that are bound to the same parent form. - Subform A has three comboboxes that draw values from a types vocabulary. All three are bound to hidden column...

My issue may sound a bit silly and there may be an obvious solution I'm just not seeing, but here goes nothing: - I have a text box (Long Text, non-RTF) occupying the left half of a form. This text box stores large amounts of text, usually running several pages long. - The right half of the form...

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...

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...

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...

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...

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...

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 will be working in the next couple of days on a situation that goes a bit like this and just wanted to know beforehand, whether it is possible. The situation is as follows: - Suppose on a form that I have two combo-boxes (A and B), which both store multiple values. The question: Is it...

Hello to all, I have an issue that can be described as follows: - There is a textbox on a form and when I fill in its value, I would like it to lookup whether that value matches any of the values in another form and if it does present a message box. Both fields hold only numerical data, so no...

Another issue that is probably easy, but for some reason did not manage to solve it on my own. I have a parent form and connected to it is a subform. On the parent form I have a checkbox which enables and disables fields on the parent form and also hides the subform, as you can see in the...

Hello to everyone, I have a problem that is probably the result of lack of of knowledge in Access VBA. The situation is the following: I have a table named ColorValues with the following three fields: - ID - MunsellCode - RGBValue 30 fields from another table called Color_Analysis are linked...

I have a quite difficult problem to solve in Access and I hope someone can help. I have been struggling with it for a week now.:banghead: My programming abilities are mediocre, but not novice. I have a pretty large scale management system to build (more than 40 tables, lots of relationships...