Search results

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

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

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

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

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

Good afternoon, I have a form from the Switchboard and when ever I click on a command button and go into a form everything is maximizing all right, but when I close the form, DoCmd.Close, the form I am using for the switchboard appears normal and not maximized. I have DoCmd.maximize only in...

Good morning, I have an OnClick procedure, that creates a snapshot report document, which is outside of the dbase, but in the same directory, My Documents. I would like to delete it after it is e-mailed and I tried playing with DoCmd.DeleteObject but that appears to be for things inside of the...

Good morning, I have a home based computer running XP Pro and Roadrunner Web Mail as the e-mail agent and Outlook is not on the computer. I found a script that says that it can do this, so I put it in a module and tried it but I can not get it to run in that macro, which is run from the...

Good afternoon, I have a report that I am trying to e-mail with roadrunner web mail and Outlook is not on the computer. I ahve thought about just sending it to a file, but snapshot and html and RT would not open or would ask what program to open them with, when I double-clicked on them...

Good afternoon, I am trying to have a report save to a file that can be opened after it is e-mail to someone. I have tried several types in Output To, like snapshot and ridh text and HTML, but they all want me to select a program to open them and so they are no good. Is there a way that I...

Good morning, I have a macro and it prints out a report and runs and update query and that is working ok. Now what I would really like it it do is instead of printing the report, I would like it to send the report to a file, in MyDocuments, and compress it is possible. Each time the macro is...

Good after noon, well I am almost done and would you know it I now have an error in an event procedure. I did change the record type from number to text for the DoctorID to get something else working correctly and now when I open theis form and give it a valid DoctorID, it now tells me there...

Good afternoon, I have a query and on the keying off of the DateCreated I am trying to create a query for a report for the last weeks entries and I am using a WHERE in the sort and in the criteria I have tried these two conditions and neither one will filter out the 6/1/08 record. Between...

I have a form with a subform and on the form and also on the subform, I have three comboboxes or txtboxes and in the OnExit event I have a little procedure which makes sure that each have been filled in or it asks if you want to cancell and if yes, it setfocus on the cmdCancell and then I can...

Good afternoon, I have a form with a subform and in the first txtbox of the subform in the GotFocus event I have a little procedure which checks the txtboxs on the parent to make sure that there is data in all four of the txtboxes. This works great the first time and it pops up a msgbox and it...

Good afternoon. I have a combo box which in GotFocus I have it dropdown, in otherwords open. I would like to know if it is possible to then hi-lite or select one of the lines in the combo box? In other words, set a default for that combo box, so the person entering the data could just click...

I have a procedure which can put in a Restocking Charge, it works good but you have to type it in each time here it is: Dim strInput As String Dim strMsg As String strMsg = "Enter Restocking Charge?" & vbCrLf & vbLf & _ "Enter percentage." Select Case MsgBox("Is There a Restocking Charge?"...