Search results

  1. kbrooks

    One user unable to access db....

    She has read/write/modify....same as everyone else that can access it. This is driving me mad! I removed her and added her again as a desperate attempt.....maybe that will work. (I'm not very hopeful!)
  2. kbrooks

    One user unable to access db....

    This may or may not be an Access problem, I can't figure it out. I have a small database set up for only 4 or 5 users. I didn't mess with front end/back end because the main function for this db is to alert me of charge corrections I need to make in our system.....before I was getting many...
  3. kbrooks

    How did you learn/what direction should I take?

    Kind of an off-topic question here. I'm wondering, purely out of curiousity, how many self-taught Access users we have here. I am one of them.....I know much more than what I started, but know MUCH less than most of the regulars here. Also, being self taught, where should I go to learn...
  4. kbrooks

    Calculate Age Function

    I am by far not an expert, but I'm going to take a stab at the first question. Instead of a check box for the deceased field, can you have a deceased date? Then you can calculate deceased date - date of birth, and if the deceased date is blank...calculate age by today's date - date of birth...
  5. kbrooks

    Don't save record when fields are empty?

    I'm sure this is simple but I can't get it to work. I have a table called Charges where the user inputs data into 5 fields via a form. The form is in tabular view, where each line is a new record. The problem is that they get overzealous when tabbing from field to field, and start a new...
  6. kbrooks

    Hours worked question

    I believe holiday = vacation in this case.
  7. kbrooks

    When starting access, open form 'main menu' ?

    Go to Tools and then Startup, and enter your form name in the space for Display Form/Page. (You can also select to have the database window not open here.....you'd press F11 once the db is open to open the database window if needed) To maximize it, if it's a form I just make a "Maximize" macro...
  8. kbrooks

    When starting access, open form 'main menu' ?

    Go to Tools and then Startup, and enter your form name in the space for Display Form/Page. (You can also select to have the database window not open here.....you'd press F11 once the db is open to open the database window if needed) To maximize it, if it's a form I just make a "Maximize" macro...
  9. kbrooks

    Open in Shared/Exclusive question

    I just read a post recently about going into Tools/Options/Advanced and making sure the db was set to open as shared. It was NOT, so I set it to shared. My (dumb) question is this....do I have to go to each individual user's computer, open the db, and set it to shared? The reason I...
  10. kbrooks

    Is it ever too late to split database?

    I have set up many small databases for various users, and have only recently been reading about splitting into front end/back end. Most of these databases have been in use for quite a while....is it too late to split them? I also have many many questions about splitting databases, and Access...
  11. kbrooks

    Autonumber from 2 separate ranges?

    Well we don't so much 'reconcile' data as we do input it into the main system once it's back up. Previously, we printed a report of all patients registered in this "downtime" database. We then went into our main patient accounting system and registered each patient there, making sure to assign...
  12. kbrooks

    Autonumber from 2 separate ranges?

    I am going to set up a database (for the 2nd time--first time was really messy and ugly) that will be used to register patients when our primary computer system is down. Doesn't happen a lot but when it does, it's for extended periods. Patients need to be assigned an account number from 1 of 2...
  13. kbrooks

    Launch form at load database?

    Tools / Startup then add the correct form in the "Display Form/Page" field.
  14. kbrooks

    Is Access the right tool to use?

    Our company wants to add the kitchen menu to our intranet site. Currently the dietary team leader handwrites the menu and makes copies for various departments. I asked her if she would mind typing it out so it can go directly on the intranet without a 2nd party having to type it up from her...
  15. kbrooks

    Printing labels question

    Hey, that's pretty slick...thanks! One question (for now, anyway) for you...how do I change the layout of the labels? I've read the readme file but don't see any reference to that and I can't tell by looking how you have it set up. Also (I guess that's 2 questions) I see on your test...
  16. kbrooks

    Printing labels question

    I have a very simple database set up with only 3 fields....Item#, Description, and PatCom#. I set up a report from an enquiry...they enter the Item # and each 3 fields display numerous times so that they print out on a sheet of labels. Works great. Now the problem. They don't always want a...
  17. kbrooks

    Change field when a report is generated?

    I have a database that another department enters charges they want me to add and/or remove from patient accounts. I go in periodically and display a report (based on an enquiry) of corrections that need made. Once I've made them, I go back to the form where they enter the information, and...
  18. kbrooks

    Send an email when new records added?

    We have a form on our intranet page (created with Front Page) that sends all records to an Access database. We go into Access daily and look for new workorders that have been submitted. My question is, can we be notified by an email when new record is added? I played with the SendObject...
  19. kbrooks

    Button staying pushed in???

    Well, see, I KNEW it would be simple!! :) Thank you very much!
  20. kbrooks

    Button staying pushed in???

    Instead of using the switchboard I'm setting up a form to use so I can have a little more control. The problem I'm having is probably pretty simple but I can't figure it out. The toggle buttons I've created work great, but they STAY looking pushed in. They still work like this but I wish when...
Back
Top Bottom