I made a calculator that helps calculate the dose and the amount of drug needed for a patient in the operating room. To understand the problem please open the...
Hi, I would like to let anyone have a look at photos we have in an Access base. How to let them come and seek and see and perhaps also download a photo of...
Hi All, I've a hobby table with child id and hobby. I want to concatenate the hobbies for the same child in a report like Arnold's hobbies are playing soccer,...
I am trying to eliminate warning/confirmation messages that appear during a lengthy macro. In previous versions of Access, this could be done by using and...
I am trying to set up some tables in Acess to do the following: The scenario is this: A person visits the hospital. On the first visit they are assigned a...
Sounds like you need to use a sub-form. Basically, you create 2 tables. 1 table with the patient info: a unique identifier, name, birthdate, address, phone,...
' So busy today but just for you to start, you need the following main tables: ' tblPatient - will handle the patient information ' tblVisits - will handle...
Hi everyone -- I've enjoyed being a member of this group for several years but I've never posted much. I am trying to run several "make table" queries on a...
Hello, I am using the following vba code, on a form button, to print a report. DoCmd.OpenReport stDocName, acPreview, , , acHidden This code works fine in...
Ok, I'll try this again and maybe it will make more sense. :-) I have a table: mytable Two columns: [Product] and [RepName] There are 350 individual...
I have a field in a form that rounds up currency to the next whole dollar. I don't know what I did to make it do that but I need it to reflect what I enter...
Ok, I guess the secret to this user group is that if you look around the web long enough you'll eventually find the answer to any Access question you have....
I believe acHidden is not used in Access 2000. Basically you can just re-write the code by creating a new button on the form and then chosing print report on...
That was exactly what I thought, but when I do that it doesn't change the value showing in the field, it still rounds it up. I must be approaching this wrong,...
Check your tables format for that field rather the the form's format for that field??? ________________________________ From: ms_access@yahoogroups.com...
can this group help out the gent below? I will forward your reply to the group to him his field name is [status] and it has listed as values in it either a C,...
If I understand the problem correctly, just set the property of the textbox on the report to be =dcount("status","my source query or table name","status = 'R'...
I will forward to him to see if that works for him...my thanks for the very quick reply! There are mutliple values that he would like to sum from that same...
To do that using the formula I provided, you'd either need to put it different text boxes (which can be stacked in the same column on the detail band) or you'd...
great...we'll give them all a try....thank you for your help today! Dave ________________________________ From: ms_access@yahoogroups.com on behalf of Peter...
dears, can you any body help me to make a query from one table and in this query i want to disply the datas in an special sorting order. thanks and regards ...
In the query grid (design view) there is a line for sorting. Here you choose ascending or descending for the fields you want to sort on. May God bless you...
thank you for yor reply, i want to sort in a complex way other than the ascending or descending availble in designing view pls help me to solve this matter. ...
Muhamed You need to explain how your data is arranged and how you want it to be sorted and we may be able to help you achieve that if it is possible. Regards ...
dear tumbulu , in my query i have text string line no (for eg line no:1,line no:2,....line no:10) and carsponding data like qty produced and damaged etc. and...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
