Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2006
    Posts
    1

    Newbie question

    Hello everyone. I'm not a programmer, but my employer has assigned me the task of overseeing the 'IT' issues in our department. I work in healthcare industry, and our department uses a Microsoft Access program to track regular staffing assignments.



    The previous employee who actually wrote the code for the program was demoted, disgruntled then quit. He left without orienting anyone to the program/code. I know that he had no programming experience prior to developing this code. He learned it all from a book he bought. I thought it might have been one of the 'For Dummies' books, but after reviewing one, I get the impression that he probably used one that was a little more in depth, and that started with the very basics (where to start a program from scratch).

    To make a long story short, I need to fix the code in this program as the program is no longer working correctly. The program inputs data such as employee name, shift worked, area assigned, supervisor's name, then all the different patients are scanned into the program using a scanner (laser).

    Initially, the first problem was the data entry fields for the patients. Normally, after a patient's barcode was scanned, the field would automatically tab to the next field, but now the we have to tab manually (which is a huge pain).

    The current problem I'm having now is the program will not even open, almost as if it has been deleted. I have tried to find the data base to save it so I can reload the program completely, but I can't even find the data base.

    My main question is this: Is there a resource (online or book) that a newbie can use to learn the basics. Where to find the data base, what program is used to open and view the code, and possibly how to correct the code would be very much appreciated.

    Any input you have on any of these issues would be greatly appreciated.

    Frank

  2. #2
    Join Date
    May 2007
    Posts
    2

    possible solution

    My main question is this: Is there a resource (online or book) that a newbie can use to learn the basics.

    do a search for Ms Access in http://knowfree.net

    Where to find the data base, what program is used to open and view the code,

    do a search in windonws with *.mdb and Search entire disks as criteria.
    to view the code, use the Visual Basic editor

    and possibly how to correct the code would be very much appreciated.
    Learn programming!

    cheers........

  3. #3
    RAPSR is offline Novice
    Windows Vista Access 2000
    Join Date
    Dec 2007
    Location
    El Paso, Texas
    Posts
    6
    I use a scanner in my everyday work! Scanners usually can be programmed to either enter the bar code without an enter character or the can be programmed to enter the bar code with the enter (return) character. Usually codes are included with the operation manual for the scanner that does this automatically.

    Check your scanner manual for these options.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. newbie questions
    By bigmac in forum Access
    Replies: 0
    Last Post: 10-07-2008, 12:53 AM
  2. newbie needs design help
    By ashiers in forum Database Design
    Replies: 0
    Last Post: 09-13-2008, 07:05 PM
  3. An oldie but newbie
    By GTodd in forum Access
    Replies: 1
    Last Post: 06-25-2008, 08:15 AM
  4. Newbie question
    By benplace in forum Queries
    Replies: 1
    Last Post: 12-13-2005, 06:40 PM
  5. Newbie filter question
    By benplace in forum Access
    Replies: 1
    Last Post: 12-03-2005, 08:31 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums