Search results

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

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

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

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

Okay…bit of a irrelevant question..for cosmetic purposes only…. But does anyone know how to make an actual check box bigger??? Surely theres a way to change it from the minute size it is??? Thanks if anyone can help….. S :)

Okay heres my problem!!! I have a form ‘selection’ on which I have a combo box, from which the user selects a category. This choice of category generates all the relevant products within this category to a list box. I have an order form which includes a orders subform, this subform holds all...

Right ….i’ve been using this code to save and lock records that are finished…however it seems that ‘on click’ I’m locking all the records…including new ones…so I can’t create anymore. If I exit the form, go into design view or edit the code in some way..i’m able to create a new record and all...

hi i'm trying to allow users a selection in a listbox. However i have not used dynaset before, with the following code i get an error...'too few parameters, expected 1'......when i debug this it points to the line Set Rs = CurDB.OpenRecordset(SQLStmt, DB_OPEN_DYNASET) the value that the...

Okay I have the following problem …which I can’t even think how to solve…. I have an order table with a subform …’order details’..each line has an detail ID I need the order form to have the option to pick from previous detail ID’s (order detail records)…which will generate the chosen record...

Hi...was wondering if anyone knew how to shade colums in a datasheet..if its possible at all!!!??? Thanks for any replies S

Okay i've already mentioned this problem before...but its getting desperate!!!! Pleae if anyone can help i reeeeaaally need it now.. I have a successfully running database...but the problem is the reports... i need to generate these reports as they are currently displayed..in a format that...

okay...hopefully a really simple question....does anyone know how to attach a report as an e-mail attachment???? Thanks in advance!!! S

Hi I have a problem, that’s been getting to me for ages. I’m trying to code a combo box to be a search field. I have used the following code successfully over loads of forms….where I’m searching for a primary key (which is a number) Private Sub Combo237_AfterUpdate() ' Find the record that...

Hi, I’ve got a problem I hope will be really easy to solve…. I am hoping to number the items in a report. Basically if there are two records in the report detail I would want them numbered 1 and 2 and so on. Is this possible, if it is could someone please help!!! Thanks in advance for any...

Hi, i am completely new to filtering queries and wondered if anyone could help. I have a query that shows a 'product list' with their relevant serial numbers, what i am trying to do, is simply block two products from being displayed. I use product ID in my query yet display the product name...

Okay... I have a query to display relevant data for a user..i am displaying a field called 'product'. The problem is that i do want all of these products displayed...apart from one! Is there a way i can filter the query so that it will hide a field if the value is a variable i have...

Hi am slightly confused as to why this keeps happening, and wondered if anyone else has experienced a similar problem??? Whenever I make e.g a record in my orders form, if I was to open a query which displayed fields I have just added to or edited (via a button on that form) I find the query...

okay..i'm not very good at coding....i'm trying to copy some fields in a form to a table. Can i use the code for forms e.g. Private Sub Purchase_Orders_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "PurchaseOrder" ' DoCmd.OpenForm stDocName...

Okay..got a really strange problem…(or I’ve just been completely dumb!) I have a form with order details such as customer name, address etc. Within this form I have a subform…this includes details such as products , price etc. The problem is that each detail (line in the subform for each...