Recent content by di.miller

Hi All, I changed the code for the field I was having trouble with in Access. Here is how I formatted it so that the pesky leading 1 was dropped: SELECT RIGHT([HBELP_FINAL_Q.COMPLETEDATE],6) AS RealCompleteDate,Now it works great!:p -Diana

OK, I know I need to do something here with the Left or Right( )... I have looked online and I am not finding anything helpful. That is why I am asking here. Can someone please help me to drop off the leading 1 in the string? The data comes in as "1110314" and I need it to be in the format...

Hi All, I am having trouble with formatting a field in Access. The field is called COMPLETEDATE. The data in this field has the format of "1110314" the data is of type string. How do I drop off the leading 1 in the string? :confused: What I would like to see is "110314" not "1110314" Can...

I found the answer on another forum. Here it is, I hope this helps someone: Private Sub cboYEARMONTH_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboYEARMONTH.SelectedIndexChanged If cboYEARMONTH.SelectedValue Is Nothing Then Exit Sub...

Hi Veasna, For Access 2007 standard security string: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False; If your database has a password: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Jet...

Hi Veasna, You can find the correct connection string to connect to your database at: http://www.connectionstrings.com/ They list connection strings to any database you need!:) -Diana

Hi, I am using VB 2008 Express to connect to an Access 2007 database. I have a combo box called SelectYearMonth that is populated by the database. When I used the Access report VBA, I used the AfterUpdate() event to calculate a sum. I need to know how to do the same operation in VB 2008...

OMG! I used Count and not DCount in my code! It works great as: DCount("JOBTYPE", "HBELP_FINAL_Q", "YEARMONTH = " & [SelectYearMonth] & " AND JOBTYPE = 'E'") :D

Hi Ray, I am over trying to get this thing working by groups it is just too frustrating! I have coded the individual JOBTYPE boxes, since there are only 4 JOBTYPES as: Me.ExactReprintTextbox = DSum("Pages", "HBELP_FINAL_Q", "YEARMONTH = " & [SelectYearMonth] & " AND JOBTYPE = 'E'")...

Hi Ray, I am sorry to say that I can not post a sample due to security reasons. :(

Hi Rainman, How did you know that that is exactly where I have this textbox! I thought it was suppose to work that way too! Stranger and stranger....

Hi Rainman, Yes, I have the report grouped by YEARMONTH and then by JOBTYPE.

Hi Rainman, I am getting close here, I am now trying: Me.TotalPagesTextbox = DSum("Pages", "HBELP_FINAL_Q", "YEARMONTH = " & [SelectYearMonth] & " AND JOBTYPE = '" & Me.[JOBTYPE] & "'") The result is correct for the first JOBTYPE, but it is placing the same value for the first one into all...

JOBTYPE is a text value.

Hi Trevor, I am sorry to say that there was nothing there that helped me with my problem. :( Thanks anyhow, Diana