Search results

My database project has been fully implemented for 3+ years. The first thought that came to mind was: Why can't you right click on your (date field?) then use a date filter? you can always copy the data sheet view to find multiple records. Be careful ! copy the sheet and use excel for...

Thanks for the follow-up. Article thoughtful, I still get the feeling that replication is a function of older versions of Access. Can it even be done to access2007 or newer versions? I you save a 2007 file as an earlier version to accomodate replication what functionallity could or will be lost?

A consultant will be calling me tomorrow about a downsized verson of the software I use to manage vehicle assets,parts and work orders. They mentioned something called Access Replication as a means to disiminate field data and them update field changes at the end of the shift. The terrain...

I have a new(?) problem. I have been using access 2007 for a couple of years now. This problem newly developed. On my mainmenu form I have a button called reports. Theis button takes me to a reports form. I have added 27 buttons to print preview frequently used reports. I have a new entry...

Problem solved. Query to select purchase order specific records sorted by action date Report header vendor name, vendor#, purchase order number Partial payment page header action date, req date, part pay date, Po close date, description and amount Partial payment footer =Sum([Amt])...

I have a report to submit partial payments against a purchase order. The math works fine when single purchase orders are closed after one partial payment. The math doesn't work when calculating the current Po balance when payment involves a second partial payment or when two different purchase...

There are a number of database programs availible. Most require that you adopt thier methods. They will get the job done if you can accept the position that they know more about your business than you do. You will hear things like "well in order to support our product we don't make every...

Good Question Thales750: I manage a Municiple fleet, includes Police, Fire, Trash trucks, offroad equipment, Golf course. Around 400 units, 3 mechanics and 1 retirement vacancy. Bid Spec Development and purchase, vehicle registration and title management surplus auction. Parts management...

Hi Galaxiom: Thanks for your post you have given me a lot to think about as I look over my DB in the next week or so. Your guidance ,if I understand it correctly is to 1) create a new table. 2) relocate “check inspection expiration date, lights, tire pressures and fluid levels” from the...

Thanks for the guidance Gemma. I am still a student of Access 2007, My resources are MS Access Power Mastery 2007 course MS Access 2007 Livelessions Access 2007 The Missing Manual Access World Fourms learned brethern For the benefit of GalaxiomAtHome and Missingling I will review...

Thanks for thje reply. The system has been fully functioning since 03/2010 and all ready contains 1000+ workorders it seems pretty normalized to me. The detail I am refering to would only be printed on the closed work order to inform the user of the service work that was done. Of course it...

I am using access2007 to document vehicle maintennance repairs. I have been thinking about the next revision. In the Workorder “instructions & crew remarks” I have add a default value “check inspection expiration date, lights, tire pressures and fluid levels” I would like to expand this a...

In my MSDS table I use a hyperlink to access the material safety data sheet PDF files. Embeding the file could work but as others have mentioned it will bloat and slow down data access. As you say, some feel safer if all the data is all in the same file, but another way of thinking about it is...

This is a good question. I don't know for sure. I think so, if you make a distribution copy form the db the add-in added to. I split my data base and put it on a server. I checked the two remote front ends and the print to pdf feature isn't availible. I copied my office fe to my notebook and it...

I print to pdf a number of different reports. I am using Access2007 and I learned this trick from page 308 of "Access 2007 The Missing Manual" I bought as a PDF file from Amazon.com To export a report as a PDF file, you need the “Save As PDF or XPS” add-in. To get it, surf to...

4700 pages? Maybe you could save the report as a PDF file and only print a hard copy as needed. Pdf files are eaiser to email anyway..

A few years back I noticed that gold was selling at $260.00 per ounce. I bought around eight ounces. Some I used as college graduation gifts for my children. Things got tight wor a while and I sold 4 ounces between $900 and $1000 each. I have thought if it ever goes down again I might buy...

You can't save money by spending it. I just paid off my Sears account. (my Christmas present for this year) And now I am goning to work on Capital One. I can't do anything about the country, I have decieded they don't know what they are doing and I am not going to follow.. I followed...

Have you looked at the inventory template at MS office online in the business template area? I am currently in month 9 of building your own. It has been a real learning experience for me.

The method I use is a closed wo y/n field and then run a view report with "Y" in the criterion.