Recent content by WackyWaterGuy

Thanks alot. I was thinking that I had to do something with DLookup, but just didnt know how to put it together! I appreciate the help! Thanks a bunch

Hi there. I am currently working on a form to bring up data based on a work request number (each entry has a unique work request number). I have set everything up so that they can enter the data with no problem. I have a second form designed in such a way that they can recall this data...

Hey Everyone Hope you all are doing well. Just a quick - and hopefully simple - little question that I hope someone can help me out with. I have a form, and on this form is a textbox which displays the date (its default value is set to =date() ). As such, when midnight rolls around, the...

Hey There...thanks for the suggestions... The first option doesnt work at all...it just returns a blank query for some reason. The second reason, however, WORKS PERFECTLY!! WOOO! Thank you sooo much. I realized that my syntax was likely very incorrect, but the first thing I tried was your...

I was beginning to think I had a lot of this figured out....and as soon as you think so......BOOOM, you hit a wall! hahhaha :) Ok, so I have been going around in circles here, hopefully someone may be able to point out where I have gone wrong. I have 2 text boxes on my form. One is for start...

Hi there!! No, the .lbd file is there....so I dont think that is the problem...in fact, the nature of the directory in which it has been placed is a location where everyone can place files, delete files, and edit files. I am going to try and open the file again this morning on two...

Hi...I dont know if that could be it or not. There is no one accessing the file right now, and I opened it first on one computer, and then tried to open it on a second, and got a message to the effect of "The User 'Admin' is accessing this file and has set it so that this file cannot be opened...

Hi All....hope everyone is doing great! I have a question, and would just like to know if my thought process is correct, and how to go about accomplishing it, if it is correct. It is my understanding that when I created my DB, the owner was defaulted to Admin. This is fine. Now I want to put...

Carmen!! Thanks for you help We figured it out. Sorry for wasting your time...you are going to laugh (hopefully) when you hear what happened. There are two of us working on this project...and what it came down to was a mismatch in the naming. The form we used to make our subform was...

Actually GVLLayout is the subform inside of ReportQuery. The name of the check box is [GVL Shift A] Forms![MainFormName]![SubformControlName].Form![ControlName] In your example, ControlName would be GVL Shift A ... right? Ok, so my next question to you is this...What is [SubformControlName]...

Hi Carmen ReportQuery is the form (probably a bad wording scheme) :D . GVLLayout is the subform inside the tabs (this is a gerenic layout for the check boxes). The query is called from ReportQuery and queried against the check boxes within GVLLayout. I think between you and me ... I am going...

Sorry Carmen, it still says can't find the field GVLLayout. The direct translation from your input looks like this ... If Forms![ReportQuery]![GVLLayout].Form![GVL Shift A] = -1 Then ... Thanks again for you help WWG

Hi Carmen....Thanks for you input, but that doesnt seem to work either. I keep getting an error saying that it "cannot find the Field "GVLLayout" referred to in my expression". But the funny thing is...."GVLLayout" is my subform, not a field. Could the problem stem somehow from this...

HI everyone! Hope you all are doing well today. Just a quick question about a a probem I cant seem to solve for the life of me. I have a main form, and within it, subforms. I am setting up a dynamic query system, which I have successfully done when the checkboxes are on the mainform (where...

I was able to re-work my code to output that way....and it worked! Thank you very much! You made my day Thanks again WWG