Recent content by SBM

It's a difficult question because I'm not sure how to explain it ! Hopefully the answer is simple. I have a form. On the form is a line. The angle of the line is altered depending on a value in a table. This gives the effect of a gauge (when a scale is added behind the line). In order for it to...

Thanks, that's great. Sometimes you can't see the wood for the trees !

Hi, I'm trying to isolate the first letter / letters of UK post codes. Typically they are of the format .. WS9 0JL The obvious choice is left,2 but of course it's never that simple some post codes are B1 7FH so left 2 gives me B1 but I need just the B I can use Left 2 and the look at the...

Thanks !! Pat, thanks. That worked just fine - so simple.

I have an Icon which has appeared on my main Access menu ribbon, when access first open , between File & Edit. It is not active until a database opens. It acts like a comand button and tried to open a table which resides in one of my databases. It's a though I have, by mistake, transferred a...

Success OK, fixed it ... For n = 0 To 9 DoCmd.RunSQL "INSERT INTO InventoryEvolution ( SAP, Stock, When ) SELECT UK_Product_Estimate_Live.[RE SAP Code], ((Sum([Estimate01])+Sum([Estimate02]))/50)*-1 AS Stock, date()+" & n & " From UK_Product_Estimate_Live GROUP BY UK_Product_Estimate_Live.[RE...

More It's not as simple as the date being in US format. See the dates below... When 10/06/06 10/07/06 10/08/06 10/09/06 10/10/06 10/11/06 10/12/06 06/10/13 06/10/14 06/10/15 As you can see the first few look like US style but the when it gets to the 13the the date flips to some thing else. It...

Thanks !! Thanks Guys. That works just fine. One small question. The date is in US format (mm/dd/yy) but I need it in UK format (dd/mm/yy). How do I do this ? Thanks again Steve

i am trying to run an append query in SQL which appends a calculated value into another table 50 times incrementing the day by one day each time. When I run it it asks me for the parameter [NewDay] each time. It is obviuosly not picking up the variable. Can anyone tell me why ? Dim NewDate...

i want to have a form which, after a job number is entered show a single bar graph of the time taken for that job (DLookUp ed from a query / Table). For example, if the total time is two hours and the job takes one hour, half the bar would be coloured in. i can do it by opening another form...

If I put Autonumber fields on both tables surely I could only link them if they had the same numbers. They will, without doubt, have different numbers so how can I use this method to block duplicates ?

The problem is in the DC table the only unique field (in this case) is the posting document. There is also a posting document in the GR table but they are generated from different systems and thus are different (DC posting starts 89..... and GR posting starts 56....). Steve

I have two table. Deliveries Created (DC) and Goods Receipt (GR). I have a query which links the two by PO number, PO Item, Unit code and Delivery quantity. This works fine until one PO Number has more than one delivery quantity which is equal. For example.... The PO quantity is 4,000 but...

Is there a way, when opening a report in print preview, to go to the last page. My report shows transactions by date. When it is more than one page long I would like to open the preview at the last page. I know I could sort the dates in reverse order which would show the most recent records...

Is it possible when print previewing a report to make the preview go to the last page every time? I could simply reverse the date sorting on my report query but that's not really what I want because I still need to print the report in ascending date order. thanks Access 97