Maybe I did not put my point correctly.
I know the difference between Access and Excel
What I mean is that there is actually (nowadays) NO way to survive without a small relational database.
10 years ago, this was still possible, but in the meantime it is NOT anymore.
And I dont think...
Dear all,
I wish you a happy new year and thank you again for your previous support for myself.
Thanks to all of you, I have managed to get an Access based system running which works efficiently and highly effectively.
Following this, I would like to raise a general point. I hope that you...
I tried to import the macro, but there would only the form be available. The thing is that I want to use this macro for other forms other than the inherent one...
I thought there might be a way to just copy paste it to other forms
Dear all...
There is this great macro "for opening a form by click"
https://support.microsoft.com/en-us/office/link-forms-together-4d5e8143-1859-4521-bbba-215f5ec8bb39
My question: Apart from copy & pasting the XML block, is there a way to bringing this macro from one Access DB to another?
Hi all,
Would a conversion of a (running) system be feasible?
And: "lookup data yourself through joins" is basically this:
https://support.microsoft.com/en-us/office/join-tables-and-queries-3f5838bd-24a0-4832-9bc1-07061a1478f6
right?
@ smart mike: Thanks for this template. I admit that I...
ok..
As said, this code works
'------------------------------------------------------------
' Search
'
'------------------------------------------------------------
Function Search()
On Error GoTo Search_Err
With CodeContextObject
If (Eval("[Form]![SearchBox] Is Null Or...
Hi all,
updating you on this.
I have just tried it: Using the macro above, and just amending the field/table names works pretty well.
So thanks again!!
I think we can mark this thread as "solved".
...I now found it to, converted it to VBA. It is the following:
'------------------------------------------------------------
' Search
'
'------------------------------------------------------------
Function Search()
On Error GoTo Search_Err
With CodeContextObject
If...
and a follow up to Gizmo and all others: I am happy to pay you for your product and support. Since I am still not (yet) able to contribute to this forum by posting technical comments, it should be just fine for me to contribute moneywise. no free lunch intended on my part :cool:
Hi all...:coffee:
@ DBguy: I am planning to use a (continuous) datasheet (table) view (i.e. no single or continuous form)
Yes. I actually would need such a "filter function" as in the MS template, that is:
- only filter applying to record sets
- no modification of records
- having the option...
The search button should perform a search in which all fields (of one table A) are included.
1. After a string is entered in the search box,
2. and the search function is executed,
3. all records of the table A which include the string entered in the search box before should be displayed
I...
Hi all,
I have been trying to find out how this great search box which MS has in its templates works.
Did not manage to understand its logic.
Does anybody knows how to implement this?
https://omextemplates.content.office.net/support/templates/en-us/tf01225343.accdt