Search results

err.. code, not cade

no recordsets being used in this report. as a matter of fact, no cade at all. any other ideas?

i have a report which has several subreports. Each one of these subreports uses many queries. I have never had any problems printing this report before, however, now when I go to print it i recieve the message "cannot open any more databases" and it prints only part of the report. I am having...

Thanks Pat. As far as I can tell, Q&A has no built-in ability to export to any other format. I was however, able to find a demo of a small utility which can export the Q&A data file into comma seperated values. Only major drawback of the demo is that only 20 fields can be exported at once...

This may be the wrong messageboard for this. but you guys have always been helpful in the past, so here it goes. I would like to convert an old Symantec Q&A database to Access. What would be the best way to go about converting from this format. Not sure what version of Q&A the database is in...

I would like to filter a combobox in a continuous form according to the selection of another combobox in that record (e.g. 'Department' combobox selection determines available options in 'Employees' combobox). I would like to see the 'Employee' value in all records even though that value may...

are you looking for the sum of only that page? or the total sum?

CTRL + Break usually does the trick :)

you are not holding down the mouse while you move down, are you? :) you do not have a shift key jammed down?

oh. that shoots my ideas on the matter to heck then :(

oops. forgot to format. sorry.

There are a lot of ways to go about that, but here is the one i consider to be the simplest: Sub Command_Click() fSetAccessWindow( strPathtoDBase = "X:\PATHTODBASE\db.mdb" strString = "X:\Program Files\Microsoft Office\Office\MSACCESS.EXE " & Chr(34) &...

Are the Dbase and the Website on the same machines? Different machines? If different, are they on the same Local network?

I appologize if my simple answer is not what you are looking for, but can't you just hold down the SHIFT key and press the Page Down button a few times to select all the tables and then change their permissions all at once?

oh. i just realized how silly my question was. : ) Thanks.

just a quick question: is it possible to have a calculated field in the datasheet view of a form?

*cough*

If you wanted to be a rebel, however, you could also write functions to calculate these things. E.g. Set the Control Source of your 'Minimum' textbox to =GetMin() Then put this function into your code Function GetMin() As Long Dim i As Integer Dim min As Long min =...

if you follow Pat's advice you will be able to use the DMin, DMax, & DStDev functions to Calculate the numbers you want. You Will also be able to use DAvg for Q2.

errrrr.... queries, i mean