Recent content by kdm3

Hi, I hope someone can help me out, I have a form used for data entry. The form can take either data about Component Requirements, or Operation requirements. The info for each is very different - cycle time, program etc for Operations, and the Part number required for Component Requirements...

Worse than I thought... Sorry to dig this back up but I'm having serious problems... I've run my code printing numerous values as I go, and to my horror I have found that because my recordsets are based on queries, they do not update when changes are made. My application allocates stock...

Hi, I'm writing a procedure to do some pretty complex stuff, but basically it checks how much stock is available, and allocates what it can to a specific order, and generates a PO if there is insufficient stock for the order. I am using dao recordsets to do the allocating, but realised that I...

The type of relationship specified is the only type possible with the data structure of the tables - a one-one rlationship can only be set-up between primary keys which match completely i.e. the number of PK fields have to match, if composite PKs are used. If you're linking to a non-PK field...

OK, the source reference time is calculated by multiplying the quantity required (unknown datatype from query, probably long) by the est process time (long) and adding the est setup time (again long), all from other tables and queries. This generates an estimate of the time required to perform...

Hi all, I have a problem which needs resolving, I have a query which is used to calculate the number of days to complete a task, based on the time it should take in mins - i.e. if it takes 5 mins, you still need to set aside a day to peform the task. I thought of setting the datatype as...

My bad, as you said the DoCmd.OpenForm method works fine, I guess I tried to create a problem that doesn't exist. In response to the second point, alas I am using an older version of access, and it doesn't have pivotcharts. Plus I found that it isn't all that difficult to create gannt charts...

Thanks, I looked through the argumnts of the DCmd.OpenForm method as you suggested. But a question, is it possible to change the form view while a form is open, since the DCmd.OpenForm would tend to point toward having to close the form view of the form, open it again in design view do the...

Hi all, I have a trivial question, but one which has been perplexing me for half an hour now. I have the requirement to create a lot of controls dynamically - basically I'm creating a gannt chart using Rectangles. I realised, quite logically, that the form to which I am writing must be in...

Like you said, use a recordset based on the query, and use the recordset as the datasource, then clear the recordset once finished.

Hi, I find myself in a spot of bother... I have just written a quite complex query, which is basically a union query based on data from three queries, which in turn are based on multiple queries, calculated expressions and further union queries (it's kinda an involved requirement). I finished...

Setting default date order An add-on problem - I just noticed that some of the dates appear to be in US format, "month-day-year", but I'm British and I use "day-month-year", how does one go about changing the default date order from US to UK format, cause this could really pose problems if I...

A frustrating and somewhat annoying problem. I have a lot of dates to show, and am looking down at alot of numbers - not particularly attractive, or easy to read. I what to make these dates more readable, and display it as for example Fri, 3rd Sept, 2004 What is the best way to accomplish...

The easiest way of storing incoming stock, outgoing stock and stock adjustments (i.e. in response to a Stock Take), is to have a transactions table (as already outlined) and then have a field specifying the TYPE of transaction - whether this be an order receipt, adjustment or whatever - which...

Use a CrossTab Query - no idea how it works - but that's what you want to use.