Page 8 of 9 FirstFirst 123456789 LastLast
Results 106 to 120 of 132
  1. #106
    farmi is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Posts
    73
    Ah but that i dont want. I want 1 gpk code that could relate to multiple knmpnummer. so every knmpnummer can only relate to 1 gpkcode, not multiple.
    thanks!

  2. #107
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Have a look at the updated front-end that I reset to use the old field.

    Cheers,
    Vlad
    Attached Files Attached Files

  3. #108
    farmi is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Posts
    73
    Hey Gicu,

    thanks for the new front end. i tried to integrate all the new functionality into my own front ent as it has some other adjusments. It mostly works now. i also adapted the overzichtstabel and deleted the gpktable.
    The only thing im running into now is the ontstripformulier. i cant get it to work with my newest version. it keeps giving me the error ''barcode does not exist or is not active''

    heres my newest frontend: https://drive.google.com/open?id=1nm...xVImK17b7ec-dA

  4. #109
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Try this one. Please note that you have missed some code changes in the Geneesmiddelbewerkformulier form as well, I have now corrected both.

    Cheers,
    Vlad
    Attached Files Attached Files

  5. #110
    farmi is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Posts
    73
    Quote Originally Posted by Gicu View Post
    Try this one. Please note that you have missed some code changes in the Geneesmiddelbewerkformulier form as well, I have now corrected both.

    Cheers,
    Vlad
    thanks!
    but it still gives the same error?

    EDIT : fixed the cb name and the sql still refered to gpk, changed column number and now it works

    thanks again!

  6. #111
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    You're welcome!

  7. #112
    farmi is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Posts
    73
    Quote Originally Posted by Gicu View Post
    Sorry haven't had time to look at it, it is hunting season in my neck of the woods... For the first one I thing you should give it some more thought as the backup copies can pile up quite fast the way you want it. It can be done but you need to think about disk space, naming conventions and general usability. As an alternative you could export the main tables as text files and keep a rolling 5 or 10 copies of each (every time you shot down you replace the oldest set with a new one).

    Cheers,
    Vlad
    So how would i go about making a single backup file that automatically backups when i close the program?
    i dont need seperate versions of the backups, overwriting the same one is good enough.(as long as i have at least one backup)

  8. #113
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Download my free utility and either schedule it (with Windows scheduler) to run sometimes during the night or open it from the unload event of your main form.
    http://forestbyte.com/ms-access-util...end-compacter/
    Cheers,
    Vlad

  9. #114
    farmi is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Posts
    73
    Ok thanks! will have a look at it and try to put it in the unload form.

    i have an issue with the ingevoerd door field in the forms, sometimes it shows up empty and sometimes it only shows a number instead of a initial(which is my main problem now). i cant seem to find the issue in the form. what's causing this?
    https://drive.google.com/open?id=1Xo...bxuSDJwEhpLOS8

  10. #115
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    The issue is caused by the use of the lookup in the table for that field. You are displaying the initials but storing the user id. If you open the table (in the back-end) in design view and change the lookup from combo to textbox and save you will see that the field has a combination of initials and user ids (numeric). You need to remove the lookup in the table and remove the ID column from the combo on the OverzichtstabelListForm form. I have done it for you in the attached (look at the screen shots to see the problem).

    Cheers,
    Vlad
    Attached Files Attached Files

  11. #116
    farmi is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Posts
    73
    thanks for the reply!
    i can't see your screenshots, they wont extract here and give an error
    the forms work now, thanks. Still get an error(instead of the errormessage i want) when the form is empty though.

    Im looking through the code you have written and the comments. When you say that i missed those changes does that mean that i still have to change something or that you already fixed it?

  12. #117
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    I have done the changes. Did you run the update query to fix your data? I will insert the screen shots in this message.
    Click image for larger version. 

Name:	ingevoerd_door1.jpg 
Views:	17 
Size:	177.1 KB 
ID:	37717

    Click image for larger version. 

Name:	ingevoerd_door2.jpg 
Views:	17 
Size:	155.7 KB 
ID:	37718

    Click image for larger version. 

Name:	ingevoerd_door3_update_query.jpg 
Views:	17 
Size:	120.8 KB 
ID:	37719

    Can you show/tell what form and what error are you getting?

    Cheers,
    Vlad

  13. #118
    farmi is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Posts
    73
    error 94 invalid use of null. when i click on the error handler i see that the error is in the line: ''FileName = Me.Geneesmiddel & Me.Id''

  14. #119
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    When do you get the message, is it in Knop179_Click on the Geneesmiddelbewerkformulier form? Are the Geneesmiddel and Id populated? You can test for them and exit if missing.
    Cheers,
    Vlad

  15. #120
    farmi is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Posts
    73
    its the ''opslaan'' button on the geneesmiddelbewerkformulier form (not at a computer now so cant check if its 179).

    I have a control to check if there are empty fields in the form. So if i try to save i want it to give an error that there are some empty fields.
    So to test the function i left all fields empty on the geneesmiddelbewerkformulier in dataentry mode, when i press the save(opslaan) it gives that error 94.

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

Similar Threads

  1. Inventory System in Access
    By Antonww in forum Access
    Replies: 6
    Last Post: 11-29-2017, 06:35 AM
  2. Need Help:Basic Inventory System
    By shazi9b in forum Access
    Replies: 5
    Last Post: 09-26-2013, 12:48 AM
  3. An inventory system
    By stew8908 in forum Access
    Replies: 3
    Last Post: 05-08-2012, 05:50 PM
  4. Inventory System
    By Rawb in forum Database Design
    Replies: 8
    Last Post: 01-05-2011, 07:26 AM
  5. Replies: 1
    Last Post: 12-30-2008, 08:58 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