Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Rich8541

    Recordset .BOF returns false

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

    Recordset .BOF returns false

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

    Recordset .BOF returns false

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

    Recordset .BOF returns false

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

    function call starting point

    Great Info, Thanks. I'm trying the MZ-Tools right now. Regards, Jim G.
  6. Rich8541

    function call starting point

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

    Difference between Format and VBA.format Access 2010

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

    How do I get more than one field value from a query in vba?

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

    How do I get more than one field value from a query in vba?

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

    Tab Control

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

    open form at top

    Yes, exactly right Aceman. You're fix worked perfectly. Thank You.
  12. Rich8541

    open form at top

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

    Listbox formatting

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

    listbox data (phone number) formatting

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

Part and Inventory Search

Back
Top