Results 1 to 9 of 9

Small Access Project by Access Newbie - (Gone Wrong!)

  1. #1
    DNDPMick is offline Novice
    Windows 10 Access 2013
    Join Date
    Jan 2016
    Posts
    8

    Post Small Access Project by Access Newbie - (Gone Wrong!)

    Evening All,



    I work for a small Social Enterprise in the UK. We have a need for a small, easy database to manage accounts and bookings. I have managed, with my novice knowledge to get the database up and running. Nothing fancy, just got a template online that did most of what we needed then manipulated to our end goal.

    There is just one annoyance. Everytime the form is opened a dialogue pops asking for "Contact". I have scoured the net and yes I know there will be somewhere on the form that is calling that dialogue, however neither the tables nor the queries are "contact". I have spent hours trying to find the annoyance with no joy.

    The database is simple. It has an account "contacts" table and a "Calls" table. The calls allow us to book pickups, automatically booking for the next day and automatically log returns 7 days later. It was originally a template from MS I think.

    IS there anyone who would be prepared to take a little look at it. I'm sure a Pro, would suss it in seconds. I can email (with no data).

    I realise this is an ask, but I just need this to work, and get rid of the mass of paper.

    Here's hoping
    Michael

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    20,628
    You should be able to attach the db here, after compact/repair and zipping.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    nick404's Avatar
    nick404 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    May 2015
    Location
    Wisconsin
    Posts
    352
    I surmise the form must be based off a query and the query is a search on the "contact" field. What is the form's function? Is it to display data or for data entry?

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,273
    I use Rick Fisher's Find & Replace add-in utility to track down issues like this. Cost about $50. Saved my sanity more than once. Another add-in with positive reviews is VTools and is free. I have also heard of MZTools.

    However, follow instructions at bottom of my post and I will look at using Rick Fisher's add-in.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    DNDPMick is offline Novice
    Windows 10 Access 2013
    Join Date
    Jan 2016
    Posts
    8

    Hopefully I have uploaded correctly

    Dbase for Forum.zipHopefully I have uploaded correctly. Thanks for the help / advice guys.







    I work for a small Social Enterprise in the UK. We have a need for a small, easy database to manage accounts and bookings. I have managed, with my novice knowledge to get the database up and running. Nothing fancy, just got a template online that did most of what we needed then manipulated to our end goal.

    There is just one annoyance. Everytime the form is opened a dialogue pops asking for "Contact". I have scoured the net and yes I know there will be somewhere on the form that is calling that dialogue, however neither the tables nor the queries are "contact". I have spent hours trying to find the annoyance with no joy.

    The database is simple. It has an account "contacts" table and a "Calls" table. The calls allow us to book pickups, automatically booking for the next day and automatically log returns 7 days later. It was originally a template from MS I think.

    IS there anyone who would be prepared to take a little look at it. I'm sure a Pro, would suss it in seconds. I can email (with no data).

    I realise this is an ask, but I just need this to work, and get rid of the mass of paper.

    Here's hoping
    Michael[/QUOTE]

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,273
    Okay, what's the password and which form? Even shift key bypass doesn't work.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    DNDPMick is offline Novice
    Windows 10 Access 2013
    Join Date
    Jan 2016
    Posts
    8
    Lol yes sorry password is dndp2013. sorry should have thought about that. Form is contact details.

    thanks again.

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,273
    I had to add PtrSafe to the API function declarations. Also had to comment the AutoExec function code.


    'Contact' is in the LinkChildFields property of the Calls Subform subform container. This should be Account Number.

    You are saving Contacts table ID into Calls table Account Number field. Since this is not actually the Account Number that is saved, a better name could be ContactID_FK.


    Advise not to use spaces or special characters/punctuation (underscore is exception) in naming convention.

    Recommend naming subform container different from the object it holds, like: ctrCalls.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  9. #9
    DNDPMick is offline Novice
    Windows 10 Access 2013
    Join Date
    Jan 2016
    Posts
    8
    Thanks June7, Not sure I understand all of that, but ill give that a go tomorrow and see where I get to. Really appreciated you spending some time on it.

    Thanks again
    Mick

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 09-12-2014, 10:39 AM
  2. Replies: 2
    Last Post: 04-07-2014, 10:01 AM
  3. Replies: 4
    Last Post: 12-14-2013, 06:20 PM
  4. Replies: 6
    Last Post: 07-02-2013, 11:28 AM
  5. Barcode scanner for small project
    By miziri in forum Programming
    Replies: 7
    Last Post: 05-20-2011, 01:50 AM

Posting Permissions

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