Page 2 of 2 FirstFirst 12
Results 16 to 28 of 28
  1. #16
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Okay, but the link opens a page that says 'This library is empty'.
    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.

  2. #17
    streub is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Oct 2017
    Posts
    42
    I can't win

  3. #18
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    That might be your own OneDrive folder. At least that's where the link seems to take me. When I choose other folders, what looks like the account number in the url doesn't change.

    We are talking about a db that's less than 2 Mb, yes?

  4. #19
    streub is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Oct 2017
    Posts
    42
    If you could, please, use the login and password I sent in the previous post(s). I logged on and had not problem.

    Thank you

    Steven

  5. #20
    streub is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Oct 2017
    Posts
    42
    Yes it is less than 2MB. Would it help if I uploaded the Database Documenter report for the form(s) and/or table?

    Steven

  6. #21
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I repeat - as soon as I click on Shared (or any other icon) I end up in my own One Drive account. Maybe you haven't set up a folder for sharing? I have an account but have never done that. The documenter details won't help me. Maybe June7?

    I'm at a loss to understand why you can't upload here if it's 2 mb or less and you're following the directions exactly. Maybe try a jpg and if that does work contact a forum admin and ask why not a db?

  7. #22
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    The link doesn't offer any opportunity to enter login and password. Doesn't login require email/phone/skype to identify the account? To share OneDrive folder https://support.office.com/en-us/art...0-a82024800c07

    As for uploading the Database Documenter - that monstrous report that Access builds - I would not even look at it.

    A Windows compression zip file of under 2mb should upload.
    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.

  8. #23
    streub is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Oct 2017
    Posts
    42
    I have set my OneDrive account to allow sharing. Below is the link and a password is not required. I cannot determine why my system will not allow me to upload my file to this site. Perhaps this is a solution.

    All of you have been extremely patient and helpful and I am thankful for your assistance.

    https://1drv.ms/u/s!AnyQE4O4uZnQaThODLbmVGwt2b0

  9. #24
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    You said it was less than 2 Mb but it's 36 Mb?? And that is after being zipped?
    Am I wrong, or is it no wonder that you couldn't upload it?

  10. #25
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    you have ="[PvNum]=" & Forms![Product Variable Search]![PvNum] in your embedded macro on form pv num search
    Not sure if the double = sign is the issue or that you're referring to the wrong form or if it's something else. I don't use and don't care for macros of any sort so am not totally familiar with them.

    This seems to work
    Forms![Prime Inventory Entry]![VarNum]= [PvNum]

  11. #26
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    OP was likely mixing 2GB db limit with 2MB forum limit. Case of seeing and thinking different things.

    Form Click event will not execute because there are active controls on the form. Should probably put code in Load event or just eliminate it, don't really think is needed.

    [Prime Inventory Entry] form has DataEntry property set to yes. This means cannot open to a filtered set of existing records, only to new record row. Change to No.

    I see the following expression in the macro - ="[PvNum]=" & [PvNum] - remove the first = sign and it works.
    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.

  12. #27
    streub is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Oct 2017
    Posts
    42
    Outstanding advise!

    I will let you know.

    Thank you!

  13. #28
    streub is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Oct 2017
    Posts
    42
    Most excellent advice!

    Problem resolved.

    Thank you all for your patience, expertise and diligence.

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

Similar Threads

  1. Parameter Value Error Message
    By qwerty in forum Access
    Replies: 4
    Last Post: 11-10-2018, 02:28 PM
  2. Replies: 7
    Last Post: 03-17-2016, 05:53 PM
  3. Replies: 15
    Last Post: 11-01-2013, 03:24 PM
  4. Replies: 2
    Last Post: 04-04-2013, 03:13 PM
  5. Unwanted parameter message
    By Andrea in forum Reports
    Replies: 1
    Last Post: 09-27-2012, 03:53 PM

Tags for this Thread

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