Search results

  1. JPFred

    BIG problem!

    This issue is not programming related. My hard drive on my laptop is dying and I need to make a image (bootable) of my main Windows 10 hard drive (SSHD). I only have on hard drive slot on my computer and was thinking I could make a complete (bootable) image of the main drive along with all...
  2. JPFred

    Looking for a simple way to create a qr code and load into a database

    I am a beginner / intermediate VBA programmer and need an easy to understand a code example that will accomplish the following: The table is mytable with the following fields: texttoread (string), qrcodeadd (string? ) Read the table mytable and generate a QR code that will be stored into the...
  3. JPFred

    Need help with report (3x5) cards

    I have some card stock that has the following dimensions: w=5in. H=3in Left and right removable margins = 1.5 in There are 4 cards per page like: = = = = I have done very little with reports so could some assistance. The data being printed is a barcode with the bar code "text" information on...
  4. JPFred

    Generate list of barcodes

    Hi Access Superheros! I am looking to pick your brains again. I am looking for the code (sample) to create a report of barcodes where the user is prompted for the beginning and ending barcode number incremented by 1 when code is executed. It would look something like the following: Form...
  5. JPFred

    Barcodes

    I ordered a bar code scanner to play around with scanning barcodes into a ms access database. Does anyone have any code examples to link the scanner to the database to do immediate and/or batch scanning? I am going to take the Christmas break to see if I can make it work. Thanks in advance, Doc
  6. JPFred

    Barcode / QR scanner

    I am looking to purchase a barcode/QR scanner to work with my database. Any suggestions?
  7. JPFred

    Changing text color in vba

    This is more than likely a simple question. I have a for that loads a record from a table and displays the record for editing. What I would like to happen is to change the background and/or text in a combo box if the data coming in meets a given condition, I.E. Private Sub Form_Load()...
  8. JPFred

    Diabetes Application

    I am a Type II diabetes and am looking for a public domain diabetes Access database application. Does anyone have one or know of one I can download?
  9. JPFred

    "Id is not an index in the table"

    Has anyone ever received this error and if so how did you recover from it.:eek:
  10. JPFred

    Thanks

    I would to thank all of the brain trust that assisted me in my creation of a card catalog for my grand sons school. I still have a good bit to go but it is in placed and being used. Again, Thanks Doc
  11. JPFred

    Reading single record

    I am writing some code and need to do the following: Call up a form by clicking on the proper button from a menu I need to add this to Form_Load 1. Prompt user for search data 2. Use the entered data to find the record using the search data 3. Once found I will insert the record to a...
  12. JPFred

    Column headings in SQL

    I have written an sql query (below) and need to have a user friendly column heading displayed with each field. I a retired senior programmer analyst and have been retired for 10 years. I know there is something I have forgot to accomplish my issue. Any help will be appreciated. SELECT...
  13. JPFred

    Compare database date field to todays date

    I am trying to compare a field (datecheckedin) to today's date in an sql query. The field is defined as a short date. I thought I could use curdate() but it is not the proper way to get today's date. I know the brain trust has the answer:)
  14. JPFred

    Multi user run of a db application

    I have written an access application and would like to have accessibility to the database on a network server in a read only mode. I know how to auto-run a form but would like the main access options inhibited and allow multiple users to access the database application from laptops having...
  15. JPFred

    Bar Code input

    I am currently creating a card catalog system for a private school library and would like to add a feature to scan a bar code on a book adding the necessary data to the database. This data will be used to retrieve information from the database when the book is scanned in. It must also have the...
  16. JPFred

    OpenForm (filter name)

    I am fairly new to the macro creation utility in access and was wondering if anyone can give me a few examples with the use of "filter name". From what I can tell you can place a form or query name here to restrict record retrieval:). Thanks, Doc
  17. JPFred

    Excel macro language

    Hi gang. I have returned after a recent illness. Even though this question is not directly access related it does tie into a project I am working on. Due to limited available of the access db program I am in the process of using access to create and maintain a card catalog database. The...
  18. JPFred

    Locked forms

    Hi Gang, I am back again after a bout with pneumonia. In that time I must have made some global change that will not allow any entry from any form. Direct entry is allowed if entered directly to the database without using a form. Pretty weird huh! Doc
  19. JPFred

    Auto load a form upon access load

    Is there a way that I can have a for automatically load when access is opened? i.e. Library.accdb (form name) sort cut from desktop?
  20. JPFred

    DoCmd.RunSQL (what am I missing?)

    I am attempting to run an SQL statement from code when a check box is clicked on. I build the statement (seen below) and try to execute it using the DoCmd.RunSQL function. When I execute the code I a 2342 run time error. If I use the the DoCmd.OpenQuery function passing the name of a query...
Top Bottom