Recent content by Andy B

Guys, Got it sorted after messing about and i came up with =Max(IIf([sumofstocka]<0,Null,[ShipDate])) and it WORKS !!! Might not be the most eligant solution but got there in the end. Thanks for all of your help. Andy B

thanks for advising it it would work in a query but i am trying to set it up in a Subtotal section on a report, ideally as an expresssion. I am running SQL on the subtotal section to hide the section all together if the stock level is zero as follows: Private Sub GroupFooter0_Format(Cancel As...

Ok the reason i was confused about the SQL is because for this operation i was using the exprssion builder and putting the formual directly into the property sheet. As a subtotal in a report picking the last date was OK, the MAX function gave me this, but i want the alst date stock went in...

sorry to be a bit thick whats my SQL ?

Producing a report that shows stock in and out, i have set up subtotals to record the actual amount of stock, and i want to show the last date of the stock in. Now i have used MAX date but that shows the last transaction ( which could be an out not an in). As the outs are minus and the ins are...

Vba Conditional Formatting Problem I think i have sorted out part of the problem, but this has left me with other problems. After a bit of messing about i got the forecolor variable to work. Obviously when it wasn't letting me have this option it was because it did not think it appropriate...

Vba Conditional Formatting Problem Tommy, Thanks for your reply, however I think I may have mislead you a bit. the problem is not the code for the colour but the actual word "forecolor" or "backcolor". VBA does not want to accept this as a known variable. Hence my problem. I have read that...

OK my problem is as follows, I am using Access 2003 and i am running a form which already uses the 3 available conditional format options. I have read on the forum about VBA conditional formatting and this didnt seem to be to bad. However i have used the available code , but VBA is telling...

I have created my database and got replication working and to that end l am very happy with the results. THe only bug is that if l Syncronise (master) to replicants (lets call this pushing) the system all works great. However if a replicant synconises with me (pulling) then their system slows...

I have created a master & replicas and sorted out synchronisation across a VPN and overall l am very happy with what l have achieved (lots of thanks to to help l have received todate from this forum that has made that posssible). I now have a couple of questions which are niggles rather than...

I have set up my security on my DB and all is well, however on my read only permissions when you enter the DB the main form is exactly correct (ie read only and cannot be modified) however you enter a second form through this first one , but the second form is fully editable even though the...

Replication Query Thank you so much !!!!! What it turned out to be is that a tick box to allow network users to modify my file has to be ticked and it all worked. It so easy when you know how !!!!! Thanks again Andy B :D

Replication Query With regards to rights - could you please explain ? I do not understand what you are alluding too. THe situation is l am the author of the DB and have full admin rights it is my laptop and l am logging in as me when l access the DB. Does this cover the rights issue or is...

replcation query Len, I think you have got the wrong end of the stick according to all l have read repication / synchronising is a twl way system that allows either the master or rteplica to update any others within the replica set. The only advantage the master has is its ability to allow...

Replication Query Sorry bad terminology on my part. I am talking about Synchronising, i can synchronise form master to replica - PC (XP) to Laptop (MS2000) but not the other way around. I am completely baffled. AndyB