Search results for query: *

Thanks softhemc, I got the first field working fine. However, the second field is not dropped the 0 number. For instance, 095*44'09.7" = -095.44097, should be -95.44097 095*32'48.0" = -095.32480, should be -95.32480 Again, thanks alots ...your post is so helpful.

Thanks softhemc, part of the values are working fine except some missing a number such as 0 at the end. 29*54'05.0" = 29.5405 29*52'06.0" = 29.5206

Like I have 2 text fields in the table, now those 2 text fields need to change the data type to number. all values in one field have 1 format such as 29*52'03.2" need to convert update = 29.52032 29*52'43.3" need to convert update = 29.52433 always 2 number, then *, then 2 number, then '...

Please help with converting values. How can I convert text to number in running append or update query? For instance 2 have to fields need to convert from text (same format in each value) 29*52'42.0" needs to convert to 29.52420 Another one is: 095*31'43.6" needs to convert to -95.31436...

Thanks PHV...It worked...Again, thanks alots.

I would like to ask a negative sign such as user enter 96.969696 then i would like it change to -96.969696. If user enters -96.969696, then it would keep this value and nothing change. This field is always stored a negative number. Please help, thanks.

Thanks PHV... It worked...Thanks alots...

Hi PHV, thanks for your response... Even I place the code under BeforeUpdate, it's still doing the same when close form using close button on the menu (tool bar)....(Close Button on form set equal to Yes) Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me.txtText1) Or (Me.txtText1)...

I have 2 forms, one for data entry and one for edit. Data Entry form is working fine, all required fields needed to fill in for record to be saved. However, on the edit form...when someone deleted some values on the required fields and hit the closed button on the menu (tool bar), it just closed...

Thanks Remou, I got it...I accidently close the form before run the sql and sorting set equal to cboSortBy... Now I got it fixed...and thanks for your help... I'm very appreciated...You deserted a star...Again, thanks..

Hi Remou, I created a combo box as you said and set row source type = field list, row source = tblDisease. When I run the form and select sort with coding exactly what you posted from reply mail, i got an error... 2467: The expression you entered refers to an object that is closed or doesn't...

Thanks Remou for your response...I got the check All working but sort... Where can I get the [Name of sort field]? I don't understand....

I have a continues form to show all item to be able to check and uncheck to view the query. it's working fine with the code below. I have 2 questions on this form: First, how do I sort the record based on user selected? Second, I need to add a check box and named "chkAll". I would like if this...

Thanks pwise and MajP for your advise...It works...Thanks a million...

Hello all, please help...I'm very appreciated. I have a main form listing all customer information Example: Main Form: "frm_Customer" CustomerID = 08-00145 (txtCustomerID) Customer LasName = Doe (txtLastName) Customer FirstName = John (txtFirstName) and some other fields.... and a...

Hello everyone, I have a main form and a subform linked on ONE TO MANY with an "CUSTOMID". For instance, On main form: CustomID:15, DateReport:10/20/2008 On Subform: CustomID: 15 , DateCollected: 10/10/2008 and some other field. When the user enter a date into "DateCollected" on the...

Thanks dhookom, it works great...Once, thanks.

Add date such as 200810310001, then use this: If IsNull(maxIdx) Then Me(namIdx) = Format(Me.txtDate, "yyyymmdd") & "0001" 'Start over on every day Else Me(namIdx) = Format(Me.txtDate, "yyyymmdd") & Format(CStr(maxIdx + 1), "0000") End If

Use this one, hope it help... Private Sub txtDate_BeforeUpdate(Cancel As Integer) Dim maxIdx, Criteria As String Dim namIdx As String, namDate As String, namTable As String If Me.NewRecord Then namDate = "DateField" namIdx = "IDField" namTable = "tblTable"...

Need to correct on the result: Hello all, please help me on the percentage. Below is my query. SELECT DISTINCTROW TblTableA.FieldA, TblTableB.FieldB, TblTableB.FieldC AS TypeC FROM TblTableB INNER JOIN TblTableA ON TblTableB.FieldA = TblTableA.FieldA WHERE (((TblTableA.FieldDate) Between [Enter...