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...

AvGuy Sorry, but your suggestion is way over my head. Isn't there a simple way to get back my default toolbars and menus after removing them from the db? camelk

FancyPraire: I opened my db and right clicked on what was left of my menu and tool bar but nothing happened. Do you have any other suggestions. Thanks Camelk

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?

Thanks for your help. camelk

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...

Laois: Thanks for the info. camelk

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...

Terry: It's a very long query (25 flds). I'll just keep playing aroung with it. Thanks for your help. camelk

Terry, I'm still getting the #ERROR msg. Any idea why? camelk

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

Thanks. I used Rod's code and it worked well. 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 entered the On Activate code for frmA but the results were less than satisfactory....the combo box got updated, but when I selected the new name in the combo box on frmA (remember I entered the new name and other info about the person on frmB) the rest of the text boxes on the frmA were not...

Ex-JimAtTheFAA And just how but how do I issue a requery on the combo box in frmA before I close frmB???? I'm really new at all this and need explicit instructions. Thanks

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...