Search results for query: *

Rob, Thanks for your reply this sent me down the right track.

Hey All, I am trying to pass word protect a switch board. I have the password check portion working fine. The problem I am haveing is I would like a specific sub switchboard to open and not the main switch board when the correct password is entered. Could anyone tell me what aruments I need to...

Hello All, I am trying to create a way to handle employee vaction. I would like the database to run a process daily (Perhaps on open). That will check all the employees start dates and if they match the current month/day reset the employees vacation. I am not having much luck and see a few...

BBaggins, Thanks for your reply. I thought about this approach myself but I think it will be a little too limited. I am now looking at haveing the users create a record on the main database then write down the ClientID and EvalID assigned by this database. They could then manually enter this...

Hello All, I have a database at my organization wich is used to evaluate individuals to determine if they qualify for another one of our programs. The database which stores the information is a multi table database wich resides on our server in the office. As it stands now clients are...

Thanks Tom, I actually just solved the issue. I used the link below to correct my problem. It may be of interest to some so here it goes. http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_20305390.html

Hello All, I am writing a program that writes a line of text to a text file. I have another program(3rd Party) that checks the text file for the entered line of text. It then executes a process based on the text it finds in the text file. The problem I am having is that my program must write...

Nevermind got it. Just using standard or. =)Typed the SQL wrong. <Blushes>

Hello All, I am trying to create a query that will find any records that have a date that falls in a given range. The problem I am having is searching multiple fields containing dates. How can I enter the date once and have it check all these fields for any matches. The design is I have six...

I just wanted to thank you guys for the input. I have created a little sample database for myself which allows me to archive old records and then restore them if needed. I am planning to use this type of construct in all my future works and possibly work on redesigning our current databases to...

Guys, Thanks for the input. I agree with your never truely delete theory and try to stand by it. The database in question was unfortunately engineered before I started my tenure here. I would have created the same problem with the way I usually delete. I normaly move records from the active...

Hello All, I have a problem. This morning about 40 clients were deleted out of my DB. I wasn't informed of this until the end of the day today. I need to restore these clients to the database. The problem is they have customer numbers that are created by the auto number field in the DB. Does...

If you are looking to just reinstall W2K then disregard this post. If you would rather just change the administrators password on the local machine you can do so by using the Unix based boot disk found at the link given below. The directions can bve found out the link as well. It won't help...

Guys, Excellent stuff. You got my mind working. The main issue I was having was that the form I was working with was based off this query. So I was getting prompted to suppy the parameter before I amde any adjustments to the form. What I did was create a new form that only has the Week Combo...

All, I am developing a database for a kitchen staff that is not very familiar with computers. I am trying to limit the possibility for errors as much as possible. I am curious is there any other way to supply parameters to a query without typing them in the text box? For instance if I am...

Ggreg, Worked great thank you so much. My error was that I set my first critera on the critera line and then all the fields after that I set the criteria on the or line. Meaning I only moved down once and then went straight across for all the ORs. Thank you very much for your help and...

I am currently working on a database that by design has a large list of yes/no check boxes. I am trying to create a query that returns all the check boxes that are true in the table and none that are false. The problem that I am having seems to be with the OR operator. I can not seem to...