Recent content by JustMaybe

Hi, I've been asked to do sql join strategies testing times to retrieve data. I am doing a simple hash join of two tables e.g. Select /*ordered use_hash (customer) */ cust_lname from customers, orders Where customers.cust_id = <=500 AND customer.Order_id = orders.order_id there are 2000...

Hi guys! Okay this is a pretty basic problem, but one that is stressing me out! I have a query that shows records within a date range, set in the criteria field of 'Date' When i have done this before it has prompted me for the two dates when the query is opened! Which is what i want!!..but now...

Sorry if i've confused you! :D

Errmmm... think we've got things muddled now!! Copying the memofield really isn't the problem!!... the problem is when i copy a record from the orders subform to the PurchaseOrders subform .... Forms!PurchaseOrder![PO Details Extended subform].Form!ProductID = Me.[Orders Subform]![ProductID]...

Hi, sorry if i haven't been completely clear!..I'm always a bit wobbly on explaining myself!! Firstly the subforms are on different forms alltogether.... [Forms]![PurchaseOrder]![EndUser] = [Forms]![Orders]![EndUser] PurchaseOrder and Order are the two main Forms PO Details Extended...

Thanks alot for your help Rob!! This is my code Sarahx Private Sub Purchase_Orders_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "PurchaseOrder" ' DoCmd.OpenForm stDocName, , , stLinkCriteria ' [Forms]![PurchaseOrder]![EndUser] =...

Hi guys!! thanks to mile-o -phile's excellant subform syntax sheet...i discovered a line of code i needed to copy details from one subform to another... thing is it only copies the first line of the subform...and there can be up to ten products.... Does anyone know how to support this bug?? I...

Thank you soooo much!!...exactly what i needed (i hope!)..am printing a copy now!! Sarahx

Hi all! I have what I hope is a very simple problem!..Within my database I have an order form. This is filled out by an administrator and then a Purchase Order is raised to our suppliers. When the Purchase Order Form is opened from the Order form I use the following code to copy across some of...

The problem with hiding the scroll bars etc. to make this form only so users view a new record...is that they will only be able to enter one customer details at a time. e.g if they entered a set of customer information in, then they would need to re-open the form to add more!...however if you...

okay.....from how it sounds you seem to have got yourself pretty confused here!! By creating a form your also creating a way to display your current records. The forms you have tried will be showing current customer records... however if you click right on the record navigation arrow untill...

this example database might help you...posted by another member on this forum.....it can be found by searching for a cascading combo...but includes listbox examples http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=36863&highlight=cascading+combos

Col, again you have been a star!!! thank you v.much!!! That has helped so much!!!! Sarahx for anyone who needs to use this the code is (tiny, slight difference from above!) Private Sub Report_Open(Cancel As Integer) If Forms!Orders!YourCheckBox.Value = True Then Me![LabelName].Visible =...

Hi, I’ve got a bit of a weird problem which could possibly be solved with the following solution: However I don’t even know if it is do-able!! Does anyone know if it is possible to have a label appear on a report, conditionally by a check box being checked on a form?? If so does anyone have any...

this might help.. http://www.mvps.org/access/reports/rpt0016.htm