Recent content by bradlannon

  1. B

    How to Create new records based on old records...

    Hi All, I am slightly new to VB and I am having difficulty on creating a duplicate record and adding as a new record on same table. Here is what i'm looking for as I cannot wrap my head around how to do this. I have a database with a dozen tables (ie. tblPage1, tblPage2, tblPage3, ...
  2. B

    Access not showing all records in table...

    Hi, I have a little issue that I cannot figure out! I have an application with a MS Access front end/back end. The problem is on a particular form frmEmployeeSpecificJob it only displayed 6 employee names in txtname field. There are in fact 12+ records in employees table...and this txtname...
  3. B

    Wow...thank you for your help! You totally saved me on that one...It's been a few years since I...

    Wow...thank you for your help! You totally saved me on that one...It's been a few years since I did vb and now I just started working with a new company. I really appreciate the help! Take Care!
  4. B

    Using Access Forms, populating all records in textbox...

    Hi, I've decided to go another route with this. As you can see from my attached timeclock.mdb, I am working on form frmEmployeeSpecificJob. Basically what I'm trying to do is first load txtname (through access forms control source....not in vb code). When a particular record (in forms 'txtname'...
  5. B

    Using Access Forms, populating all records in textbox...

    I have the report set up, I am fairly confident that everything is ok with that. Actually my problem originates before I even have the chance to click on the cmdReport button. Here is what I've noticed... When I put a MsgBox myRecordSetDesc.RecordCount it always returns a -1 for some reason...
  6. B

    Using Access Forms, populating all records in textbox...

    Hi...sorry for the confusion. Basically what I have is 3 tables (Employees, HoursEntry, Jobs) and I am trying to pull a report (by clicking on CmdReport button) based on Jobs.Desc and Employee.name that are populated on the form. (I am using Access Forms as front end and it automatically...
  7. B

    Using Access Forms, populating all records in textbox...

    Hi, I am wondering if someone wouldn't mind taking a look at this code. I'm new to Access and VB and I cannot seem to populate my txtboxes with my table data. It only seems to load 1 record, when I click next, nothing happens. Please note: lblmax.Caption = myRecordSet.MaxRecords pulls back...
Back
Top Bottom