Search results for query: *

My report comes from a parameter query that accesses several records. However, I want only one record per report. How do I do this without writing code? I thought there was something in the properties list.

I have a table that stores patient progress reports. The Composite key is Patient Number (PtNo) and Date of Progress Report(DatePR). I have a query that accesses the records from the table. But....I want the query to access only the most recent record for each patient number. How do I write...

I have a table that stores patient progress reports. The Composite key is Patient Number and Date of Progress Report. I have a query that accesses the records from the table. But....I want to access only the most recent record for any given patient number. How do I write a criteria that will...

When I finished by db I went to startup and took off all the toolbars. Now I need them back to so that I can continue to work on the db. How do I find/access them?

I have a problem with radio buttons showing-up correctly in a screen report. The form uses 2 radio buttons to input data into a table. (one button for M.D., the other for D.O.) The fld in the table that supports this is "Title". The data is entered into the table as 1 for M.D., and...

I have 2 strange phenomenon happening with margins and layouts on some of my forms and report. (1) I set the margins via File...Page Setup. Save the new margins and layout. Everything looks fine. Close the db, open it again and the margin settings and new layout are back to the defaut...

I need help writing an 'IIF' query. The field in my table is 'Title' and the person receives a '1' if an M.D. or '2' if a D.O. When I query the table, I want 'M.D' and 'D.O.' to show-up in the query, not '1' and '2'. I wrote: Title: IIf([tblPhy]![PhyTitle]=1," M.D.",&quot...

In the header of the report, I want to put a text box that shows "year to date" (i.e., 01/01/02 thru 04/15/02). How do I do this? Thanks camelk

I have a query in which I want to retrieve all the records from the beginning of the year to date (i.e., all the records from 01/01/02 thru 04/11/02). But, I want the query to be able to do this in forth coming years (i.e., on 03/03/03 retrieve all the records from 01/01/03 thru 03/03/03. How...

I know so little about VB and need help developing an ActiveX control. Where can I go to get help with code? I need to develop an ActiveX control that will allow a user to enter a name and password so that they can log on to a database and access information. The ActiveX control needs to...

I need help w/'refresh' and/or 'requery'on a form. I have frmA that has a combo box on it. This combo box allows the user to select a person's name. Making a selection in the combo box then populates the rest of text boxes on the form. If the name you want is not in the combo box, you then...

I have 2 flds: StartTime and EndTime (both formatted as short). I calculated the total number of hours worked by finding the difference between the StartTime and EndTime (no problem works fine). Now I need to add-up all the hours and minutes for a particular individual I wrote a query that...

I need help calculating the amount of time in hours and minutes that has passed between a start time and end time. The time is formatted as 'short time'. My calculation is Tot: Sum(Int(DateDiff("h",[StartTime],[EndTime]))). This gives me the number of hours that have passed but not...