OK, I'm pretty new in MS Access programming and I'm doing this project for an organization, which runs on volunteers, and I’m one. I have this database with organizations who give disoriented people a daily thing to do what ever one feels, to a limit, like to do.
The input is performed by a number of these people themselves so it has to be veeeeerrry user-friendly; more than foolproof.
To maintain the table of organizations,I made this InputForm without any menubar or Access control tool #-), which gives me some problems.
To go to a certain record in the InputForm, for modification, I made, via a go-to-button on the InputForm, a pop-up form where two search criteria can be filled in, in a textbox. Either the IDnumber used in the table or the name of the organisation. Both are textboxes that can be filled in with each there own go-to-search button.
Remember that no toolbars , tables or queries should appear on the screen to avoid confusion to the person behind the keyboard!
I have gone through the tips and came across some similar questions but all partial of mine., because on these the search input is on the same form and with comboboxes using the RecordsetClone; works great! My Inputform however, is crowded due to the fact that minimum fontsize=14. I already had to remove some fields in the table.
With the books next to me I created the following macro (GaNaar) from the pop-up form, with the search button and OnClick property, which works but not to satisfaction:
Echo – off
SelectObject – to go to the InputForm
ShowAllRecords – just in case....
ApplyFilter – a query that picks the info from the pop-up entry
GoToRecord – puts the filtered record on the InputForm
Close – to close the pop-up form
This in fact brings up the desired record but than the input form is frozen because of the filter.
Oke complicated; but HOW do I remove the filter (without the menubar available) again and stay in the record I selected and be able to scroll manually with Next/PreviousRecord (I have buttons for that on the Inputform).
What I more or less need is the macro above but without the filter section. However if I remove that part nothing happens; at least not noticeable.
I was also thinking about Dlookup, in the condition collumn, but what to place after the “=” since the input is on a different form than the output and what action to use it with. SetValue? GoToRecord?
Am I to solved this problem or am I going down_under?
Examples are appriciated.
An alternative, understandible VBA-sript, like RecordsetClone with result on other form (Parent/Child), are also welcome.
TGIF
Marc Rust - Netherlands
Answer can also be sent at marcrust@dagbestedingdwo.nl
The input is performed by a number of these people themselves so it has to be veeeeerrry user-friendly; more than foolproof.
To maintain the table of organizations,I made this InputForm without any menubar or Access control tool #-), which gives me some problems.
To go to a certain record in the InputForm, for modification, I made, via a go-to-button on the InputForm, a pop-up form where two search criteria can be filled in, in a textbox. Either the IDnumber used in the table or the name of the organisation. Both are textboxes that can be filled in with each there own go-to-search button.
Remember that no toolbars , tables or queries should appear on the screen to avoid confusion to the person behind the keyboard!
I have gone through the tips and came across some similar questions but all partial of mine., because on these the search input is on the same form and with comboboxes using the RecordsetClone; works great! My Inputform however, is crowded due to the fact that minimum fontsize=14. I already had to remove some fields in the table.
With the books next to me I created the following macro (GaNaar) from the pop-up form, with the search button and OnClick property, which works but not to satisfaction:
Echo – off
SelectObject – to go to the InputForm
ShowAllRecords – just in case....
ApplyFilter – a query that picks the info from the pop-up entry
GoToRecord – puts the filtered record on the InputForm
Close – to close the pop-up form
This in fact brings up the desired record but than the input form is frozen because of the filter.
Oke complicated; but HOW do I remove the filter (without the menubar available) again and stay in the record I selected and be able to scroll manually with Next/PreviousRecord (I have buttons for that on the Inputform).
What I more or less need is the macro above but without the filter section. However if I remove that part nothing happens; at least not noticeable.
I was also thinking about Dlookup, in the condition collumn, but what to place after the “=” since the input is on a different form than the output and what action to use it with. SetValue? GoToRecord?
Am I to solved this problem or am I going down_under?
Examples are appriciated.
An alternative, understandible VBA-sript, like RecordsetClone with result on other form (Parent/Child), are also welcome.
TGIF
Marc Rust - Netherlands
Answer can also be sent at marcrust@dagbestedingdwo.nl
