Search results

Ok, so remembering I'm a novice and this is actually my 1st DB Dim rs As Object ---- Whats rs? a record set? Dim lngBookmark As Long --- lngBookmark is just a variable name? Mine will be Dim StringBookmark as String? 'set a variable to the current record lngBookmark = Me.txtEmpID -----...

Good Grief!!!! I spent a bunch of time copying tables, removing "sensitive" info, putting in bogus info so I could post the DB and now it seems to be working. Don't know why, do I have to close it and re-open it for changes to take effect? can't be. anyway it works but......... When It opens...

Ok I got the me list part, sorry for being dumb and I changed the control source name to Product_Number and now get a new error. Below is new code Private Sub Command75_Click() DoCmd.OpenForm "EditBom3", , , "[Product Number] = '" & Me.Product_Number & "'" The EditBom3 form is opening but it...

To see a list of all the controls on a form where do I type "Me."?? I tried in the immediate box but that doesn't work

Thanks Lag I corrected that Private Sub Command75_Click() DoCmd.OpenForm "EditBom3", , , "[Product Number] = '" & Me.ProductNumber & "'" But still get the same error, Method or data member not found. The top line is still highlighted yellow and the Me.ProductNumber is selected with a blue...

one more thing, regarding the complete code Private Sub Command75_Click() DoCmd.OpenForm "EditBom3", , , "Product Number = '" & Me.ProductNumber & "'" The top line is highlighted yellow in the debugger

Here we go again. I am using the same technique on 2 different forms and am getting a method or data member not found error. Here is my code. DoCmd.OpenForm "EditBom3", , , "Product Number = '" & Me.ProductNumber & "'" The source form is a tabbed form, if that matters and I am running the...

No, ToolSearchCombo is not the record source, the record source (i think) is the ToolNumber Control that I clicked on. I fiddled and this code actually works DoCmd.OpenForm "ToolList3", , , "ToolNumber = '" & Me.ToolNumber & "'" I mis-interpreted baldys instructions but you guys got me...

Thanks for the quick replies. I put in baldies code in the on click DoCmd.OpenForm "ToolList3", , , "ToolSearchCombo = " & Me.ToolNumber and I get a perameter box opining when I click the cell. It says ToolSearchCombo, if I click ok, the next perameter box says RL611 (the tool number I...

Novice Macro question. I have a subform open in datasheet view. I want to click on a cell with a tool number (text) in it and open a tools details form showing that record. I created a macro, on the on click event in that cell to open the form but I can't get it to open on that record. Probably...

Thanks for your response Mr.45. Cool name. I think we are taking similar approaches however your idea to use an append query to a temporary table is a good one. My objective is to get a material requirement report based on the open orders from the top level product (finished goods). Currently I...

Thanks for your input ByteMyzer. This is indeed an ambitious project. I would love to just purchase an MRP system but money is tight and we have to use what we have. I have an extensive planning background and have worked with several MRP systems at previous jobs so I do understand the...

The database is split with the back end being on the server and each employee (all 4 of us) having their own front end. Might be a little messy sharing. I will gladly share anything I can easily share however. aa

Thanks darbid. The title is kinda scary but I will check it out. aa

Thank you sir, gotta respect the advice from a user with 20,000+ posts aa

Hello all Been using access for about 6 months now and working on an MRP program (see Queries question MRP database) and would like advice on a good VBA book to learn the basics. Thanks for your input. aa

Thank you for the information in the above sites, glad to know someone has tried to do this already, albeit in 2005. In the Celko approach, if I read it right , he created enough columns to cover the maximum number of levels he might need. I got around that by creating a junction table, similar...

Thank you for the reply jzwp. I was able to get the nested query working but I get a "query to complex" error message when I go out to 6 levels so your Loop statement idea is probably the way to go. Only problem is I am a beginner and don't really know where to start to do that. I have read the...

I am trying to create a material requirements program in access for my company. I have multi level bill of materials and have a bom table and a bom details table with the component material usages. I pull the top level demand from a customer orders table but I can only get a single level by...