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!

Register Log in
  • Congratulations TouchToneTommy 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: *

  • Users: Rich8541
  • Content: Threads
  • Order by date
  1. 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
  2. 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.
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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