Search results

  1. C

    Hide Back Access Window on Load

    Well, I'd be willing to give it a shot. Its just bothersome when I do a lot of preparations then it doesn't work. Once I have the correct code I'll be able to save it for future databases as well. Thanks
  2. C

    Hide Back Access Window on Load

    Hello, I know there are tons of "how to" pages on the internet on how to hide the back window. However, all the ones I've tried hide the toolbar and the database window but they do not hide the back window that has the access path up top, not sure what that is called? 'Hide database window...
  3. C

    Access Database Design

    Thanks for checking!:)
  4. C

    Access Database Design

    No. I have something like.. Forms frmPickUpList frmLogMyWork frmAllProjects Queries qryProjectAssignee qryProjectList_Distinct qryProjectStatus
  5. C

    Access Database Design

    Yes, some forms have multiple queries.
  6. C

    Access Database Design

    Thanks guys! That was helpful! This is my first large database creation and I was starting to get worried I too many queries. But yes, they all do serve a purpose and are single parameter queries.:o
  7. C

    Access Database Design

    Good Afternoon Access Experts, I was wonder if you guys wouldn't mind passing on some Database creation tips. I have a database that has 25 forms, 15 linked tables, and 60 queries. Does this sound like an excessive amount of queries? I have so many queries, sometimes I forget what I used...
  8. C

    Update Table 2 When Table 1 is Updated

    Yeah, I see. Takes me a min sometimes. Also, I just gave random examples above not realizing the significance. I only have two fields that are redundant, ProjectName and NeedByDate. I need to remove those from Table2 and and make sure my keys are in place. Thank you!
  9. C

    Update Table 2 When Table 1 is Updated

    Thanks! Couldn't figure out how to do relationships, forgot about the foreign key.
  10. C

    Update Table 2 When Table 1 is Updated

    I don't think I need redundant data. I thinking a whole bunch of tables would slow it down. So I had multiple tables that house extra data for fields that get used with sometimes. I don't always think the way you guys do, but Im learning. I need to separate basically.
  11. C

    Update Table 2 When Table 1 is Updated

    Table1 - ProjectName,Items, NeedByDate Table2 - ProjectName,Items, NeedByDate, BusinessName, ContactName etc. I created a form to allow me to update just the Table1 data, however, I would also like the corresponding fields on Table2 to also be updated based on the CallID feild that is shared...
  12. C

    Update Table 2 When Table 1 is Updated

    A query using JOIN and relationship defined tables?
  13. C

    Update Table 2 When Table 1 is Updated

    Hello, I am trying to create an "Update Query" that updates Table 2 when table 1 gets updated. This seems like it would be simple, however, I can't get it to work. I've tried various combinations of the expression in each field but nothing is working. Table 1 and Table 2 are connected by...
  14. C

    Import or link to data in an SQL Server database

    That makes sense. Thank you for the SharePonit info DBguy, it's been very helpful!
  15. C

    Import or link to data in an SQL Server database

    Haha...point made! LAN would be better. I have another question if you don't mind? Would using SharePoint thru your internet provider have the same security issues? Thanks
  16. C

    Import or link to data in an SQL Server database

    I had this question in a previous post but I don't think I communicated it properly. I have a database I've built for a company. I want to be able to upload the DB file that contains all the tables, then have the staff use the DB with the forms with the capability to update and change table...
  17. C

    Distinct Query + show other fields

    Got it, than you!
  18. C

    Distinct Query + show other fields

    If the 1st listbox has a distinct query for first 5, how do I create a listbox to show related fields in listbox2? Thanks!
  19. C

    Distinct Query + show other fields

    Hello, I am trying to figure out how to run a Distinct Query for a particular fields BUT also show the other fields. Basically, I have a listbox that populates a query where fields 1 to 5 are the same but fields 6 to 10 may have different values. I would like my listbox to show only Distinct...
  20. C

    Upload Access Database to hosting plan

    Thank you very much for explaining that. It was super helpful.
Back
Top Bottom