Get yourself with the program, MacLean.
That database belongs in a single sheet form. So get updated to Office
2007 or 2010. 2003 is like eight years old.
That 3 sheet method is just lame. The advanced features of 2007 make
2003 pale by comparison.
Simply adding new entries as they fall in your lap isn't good enough to
call it a good database any more. You need to update the sheet version
you save it under.
You are now TWO iterations of Office out of touch.
They are not simply newly released apps, they actually do have new
features that any large database person would want. Why you are lazy
about it is ridiculous. It been 8 years. Jeez. Even the open office
products do a better job than 2k3 does. Get a clue.
- Re: Auto Fill
... Therefore everything from phone calls to faxes to documents have to be logged into our database. ... From the fax table I already have a report that will be generated so that they can print the report out and use it as a cover sheet. ... I NEED both of these tables, as they are with all of their information so that I can see exactly where the item was faxed and to avoid people accidentally creating a wrong query and me never knowing it until it is too late OR having it be too complex and time consuming for them- it is much easier for them to be able to fill out a form and create the report. ...
- Re: Home Theater
... That database belongs in a single sheet form. ... The advanced features of 2007 make ...
- Re: Auto Fill
... I am working on a database that needs to keep track of everything we do ... report out and use it as a cover sheet. ... use a query or anything else. ...
- Re: Difficulties programming a command button
... My database field names are per your "i.e." below; ... The general format for the sheet labelling is "TechSurname ... helpful to add a field "WorksheetName" to the equipment table. ... now I need to modify it such that the particular sheet that opens is directly ...
- Re: VBA code silently crashing. Problem with Data Validation drop down lists.
... experiences of running code in XL97 with faulty UDF's - it blinded ... > common is both make sql calls to an Access database using DAO 3.6. ... > dependents or precedents with any other sheet. ... > completely independent from the rest of the workbook. ...