Search results for query: *

A colleague at work has received an email from a regular contact. He has noticed that the last few emails have included a read receipt. He is not sure if this was the case always. Is there any way to check the properties of an email to see if a send receipt was send with it. We use Lotus...

I have the following code to calculate output per hour. It works but how can I limit the result to two decimal places. Private Sub Hours_AfterUpdate() Me.lbloutputph.Caption = Me.Qty / Me.Hours End Sub Thanks

I want to be able to choose an item from a drop down list (based on a query i.e. distinct products) and have the item chosen to be automatically used as a parameter in another query.

I have a calculated field which sums the quantity field for all transactions by the part#, lot# and location. (A part number could be in several different locations and lots and are treated sperately - if they are in the same location with the same lot number they are summed). To add...

What is the best way of allowing the user to search the database and return all incidents of a particular item. It should group them by raw material, Lot# and location. It should also calculate the total in each lot# - material can be taken from a location by inputting a negative value (-10...

I am developing a simple database for stock control as a short term measure until we get a permanent solution. All I wish to do is to be able to record additions to stock and record issues from stock. I need to be able to query for a raw material Part # and see what Lots are available and...

My aim is to produce a report - using a drop down list (of customers from customer table) so that users can look at customer history. I have created a form with a drop down list of customers - from customers table. I have used this to filter the results for a query on the orders table (gives...

Hi I have setup a database which captures manufacturing data and produces management reports. i should state that I am not an access expert. I have the following tables customers, employees, operations, timesheet, workorder. The first two table are self explanatory. The operations table holds...

I have a database which is used by operators to input manufacturing data i.e. LotNo, Customer, SalesOrderNo, PartNo, LineNo, ActualQty, Length, ScrapMat, (MatStdCost), StdLineSpeed, SetupTime, RunTime, LostTime and weightperpiece. We then use this data to produce information like Standard...

I wish to secure a database and share it across a network, allowing different users different access permissions. I have tried to follow the advice from the Microsoft website on this topic but have found it very confusing. One of the problems I have encountered is that the security seems to be...

Is it possible to combine two queries into one report. The information I need to report on is as follows All yesterdays production. This will include the Lot#, operator, Date/Time, Customer, operation, qty, hrs, rejects. I have a working query for this. The second query is All the...

This question has probably been answered hundreds of times. I did search the FAQ's and forum and could not find anything. How do I query for all entries created yeaterday. I.e. The date will not have to be entered. The query will automatically give me all yesterday's details based on...