Search results for query: *

Hi cjany I've successfully done this with the subforms displaying in datasheet view instead of continuous form view. David

Thanks both. Just as a mild defence I too have been learning VBA for quite some time and have been able to provide solutions to some very tricky problems during this time - with the unbelievable assistance of Tek-Tips folk. Without taking the easy way out, and after checking the web and FAQs...

Michael Okay, I surrender, and thanks for your time. David

Point taken, thanks. It would still be very convenient to have some simple indication of available capacity within Access if possible. I was thinking that given a job with a start and end date, and a requirement for man hours, I could calculate the average hours per day over all of the...

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

Hiya AceMan Top advice as ever! I've adapted your suggestion a bit. In case it wasn't clear the main form has customer details and the subform the order item details and their suppliers. The supplier field in the subform now has an On Click procedure to run the report that generates the...

Thanks Daniel Just so the question's clear, the subform items may look like this for any particular order number. Item Qty Supplier ordered ------------------------------------ cup 2 ABC saucer 3 XYZ spoon 2 ABC plate 2 ABC knife 3 XYZ...

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

Hiya Mark I already create the output report with separate pages per supplier, and can save it as one rtf file. But I then need to dissect it manually to create individual emailable sections. Running a further set of queries by supplier would work but has a maintenance overhead eg if suppliers...

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

Darrylle Perfect sense thanks. The problem goes away if I update an 'internal' orders table with the one linked to Excel. Many thanks, indeed. Doc

Adding on to this, I now find that any query based on the table linked to the Excel spreadsheet isn't updatable, which is a problem. How best to resolve this? Tahnsk

Splendid, thanks Darrylle. I really didn't know you could link to an Excel spreadsheet like this, and the way you suggest makes the whole process so much easier. Definitely worth a star!

I do this on almost all of my forms. As above create an On Current procedure for the form Private Sub MyFormName_Current() Me.MyFieldName.SetFocus End Sub MyFieldName should be the Name of the control you want to move to, and should appear as soon as you type Me.

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

AceMan Fantastic, end of journey! Had a few error messages along the way in setting values for your [CtrlName1] and [CtrlName2]. Using things like[qryStockItems.Genus] etc gave 'Invalid bracketing of name', then 'Too few parameters...'. Eventually just [Genus] etc worked. Oh, also added this...

Gulp, sorry AceMan, here goes. Main form Rowsource : qrySaleableSock qrySaleableStock made from qryItems based on Items table with autonumber ItemID as primary key, and table Batches. Query has an outer join so it includes all listed Items (7500) and those made into batches. This is the SQL...

Thanks AceMan Last shot before Santa comes. Just to be clear about the problem, after selecting an item from Option Group 1 I use my selector listbox to find an item. The second option group allows me to jump down the list to items starting with any letter of the alphabet, to speed up the...

AceMan Wow, that's really impressive but please try to get some rest! Small thing to resolve is that if there isn't a record satisfying the filter request the form goes totally blank with no error message. How can I catch this? Bucketful of Guinness waiting if you're ever near Cambridge.