Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. germain2

    Switchboard page

    Help. I accidently deleted the switchboard page from the form menu. Any suggestions how it might be recreated. Thanks
  2. germain2

    linking databases

    Thanks Geoff. I tried doing that and it worked but I get an error message when I try to run a query from both databases. Is there further linking of the tables within relationships or something else? Thanks members.
  3. germain2

    linking databases

    I have two separate databases. Can I merge one into the other by copying the tables and forms to one database? If so, how do I link the tables so that I can run one query that pulls data from both databases/ Thanks for your help.
  4. germain2

    Access page

    Thanks Remou! That worked!
  5. germain2

    Access page

    I don't think it is the tab order. The tabs are in the appropriate order. I am thinking about how to prevent the page from scrolling up and down rather than remaining fixed. wouldn't it have to do with the page size? Thanks
  6. germain2

    Access page

    Can anyone tell me how to prevent the access page from shifting up and down the computer screen as I move from record 1 to record and so forth. Thanks
  7. germain2

    Subforms on tabbed pages

    Is there a way to prevent subforms embedded on the first page from showing on all pages of a database with several tab pages? Thanks
  8. germain2

    Linking fields in tabbed forms

    Remou Thanks, it worked!
  9. germain2

    Linking fields in tabbed forms

    I hope I can make this clearer. I have a form with several tabs, the parent tab is the child's demographics. with name, ID, address, etc. I have the next tab with information about school activities,such as classes, hobbies. On both Child's demographics tab and Child school activities i have the...
  10. germain2

    Linking fields in tabbed forms

    I am trying to create a database with tabbed forms. How do I link the common ID and Name of person so that it shows up on each tab when it is opened? I already have the fields on each tab but I am unable to figure out the parent child link. Thank you for your help.
  11. germain2

    Access database on a server

    This the first time that I am trying to place a database on the server to be used by multiple users. I have split the database how do I make the links to enable use of the database by several computers? Thanks
  12. germain2

    Access Database Question

    Can anyone enlighten me as to whether Access can be set up to allow data entry by more than one person at the same time? If so, how? Thank
  13. germain2

    Several entries to the same form

    I am trying to create a sub table that collects several discreet information points but linked to the main table. I get an error message that it can't be done because it would create duplicates. This is the scenario - Main Table has survey #10 Sub Table links to survey #10 and collects a list...
  14. germain2

    Unable to pull data from several tables

    Remou Thanks the SQl statement did populate the linking table but is there something I can do so that I can run the query directly without having to do the SQL myself, I am not very good at it. Remember my main table - Agency is linked to the linking table by Program ID and all the other...
  15. germain2

    Unable to pull data from several tables

    Remou I understand. My query is not pulling any data in the tblAgencyProgrammes table. I think that is where the problem lies. Any ideas on fixing it? Thanks
  16. germain2

    Unable to pull data from several tables

    From the Main table: PROGRAMID 235 387 402 705 SURVEYNO: 10 11 12 13 AGENCY NAME ABJ Community Services Inc.(235) ABJ Community Services Inc.(387) Ada S. McKinley Community Services Inc.(402) Ada S. McKinley Community Services Inc.(705) STREET 235 Grove Ave 45 russell Ave 34 welcome ave 678...
  17. germain2

    Unable to pull data from several tables

    Remou The query runs fine and I see the variables in the datasheet view but the cells are blank so there is no data in the cells. Thanks
  18. germain2

    Unable to pull data from several tables

    This is the query that I ran: SELECT tblAgency.PROGRAMID, tblAgency.AGENCYNAME, tblAgency.AGENCYREGION, subtblserved.Servednow, subtblserved.Licensecapacity, subtblserved.Receivetherapy, subtblserved.Internally, subtblserved.Referred, subtblserved.Contracted FROM (tblAgencyProgrammes INNER JOIN...
  19. germain2

    Unable to pull data from several tables

    Remou Thanks for the tip on saving the record and moving to a new page! It worked. I am now having problems pulling data from several forms into one query. My tables are set up as follows: Main form/table Linking table Program tables linked to the linking form All are linked by program ID. If...
  20. germain2

    Save record and open new record simultaneously

    Remou I am attaching the Save record command button to a form that is single form with embedded continuous and single forms. The code for the command button is: Private Sub Save_Record_Click() On Error GoTo Err_Save_Record_Click DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, ...

Part and Inventory Search

Back
Top