Page 1 of 2 12 LastLast
Results 1 to 15 of 24
  1. #1
    MickyB is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2019
    Location
    UK
    Posts
    25

    Database help required

    I have built a database using access 2007, which in my opinion is not bad for a first attempt.

    I have a couple of problems that i can not solve so was wondering if anyone can help

    Problem 1



    I have a table set up that collects info. from fields on a form but for some reason i can not get 1 of the fields to send the info to the table.

    Problem 2

    I want to collect info from 2 tables to create a form but have no idea if this can be done. I have tried but message keeps coming up saying tables are not related. I do not know how to create a relationship between the 2 tables and with which fields.

    I was wondering if someone would have a look. Is that even possible?

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    2,385
    Problem 1 may be a spelling error for a data name.
    Problem 2 is probably needs a form/subform solution. Google finds dozens of videos for this.

    You can certainly post the DB here for someone to take a look.

  3. #3
    MickyB is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2019
    Location
    UK
    Posts
    25
    How do i post the database... I have a blank copy.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,938

  5. #5
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    2,385

  6. #6
    MickyB is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2019
    Location
    UK
    Posts
    25
    i have zipped the whole database but it wont allow me to upload. Just keep getting failed to upload message

  7. #7
    MickyB is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2019
    Location
    UK
    Posts
    25
    Click image for larger version. 

Name:	1.PNG 
Views:	24 
Size:	15.6 KB 
ID:	36998Click image for larger version. 

Name:	2.PNG 
Views:	23 
Size:	68.9 KB 
ID:	36999

    I use the form to input info and it completes the table but the Total will not auto fill in on the table. I have to manually input the total column. Is it because I have it set as a calculation on the form. Is there a way round this so it auto fills the table? All other auto fill on to the table.

  8. #8
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    7,172
    Calculated controls can't be bound IIRC, so your control isn't/can't input to the table. A control bound to the table can accept the result of the calculation by using code or a macro to update the record. You could also do the calculation in code and update the record and do away with the unbound calculated control.

    You didn't say how big the zipped file is?
    Last edited by Micron; 01-18-2019 at 03:19 PM. Reason: clarification & question

  9. #9
    MickyB is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2019
    Location
    UK
    Posts
    25
    Wow... I have no idea what that means. the zip file is 2.49mb

  10. #10
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    2,385
    the zip file is 2.49mb
    Did you do a compact/repair on the db before the zip?

  11. #11
    MickyB is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2019
    Location
    UK
    Posts
    25
    WinZip Shared File 2019-01-18 22-18.zip

    I think i have attached the zip file of the database. This is my first database attempt...so you may find it a bit messy... but it does what i want it to do.

    If it opens... the password to open the database is TCCP

  12. #12
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,938

  13. #13
    MickyB is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2019
    Location
    UK
    Posts
    25
    The password is TCCP

  14. #14
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    7,172
    Quote Originally Posted by MickyB View Post
    Wow... I have no idea what that means. the zip file is 2.49mb
    The premise of a form's controls being bound (linked to a table field) means that if you change the data in a form control, you change it in the table (as long as there are no conditions that would otherwise prevent this). A calculated control cannot be bound. Thus, it will never update a table and would need a work around such as
    - having one control to do the calculation (as you now have; call it A), but another control that is bound to the field you want to update (call this one B). Obviously you cannot make control B = to control A as that would still be a calculation. This means that you have to update the bound control by writing code or via a macro, to make control B be equal to what the result of A's calculation is.

    The other part of the comment was, as long as you're performing a calculation, and if you were to write code to update the form control, it might be more expedient to do the calculation in code and eliminate the calculated control. Others are ahead of me on opening your db, so I'll let them take it from here.

  15. #15
    MickyB is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2019
    Location
    UK
    Posts
    25
    very well explained but i have no idea how to do that

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 07-11-2016, 07:30 AM
  2. Help required to set up database
    By dmcg9760 in forum Access
    Replies: 15
    Last Post: 09-15-2015, 09:13 AM
  3. Replies: 2
    Last Post: 06-12-2015, 07:03 PM
  4. Horses database help required
    By arnie in forum Database Design
    Replies: 8
    Last Post: 04-26-2011, 08:34 PM
  5. Simple database required
    By Steve in forum Database Design
    Replies: 2
    Last Post: 03-09-2010, 06:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums