Search results

I receive Access MDB files by email. I also use Zone Alarm firewall which is set to quarenteen files with MDB extensiosn. The quarenteened file has extension .ZLH. I can load the file ok but after I make changes, how can I save it under a different name and in the mdb format. The file menu...

Thanks dcx693, Your suggestion is what I need. I was looking in th wrong places. RealNine

Fornatian, Go here for the code to make your rectangle grow. http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b210321 HTH

Happy, re: the "solutions9" database dowloadable from micro$oft has a module for adding a rectangle around reports I searched the MS site for your reference and could not find it. Can you recall anymore detail on where to find the "solution9". Thanks

I completed a search for my question with no answers. I have searched Access help and still no answeres. Here is my problem. I am helping my son, who is 400 miles away, with Access application for a small business. He sends me the most current mdb file for me to work on. In the mean time he...

Thanks Everyone for your help. I stumbled into a solution. Here is the code I put into the Form-Properties-Event-On No Data Private Sub Report_NoData(Cancel As Integer) MsgBox ("No Tows Entered for this month") DoCmd.CancelEvent End Sub I replaced the DoCmd.Close as suggested by Wayne with...

Rich, I don't understand "behind your report" I am using the report properties-event-on no data. I thinkI need some code something like this If querry field is null Then MsgBox "No Data" DoCmd.Close End If I am not that proficient in writhing VB code.

Wayne, Thanks for your response, I tried that code before posting for help. It has the following results Runtime error 2585 This action can not be carried out while processing a from or report event. Is there some other way of aborting a report?

I did a search with my question and found no solutions that work. I have a report that lists and counts the jobs and amtBilled in the currenet month. The first day of the month there are no jobs listed in the querry. The report writer (print preview view) in the details footer gives err on all...

Leah, I didn't take a lot of time to study your problem but you might try the Nz function which returns a zero for null values. Don't know if this function works on date formats. HTH

Thanks Calvin, You gave me the road map to do what I wanted to do I made one querry which selects the records which are overdue. Then using that querry as the source for a second querry, I grouped by the source and summed the overdue field Then I included and linked this second querry to the...

I have need help on something I can't solve. I have a main table Dispatch (I have sence learned that I should have named it tblDispatch plus other nomenclature no-no's) which has pertinent fields of source, date , AmtBilled, Amt Credit and AmtPaid. The other table is Source which has all the...

Jack, Ok, I understand it now. Thanks

Thanks Jack, The additional querry does the trick. I don't understand why it is necessary but it works. Realnine

I have a querry to list sources and the total amount due. The Table is dispatch, the fields used are source,AmtBilled,AmtCredit,AmtPaid SELECT DISTINCTROW Dispatch.Source, Sum(Dispatch.AmtBilled) AS [Sum Of AmtBilled], Sum(Dispatch.AmtCredit) AS [Sum Of AmtCredit], Sum(Dispatch.AmtPaid) AS...

Try this The AutoResize property uses the following settings. Setting Visual Basic Description Yes True (Default) The Form window is automatically sized to display a complete record. No False When opened, the Form window has the last saved size. To save a Form window's size, open the form...

Use MS Access Help for startup. I use a macro named Startup which opens my form and then sets it for new record. You can also name your opening form startup and it will open the form on start up OR You can develop a form scedifically for startup that will provide options; Post New records Find...

I have a similar application, only I substract two currency values. SELECT Dispatch.Source, Sum(Dispatch.AmtBilled) AS SumOfAmtBilled, Sum(Dispatch.AmtPaid) AS SumOfAmtPaid,SumOfAmtBilled-SumOfAmtPaid AS Expr1 FROM Dispatch GROUP BY Dispatch.Source; Dispatch is my table and source, AmtBilled...

Jay, Several years ago when file compression became popular for HD, I a bad experience with it an lost data that it took a lot of effort to find and restore. What actually goes on when Access compacts a db. Is there risk of corruptin data or even loosing it. Does it slow down searches? If it...

Hi dcx693, I finnaly did get the code to work. I had to put the qry in brackest, i.e. "[qry]". If I could impose on your knowledge, I would like to understand how the code works. Dim rst As ADODB.Recordset Set rst = New ADODB.Recordset rst.ActiveConnection = CurrentProject.Connection...