newbie needing help

[rsvrobin]

I am new to access and was guided to use forms on my first inquiry for what i am trying to do. This is what i need:

To order medications, I have used a combo box on each of the fields to choose: the name of the medication, the dose, the frequency.... I put command buttons on my form but when I click on the command button, it gives me an error and doesn't do anything. I want to go to a ?new record? (another order is what I want). When the orders are complete, I need to print what I have ordered. I used the command button for print form and got an error as well, does anyone have any advice? Can I print from the form or do i need to send as a report????

Any advice appreciated.!

 

[spacepro]

First of all what is the error message when you click on the command button??

And as far as your orders go, if you have a lot of orders then you will need to create a query with the required fields using criteria to only select the records you have entered that day, then base the report on the query.

You can print the current record from the form and their are several ways to do this, do a search on the forum for "print current record" this will help you as I personally have replied on this subject recently.

If you are unsure post back.

HTH Andy

 

[rsvrobin]

Unsure is my middle name, but I will tackle anything!

When I try to print with a command button:

The expression On Click you entered as the event property setting produced the following error: Ambiguous name detected: Print_Orders_Click.

When I try to go to a new record this also occurs. At the bottom of the form is "Record" 1 in the window, but when I complete the order, it will not allow me to advance to a new record.

I will only be ordering 3 or 4 drugs and would like to be able to print from the form if possible.


Thanks, Robin.

 

[spacepro]

The best thing to do is delete the command buttons, and start again using the command wizard for the add record and print form.

When you select printform this will only print an image of the form with the selected record, if you want to create a custom form then I can point you in the right direction.

Or post a db if you don't want to delete the current buttons, and I will have a look at it.

Andy

 

[rsvrobin]

Andy:

I don't have a problem removing the buttons, but am glad to post the info. I used the wizard to set up the buttons but I am pretty access illiterate but anxious to learn.

 

[spacepro]

I do appreciate your comments. We all need to learn, I just offered it as a safety net, just incase you didn't want to do something you weren't sure about.

Let me know how you get on, if you do come across any more problems, I am very willing to help.

Good Luck
Andy

BTW..If you haven't fixed the buttons, post the db I will have a look.

 

[rsvrobin]

Okay, I'll give it another try because I "thought" the db was attached. Let me try it again. I am attaching it in the "attachment" box using browse to find it in my files. If it doesn't attach this time, any idea what i'm doing wrong there too?

Thanks, Robin.

 

[spacepro]

Hi Robin,
Maybe the db is too big to post. Can you email to me or put it on the internet at my site:

Follow the link and enter the username = access pass = guest then select upload file and when complete please log out.

Click Here

Andy

 

[rsvrobin]

Andy, Thanks for offer, I will try from work tomorrow or Thursday!

Robin.

 

[rsvrobin]

Andy, I can't get logged in. It requires a password and if i use guest as the password it still doesn't let me in. (I really do know how to use a computer though!!) Robin

 

[spacepro]

try putting the username and password in lower case.

Andy

 

[rsvrobin]

Okay, I have to tell on myself. It suddenly dawned on me that "access pass" was not the user name and pass stood for password! Okay, maybe I'm not as computer literate as i need to be. I will 'attempt' to send tomorrow from work. Thanks for your patience. Robin.

 

[spacepro]

Robin,
I have sent you an email with the details.

If you haven't seen it then just follow the link:

db

HTH Andy

 

[rsvrobin]

Andy-thanks, I will look at it at work tomorrow! Can't wait to "see what I've done" Robin

 

[rsvrobin]

Andy you're great! This will work wonderfully. Just a couple of questions.

Is there a way to put in several orders and have them print at the same time on the same page instead of putting in today's date under "medication orders" or printing separate pages for each order? I also want 2 copies when it prints (i probably could figure out this one).
I plan to put in orders and really don't want to save them, they can be deleted so I can enter for the next patient because I will print them out as an order to sign.

Also, even when i delete the data the next record becomes the next number instead of starting over with 1, is that a problem?

And, is there a keyboard shortcut to entering today's date when that pops up? (pretty lazy aren't i)

You have done a wonderful job and i really appreciate all the help you've given me. Any recommendations on learning how to become proficient. I can see i fall far below what i need to know.

Thanks again, very much!!! Robin.

 

[spacepro]

Robin,
A Few answers for you:

Is there a way to put in several orders and have them print at the same time on the same page

A - If you open the query (allrecordsby date) in design view and in the criteria for the date entered is says [Enter Date]. Delete this remark in the criteria, then on the menu select query>parameters and select the entry Enter date and delete the text then click ok, then save the query. This will show the records without having to enter the date. This is based on you deleting the records you have entered.

To be quite honest with you it is a waste to enter all these details into access and not save the records, especially when access is an excellent platform. Thus this would give you traceability on all orders placed, so if their was a query in the future, then you could report instantly on such a query.

Also, even when i delete the data the next record becomes the next number instead of starting over with 1

A - No it's not a problem, this is just a unique identifier for that particular order.

I also want 2 copies

A - Do a search of the forum, this has come up several times before.


The best advice I can give you is to buy a good access book , which will explain the basics and just search the forum on the subject you are not very good at and just study the replies and in no time at all it will come to you.
You need to understand that access is a very complex platform sometimes, depending on what you are doing and you experience.
Just be patience and it will come to you in time.
I am glad to have helped, if you have any more questions then just post them and I am sure the forum and myself will guide you in the right direction.

BTW, if you want to delete the records once you have entered then you can create a delete query or you can manually delete them if you like, but creating a delete query is the better option.

HTH
Andy

 

[rsvrobin]

I'll give all the above a try. Thanks again, Robin.

 

[rsvrobin]

Andy You have some very good recommendations. I think I might like to save the information. Is there a way to have a button to print current order(s) (may be multiple orders) and then a button to print new patient that would close the current record, save it and start a new record for a new patient to order/print on?

I could do a query on types of medications for diagnosis on a study this way. Right now I am not interfaced with the front office, but we plan to do that in the future and I could add the patients name by interfacing with them.

Everything else works great, and again thanks. I am off to Georgia for a meeting but will check back on Friday. Have a good week. Robin.