Search results

Folks I am going crazy:banghead:.........Can't figure this out.... Dim Num As String Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String Num = Me.Well_ID ' Reading an String from a field in the form MsgBox "Form WellID ----> " & Num '...

That would also work, You have got it, much better shorter cide..... I see the use of tag now...... I keep reading abt it and didn't really understood it... Thanks

Yes I agree I naturally went there after couple of hour ........ The latest is If Nz(ctl1.Value, "") = "" Then varResult1 = "No value For First Name" Else varResult1 = "Value is " & ctl1.Value & "." Ok1 = 1 End If If Nz(ctl2.Value, "") = "" Then...

i think having IIF of IF pritty much dose the same, I need run all the conditions with no messages, then run the massage to the user notifying them of what is missing. if all the conditions come out OK, which it means that they have gave me the info I want, then I can take the info and copy to...

Yes.....That is correct...... The form has more boxes but I just need to make sure they have at minimum the 6 that i want........ I have code that is probably not very efficient but it works, I just need to place the condition on it so it they don't the form let them knows that i need the...

Hello All..... Can somebody tell me how to do multiple conditions, Nested....I have 6 conditions that i like to check, if (condition-1) And (condition-2) And (condition-3) And (condition-4) And (condition-5 ) And (condition-6)...

It works for the first query and gives me the error for the second query. Run-time error '3021': No Current record. The Form . It is split form looking at table(Customer_Call). Top is the form bottom is the grid. As in any split form once I highlight any record on the bottom I get the...

The result of the query... the query returns a well ID right, in this case is 10S04E07N024...... Earlier in the code I am picking a WellID from the form WellID = Forms!f_Customer_Lookup.Well_ID with the query I am looking to see if the WellID exist in the Customer_Call table if it dose I will...

OK that worked, but I still get an error...... Run-time error '424' - Object required The error is for MsgBox RecordsetObjectName.Fields("Cus_Well_ID") Truthfully I guess the disconnect fro me is this, In concept I am executing an query(strSQL), conceptually this query has a result, in my...

Thanks Paul for getting back to me.......I really Appreciate this WellID is not a number it's alphanumerical (i.e 10S04E07N024), I changed the code to Dim WellID As String Dim strModel As String Dim strSQL As String Dim rst As DAO.Recordset WellID = Forms!f_Customer_Lookup.Well_ID...

Hi, I am hoping somebody can shed some light into my issue here, I am not a programmer but I do OK. I have a form in which am gathering information from the user to populate a table(Customer Master List) and at the same time (btn_Copy_Click Event)transferring the info to another form(Case)...

Thanks a bunch..... I see your approach. This is Good, I can modify from this point to Taylor to the project........ I really appreciate:) your help.

Good Morning plog..... I was wondering if you made any headway on this, is this possible you think through Query, Maybe it would be easier to do this in VB and make function........ommmm I wonder.....

Thanks........ I will give that a try.......

Hello All..... This should work but I get #Name? instead of the first name.....I am using this in a form. trying to pull the student name from a field in the form that has the student ID. ---------------------------------Expression---------------------------- ="SELECT...

To Simplify essentially the table in the database has all needed attributes to compile the query.....

First off I like to thank you for replying to this post……. I think I need to explain a bit more to clarify the situation. The actual database that the reads are stored in is in a different system, so what I start with is an export of the data (5000+- records) for any given quarter…… My goal is...

Hello All: I am having a heck of a time figuring this out….. :(. I Think there needs to be a conditional statement to the nearest date to the 15th day of the month. Most of date statement I have found are between and math driven(add subtract etc...). I have table with bunch of wells, divided...