Search results for query: *

My data base is acting crazy. I am trying to import as much as I can save to a new database trying to isolate the offending item. One of the issues that has developed is that my forms will open but I cannot get them to close. I either have to control alt delete and shut down Access or...

I have been struggling with some type of corruption in our database. I have tried all of the easy fixes and I just can't get this thing to correct. Does anyone know of a reliable company that can review the database and help me correct the problems that it has? Thanks for any direction...

Recently, our dtatbase has been acting very strangely. I copied a form into the database and started recieving the network connection lost message. I copied all the recods into a new database and it was working for a while but now new problems are arising. I tried a compact and repair and was...

I have a problem with an Access 2000 database. I am getting a "Error accessing file. Network connection may have been lost error" message. One fix involves saving the code for the forms and reports as a text file and rebuilding the database. I am not sure exactly how to save the code as a...

I think this is a simple problem that I just cannot resolve. I am using the expression =IIf(IsNull([Customer PO]),"NEED PO",[Customer PO]) in a report. The result is an error. Customer PO is a text data type, required-no, allow zero length-no,index-no and unicode compression-yes.

Is this a function that needs to be added to work? It works on my desktop but does not on my laptop. I want to use a function that will read the numeric month and convert it to the name ie September, etc. This works but only on my desktop. Thanks, Mitchy

I am creating a schedule report that lists each job by its actual scheduled ship date. I want to add a header to group all the jobs for a single month together. What can I do to be able to use the actual name of the month, ie. November, in the header on the report? Thanks,

This is a simple question. I want to search records base on either my job number, PO number or customer name. Entering any one of these variables will return the info I need. Can a single query give me the flexibility to choose any one parameter and return my data? Thanks, Mitchy

I am working in a workbook with three basic types of worksheet. One sheet has a list of parts and various data related to the part for an entire job including a cell refering to a vendor code. Another group of sheets is the order form for the parts for each individual vendor. Finally, the...

I have a report that I continually use. It is printed in landscape with smaller margins to fit all of the info I need on the report. Periodically, the format will revert back to portrait and all of the margins return to the default standards. How can I prevent this concersion from occurring...

I have a report that is very full of infomation. Several fields are various dates. I currently use the short date format which included the month/date and year. Is there a way to drop the year off to clean up the report? Thanks,

I am currently using the following Dsum function to calculate some totals based on specific dates. Now I want to use the Is Null function to return a 0 value when no information meets the criteria. I am currently getting a blank entry. When I try to use the Is Null, it is not returning the...

I have a large database to track our jobs. I track the date the order is received, the date it isreleased to purchasing and the date it is released to the shop. Each job has a specific weight related to it. I would like to run a query where I enter the beginning date and the final date and...

I currently use a db to track quotations by customer. Is there a way to link this data to an Outlook calendar so the quote number appears on the due date?

I have a large customer database which contains a field for e mail addresses. Is it possible to set up a mass e mailing from this table? I would like to verify each person is still a viable contact and if I could use some type of mail merge to send out a message it would be extremely helpful...

Currently, I have a database set up for all of our customers. In a separate db, I track quotes and jobs. I would like to link the dbs to insure a new customer is inserted into our contact db. Do I have to put all of the data into a single db or can I run them separately? I would like to keep...

I am using a database to track shipping infomation for a specific product. There is a structure type that I track in one table. Sometimes there is a quantity of one but other times it could be fifty. Each structure is made up of two or three sub components that I track in a second database...

I am currently tracking machine production daily and comparing that to a fixed goal as a percentage of completion. Since I have four different machines, I stored each of the goals in a table which ties a machine to its particular goal. For each date, I have a report that will show the daily...

I currently use Access to track information regarding quotations for my company. I would like to know if I can have Access create an appointment in Outlook as a reminder for me to follow up with a customer call or visit on a set date. This database is used by several people and I want everyone...

Happy New Year, I am currently using an Access DB to keep track of quoting activity. I would like to see if I can create a link from Access to Outlook that will post a message on a specific date to follow up with a phone call, visit, etc. If I can make this task seamless thru Office it would...