Search results

First of all, I just want to make sure...it's *not* possible to simply copy and paste a report or parts of a report into, say, Lotus Notes (unless you want to do a screen print), right? Assuming that it's not possible to do that, I am wondering if there is a better way of exporting a report to...

Is it possible to sort a report on part of a field, such as the last three numbers of a medical record #? Can I enter some sort of expression in the sorting and grouping dialog box that will do this? TIA

This is stumping me, although it must be something obvious. I have an unbound form with a text box for users to enter a date. I want to take that date and generate an SQL statement that will open up my main form showing entries with the specified date. Here is what I have, but it will not...

Originally, I had wanted to have a form with a subform that showed letters received on a particular patient. I set it up that way, but then my boss decided that she wanted the ability to search on fields that were in the subform, and I was unable to figure out a way to do that. Then I was...

I don't know if this is possible, but... I have a main form with a subform. I would like to build a search form that allows users to base their search on many criteria. I know how to do this for the main form, but I don't know how to find a record if the criteria is a field on the subform...

I have a report that prints fine when there is data. However, when there is no data, I get an error msg and the report doesn't run. I think this is because of some code that I put in the Format event of the detail section to remove labels on fields where there was no data. For example: If...

I have a report that I export to excel by using: DoCmd.OutputTo acOutputReport, "rptletterdate", acFormatXLS, "H:\Excel\GovernmentManagedCare\rptletterdate.xls", True This works fine, but every time I export the file, I get a msgbox in Excel that tells me "File error. Some number formats may...

This seems like it should be simple, but...(hmm, I seem to preface most of my posts like this!)I can't figure out a way to generate a record count at the bottom of my report. I have tried putting =count(*) and all sorts of variations in the report footer, but then I get a "# error" at the...

Not sure if I'm using the correct terminology here...Basically, I am using a search form to build an SQL statement "on the fly". The resulting statement is a variable named Mysql. What I have discovered (by using the debug window) is that if I put in lots of different criteria in my search...

I would like to use an unbound form so that users can specify various criteria for a report. Then I would like the users to be able to click on a button and open up the report with their data. The problem is that I can get the report to filter on *some* of the criteria, but not on others...

There are certain fields on one of my forms where I had to set up a manual tab order (because the fields are on different tabs and sections of the form, I couldn't just drag and drop using Tab Order). I did this like this: Private Sub cboCMstatus2_LostFocus() Me.cboCMaction.GotFocus End Sub...

I am writing a query where I would like to group certain lab tests by month, so I am trying to separate out the individual months from the date field. I have tried to use DatePart but I cannot get it to work...I created a new field with the expression DatePart("m",[Date_of_Service]), but when I...

This seems like it should be so easy, but I can't get it to work! I know that it is not good practice to use the same bit of code over and over in a form, and that I should instead write a function and call it. I want every field in a form to be capitalized. I have been using...

I have a field in one of my forms where users will be entering hyperlinks. Is there any way to have a command button on the form that will allow users to browse for files (like the insert hyperlink button on the toolbar)? I would like users to be able to scan certain documents in to a specific...

I have been reading postings on this board and have read the MS article on querydef and yet I am still confused... Basically, I am trying to have one form where users can enter up to 5 criteria for a search, and then I want the results displayed on another form. I tried copying and pasting...

I am making a search form that has five (unbound) fields. I want users to be able to search on either single or multiple fields. I am able to get this to work with one field using a query that pulls criteria from the unbound combobox. But when I try to specify multiple criteria, or even single...

I think this should be possible, just not sure where to put the code...I have a form with five tabs. For most records, only one or two of the tabs are filled in. Is there a way to make only the tabs that have information on them visible? Would I check a key field on each tab to see if it's...

I have a form that users search using Filter By Form. Some of the users, however, get confused trying to figure out when the filter is on and when it is not. So my idea was to have a little label pop up when the form was being filtered. After searching and searching, I finally found this bit...

I *think* this is possible, I just can't quite figure out how it should be done and where the coding should be put... I have a form that users search via filter by form. In fact, the form opens in Filter by Form view. Don't ask me how, but users often get confused about whether they are in...

I have a field on a form that I don't want users to leave blank. So in the On Click property of the exit button on that form, I put in If IsNull(Me![Combo20]) Or Len(Combo20) = 0 Then MsgBox "You must enter a payor!" Else: DoCmd.Close End If This works fine under most circumstances. But if...