Search results for query: *

I’ve been working on a query problem for several weeks and I’ve kept hitting a rock wall. HELP!! I have a preventative maintenance (P/M) program that calculates the number of days from the start date and generates a P/M work order. All of this works smoothly. My fields are: [start date] +...

I am trying to use conditional formatting to solve a problem in a MS Access Form. I’m trying to turn a field’s conditional formatting on if a value passes a certain point based on the value set in another field. In this case it’s for Work Orders that have been open too long. Each work order...

I need to come up with the correct code to put behind a button so that after the button is clicked one time the form will not display in the future when the DB opens. it's for a EULA agreement and displaying once at the first startup is what i'm looking for. At present this form will open...

for some reason i can't enter input when an input box for a query pops up. [ the one that looks for your input with these bracket boxes] i don't know if a software switch has been moved or what has happened. any thoughts will help. i can't figure what to do. when i go on the network and get into...

I need some good technical advive on this problem PLEASE help me solve this problem. 3 times in the last few days my data base has locked up and displayed the following message "AOIndex is not an index in this table" I've had to delete the data base the previous times and begin to...

I'm Using MS ACCESS 2000 and I need to retrieve records having a descriprion field containing various words. It is a parts description field named "Descriprion" I've tried to insert variations of "LIKE" as a search perameter but that only works to a limited degree and won't...

I need to find a way to cause a form not to display if a check box on the form is checked. I only need to have the box show up once and if the box is not checked stop the program from operating untill the box is checked. It's for a EULA agreement at the first opening of the DAta base. I'm...

when I try to close may Access 2000 db i get a message... what does it mean and how do i stop it?? Amessage pops up on close of the DB "Table 'TempMSysAccessObject' already exists." what does it mean and how do i g et it to stop coming up. this only started recently and i don't...

I've got a group of queries that perform needed update functions when my DB is closed or behind a few button clicks. all of the queries work fine individually. The problem i'm having is finding how to trigger these queries from a macro. any help is needed. I can't find the command from a...

I've got a group of queries that perform needed update functions when my DB is closed or behind a few button clicks. all of the queries work fine individually. The problem i'm having is finding how to trigger these queries from a macro. any help is needed. I can't find the command from a...

I'm trying to find a way to send the results of an Access Query and selected information fields to task lists for multiple topics in Outlook. Is that even possible? The overview of the situation: Information is gathered via an Access data base. After sorting with a query I need to transfer...

I need to send forms from Access 2000 via Outlook. It is a Work Order reciept and I've tried to find a way with no real success. The W/Os have a Outlook user name as one of the fields. An eMail address field is also available. There are 10 fields in all. I also want to automatically check a...

I need to export information from one table to another in the same data base. The information will be dates, ID#s and some other Identifing information. The problem is compounded by the fact that I don't need to copy duplicate records to the second table and the information will not be usefull...

I am currently working on a feature that tracks task performance dates on a Preventative Maintenence program. My goal is to have a table that has performance dates for 5 different categories, covering the last 5 years. I need to enter a new performance date in to the table and as the...

I've completed developing a access 2000 db., converted it to MDE. Now how do I keep casual users from poking around and looking at tables and other objects or viewing the structure of the DB? This part of db developement is completely new for me, ANY help will be sincerely apreciated and...

i need to calculate the day of the week (Monday, Tuesday and so on) from the calendar date. how can I do it and have it displayed on a form in a field? thanks for the help in advance! Phideaux The mind is the best toy. Play with someone else's often

I need to put a password on a bush button. in fact i need to put different passwords on 3 buttons on the same form. I've read up on puting a password on a form and done that to slove some one of the barriers i'm encountering, but i'm doing something wrong when it comes to putting a password on...

at present i'm using an append query to write from one Access DB to another having the same tables names. something in the relationship structure of the tables is causing a null conversion error. i intend to move data from my original db to a newer and better version as it is developed. what...

I'm using this line of code initiated by a button click to move information displayed on a form to a table to initiate a work order. DoCmd.RunSQL "Insert Into WorkOrders(MaintCntl)Values('" & Me!MaintCntl & "')" This works well but i'd like to improve my operation and...

I need to enter todays date in various MS Access forms by using a function key.( say "F12" or "Cntl F Something" ) is there any way to use a VB code that will make it possible to enter todays date in any place needed while running the application or in lines of text or...