Search results

That did it. Thanks a million on this one ByteMyzer

Thanks for the quick reply. That is giving me an error " Invalid use of Null " when I try to run it.

Hi All, I have a query that I just can't seem to get my head around. The end result is that I need the query to return ONLY records where the TOTAL_ON ( total on hand ) is equal to or less then the MINIMUM. part of the problem is that the MINIMUM field is a text so I have a field Min that...

Thanks Wazz, Yeah I do I think I will try and start the form over again. I wish I could come up with an easier way to do this form. It's a new part entry form so the user needs to add all of those fields that go into the Master table, but I also need it to add a entry to the Inven table to be...

Hey Wazz, Nice find, I think I have been looking at this thing to long I should have seen those. I changed them and for now I took the default value out of the RP_Date field. In your post you said you got it to work? I am still getting errors. I keep getting a Compile Error on the Me.UNIT_MEAS...

I tried that and I am still getting the 3134 error. I am beginning to wonder if I have some kind of corruption underlying in it. I tried REMing out my statement and running just yours and still getting it. I have attached a copy of it for you to see if maybe I am missing something on this...

That did not seem to get it. I went back and checked all of my fields. It seems to be a syntax error my DoCmd lines. Do you know if there is a limit to how many fields can be updated.

Hi All, I am trying to get code for a button to work. I keep getting errors everytime. I get error 1334 if I do seperate DoCmd lines. If I try both on 1 line I get 2943 errors. Im still pretty wet behind the ears on VB code so any help would be greatly appreciated. I have tried like this...

If I am understanding your question correctly, You have a field on your "main form" with the case number in it. On the form you are opening you need to have a field that also has the caseID in it. If you put something like this in the Default Value property it should work for you...

Hi All, I have a project that I need help with. I'm trying to recreate a form from a Borland dB3 database. I was able to find code from the Northwind database to do the toggle buttons on a form. I can get it to work fine as long as its a single form and only displaying 1 record at a time. What I...

Hi All, I have a project that I need help with. I'm trying to recreate a form from a Borland dB3 database. I was able to find code from the Northwind database to do the toggle buttons on a form. I can get it to work fine as long as its a single form and only displaying 1 record at a time. What...

Thanks Anyways Guys I figured it out I was using the wrong requery...... FYI to anyone else who gets this it should be ME.SubformName.Form.Requery

Hi All, I found a DB that RuralGuy had posted on another thread that is exactly what I was looking for. The problem that I am having is I had to add a subform that shows comments for the classes that are scheduled. It works correctly on opening the form but I can't seem to get an code to work...

Hi All, I search the forum but could not locate exactly what I was looking for. I have a Form that is a has 31 fields that I need to color code beyond the 3 that are there. I have seen code that people have tried but everytime I try 1 of them It colors all the fields. I need to it to color 5...

Hi All, Im not sure if this can be done or not. I have a form that when a part is received gets entered there and a quanity with a check box for if labels are needed. When the button it clicked I need to generate the labels bases on the qty that was inputed on the form. Example: part_num...

Hey WayneRyan, Your right I wasn't even thinking on those lines. I will be tracking the received parts as well so I will do it that way. Thanks for all your help... its one of those you can't see the forest because of the tree's things. LOL Don

Hey WayneRyan, I tried that and it is not reducing the quantity on hand in the "tbl_parts" table. If Im reading your code correctly that is checking to see that there is a quantity on hand correct. What I need is it to reduce my quanitity in "tbl_parts" by the number that I am removing. Thanks

Hi All, I have an inventory DB that I am trying to setup. I have 2 table "tbl_parts" which holds my barcode_num, description, stock_level ( qty on hand ) etc. The second table is "tbl_stock_level" which has barcode_num, trans_date, qty, emp_int. I have a form frm_parts_used that when the user...

Hey Rural, I did that and most of them are working now. The only ones that don't seem to be working are the calculated fields and the Form_Current, so I added a button they need to click on and I added it to the last text box on the page and it runs the code on both of them so I think it should...

Yeah Brian that is exactly what I need it to do. Basically the form is a vacation request form and it shows there current available vaction and if they try and over schedule and the total goes into a - value we need it to display a message to inform them that they have over scheduled their...