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 Chriss Miller 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: southboy
  • Content: Threads
  • Order by date
  1. southboy

    Find Record and fill form

    I have a form I use to pay monthly bills. I had a findrecord combo box and a find next record button that worked before MS Access 2007. After I selected the bill I wanted to look at it would fill the form fields with that record and I could edit it. After I converted the DB to 2007 now I get...
  2. southboy

    More than one instance open on same Database

    I have a database I use. If the database is open and the shortcut icon is clicked again, another instance of the same database is open, so now you have two instances of the same database open. If you enter information in one, it is not reflected in the other until it is closed and reopened...
  3. southboy

    Rename Userid

    I have a database that has tables based on the Windows userid of the person who opened the database. When opened a form opens that the user inputs work information for their job. The form is linked to each of their personal userid tables. The windows userid's where based on the first initial...
  4. southboy

    Last Date entered

    I have a bills database and I need to find the last date paid for each bill in the bills table so I can start weeding out bills I don't pay on anymore. I'm tring to do this in a query but can't seen to get it. I've tried using the MAX, DMAX, DMIN, datediff and between dates to not avail. Any...
  5. southboy

    Birthdate Expression in query

    Hey Everyone! I have a birthdate database for work and had to convert it to 2003 access. It tells me how old a person is based on this query expression - Age: DateDiff("d",[birthdate],Now())+1 This worked great in Access 97 but in 2003 now anyone born after 07/01/1977 it comes up as a year...
  6. southboy

    Report Print Error using 2000 Runtime

    Our company installed all new computers which now uses the XP Operating System. All our in-house databases were created in Access 97 before the new computers, and now have to all be converted to Access 2003 using the Access 2000 format. Our Staff uses Access 2000 runtime to be able to access...
  7. southboy

    Text Box not reflecting Label.caption

    I have a text box that shows the forms list box record count using this code in the text box control source. =Count(*) & " " & "Total Records" and the text box shows "76 Total Records" I also have a label box at the top of the form telling you the name of the current table you are looking at...
  8. southboy

    Changing a sorted Combo box value to be the first value

    Hello, I'm new to the Microsoft Access forum and I have a problem I could use some help on. It is probably a simple solution but I can't seem to get it. I have searched through out the forum with no luck. I have a combo box that list record names and when you click on that record name...

Part and Inventory Search

Back
Top