Jumat, 26 Februari 2016

Re: [MS_AccessPros] Setting up forms

 

Steve-


I don't know what you mean by "personnel hub."  Do you have a table in the Record Source, or do you have a query?  If a query, what's the SQL?  And do you have the Data Entry property of the form set to Yes?

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)



On Feb 26, 2016, at 3:06 PM, Jean-Pierre Brown jpbrown0127@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

The record source is the personnel hub. The other tables are different subjects that i have directly related to the hub


 

Steve-

If the Record Source is not updatable, the form may be blank if the form is in Data Entry mode. What's the Record Source of the form? (SQL if a query.)

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

On Feb 24, 2016, at 7:44 PM, Jean-Pierre Brown jpbrown0127@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Anyone,

I am putting together a form. The form begins with personnel data. I am trying to add a tab control in which I will have different questions for the personnel to answer. One tab is label Operational, another is Doctrine, Materials, Leadership, Training, etc. Each tab has is individual table. So, for the first tab I made it Operational and put all the fields on the tab. I add the table to the query and all is well. However, I make the next tab (Doctrine), put all the fields on the tab that I want and add the table to the query and try to go back to form view. The form is blank. Can anyone help me with this? I checked all the relationship and have each table related to the main personnel data ID (one to many).

Thanks for any replies,

Steve

------------------------------------
Posted by: Jean-Pierre Brown <jpbrown0127@yahoo.com>
------------------------------------

------------------------------------

Yahoo Groups Links


__._,_.___

Posted by: John Viescas <johnv@msn.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar