Search results

As much as I hate to admit, I am not understanding how to change this: "Base your "Tools Description and info" form off of your "Tools Description and info query" instead of the actual table". I have my book (New Perspectives: Microsoft Access 2002), Im reading all kinds of stuff, but Im not...

This is just frustrating! A bash Obama thread! Im from the USA and I am just upset.... Because no one invited me to this! :D

I am trying to help some one with a DB but I have limited experience in Access VBA or DB's, I had thought it was a VBA problem. Thats what I get for thinking. ;) Here is the dilemma. the user opens a form (DAHM-A TOOLS DATA), selects "SEARCH", this opens another dialog where you can enter a...

Thats funny, and scary at the same time. LOL

Sure! Your assitance and examples are very much appreciated! It has helped me with some syntax for tables (DLookup, DCount) that I was not understanding to well and now may be able to apply to other commands. We will see how that goes. LOL Thanks for your time and effort. ;)

I have seen the use of "Nz" before, is this some method (command) to ignore Null and redirect if equals "0"? Oh yea, it works with your new example.

The error highlites this segment of code in its entirety. Only if a value is entered that is not in a table. lngID = DLookup("pkJobID", "tblJobs", "txtJobNo='" _ & Me.tbJobNo & "'")

I read this line a lot in posts and I dont fully understand it. I'm as normal as they come, unless you ask my mom, she says I'm an alien. :cool: What does this mean to databases?

Using your last suggestion appears to work when a user enters a value that "is" in the table holding "fkPartID". If I type any value like "x" (just an example) that isnt in the table I get an error:

namliam I have two textboxes so I thought, hey, two DLookups. One for each textbox. :D boblarson I originally had DCounts, I was redirected, at this stage I do not know which methods are best until people such as yourself or namliam tell me different, none the less they are both excersizes in...

Better example? In this code I set a value for tbPartNo based on tblParts. Private Sub tbPartNo_BeforeUpdate(Cancel As Integer) 'This code revision thanks to Beetle of MS Access Groups) 'Lookup the value in the table using Dlookup. 'Dlookup will return Null if the value is not found so 'we...

I am having trouble with syntax for a DLookup. Private Sub tbJobNo_BeforeUpdate(Cancel As Integer) 'Get the Pk value of the Job number in tblJobs lngID = DLookup("pkJobID", "tblJobs", "txtJobNo='" _ & Me.tbJobNo & "'") 'Now check if the revision value entered exists for that _ Job...

I only did that to format the code window. ;) Other wise it will look like this. Sub aaa() MsgBox "This is my message for line one" & vbCrLf & "This is my message for line two" & vbCrLf & "This is my message for line three" End Sub

Using message boxes to see values of each, shows the correct value saved in the registry for each combobox. I just cant get the values (.Value or .Text) to show up in the combobox.. MsgBox Me.Combo1.Value Displays the correct value. Note: Using "Me.Combo1.Text" yeilds an error and places...

I use practically the same code for a textbox that I do for a combobox. Due to my inexperience, I dont know why this wont work. Textboxes: Private Sub Check32_Click() If Check32.Value = True Then varSettings = GetSetting("GeoMeasure", "CMM Data", "sPartNumber") If varSettings = "" Then...

vbCrLF example: Sub aaa() MsgBox "This is my message for line one" & _ vbCrLf & "This is my message for line two" & _ vbCrLf & "This is my message for line three" End Sub

Thanks for expanding on this, Im pretty sure it was one of your posts I read about SetFocus.

What'd he say? :p All I got out of that was "BAD, BAD, BAD. If you want a good set of free Access tutorials...blah blah blah..." Thanks for the link ;)

Thank you Galaxiom and boblarson for your input.

I learned to call a random control for SetFocus and then the true control for SetFocus. Me.First_Billable_Month.SetFocus 'random control Me.Completed_Date.SetFocus 'true control It happens so fast, you wont see it.