Recent content by svtguy02

For the record this issue has been resolved. The fix? Copy all the code, copy all the objects from the existing forms over to a NEW form. Change the pointers in the code to point to the new form names and it works!! Can you say corruption?

arg!! ok.... so I got the above code working! It worked beautifully and I'm sure you all know how sweet "victory" over your problem feels. So I go ahead and open it up again after the, maybe, 10th time or so... and I Start getting the following error: Any ideas? When I click debug it...

oh... strSQL4 was probably resulted as an empty string due to LOTS of trial and error. trying this, trying that, and just didnt realize it was empty. Thanks for pointing that out! I'm gonna try to poke around it a bit, wish me luck!

sweet. Thanks for letting me use your code. That being said, I'm having problems with one portion. It doesn't seem to want to stick all the strSQL's together properly. Here's what I've got: Private Sub Form_Open(Cancel As Integer) Dim strSQL As String Dim strSQL1 As String Dim strSQL2 As...

hahah I guess you WOULD know about that one then :s So just to go over the code that you wrote for that time matrix thing. You created ONE subform, and used that as sort of a template to propegate over to all 4 quadrants of your time matrix. Do you mind if I try to copy that code into my...

For the record, you need to signup an account at that site. But thanks, i'll check it out!

I've got a form with 2 subforms in it. The fact that there 2 subforms isn't really the problem, its moreso the fact that the form does not display any data (doesn't initiate ON LOAD) until you CLICK IN it. It litterally just appears blank, then you click in it and it initiates onload (where I...

the Dcount proved to be the easiest and most successful for what I needed! dcount doesn't mess around :D Thanks alot for all the suggestions and help guys!

well, I'd ultimately like to get the value output in a text box. I just need to know if there are records in the table for SAID ID number. do a count and output the value to a txt box then use an IF statement from there. IF me.txtbox > 0 then BLAH BLAH else BLEH BLEH end if and I want this...

I've got such a simple SQL query, but it won't output the friggin results of the query! I put the query in a "Query" in access, run it... and it outputs me a integer value. I'm running the following VBA code in "Form Load" Private Sub Form_Load() Dim strSQL As String strSQL = "SELECT...

Sorry guys, I'm just really bad at explaining how things work. Ive explained it as best I can but that isnt working. To resolve that, I'll just upload the forms I'm talking about so you can ALL take a look at what I have, how it works etc etc... the Customers form is intended for adding...

not at all.... and thats the issue I'm looking to resolve. When I try using Openargs to pass the CustomerID or FacilityID over, on the form it opens on "Form_Load()" event I have the following: If Me.OpenArgs <> "" Then DoCmd.GoToRecord , , acGoTo, Me.OpenArgs End If I would like it to...

When you load that form, the Facility combo box has no options in it until you select a customer. Once the customer is selected it then shows facilities that are related to the customer chosen in the Customers Combo box Thats how its possible to "never ever" choose a facility before a customer...

Let me clarify the objects listed on this form FormName - "Customers Combo Form" Customers Dropdown - CustCmbo-Customers Facilities Dropdown - CustCmbo-Facilities Continue Button - BtnContinue Cotninue Button Hover - BtnContinue_over By selecting a Customer from CustCmbo-Customers and...

Alright well I've figured that part out. I've written the following which works: If CustInt <> "" And IsNull(Me.CustCmbo_Facilities) Then That being said..... instead of geting "Invalid Use of Null" now.... I'm getting "Type Mismatch" as per the line RIGHT after it! DoCmd.OpenForm...