Thanks PHV,
I got it to work, although not pretty it does the job. I borrowed some code called DeltaDays but can't remember where I got it from.
' Procedure : GetSixtyDayCount
' Author : Jim
' Date : 10/23/2013
' Purpose : Determines the number of days working by getting the Start and...
When I reach the end of the recordset using (MoveNext to step through the records) even though I use code to check for the end of the file (which returns false), I get a No Current Record" error.
If rs_SixtyDayList.EOF = False Then
rs_SixtyDayList.MoveNext...
Thanks for the reply. I tried MovePrevious, but I get a No Current Record error when I check the value of the record. When I use MoveFirst, then check the value of the recordset, I'm actually on the first record. I'm trying to loop through the records(which are dates)and compare each record to a...
Hello, I'm trying to test for BOF using a movelast then movefirst, but when I test for BOF, it returns false. Shouldn't a movefirst take me to the BOF of the recordset?
Thanks, Rich
Hello, is there a way to determine where a function is being called from, that is, the calling procedure. I know I could do a search for the function name but I was looking for a better way.
Regards, Jim G.
Hello, What's the difference between VBA.format and just Format in Access VBA. I'm opening some 2007 version db's in 2010 and I get an undefined function error, so I preceded the format and date built-in functions with VBA and they worked. I remember having this problem in 2003 and the quick fix...
OK, thanks. I'm trying this but it returns the same value of 80 for each variable and 80 is also the Contractor ID I'm using to identify the record.
Public Sub Calc_Pay()
Dim rst As DAO.Recordset, strSQL As String
' Dim strPath As String
Dim ST As Integer
Dim OT As Integer...
Hello, I have a query that I want run from vba using the sql code. The query has 11 fields. For example, for contractor = 80 i want to get the ST, OT and DT and fill 3 variables in my code. I know how to set SQL result equal to one variable in my code but how do I extract values for 3 variables...
Hello, I'm using access 2003. I added a tab control to an existing db I use for tracking contractors and work hours, benefits, etc. I added the tab to an existing form, cut and pasted the existing controls so they were where I needed them but they didn't work. I had to reset the event procedures...
hello, I have a main form with a tab control(big, it takes up the whole form so I can have tabs across the top) on it and another form on page one of the tab control.When i open the main form the tabs of the page control are not seen. I have to scroll up to make them visible. How can I open the...
Hi, I have a listbox that is based on a query to return contractor info. Just one record based on a selection from a combo box. One of the fields is the phone number. In the query it is formatted to show dashes between the numbers such as 609-111-2222. But in my listbox the numbers have no...
Hi, I have a listbox that is based on a query to return contractor info. Just one record based on a selection from a combo box. One of the fields is the phone number. In the query it is formatted to show dashes between the numbers such as 609-111-2222. But in my listbox the numbers have no...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.