Search results

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

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

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

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

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

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

Hey everybody, a question I hope someone can answer... I have a table (well a few tables) with composite primary keys (upto 4 fields). I am using the Recordset method for interacting with the data held within, and was wondering if it was possible to search on composite primary keys using the...

I have hit a crisis of confidence - am I doing the right thing? I am building an incredibly complex app., and have to do alot of weird calculations. At present I have made extensive use of queries, but these are layered up to 3 or 4 deep, is it considered bad design to do this - should I try...

Hi, I have a very odd requirement, and am unsure if its even possible, but here goes... I have a number of queries which create produce data in a similar form, but in very different ways - i.e. there isn't any way of combining them. E.g. Query1: ID Field1 Field2 123 12 23...

Hi a problem has been perplexing me... I am mitgrating some data, and forgot to include one of the fields. Hence I wrote a little function to add the relevant field values on, easy enough - or so I thought. I am appending the weights of some items on, and the data type is DOUBLE, with a...

Hi, hope somone can offer me some advice. I am developing an application to process orders (a bit like MRP), and want it to work closely with Sage (Line 50 - v10), sharing info about customers, suppliers, PO's, SO's - but then generating more info. about product lead-times, and operation steps...

UPDATE queries scare me, there's too much scope for causing huge problems. I find myself with a requiremnt to use one however, and was hoping someone could help me with the following: I have two linked tables, one with a single primary key, one with a composite primary key - one half of with is...

I Hope someone can help... I need to break a long product code into its constituent parts (all seperated by a "-"). With some effort (my brain hurts) I managed to write queries to extract the first 3 groups comprising the number, but also want the final group. The length of these code are not...

Hi, I want to measure the length of a text string - the length will determine what is done to it in a module - I know that this isn't to difficult because I done it in the past, but can't remember how. Hence any suggestions would be welcomed!?

Hello Everybody, I have a problem which is really starting to annoy me (after much time spent messing with it). I want to base the contents of a subform on a query, which in turn takes its arguments form controls on the main form... simple enough you'd think. However, if no values are in the...

Hi, I should, and did know the solution to this problem, but have forgotten! I have a query to sift a table and only retreive certain records (item colour to be exact - for use in a selection combo box). However, I have the classic problem of duplicate records - i.e. there are multiple records...

Hello everybody, Was wondering if anyone knew of a way of creating a calender which only counts working days. The motivation being that when a ,for example, delivery time is quoted, this usually refers to working days, hence when determining what day this delivery is due, it will be the current...

Me again, my head's sore from banging it against a wall! I wanted to ask for opinion regarding the pros/cons of linking tables. More specifically I am writing an application to do some pretty scary stuff, and need to 'get' some data from another application - but then need to add more fields...

Hi, I have a problem which I am hoping someone can help me with. I am writing an application with a Memo function. Basically an electronic post-it note - the idea being that a user can write a note reminding them (or someone else to do something at a specific time). My hope is to attach a...

Hi all, A problem I have, and after much thought have still been unable to rectify - hence I ask for some impartial advice and suggestions... I am writing a pseudo-MRP application, and need to store info. on products to be produced - hence the BOM. However, the company is a design-to-order...