Search results for query: *

Juliane Thank you. That seems to be the answer - my apologies for doubting you. Regards Niall

hello Juliane I think you may have misunderstood my question. I wish to look at an old email that was received and see if a read was sent with it. The email waws opened at the time it was received but the user cannot remember if it included a read receipt. He now wants to know!!! Is there...

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...

That works fine Thank you

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

Still no luck. Is there anyway I can attach a small example database to show exactly what I'm trying to do.

Hi Thanks for your input but I can’t get it to work. Do I need to put an on_click or an After_update event in the first box to run the second query (qrysum) and populate the second list box. Here is my setup below. I have a form called frmsearchNew. I have a combo box called pickpart to...

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.

You are probably correct but I don't know anything about VB. Ideally I would like to put the required code in the click event of the save button in the frmissuestock . This would check the value in the qty text box in frmissuestock against the value in the SumOfQty field in the qrySum (for...

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...

Thank very much It seems to be working fine - returning a value of 0. I used the Nz function as you suggested. Again thank you

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 is the SQL statement I have tried to enter. SELECT timesheet.ID, timesheet.OperatorName, timesheet.Date, timesheet.Customer, timesheet.WorkOrderNo, timesheet.Operation, timesheet.Qty, timesheet.Hours, timesheet.Rejects, timesheet.Comments FROM timesheet where timesheet.Date =...

I have enter this exactly as above and I am getting a 'data mismatch in the criteria expression'. I have changed the date field in the table from short date to Medium daate and the error still occurs. I have Now() as the default value for the field. What am I doing wrong