I have a form with an unbound combobox. This combobox serves as the criteria for a Query that then feeds a Report. It is simple, efficient, and works very well. I am also using a vba codefor this purpose.
I would like for this combobox to allow for multiple selections so that when the report is produced more than one selection would show on the report, instead of running the report two different times. How is it possible in MS Access?...
mshakeelattari
Last Activity: 3 hours ago
Joined: Nov 10 '14
Location:
-
mshakeelattari started a topic How to use unbound multi-select combo box to filter a query for reportin AccessHow to use unbound multi-select combo box to filter a query for report
-
Thank you @NeoPa for your response.
Yes, the controls are to be compared across the forms and/or reports.
I need comparing the.Tagproperty of only Lable controls for which we can useIf ctl.controltype = acLabel Then.... -
mshakeelattari started a topic How to find the controls on different forms or reports having same tag?in AccessHow to find the controls on different forms or reports having same tag?
Is it possible to see if more than one labels (on different forms/reports) are having same tag property? Can someone help me? -
Perhaps I am failing in clarifying my issue. I have a report about some items which have monthly data. Each month has certain number of records date-wise. If all the records of a month end up in the middle or bottom of the page, then its fine. However, in some months, the number of records are so large, or if a month starts near the bottom of the page and only few records come under it while the rest of the records go to the top of the next page,...Leave a comment:
-
Sorry, I am not much clear. I further try to clarify my question. I have a report in MS Access in which records for a Month are very few while for another month, there are many records some of which may go to next page or next column. In such cases only, we need to indicate on the top of the next page/column as "Continued. .." etc.
For example:
...Code:October-2021 ============================ Date
Leave a comment:
-
mshakeelattari started a topic How to add "Continued...." if rows go to next page or column on a report?in AccessHow to add "Continued...." if rows go to next page or column on a report?
How to add a word "Continued. ..." or any other indicator if some of the rows go to next page or column on a report? Can anybody help me? Thanks in advance. -
Thank you. I have got idea.Leave a comment:
-
Field list in combo of a table from another combo
On a form, I have a combo box with list of tables using 'msysobjects.na me'. I want another combo showing list of fields of the table name selected in first combo. How is this possible? Please help me. Thank you. -
mshakeelattari started a topic MS Access VBA unicode language strings change into meaningless characters.in AccessMS Access VBA unicode language strings change into meaningless characters.
In MS Access, when coding in VBA to show a string of any Unicode language (e.g., Arabic or Urdu, Persian, etc.) in a message box or textbox, it is changed into a strange language, e.g., äÏÑÀ ãÇÑ¡ Ïæ ÀÒÇÑ Çä-. Is there any solution for this other than going to settings/control panel and setting an alternate language for non-Unicode languages? -
mshakeelattari started a topic Prevent user to change the size or order of the columns of datasheet subform in Accesin AccessPrevent user to change the size or order of the columns of datasheet subform in Acces
I have a form with subform in datasheet view. I want end user not to modify the order and size of the columns. How is it possible? -
Print Data Only in Report - Control border issue
I have designed a report in MS Access. I want to print Data only. But when I check the option print Data Only, I see some Textboxes with borders while certain others without. What is the reason behind it? Any help please. -
When I replaced dbOpentable with dbOpenDynaset in line no. 27 in the code posted above, a new error appears in the line no. 31Run-time error 3251: Operation is not supported for this type of object.Code:rst.Index = "MyIndex"
3057: Operation not supported on linked tables.Leave a comment:
-
The debug.print prints the correct table name but again in line 27 (as posted in code), Run-time error 3219 Invalid operation occurs. The table is in backend database and the vba code is being run from the front end. Is this causing any issue?Leave a comment:
-
Line no. 27Run-time error 3219Code:Set rst = db.OpenRecordset(TableName, dbOpenTable)
Invalid operationLeave a comment:
-
Compiled (with option explicit set) but no error shown there.Leave a comment:
-
91: Object variable or with block variable not set
I am using a split database. In the front end I am using the following code:
...Code:Public Function RankList(ByVal TableName As String, _ ByVal Grp1Field As String, _ ByVal ValueField As String, _ Optional ByVal Grp2Field As String) '----------------------------------------------------------------- 'Preparing Rank List 'Author : a.p.r.pillai -
Thank you for quick response. Actually I am already using the "can grow" property for number of reports. However, if I have to print Data-only on to a pre-printed form/paper then I have to fix the height of the text box accordingly and most of the data does not exceed the dimensions of the text boxes. However, only in rare cases, a specific field may expectedly exceed by a few characters. When I use the method to shrink text to fit in the...Leave a comment:
-
How to Shrink text to fit in the text box in MS Access report
I have a text box on a report that has height to show two lines of text. Is there any way to shrink the font size to fit the height of the text box? I have seen a code on this forum that shrinks the text font size to show the text in a single line that becomes too small to be read easily.
Any help please. -
Yes, let us go ahead. Yes I have Skype with the same name as my username here!Leave a comment:
No activity results to display
Leave a comment: