Search results

Minty, Yes, both tables have a unique ID ( I always have unique ID's in all of my tables). Could I also run a query on the "Form Load"? Thanks Dave

Minty, Could you please explain further? I have a form with a subform. The main form ties to "tblMain" and the subform has other fields that tie to "tblAtion". "tblMain" has constants for the item that never (or very rarely) need to get changed, "tblAtion" contains specific info for each use...

Hello all, I need to grab a field in a table "tblMain" field named "Interval" and use it to calculate a new date in a different table "tblPass" field name "NextDate" I have what I want working on a form and it works perfectly in the If statement below, ' If Me.Term = "Months" Then '...

ridders, Here is the link to the other site. I should also add that I don't know how to incorporate Allen Browns code. http://www.accessforums.net/showthread.php?t=71087 Thanks Dave

Hello all, I posted this on another forum about a week or so ago and still have no answer that works so I thought I'd post it here to see if I get other replies that may solve it for me. I am trying to calculate a "QtyonHand" field from a query and haven't had any luck, I am not sure what I...

Cronk, I don't believe the data is incorrect (but not positive), can you edit or generate the unique ID differently (comment out existing line please) so I can see how else to do it? Thanks Dave

Ridders, I had forgotten to change the code back to the original code before I tried to edit it. Delete the "<Type>Comment</Type", from line 93 and comment out line 77 and uncomment out line 76. I just don't know which items are causing the problem and how to fix it. I believe the tvChild...

Hello all, I am having issues trying to track down the "Unique Key error" that is happening. Can someone please help me understand the code better so I can track down what is happening? I have attached the file and if you open "frmExpandAssembly", then pick the first assembly in the list...

CJ_London, I had already downloaded the sample files from the link you provided, someone else had suggested that on a different post that I had found when reasearching this issue over the weekend, so I wasn't ignoring your suggestion at all. That code is full of all sorts of extra stuff and...

Re-Installing as 32 bit has made the controls available, Thanks CJ_London for suggesting that. Now I can at least follow along with the tutorials I have been trying to learn from. I do appreciate all the help and suggestions on this and other forums and I do take to heart all of the guidance...

CJ_London, Yes I meant it was 64 bit. I am uninstalling it not and will re-install as 32 bit. Will update thread when completed. Thanks Dave

CJ_London, I thought I was running 32 bit office but I just checked and it is 32 Bit. How do I change it to 32 bit? Did it install 64 bit by default because it is a 64 bit operating system?

Ridders, How can I get a treeview control then? The system did register it OK.

Hello all, This is driving me crazy, and it is beginning to be a very short drive. I am by no means a rocket scientist when it comes to this stuff but I have always gotten by. I am running Windows 10 64 bit on my home laptop and access 2010. I am trying to use a Treeview control however...

I have it resolved, Thanks for looking. Dave

Hello, I don't know SQL at all so please bear with me as I learn. I have a query that runs great and gives me expected results in datasheet view. When I try to create the report based on the query, I get the error "multi level group by not allowed in subquery" I copied the SQL statement...

arnelgp, It looks like you used the original table which had the redundant fields, is that correct? How did you get the correct output, when I had them in there I wasn't getting the correct output, it would just give me the 1st lot from the first field. I see in the query that each of...

Pat, I appreciate the extra guidance, I use the naming convention because it reflects the documentation I am getting the data from, so it's familiar and I recognize it. This table could just have easily been named BeerCard, which is really its name, the Doc # it's M22368 that is why it is...

arnelgp, At a quick glance,That looks like exactly what I was trying to get. Can you explain how you did it please so in the future I won't have the same problem. Thanks Dave

Collin, Could you please give some more direction and reason why. The table represents the materials that go into making up a particular component. This is just 1 of about 25 in the actual database, all others are working fine, this particular one had the possibility for up to 6 instances of...