Search results

Dear Access experts, I have two tables "Tab_Issue_1" and "Tab_Issue_2". Tab_Issue_1 has two fields "Issue" and "AssignedTo". Tab_Issue_2 has the same fields. However, the "AssignedTo" is a multi-value field in both tables. I want to append data from Tab_Issue_1 into Tab_Issue_2. I use the...

Dear all, Is there a free online SharePoint server available on the internet? I want to test upload an access database on the SharePoint to see how Access works online from an online SharePoint site. Thanks, Dad

I mean how can I THANK myself?

Found the issue. The issue was how to surround the expression in the 'where condition' part of the macro so that the macro considers the field as a text. Here is how the expression should look like if the linking fields are text. Where Condition: ="[QuestionCodeInRes]=" & "'" &...

When I click on the blue color question-codes, another form that has details for that particular question code should appear. But it doesn't work. I have used this expression in 'where condition' of the macro: [expression] ="[QuestionCodeInDes]=" & [QuestionCodeInRes] [Expression] Above Macro...

Dear all, I spent 4 hours to find the error that causes an embedded macro not to work. When I open the attached database, I click on one of the question codes to open another from that shows me more details for the same question code. It doesn't work as far as I could understand. Can you...

MouseMove did what I wanted to do. Thanks, mate.

If I understand you correctly, If a form is unbound, you can not do entry in it? Can you elaborate more? Thanks, Dhamdard

I have added buttons to each province on a map. ControlTip Tex only displays a message that we type but it doesn't run a macro or VBA code, right? What I want is that when my cursor passes over a button on the map, a message box should appear and when the cursor leaves the area of the message...

Dear mates, I spent several hours but looks like I can't pop up a message in a form when the cursor pointer is on a specific object. Focus of cursor maybe somewhere else, but when I move the cursor with mouse and it reaches to a specific object, I want the object to display a message. I...

You can retrieve product cost in two ways that I know. You can use DLookup expression on 'afterupdate' event to change cost of product when product name gets changed. Or You can add product name and product cost fields to the lookup field. Then on 'afterupdate' event on the lookup field, you...

If I understand you correctly, when you select a value in the combo box, the supplier ID is automatically shown in another text box. Make sure that the tex box is not an unbound text column.

You need to have similar fields in sub to link them with main form. I usually design the main and then drag and drop the sub table into the main form in design view. Access automatically opens a menu asking for fields from the sub to link with the main. You can select as many fields from the sub...

It worked perfectly. You are the HERO.

Dear friends, I use following function to concatenate data from multiple rows into a single row/field. It puts a comma ',' after each concatenate. What I would like it to do more is to put 'and' instead of comma between the last two concatenated words. For example: Now it gives me Value 1 but I...

Re: VBA AfterUpdate Event Procedure Hi, We had a chat long ago about it. I couldn't make it. I would appreciate if you download attached light database and help me with; In the form, there is a multiple value combo box named 'stations'. What I hope to do is that when I select 'Nationwide'...

Thanks, dude. I am completely confused as have never worked with multi value combo box before. Thanks for your info. Could you write up a sample code for loop and then for setting the index property? Dad

VBA AfterUpdate Event Procedure I think event procedure for normal combo box and multiple-value-select combo box is different. I have 'station' and 'language' combo boxes. Both are multi-value-select combo boxes. This means that more than one item can be selected from the drop down list. When...

Make sure that relationship between the sub and sub-sub forms exists. Docmd refresh shouldn't be an issue here. Access automatically save an entry when the entry is completed.

I think event procedure for normal combo box and multiple-value-select combo box is different. I have 'station' and 'language' combo boxes. Both are multi-value-select combo boxes. This means that more than one item can be selected from the drop down list. When the value of 'station' combo box...