Search results for query: *

Hi I'm stuck for ideas how to even start this. A job form stores start and end dates of various jobs, and the man hours needing to be provided during each job. So Job xyz - starts 1/3/07 - ends 15/6/07 - needs 30 man hours If resource available is say 8 men doing 40 hours per week I'd like...

Hi All Have order form, and order items subform in datasheet view. The latter contains a Supplier field for each item, with a DblClick procedure to open an order form to this Supplier, also using other fields from the same row. Can this be extended so double clicking anywhere in the row, or...

Hi Have an orders form that lists customer details, with order items in a subform. The items may come from different suppliers. I want to select the items for a particular supplier, generate a report, and flag these items as ordered, ie with subform fields Supplier and Ordered, select all...

Hi I'm outputting data on customer orders to a report and want to save it for emailing. This is okay as I can save as rtf. There may be several items in an order, and the items may come from different suppliers. The report groups by supplier, with separate sections for each. I'd like to be...

Hi all I'm importing order records from Excel into an Access table using this procedure. *************** Private Sub Import_Click() ' Import orders from Excel file Orders.xls DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblCustomerOrders", "C:\orders.xls", True End Sub...

Hi Have a large number of items in a form's source and an option group to pick any of the 10 groups they belong to. The AfterUpdate procedure also limits the list box selector to the current group. Some groups are still large and it would help to have another option group with letters A to Z...

Hi In a subform that logs production of items in batches of different types, and their batch dates, I'd like to pick out the most recent price per item. The subform has source Batches and links via ItemID to the main form. For a particular ItemID the subform data could look like this Date...

Hi I have a form + subform to record movements of batches of garden plants from stock. The Batches in the subform can be categorised in a BatchType field as Saleable, Growing or NewlySeeded. I'd like to total the Saleable items only, and have tried creating an unbound field in the subform...

Have database for a plant nursery where they produce batches of different plants. They want a main form to show the plant details then a subform for different production batches of each plant. The subform would best be in datasheet view. Is there a way to number the batches sequentially, ie...

Hi Want to send data to Excel but keep getting multiple instances of Excel starting if I use GetObject("","Excel.Application") in the code below. Without the first double quote I get Error 429 and debug highlights the GetObject line. Any help much appreciated. *************** Dim objXL...

Hi Have simple continuous form to create a pick list. One combo field looks up products from a list of about 5000 items. Even though the combo homes in as letters are typed there is still a lot of typing needed to identify the target product. This is because many products have the same 10 to...

Hi Have a form that lists people's names, each with a tickbox to allow selection for later use. I'd like a button to clear all existing ticks. Since the form is in datasheet view I can't see a way of container form with no data source and dropped the datasheet into it. If the form is called...

Have a form with a combo box called Customer. A command button launches a second form which I'd like to show relating to the selected customer. In more detail, A jobs form with the Customer combo builds up items in a subform. Different jobs may have items for the same customer. The second form...

This is an extension of ane earlier question, and thanks to Remou, TheAceMan1 and PHV for help with that. Have main form frmCustomers containing customer details and a subform with items tready for delivery to them, as a datasheet. I want to enter a DeliveryNoteNo in the main form and apply it...

I'm trying to get update a field on a form depending on entries into a subform field. Example : - text field called Action in subform sfmHistory - yes/no field called MakeContact in main form frmCompanies If Action field value is 'Phone' I'd like to trigger 'yes' in the MakeContact field...

I'd like to use filter by form to extract various selections of contact data (just company addresses, eg by postcode), then click a button to mailmerge the data using a pre-designed Word template. I'd preferably like to do this directly, for whatever filter criteria I select and without using...

Hi all Have data field for addresses that contains the entire address, separated by commas eg Hillside, New Road, Summertown, Exeter, Devon, EX12 3TY I'd like to be able to chop this up into these components in a query Address1 Address2 Address3 Town County Postcode Help always appreciated

Hi all There are some useful FAQs on this, but have a small problem. Sorry it may be old ground. Want to email people selected in a fixed query using a command button. This code nearly does it ---------------- Dim rs As DAO.Recordset Dim qd As DAO.QueryDef Set qd =...

Hi When I export a query to Excel the web addresses appear enclosed in hash signs eg #http://www.bbc.co.uk# How can I stop this? Thanks

Hi all I've successfully used GetObject and CreateObject to open Word from Access if not already open, or use an open instance otherwise. Converting this for Excel gives this error Run-time Error '429' ActiveX component can't create object The code I'm using is Dim objXL as Object Dim ...