Search results

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

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

I have replicated my Access 2002 database and moved a copy to my laptop. (on a wireless network) - so far so good. Here's the problem l can replicate FROM my PC to my LAPTOP - GREAT !!! I can't replicate the other way :confused: My PC is running XP and my laptop is running 2000. Does...

I have secured my database and l have set user access so that two users only have read access. However when l log on as them l can get into the Database although l cannot alter anything (though holding down shift key) and in normal use l can alter fields within my forms and create new "orders"...

I have got my now secure DB replicated (3 times), it replicates fine, however l have to replicate each copy individually. It appears that there is an option to replicate all in the background, however this is greyed out. How do l set it to replicate all copies of itself at the same time (or at...

Might be a stupid question but here goes. I have successfully created my own private workgroup and have set up security levels for 4 users on one access programme that l have written. I have a second access programme that l use with the same users, however l want to set different user...

Firstly, didn't know which discussion to put this in hence in General, hope this isn't a problem. Running Access 2002 My issues are, 1st l have created several replicas of my database and it all works great, however l am having to replicate once for each replica. Although there is a "replicate...

I have built an ACCESS 2003 DB, happy with that, however l now want to create a copy and put this on a remote computer (the only link being internet) and l want the two to replicate. I have followed replication creation and this works fine on my computer (different file locations within my...

I have created a database which needs to contain various items / formulas which are superscripted such as cm³, °C etc etc. Now l can find some of what l need on the character map but in other instances what i need is not there. I have been through the available toolbar buttons but cannot find...

I am trying to create a stock report that shows total stock by product. The problem l have is that as not all my sales are out of stock , l have created a tick box on my order form to denote stock in & stock out, only ticked as appropriate. What l do not seem to be able to sort out is a...

I have ACCESS 2000 running on XP and l have developed a simple sales data dase with drop downs for selecting products and customer details. It works fine on my machine, however l want to run a copy of it on a laptop running ACCESS 2000 on Windows 2000 and have copied the .mdb file onto my...