Search results for query: *

Thanks for the advice; not to au fait with Pivot tables so will need to investigate and see if I can suss out. Thanks Jack

Hi there I am hoping someone can point me in the right direction. I am attempting to pick out the latest salary update/reduction from personnel data - for example Employee Ref Date effective Salary Old Salary 1001 01/04/2011 15000 14000 1001...

Gentlemen Many thanks for all great advice. I am off-site today so I cannot test at moment but I will get back to you ASAP when I have chance. I am sure you have sorted problem. Once again your assistance greatly appreciated. Regards Jack

Trying to replace a date field using following 2 examples and I am getting "function argument value,type or account is invalid". I have SET DATE BRITISH AND SET CENTURY ON. replace it_dteinv with DTOC(05/28/2010) FOR IT_DOC="DOC11320" replace it_dteinv with dtoc(22/06/2010) FOR...

Many thanks for reply. I was asking for a colleague who is au fait with VFP but not SQL. The problem she was having was that the SQL DB was not handling anything else. She was trying to get some accounts data.... She is basically trying to return some data into a dashboard report. i.e. If...

Sorry if this is very basic but I am not sql orientated. I need to put a sql query together I require to say If year = year and month = month return a value if not return zero I hope that makes sense to someone out there Any pointers gratefully received Regards Jack

...save to the share throught a program but if you go into the share and say try to create a new folder you get a message like \\sbsserver\user share\*** does not exist do you want to create it - if you answer yes nothing happens - prompt just reappears. Can access shares from server OK. Net...

Many thanks Gentlemen Both answers a big help. Data aligning now. Many thanks Jack

Hello there I have a spreadsheet with the first 7 columns populated via a data query, 2 additional columns that are manual input, and 6 columns that are product/sum formulae. My problem is that wbenever the sheet is updated and a line is inserted by the query - the formula does not move with...

Hello there I am not to au-fait with this so forgive me if it is really basic. I have taken over a small business and I want all the customers who would have accessed the original business site to be re-directed to mine. Both websites are hosted by different ISP currently. I dont really want...

Many thanks You have saved me a lot of wasted time and effort. I will give DAP a miss as I need a number of drop down options. Whilst googling this I was heading towards a similar conclusion. I was hoping I might be able to let access build the majority of the data access page (which...

nwprog Once again - many thanks even better - whilst I have your attention - I have come across another problem - I have created a couple of list boxes - but when saved as a data access page (htm) they do not show correctly. Are you aware of problem. Jack

Remou Just needed that little prompt to get the old grey matter jump started. Many thanks Jack

Hello there I am using Access 2003 for data front end to a SQL 2005 DB. I am trying to design a 'job card' that will allow users to report faults/request help. What I want to do is Have a Date reported box on the job card Form that will auto input the date reported (linked to the relevant...

Many thanks Gentlemen another step closer to the solution. I will ask the Access gurus for some assistance. Regards Jack

Hello there I am trying to setup a basic SQL DB in SQL 2005 post a sql admin course to enable a little practice. My project is to provide all personnel with a means to report faults/request for assistance. What I need to know is - how can I stop a user from overwriting a record or changing a...

Just to keep you in the picture - I am progressing through MarkArnolds link but have not solved it yet. Will let you know how it goes. For Marc - thanks, I have excluded ALL exchange directories on server - is it wise to exclude all or should it just be the 'real path' and what exactly is that...

Mark Exadmin in IIS. Public showing in IIS but will not connect. Should I recreate - what is best way to go about this? Many thanks Jack

Mark Many thanks for your assistance. I did not do anything from the M: drive but I did look there when I started having problems with the PF. Information store is running and public folder is mounted. Virusscan does not scan m:drive. From outlook - unable to display folders. MS Outlook...

I wonder if any one can point me in the right direction for a problem I am having with Public Folders My public folders are mounted and db files in exchsrvr/mdbdata look fine although I have not use eseutil or isinteg on them yet. From my exchange drive (M) I cannot connect to the Public...