Search results for query: *

Hi. Table that assigns a descriptive value for each day for each staff member Important Fields: ClinicDate, Staff, Description I need to create a module that will create new records and populate them with consecutive dates for each staff, then look up the corresponding value in a separate...

Dear All I have a large from that contains several subforms and listboxes. The subforms are linked to the main form (Master-child link). The purpose of the form is to display various data when the user logs on. Everything works well except that every time a command is run, all the subforms get...

I have a continuous form that is based on a filtered table. Each record in the form contains a check box that is bound to a field in the table. I would like to have an unbound checkbox in the header of the form. When I check the header checkbox, I want the checkboxes in all the records of the...

Dear All I have a main form that contains several subforms and command buttons. The command buttons open other forms. It is becoming busy and cluttered and I would like to clean it up. My idea is to create several unbound ComboBoxes and line them up in the Header, and on the AfterUpdate...

Hi I have an unbound form that contains two unbound controls, DateFrom and DateTo. The idea is to select two dates. I was wondering if there is a way and I can have a command button called cmdWeek. When the user clicks it, the two controls will be populated automatically with the dates...

Hi I am using MS Access 2007. I have a memo field with property set to rich text format. I use code to compile data from several tables to populate the memo field. I wonder if there is a way to apply rich text formatting on specific parts of the memo field using code. For example: make a title...

Hi I have a database that I need to split into a backend to be housed in a server and frontend to be housed on several network computers. I have two questions, since I have never done that before: 1. Do all the frontend databases have to be similar, or can I have a different versions on...

Hi I tried to fined an answer in the previous posts but couldn't Hope somebody can help. The database is a comprehensive medical records database for a medical office and I need to create a form for the secretaries to schedule appointments for patients. The appointments are scheduled in a table...

Hi, anybody has experience with the Active X control Adobe pdf Viewer in Access 2007. I can't figure it out. Any other ideas to insert an image viewer in a form for pdf or other file formats linked to the table as OLE objects?. Thanks.

Hi all, This is for a medical database. I have a table called Medications that includes five fields indicating the amount of pills to be taken (Mor, Noon, AfN, Eve, HS). All five fields are Double. I need to print out a prescription for selected medications, but I would like to change the...

Dear all, I am creating a database for a medical practice. There are three locations from which a medical test can be ordered: Hospital, Office and Phone conversation. Each of those locations represents an encounter with the patient and has a table: Hospital: VEEG VEEGID...

I am using the MS Date and Time picker to fill the time in a control. However, I don't need the date, all I need is the time. Is there any way I can do that. Or, are there other ways to pick time. Control name: SzTime date and time picker: SzTimePicker This is the code I am using...

This is probably very easy, but I don't know how to do it. I have a multiselect list box on a form with a visible property set to False. There is a command button that sets the visible property to True. Is there any way I can make sure that every time the listbox appears (becomes visible)...

I have a form with multiple fields. It is a continous form, allowing entry of more than one record for the same person. I have a memo field (Summary) in the form footer that combines all the fields. I concatenated all the fields in the summary field. I would like the summary field to combine...

Hi All, I have a form with two dates, AdmissionDate and DischargeDate. I have a field for number of days. How can I make the field can filled automatically based on the the admission and discharge dates? I tried this code for DischargeDate_afterUpdate: Days = DiscahrgeDate - AdimssionDate...

Hi all, I would like to add a new field to a pre-existing table. How can I also add the new field to the corresponding form without having to re-create the form? Thanks. Georges Ghacibeh

Hi all, I would like to have a calender popup when I want to enter a date on a form, so I can click on the month and day instead of typing them in. Can I do that? Thanks. Georges Ghacibeh

Hi all, Can you base a single report on multiple tables and/or queries, whithout combining everything in a single query?Can you divide the Detail of a report into multiple sections, each based on a different table?

Hi All, I have two controls side by side on a report. There is usually a space between them because the size of the content can vary. I want the one to the right to appear on the report immediately next to the one on the left. I need to move the right field to be next the left, based on the...