Search results

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

Most appreciated Thanks Len, I sorted the problem out pretty quickly in the light of what you said, but as Pat points out, it probably wasn't the best idea to consider changing the primary keys. To put you in the picture of what I'm doing - I basically have a table holding info about material...

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 worked it out, use the STRREVERSE() function, flip the string, do standard left side procedure, then flip back.

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

Nice neat function, in the past I've used a horribly ugly, long function - this is much more elegant!

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!?

Yo thanks Doc Man, I think i will just construct the entire query in code. Only lately did I realise one could include user-defined functions in queries, and I've started to use this property over-obsessively, without completely knowing what I'm doing! I looked over what I'd written and it was...

A few screenshots... I removed most of the fields from the query, once one works the rest will. I know function is pretty crude, but like I said it ran when I debugged it. Any assistance 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...

it's cool... Hi, It's OK I remembered, GroupBy...

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

That's done the trick... Yo dude, thanks alot. I used the concept employed in the code and wrote a compact, and efficient little function to achieve exactly what I wanted!

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

Further... In answer, From Sage, basically details regarding orders, customers, suppliers etc... Needs updating whenever a new order/customer/supplier etc. is added, so would need updating tres often! I had intended adding new records periodically using a timer! Didn't get that one!? The...

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

Thanks for the advice... Thanks for the advice guys, I has given me alot of food for thought! Finally, with respect to my description of a pseudo-MRP application, I say this because it isn't a classical MRP structure. Due to reasons I won't bore you with, the application has a hybrid MRP/FOQ...

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