Recent content by petersdaniel

DELETE * FROM YourTable WHERE EXISTS (your Find Dupe SQL Here); petersdaniel@hotmail.com "If A equals success, then the formula is: A=X+Y+Z. X is work. Y is play. Z is keep your mouth shut." --Albert Einstein

It sounds like the database has some screwed up object references in the System tables. My recommendation would be to create a new database with a different name and import the table,queries, forms, macros and module objects. This will force Access to re-evaluate the structures when they are...

This is happening because your bitmap object is occupying space outside the printable margins determined by your printer. Access report automatically forces an additional page when any object exceed the printable margins. You need to reduce the size of your object and pull it within the...

You need to be thinking of this from how you would launch the report. First of all, I would create a form that presents the data that the user needs to interact with (including the Yes/No boxes). Once this was developed, I would create a Query object which had it's criteria linked to the...

You need to be thinking of this from how you would launch the report. First of all, I would create a form that presents the data that the user needs to interact with (including the Yes/No boxes). Once this was developed, I would create a Query object which had it's criteria linked to the...

That is a possibility. Unfortunately, I no longer have '97 on my platform due to low demand for it. In most cases, I am converting up to 2K or XP (2002) petersdaniel@hotmail.com "If A equals success, then the formula is: A=X+Y+Z. X is work. Y is play. Z is keep your mouth shut.&quot...

Well, it isn't an issue with the intrinsic operation of the iif function. "Iif" has been around for some time and this function should work. Have you tried backing this down in steps to see if it is a specific portion of the statement that is causing the issue? Try...

Try Me![txtAddrState].Value petersdaniel@hotmail.com "If A equals success, then the formula is: A=X+Y+Z. X is work. Y is play. Z is keep your mouth shut." --Albert Einstein

Your relationship for your tables should be established at the backend MDB file where your physical tables are at. Your Access front-end will see the relationships when it works with the tables The relationship type of "One to Many (External)" means that you have a primary key...

Set your columns widths to 0,0, 1cm petersdaniel@hotmail.com "If A equals success, then the formula is: A=X+Y+Z. X is work. Y is play. Z is keep your mouth shut." --Albert Einstein

In most systems that I have worked on, the Fiscal year settings were maintained in the database and retrieved when needed by subroutine. This prevents the hard coding issue plus makes the system adaptable should the company decide to shift fiscal periods (one company may want calendar fiscal...

Looks like it will plus it is a little more compliant with ANSI SQL standard method. I generally don't recommend EXISTS statements unless I know the user is able to code SQL and know how to build sub selects. Many of the people seeking information here tend to not know the differnece between a...

You situation sounds a bit confusing. First of all, in most business models, an employee is only assigned to one department not many departments. An employee might be assigned to many projects or tasks or etc.. So, taking a standard business model for managing a corporate structure, I might...

Expression Builder allows you to build simple data calculations and advanced formulae without investing a lot of time in VB coding. To do the VB Requery Methods, you need to enter into Code Builder. This takes you into the VB editing module. The afterUpdate event that you use should be on the...

That's what we like about Microsoft. 100 ways to get something done and no absolute authority on what is the best... That's why Tek-Tips is here!!!! petersdaniel@hotmail.com "If A equals success, then the formula is: A=X+Y+Z. X is work. Y is play. Z is keep your mouth shut." --Albert...