There are 3 ways I know of to save a previewed report to a file. The unacceptable way is to export it to Word, not good because you lose a lot of formatting and subreports, or you could install Microsoft's SnapViewer, which is fine but you'll have problems if you want to email the file to other...
Write a public function that takes five parameters, and returns the highest one. Make a query based on the table with the five fields, with a calculated field in the query that calls the function with the five parameters being your fields names.
Not sure exactly what you are trying to do, but in general, the linking of excel in Access (using the '97 Suite) was implemented by microsoft abysmally. I do not have the ms tech tip right now, but it says you have convert the excel 97 sheet to excel 4 in order for data updates to the linked...
I see you've got it to work, but I believe that linking and deleting the link is unnecessary. The SQL statement in Access is <br>
<br>
UPDATE DISTINCTROW DataTable IN 'c:\db1.mdb' SET Field1 = whatever);<br>
<br>
I'll admit I don't know the SQL way to do this, and if there is an SQL way, it will be better than what I'm suggesting. <br>
<br>
In the general declaration of the report define 2 variables:<br>
<br>
Dim m_prev$<br>
Dim m_this$<br>
<br>
In the format of the detail section:<br>
<br>
Private Sub...
Which way to go depends. Do they need a more powerful database for other apps, or just this one? If this is the only app, you could handle 2x your size database with faster machines and some VBA coding. I have 1.5 million record database that I can get results on in a respectable time.
Has anyone experienced problems with memo fields getting corrupted in databases that are accessed by several users simultaneously on a network (Access97)?<br>
<br>
I've found 2 instances in the past month where the word "#Error" is displayed in the memo field. If I try to put the cursor in the...
Not sure if this will solve the whole question, but given a table called "xxx" with date fields "dopen" and "dclose", then this query will group by month, sort Jan to Dec, and give the average per month in minutes:<br>
<br>
SELECT Format([dopen],"mmm") AS Month...
I use the following function, though there may be a built-in one through syscmd function, where p_tabname$ is the name of a table local to the mdb.<br>
<br>
Function ztablocation(p_tabname$) As String<br>
<br>
Dim l_db As Database, l_rs As Recordset<br>
Set l_db = CurrentDb()<br>
Set l_rs =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.