Search results

This is not a bright idea. I have an exact requirement for this

I need to display the location of equipment in a warehouse. The warehouse will consist of storage racks. Each rack is divided into rows and columns. Each rack will be configured differently. I need to be able to specify the configuration of the storage rack, and then allocate the equipment to...

American dates is indeed what is required Thanks

I need to find a range of data in a recordset. I have the following code .FindFirst ("Reading > " & LowerLimit) If .NoMatch Then MsgBox ("No Records Found!") Else dteStart = rstData!DateTime End If .FindFirst ("Reading <= " & LowerLimit & " and DateTime > #" & dteStart & "#") The first...

I have the following SQL statement: SELECT tblLoggerData.StoreRecordingLocationId, tblLoggerData.LoggerNumber, tblLoggerData.StartTime FROM tblLoggerData; I need the query to return the top 5 StartTimes for each LoggerNumber How do I modify the SQL statement to do this? Many thanks in advance

How can I create a pivot table in a query and use it in a form? My date looks like this: LoggerNumber DateTime Reading 33 12/10/2011 11:53:13 AM 3.9 34 12/10/2011 11:53:13 AM 3.1 35 12/10/2011 11:53:13 AM 3.8 33 12/10/2011 11:55:13 AM 3.9 34 12/10/2011 11:55:13 AM 3.1 35 12/10/2011...

Many thanks Attached AccessReport is what I get in Access HowIWantIt is what I want it! The graphics only show 2 print types. Please bear in mind that at run time the number of print types could be 1,2,3,4 or 5. And could increase in the future. It is not a given that all print types are...

I have data that consists of two fields. One is a time stamp (date & time), the other is a number. I need to determine the: * number of instances data is above a certain value * duration that data is above a certain value I have attached a sample database. In the only table I have 4 fields 2...

In Access 2010 I have created a 2 column report. I have a grouping on a field called "PrintType" The data gets displayed like this: PrintType..........data data..................data data..................PrintType data..................data I want the report to display as follows...

I need to requery numerous fields on a subform of a subform! I use this: [Forms]![frmCustomer]![frmCustomerQuotationManufactureDispatch]![frmCustomerQuotation].Form!lstQuotationDates.Requery Because this is longwinded, I was hoping to declare the forms like this: Dim ctlName ctlName =...

In Access 2010, pressing F11 will either maximise / minimise the navigation pane. Is there a method to hide it completly? I use this to show / hide the toolbar: If pubShowRibbonBar = False Then DoCmd.ShowToolbar "Ribbon", acToolbarNo Else DoCmd.ShowToolbar "Ribbon"...

I have form (frmCustomer) which has a subform (frmCustomerQuotation) which also has a subform (frmCustomerQuotationProduct) In subform (frmCustomerQuotationProduct) I have a Public Sub called UpdateCosting What is the correct syntax to call UpdateCosting from frmCustomerQuotation? Many thanks

On a from I have three fields If a user changes data in one of them I want an event to run - but only when the user navigates from the record. I don't want the event to fire when a field is updated. If this happens the event could fire three times which is not what I want. What event should I...

I am using Access 2010 I need to store pictures of a product in my database. The product will have multiple pictures. I thought of using an "Attachment" field to do this. On a form this works great, but on a report only one picture is displayed / printed! How do I get all the attachments...

The table that a form is based on contains an "Attachment" field I have the "Attachment" field on a form, and have allocated multiple pictures to it. Works great! Is there a method I can adopt whereby if the user double clicks one of the pictures, the picture will open in a graphic...

Why wouldn't record 1 be returned for 87? It's in the range. You are correct. My mistake! I have tried what you suggest but it does not work. What you wrote is what I originally thought and really cannot understand why it does not work.

I have the following data in tblProductBottle ID, ProductBottleMinLength, ProductBottleMaxLength 1, 80, 90 2, 85, 90 3, 80, 85 I want to filter this data in a query based on criteria entered on a form...

I need to get the full URL of a file Using VBA, how can I open Windows File Explorer to navigate to the file and get its full URL? I am using Office 2010 and Windows 7 Thanks

I need help summarising data! Attached file include: Access Database with contains a table and a query. The query is a summary of the data in the table Excel Spreadsheet. The spreadsheet contains the same data, but also shows how I want to finally summarise the data from the Access query If...

On a form I have two combo box's The contents of the second combo box are filtered by the item selected in the first combo box. If the value of the first combo box changes I want to delete the value in the second combo box I have tried...