Search results

Thanks a lot that did the trick.

Good morning, I have a cmdButton and it is supposed to open a report on the current user being displayed in the form. Instead, I get an error, Data type mismatch in criteria expression. Here is the procedure: Private Sub Preview_Click() On Error GoTo Err_Preview_Click Dim stDocName As...

Thanks, I got that working, but what did you do to it to get it to work? Also one small favor, could you look at that table, tblReportData, is there anything I can do to make that date behave better? If you go to change it it reverses back to "2008-08-07" till you take focus off of it. Being...

Sorry about that.

Here it is, two sample tables and two forms and there is no query. The reports are similar. Thanks.

I have tried a few things to export and/or copy the report out of the dbase, but so far nothing. I can do the entire dbase but that is about it. If you can tell me how, it will be on its way. Thanks.

Thanks for the response khawar. That is exactly what i did do and the grand total or report footer is twice what it should be, with 2 doctors or sections. It added both the section totals and the individual line counts together. At this point, the only thing I can think of doing is deleting...

I am beginning to wonder if Access can total in the section footer and the report footer, can this be done? Or does it have to be one or the other. Thanks.:confused:

thanks again for the response. I tried to dim response and that worked, but I should not of had to because it is a VB known variable and I have not had to do that in the other dbases where this was used.

Thank you for the response. Same thing, Compile Error, "Variable Not Defined". I have used this several times and no problems, even in the OnOpen, where it has worked very well, till now. For some reason, it suddenly does not know what response is. Oh I did check to make sure the same...

good afternoon, I have a report which has several section and each section has a list of records with their line counts and the line counts are totaled for each doctor, doctor footer. There are several doctors and so there are several section totals. At the bottom of report, report footer, I was...

Good afternoon, I have a form and in the OnOpen I have a procedure which I have used several times in the past, so I tried to modify this form and suddenly I am getting a Not Defined Compile Error with Response hi-lited. Here is the code: Private Sub Form_Open(Cancel As Integer) Dim...

Thanks for the response. I added a new line, DoCmd.GoToRecord , , acFirst and now it works great.

Good morning, I have a form and on the form I have a cmdButton for deleting reports that have been entered, but it is not functioning correctly. Along with delete the report, especially the last report, it creates a new record as well. Here is the code for the cmdButton: Private Sub...

Tahnks, that did the trick.

Good morning, I have a report and the date is coming out like this: August 6, 2008 and I would like it to read 08/06/08. I set the table's field and the report's format to Long Date to get it to stop displaying the year first. I have tried a few Input Masks but Nothing is appearing as I would...

Thanks for the response Paul, that did the trick and now it is flying right.

Good afternoon, I have a form with a PKey that is assigned by a module, which replaces the Access Autonumber procedure. It works good for new numbers but when i recall a existing Report no, it changes the report no to a new report number. This is be caused by the OnCurrent event and I was...

I tried that Autoexec ideaa and nothing at all. So I added a message box and the message does appear, but when I close a form, the switchboard form goes to normal size instead of maximum. Like if hav esaid I did they DoCmd.maximum in several event, but nothing appears to work and it should, or...

Thanks for the help statsman. I created the Autoexec macro and from what you are saying, I don't have to put it anywhere, like startup and anything, is that correct?