Search results for query: *

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...

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.

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...

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...

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...

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 First Date:] And [Enter Last...

txtValue = "Sugar land, City of |15245|what|8558" i would like to get the value like: txtNewValue = "Sugar land, City of" Please help, thanks.

I had a module and named “modCheckAddress”. Below is the code: Option Compare Database Option Explicit Private rst As ADODB.Recordset Private con As ADODB.Connection Private strCon As String Function CheckAddress(strAddress As String, strCity As String, strZip As String) As String On Error...

This is a list in my query. Code Date EP_Num 1 6/16/2008 1 1 6/16/2008 0 2 6/17/2008 1 3 6/17/2008 1 3 6/17/2008 1 3 6/17/2008 2 4 6/17/2008 1 4 6/11/2008 0 4 6/18/2008 1 4 6/18/2008 1 5 6/18/2008 0 6 6/18/2008 1 6 6/18/2008 1 6 6/18/2008 1 6 6/18/2008 1 I would like a result to...

Hello, It was working fine on access 2003 back-end. However, when I upsized to SQL database I got this error "2105" when open the form with message " "You cant go to the specified record". Private Sub Form_Load() txtSite.SetFocus imgFace.Visible = False lblCheck.Visible = False...

Hello all, I don't know where to start, please help. I don't know if it's possible to calculate the average number of days between a start and end day. Below is my query's result: [Enter Begin CheckedDate] = "01/01/08" and [Enter End CheckedDate] = 06/20/08] ID CheckedDate...

Hello all, I don't know where to start, please help. I don't know if it's possible to calculate the average number of days between a start and end day. Below is my query's result: [Enter Begin CheckedDate] = "01/01/08" and [Enter End CheckedDate] = 06/20/08] ID CheckedDate...

Hello all I have a form and a subform, link by the CollectedID for example: on the form I have CollectedID: 2008-VKGS-65656 subform: CollectedID ConfirmedID 2008-VKGS-65656 T00005 2008-VKGS-65656 T00006 2008-VKGS-65656 T00007 all data stored in a table...