Search results for query: *

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

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.

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.

Thanks Remou! That worked!

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

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

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

Remou Thanks, it worked!

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...

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.

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

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

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...

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...

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

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...

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

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...

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...

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, ...