Ask Experts Questions for FREE Help !
Ask

Search:

Type: Posts; User: hwinceFL

Search: Search took 0.00 seconds.

  1. Answers
    0
    Views
    513

    Coding a form in Access 2007 Redux

    I am using Access 2007 under MS Win 10 x64 to manage an inventory. I have an Issue form (frmVolAssetIssuingForm), which works fine and creates a record in tblAssetsLoaned with the following fields:...
  2. Answers
    0
    Views
    550

    Coding a form in Access 2007

    I have keyed in my question four times, but just before I can "submit," I get kicked off and loose everything. I don't know if the problem is Internet Explorer or Ask Me. Help.
  3. Answers
    7
    Views
    1,459

    Let me explain further. BorrowerID #2 is offering...

    Let me explain further. BorrowerID #2 is offering to return AssetID #1842, which was issued earlier under LoanID #18 and posted in tblAssetsLoaned. Volunteer/Operator/UserIDIn #3 (that's me) has an...
  4. Answers
    7
    Views
    1,459

    OK, I'm back, but this has been quite an ordeal....

    OK, I'm back, but this has been quite an ordeal. First, it took several days for the repair tech to look into the login issue. Finally, backed out Win update, re-did it successfully. I think I...
  5. Answers
    7
    Views
    1,459

    Hello ScottGem, Thanks. Regrettably, following my...

    Hello ScottGem, Thanks. Regrettably, following my last Win 10 update I can no longer login to my laptop computer where Access exists. It's now in the repair shop. Will continue this issue as soon as...
  6. Answers
    7
    Views
    1,459

    Hello ScottGem, thanks for your response. I am...

    Hello ScottGem, thanks for your response. I am sure your suggested alternative to solving my problem will be a much more effective approach than my current one.

    However, I would like to understand...
  7. Answers
    7
    Views
    1,459

    Help with form input

    I am using MS Access 2007 under MS Windows 10 Home x64. I have created a form for handling an inventory item in my project. This is an item issued to "Borrower." The issuing form identifies the...
  8. Answers
    4
    Views
    1,376

    Hello Scott, Thanks so much for your very helpful...

    Hello Scott, Thanks so much for your very helpful guidance. Just a couple of more questions -- the line thickness in the report appears to be "double space"; how do I set in to "single" or otherwise;...
  9. Answers
    4
    Views
    1,376

    Using Acrobat in Access 2007

    I am using Access 2007 under Windows 10. I have created a table which I would like to print out. How can I set the specifications for Acrobat, such as landscape vs. portrait output, top/bottom/side...
  10. Answers
    2
    Views
    867

    I believe I should have asked this question in...

    I believe I should have asked this question in Computers & Technology>Programming>Databases>Access, but I don't know how to move it. I would appreciate guidance in that move.
  11. Answers
    2
    Views
    867

    Using Access query in a report

    In Access 2007 under MS 10 x64, I run my query sorting two of multiple fields in a table, which gives expected results. However, when I use that query as the record source for a report, the results...
  12. Answers
    4
    Views
    808

    Hello ScottGem, Please accept my apology. I...

    Hello ScottGem, Please accept my apology. I thought I had already responded to your help. I chose your checkbox suggestion and thus considered the issue RESOLVED. Sorry this didn't get recorded.
  13. Answers
    4
    Views
    808

    I have made the suggested coding changes and they...

    I have made the suggested coding changes and they work; however, not as desired. Although the form using this button is currently pointing to a single record, the Execute instruction effects OnHand...
  14. Answers
    4
    Views
    808

    Help with VBA coding

    This is to request help with VBA coding not working as expected. I am using Access 2007 under MS Win 10 x64. I have a tblAssets (Inventory) with the following structure: AssetID, AutoNumber;...
  15. Answers
    0
    Views
    613

    Need help with form updating table content

    I am using MS Access 2007 under MS Windows 7 Home Premium. I am having a problem with updating a table record in my Lending Library system. I have a multi-form which is based on tblAssets, which...
  16. Hello ScottGem, Is there anything further I need...

    Hello ScottGem, Is there anything further I need to provide to continue progress on this issue? Thanks again for your help.
  17. Thanks. Another try. Can I ZIP my DB, if that is...

    Thanks. Another try. Can I ZIP my DB, if that is required?
  18. Hello ScottGem. I hope this is what you request....

    Hello ScottGem. I hope this is what you request. Thanks.481524815348154 Is there a way to upload my DB?
  19. Hello ScottGem, This procedure is still not...

    Hello ScottGem, This procedure is still not working. What needed information am I not providing that will lead to the solution. I'm trying as best I know how. I will appreciate your further help....
  20. Hello ScottGem, thanks for your response. I...

    Hello ScottGem, thanks for your response. I should have been clearer in my review. The User is the volunteer/staff handling the transaction of issuing the asset. He/she (likely knowing their own ID)...
  21. Unfortunately, I have had to leave this project...

    Unfortunately, I have had to leave this project since my last post, but am now back looking for help again. So let me review. I have created a form, frmAssetsMainForm, bound to tblAssets. This form...
  22. Thanks for the clarification. When I open the...

    Thanks for the clarification. When I open the subform separately, I find the subform, frmAssetsLoaned, the record source is tblAssetsLoaned. Now when I open the main form, frmAssetsMainForm, it...
  23. I don't see Recordsource, as such. The Source...

    I don't see Recordsource, as such. The Source Object is frmAssetsLoaned with Link Main Fields as AssetID and Link Child Fields as AssetID. Further, neither of these is more uniquely identified, e.g....
  24. Thanks, Scott. That worked just as you described....

    Thanks, Scott. That worked just as you described. The selected Asset on the Main form (by AssetID) is linked to the subform and the AssetID field there shows the same number. However, the other...
  25. Scott, I'm struggling trying to set up my forms...

    Scott, I'm struggling trying to set up my forms to follow your earlier suggestions. I have set up my Main form bound to Assets and using a combo box am able to select an asset on the Main form. Then,...
  26. Of course, I see your point. We do have some...

    Of course, I see your point. We do have some limitations/requirements on User qualification; but, we do have volunteers so we're pretty flexible. However, as you point out a Borrower might well...
  27. Thanks for the clarification of the definition of...

    Thanks for the clarification of the definition of a foreign key. I've been thinking of them in that way, but thought there might be a setting I've been missing.

    The User is my acronym for...
  28. Thank you for your very helpful guidance. Your...

    Thank you for your very helpful guidance. Your conclusion that I'm making this more complex than is needed is certainly true. I'm going to have to spend some time digesting your suggested plan. It...
  29. Hello Scottgem. Thanks so much for your response....

    Hello Scottgem. Thanks so much for your response. The SQL for this form record source is SELECT tblAssets.AssetID, tblAssets.PerformanceType, tblAssets.Title, tblAssets.PrimaryLoc,...
  30. Help with multi-table query results to populate a form

    I have three tables each with primary keys with relationships to another table in which each of these fields is a foreign key. I have attempted to prepare a query using these tables (requesting...
  31. Answers
    0
    Views
    665

    Help with run-time error in Access 2007

    I am getting a confusing error in my use of moving one form to another. First, a user (me) logs in by selecting his record from a pull-down list and enters his appropriate password. When PW is valid,...
  32. Thank you, Scott, for your very helpful...

    Thank you, Scott, for your very helpful suggestions and guidance. I'm working on it now.
  33. Help needed in handling lending library borrowers

    I have a table of existing borrowers of our lending library. I am asking for help in how the librarian(s) can determine that a customer's record is in the current table; does any of their personal...
  34. Answers
    17
    Views
    1,413

    OK, I have corrected the coding in my...

    OK, I have corrected the coding in my StrongPassword function and it is now working as expected. But, either Scottgem is unavailable or simply ignoring my earlier requests. In any case, therefore,...
  35. Answers
    17
    Views
    1,413

    Hello Scott, May I continue to seek your help in...

    Hello Scott,
    May I continue to seek your help in trying to get my StrongPassword function to work? I have made some changes from my previous version as follows:
    Public Function...
  36. Answers
    17
    Views
    1,413

    Is there anything further I need to provide in...

    Is there anything further I need to provide in support of my request for help in solving this macro error message blocking my attempt to debug my StrongPassword function?
  37. Answers
    17
    Views
    1,413

    Thanks for your patience. I have tried to follow...

    Thanks for your patience. I have tried to follow some of your guidance in your book and have prepared my modUDF as shown in the attached screenshot. However, I am able to debug (insert cursor; select...
  38. Answers
    17
    Views
    1,413

    Thanks, Scott, for your very helpful guidance;...

    Thanks, Scott, for your very helpful guidance; however, I'm still hitting a snag. I have updated my StrongPassword coding as suggested and prepared it for Debug by setting a breakpoint at the first...
  39. Answers
    17
    Views
    1,413

    I have prepared my module as you suggest. But,...

    I have prepared my module as you suggest. But, I'm having trouble debugging it. Trying to follow you guidance in your book, I open the coding, place the cursor at the first If statement and select...
  40. Answers
    17
    Views
    1,413

    I'm not sure what happened to the formatting...

    I'm not sure what happened to the formatting above, but all of the Go to are with a capital T included.
  41. Answers
    17
    Views
    1,413

    Hello Scott, Thanks for your response. Obviously,...

    Hello Scott, Thanks for your response. Obviously, I should not, at my level of skill, state that my coding is "without error."
    My effort relates to my attempt to modify your Login Security procedure...
  42. Answers
    17
    Views
    1,413

    I have another question regarding VBA coding. I...

    I have another question regarding VBA coding. I have set up a For loop as follows:
    Dim ICount As Integer
    ICount = 1
    For ICount 1 to 8
    [Intermediate coding without error]
    Next ICount
    Here I get...
  43. Answers
    17
    Views
    1,413

    Thanks. The problem was in the Menu coding and...

    Thanks. The problem was in the Menu coding and the suggested change corrected that. I don't see the need to upload my DB at this point, but what is the maximum size for an attached ZIP file?
  44. Answers
    17
    Views
    1,413

    Thanks, Scott. I have acquired your book and will...

    Thanks, Scott. I have acquired your book and will be downloading it to my iPad and iPhone shortly. I would like to send you my DB, but when I try to attach it, I get an indication that this an...
  45. Answers
    17
    Views
    1,413

    Help with VBA code

    This not really a Quick Answer; it's more a Slow Question.Like Lisa, I need help with VBA (rather than VB) coding since I'm using Access 2007 under Win 7 Home. I have copied (modified slightly to fit...
Results 1 to 45 of 45