Search:
Type: Posts; User: hwinceFL
Search:
Search took 0.00 seconds.
-
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:...
-
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.
-
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...
-
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...
-
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...
-
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...
-
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...
-
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;...
-
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...
-
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.
-
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...
-
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.
-
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...
-
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;...
-
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...
-
Hello ScottGem, Is there anything further I need to provide to continue progress on this issue? Thanks again for your help.
-
Thanks. Another try. Can I ZIP my DB, if that is required?
-
Hello ScottGem. I hope this is what you request. Thanks.481524815348154 Is there a way to upload my DB?
-
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....
-
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)...
-
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...
-
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...
-
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....
-
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...
-
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,...
-
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...
-
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...
-
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...
-
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,...
-
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...
-
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,...
-
Thank you, Scott, for your very helpful suggestions and guidance. I'm working on it now.
-
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...
-
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,...
-
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...
-
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?
-
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...
-
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...
-
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...
-
I'm not sure what happened to the formatting above, but all of the Go to are with a capital T included.
-
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...
-
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...
-
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?
-
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...
-
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...
|