## Crashed Office 2000, Win 98 Files

MS Office Access

### Next

I have a query that determines return item price based on 1. the correct price level for the customer and 2. the packing type returned (each, pack, box, brick). The query calculates the total of the return of each item. My confussion lies in calculating the total for the group of items returned in each box (which is individually bar coded). And then the total for the overall return for th client. Each client may return many boxes and each box may have many items. When I try to sum my expression total for each item by the group (box it is in) in my report it only calculates the last item listed. If i do it as sum of all then I get the previous box total plus the sum of the last item in the current box. Report is as such: Box: 495858 4549 Bubble Smoke- Blue 15 Each * \$1.59 = \$23.85 27 Pop Goes The Wesle 3 Pack * \$7.99 = \$23.97 Box: 495859 9794 Booby Call 4 Each * \$59.95 = \$239.80 Box 495860 10050 Firecrackers 11 Bricks * \$16.95 = \$186.45 2945 Snakes 255 Boxes * \$ 0.75 = \$191.25 I need to put a total for each box and then at the end of the report a grand total of all boxes with a number of boxes so I can produce an average amount.
• 2. Depreciation Schedule
Does 'Now()" or "Date" have a value that represents a Month Value..IE, Aug 2006 = 234, Aug 2007 = 246.. I would use this in a straight-line 60-month Depreciation. TIA - Bob
Table A has an OLE field called [Image] that needs to be populated with images found in folder C:\Images. Each image has a unique path. Query Q is a select query based only on Table A. Using concatenation, Q creates a text field called [Image_Path], associating for each record in A the full path and name of the corresponding jpg file in C: \Images. Is there a way to automatically link each [Image_Path] in Q (text) with the corresponding [Image] in A (OLE)? Has someone posted some VBA code on how to accomplish a similar task? Can it be done without VBA? I use Access 2007. Many thanks, W.
• 4. folders to organize queries and forms?
My database has many queries and forms. Is there a way to organize them into folders within ACCESS?
• 5. use drop down box to search table
i have a table that I would like to search using a drop down box. I can create the form and and box, I just can not get the command button to use what I selected in the drop down box to search the table ?

### Re: Crashed Office 2000, Win 98 Files

```"They are in the registry and " & (probably) & " unrecoverable :("

Try to find your personal macro workbook for excel (personal.xls)
Don't even re-install Word
What could you have possibly customised in Access unless you have developed
some ds's, in which case just get those.

BTW this is a MS Access specific ng. You may get a better response on
others.

```

```Dear All,

It it possbile to install Microsoft Office 98 & Micrsoft
Office 2000 under a single operating Windows 98
environment? If yes,appreciate if you guide me with the
process.

Many thanks,

Savio
```

```I can't get Access started.  I get an error message: "A system error
occurred, or there isn't enough free memory to start Microsoft Access.
Close unneeded programs and try again."

I've pretty much tried every possible solution found on the web and the MS
Knowledge Base, all to no avail.  I've re-checked the system requirements
for Access '97 and even though I'm well overdue for a new PC, a Pentium II
300 Mhz with 64 megs of RAM and plenty of disk space, appears to amply meet
the state requirements.  I suspect that I have a DLL conflict with the
library files installed for Office Xp Standard Edition.

Any clues anyone?

Tks!

Uncle Ben

```

```Is their a free down load of word that is compatable with windows 98. i use
to have word 97 but my computer crashed and wiped word out of my computer.any
sugestions:(
```

```
"JoAnn Paules [MSFT MVP]" wrote:

> No, there isn't. Since you no longer have your disks, your only option is to
> see what you can find on eBay or something similar to that.
>
> --
>
> JoAnn Paules
> MVP Microsoft [Publisher]
>
>
>
> "terry" < XXXX@XXXXX.COM > wrote in message
> news: XXXX@XXXXX.COM ...
> > Is their a free down load of word that is compatable with windows 98. i
> > use
> > to have word 97 but my computer crashed and wiped word out of my
> > computer.any
> > sugestions:(
>
> xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
new question:) what version of ms word would work with my windows 98 with
out crashing. i know 97 would be great if i could find one. is word 2000
compatiable with windows 98. [also is their a word program in ms works that
is compatiable]
>
```

```can office 2000 be installed in WIN 98?
```