A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Separately named Forms?



 
 
Thread Tools Display Modes
  #1  
Old April 29th, 2010, 12:09 AM posted to microsoft.public.access.gettingstarted
JMay
external usenet poster
 
Posts: 300
Default Separately named Forms?

In setting up a application where clients master info is to be entered,
would/should I have one frmDataEntry and another frmViewClientData,
since the frmDataEntry will involve strict Entry but with the
frmViewClientData
I want to utilize the various methods of SEARCHING for Client data, using
ComboBoxes (drop downs) to select client of interest. I've always been
confused by this. Can someone clarify to me?

TIA,

Jim
  #2  
Old April 29th, 2010, 02:07 AM posted to microsoft.public.access.gettingstarted
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default Separately named Forms?

You can use the same form for data entry and viewing/editing data.
You can also have 2 separate forms, one for data entry, and one for
view/edit the data.
Some people put a 'New' button on the edit form. User clicks the 'New'
button to open a form to add a new client.


To search using a combo box, you can use the combo box wizard to put a combo
in the header of the search client form.
The wizard will do the code for you, just use the option to find a record -
or words something like that.

The search client form will be based on a query using the client table. Make
it a continuous form. Set its allow additions property to No, to avoid a
blank screen when there are not matching records.
Also set allow edits to no and delete to no.

Put a button in the detail section. When user clicks the button, the client
edit/view form opens to the ClientID on that row where the button was
clicked.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"JMay" wrote in message
...
In setting up a application where clients master info is to be entered,
would/should I have one frmDataEntry and another frmViewClientData,
since the frmDataEntry will involve strict Entry but with the
frmViewClientData
I want to utilize the various methods of SEARCHING for Client data, using
ComboBoxes (drop downs) to select client of interest. I've always been
confused by this. Can someone clarify to me?

TIA,

Jim



  #3  
Old April 29th, 2010, 02:09 PM posted to microsoft.public.access.gettingstarted
JMay
external usenet poster
 
Posts: 300
Default Separately named Forms?

Thanks Jeanette - VERY helpful!!

"Jeanette Cunningham" wrote:

You can use the same form for data entry and viewing/editing data.
You can also have 2 separate forms, one for data entry, and one for
view/edit the data.
Some people put a 'New' button on the edit form. User clicks the 'New'
button to open a form to add a new client.


To search using a combo box, you can use the combo box wizard to put a combo
in the header of the search client form.
The wizard will do the code for you, just use the option to find a record -
or words something like that.

The search client form will be based on a query using the client table. Make
it a continuous form. Set its allow additions property to No, to avoid a
blank screen when there are not matching records.
Also set allow edits to no and delete to no.

Put a button in the detail section. When user clicks the button, the client
edit/view form opens to the ClientID on that row where the button was
clicked.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"JMay" wrote in message
...
In setting up a application where clients master info is to be entered,
would/should I have one frmDataEntry and another frmViewClientData,
since the frmDataEntry will involve strict Entry but with the
frmViewClientData
I want to utilize the various methods of SEARCHING for Client data, using
ComboBoxes (drop downs) to select client of interest. I've always been
confused by this. Can someone clarify to me?

TIA,

Jim



.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:03 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.