Search results

Wooooooooow! Entirely toooooo much time spent on this one... Thank you so much for being so patient!!!!! I tried money and it was almost there....then I tried float and it worked.... This is crazy!!! Thanks again Take Care.......you deserve a beer!

Here what I think is the problem. The data is linked to SQL.....so the data types is not set right and it is rounding it to 0..... I have to find the data type that will let this happen.... I tried it on decimal and it still rounded it to 0... Do you know what data type in SQL that would...

Thanks for your patients.... I see what I did wrong.... I sent the wrong file...sorry. I think it is something wrong with my db... It works fine on the one you sent....but when I copy everything exactly it still returns 0.....so I'm not sure what's going on.....I even imported everything over...

Please if not correct...please correct and send back so I can see what I did wrong.......:banghead:

Can I send that testdb12 back with your changes...so I can make sure I have it right?

Im sorry, I will not be about to overwrite the Cutoff field if I put it in the row source....that why I was trying to create a vb code for it. I don't mean to be pain with this....

Well what I want to return is the CutoffWidth which is numbers like 0.145....this number should populate in the cutoff field..

Here is just an example of what I have, The db I have is too big Thanks

pbaldy, I tried Me.Cutoff = Me.Combo76.Column(2) and I did not get anything.... not sure what is wrong...I tried Private Sub Combo76_AfterUpdate() Dim varX As Variant varX = DLookup("[CutoffWidth]", "[qMachGroup]", "[MachineSize] = '" & Me.Combo76 & "'") Me.Cutoff = varX End Sub On the...

Ok, I put it on the afterupdate event on the cutoff field and I'm am still getting nothing.... Is there something wrong with my code?

Pbaldy, I changed it to this Private Sub Cutoff_Click() Dim varX As Variant varX = DLookup("[Cutoff]", "[qMachGroup]", "[MachineSize] = '" & Me.Combo76 & "'") Me.Cutoff = varX End Sub No error now...but still nothing...what event should I have this on? Whenever I change what is in the...

Thanks michaeljryan78 That make sense however, I need the user to be able to overwrite the field. The drop down will just reset it to default. So they can use the drop down...but if they wanted to change the amount they can... Thats why Im trying to do it in code....trying anyway any...

Thanks, I tried this below and I get runtime 2471.....sorry I'm still learning..... Private Sub Cutoff_Click() Dim varX As Variant varX = DLookup("Cutoff", "qMachGroup", "[Machine Size] = '" & Me.Combo76 & "'") Me.Cutoff = varX End Sub The reason I need code is because I need for the...

Hello All, What I am trying to do is when I choose a value in a drop down this will populate the the next field called "cutoff" based off of the drop down. Is there a easy way to do this in VBA? I tried this but it is not working Private Sub Cutoff_AfterUpdate() Dim varX As Variant varX =...

No...I didn't do that.... it still was not launching the hyperlink... then I added this selFile = "#" & selFile & "##" And now it is launching.....see... I am learning alittle bit! Thanks for all your help....hopefully I will keep learning... Thanks again!

which reference should I use in tools...getting the user define error again... Thanks

Ooops..thanks for that.. This is the end result Private Sub Command299_Click() Dim dd As Integer Dim selFile, selRoute As String Dim fileDump As FileDialog Set fileDump = Application.FileDialog(msoFileDialogFilePicker) dd = fileDump.Show If dd = -1 Then...

Thanks that worked. Now Im trying to get the results in my field called Blueprint1. So I did this If dd = -1 Then selRoute = fileDump.SelectedItems(1) selFile = StrReverse(selRoute) selFile = StrReverse(Mid(selFile, 1, InStr(selFile, "\") - 1)) selFile =...

Thanks, I get a "user define type -not defined" on filedialog error Any Ideas?

No hassle, BTW, Do you know a easy way for a browse button. Basically, I need to browse for a file and just the path of the file is returned??