ok - here is trimmed version:
Query to Access database ('BUDGET 2004-2007' Table in Budget.mdb) from Excel (using Import External Data):
SELECT `BUDGET 2004-2007`.DEPT, `BUDGET 2004-2007`.OBJECT, `BUDGET 2004-2007`.`BUDGET 04-05`
FROM `s:\budget\Access MDB'S\BUDGET`.`BUDGET 2004-2007` `BUDGET...
In Access, I may have a table of transactions, all of which include the account they were charged to. In Access, it is very simple to create a report grouping on account number and listing all the transactions for that account. I would like to be able to do the same in Excel.
Please keep in...
I would like to create reports in Excel using query data. The reports are required in Excel format so our clients can then later add their data and do what calculations they need to - simply exporting the report will not suffice as I would like to "lock" the data we are providing and provide...
Does anyone know how I go about selecting files of a certain type (eg: *htm) in the Files Panel? I know I can select Recently Modified, Newer Local, Newer Remote and All, but I would like to be able to custom search/select the files without manually going through them all and CTRL clicking...
Hello:
I'm new to Cognos PP and Transformer and I'm using it in an educational environment (as opposed to business) so I will be using it to build cubes of student/enrolment data.
Does anyone know of any good tutorials out there that explain the "strategy" behind designing a model ?
Thanks,
r
I have created a PDF form based on an MS Excel spreadsheet. I have created a number of fields as well as some embedded Java scripts. I now want to make changes to the original layout (i.e. the spreadsheet) to update the form. My question is: how do I export all the fields and J scripts from...
I am generating multiple reports which are being printed as each are generated. Here is a snippet of code to give you some idea:
Dept = "[SendListAllSumQuery]![ContactName]=" & Chr$(34) _
& LabelFlag & Chr$(34)
DoCmd.OpenReport stDocName, acNormal, "", Dept
This code is in a loop which...
Is there any way to have Access show the "structure" of a database. For example, if I want to know what queries, forms and/or reports rely on a particular table (pretend there are 100's of queries), is there any way I can find out rather than going through each object.
Thanks,
Rob
This is probably a very basic question, but here goes: I would like to run a query and then provide the sum of records of a field. Can I do this (query and sum) all in one query, or do I have to run a second query (on the original query) to get the sum.
Woa ...
R
Hello:
Does anyone know how to create a diary (or journal) in Outlook. All I need is a way of manually recording the days events and possibly printing all entries (say over a month or week etc).
Thanks,
Rob
I'll try it 2002 and let you know.
While I have your attention: have you ever tried printing a report using a postscript file as a template ? If this is of any interest, I'll write back with more details.
Thanks again Dave,
Rob
I am trying develop a form in which a user can print one cheque. He/She enters the information (date, amount, cheque number, name, address) in a form and I would like to have a bmp of a blank cheque "under" all the entry fields (text boxes) and print the form out (or convert it to a...
Hi:
I would like to use a bmp of a standard company cheque and then overlay objects (eg. text box) on the cheque. When I set a bmp file as a picture, the cheque is not displayed until I do a print or print preview. It would be nice to have the bmp displayed while the form is open for input...
I am trying to use MS outlook with Grouwise email server. Certain GW clients seem to have problems using the calendar feature of Outlook - when they try and create a new appointment, the get "An Unexpected Error Occurred". However, some people are able to log in on the SAME machine...
Hi:
My db currently runs a loop to print out reports, but this gives us problems with our printer. I was wondering if it might be helpful to run the loop and append each report to one big file and then print just the one big file. Does anyone know how to do this ? The code looks something...
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.