Search results

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...

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...

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...

I guess I need another lesson. Records cannot be deleted from my front end forms. I just discovered one record from my back end units table that is no longer there. I may have deleted it in error. Is it possible to password deletions in 2007?

I have a report using the following tables but, the report shows the ID number rather than the type or description text. It is a little hard to follow and I would like to make the report more understandible. Muchas grassious in advance.. John. vehicle_typeIDtypedescription1Automobile...

I make a table named Vehicle _type that was intended to be a lookup field in the units table. I made it incorrectly I selected number field as the type. After I made it correctly as Vehicle_type2( a text field) I was unable to delete Vehicle_type field in the units table. The message indicated...

Can anyone help me understand and fix? works right, prompts for vendor number then prompts for start date and end date PARAMETERS [Vendor#] IEEEDouble; SELECT VENDORS.[VENDOR#], VENDORS.[COMPANY NAME], [t_PO-actions].ActionDate, [t_PO-actions].Desc, [t_PO-actions].Amt, [t_PO-actions].[Posted...

I have a DB with tables which get updated from a form. I have been getting a message (since I split the data base, I think) When updating/ exiting the form. "You cant't save this record at this time" coe100710fe may have encountered an error while trying to save this record. If you close this...

I have just split my 2007DB. I also just noticed that AGST (Above Ground Storage Tank) table/form has lost some functionallity. before the split a lookup field let you select the tank registration number. (Multipul locations have different numbers) Since the split this stopped working. I...

I took a 2 day class last year, I really got busy early this year and I have learned a lot. Some came from books, some I learned by reading these forums and some was by paying for tricky programming help. My DB gets better and better. I recently split the data base and I am now working on...

If a database is starting to look better than any other and entering, accessing and reporting the data is getting ship shape too. Should you ever copy right it? Has anyone any experienced the process and would you do it again? just wondering..

Once a database has been split how often should it be compacted? Do you compact both the FE and the BE or is one mere important than the other?