Search results

Just a note - on your Homepage of your website : Speach & Language Therapy Database Speach is mis-spelt... should be Speech. But I am sure you knew that, right? ;-)

Office 2003

PDF Report Output - Save path I am using a PDF printer driver to generate a PDF copy of a report in my code using : ============================== DoCmd.OpenReport strReportName, acNormal, , strWhere ' output to PDF driver ============================== What I need an answer to is this - Am I...

Thats reassuring - and good to know that this is a known reset - but the fault is a real problem when it is happening more than once a day and seriously affects productivity..!

On occasion and on different machines - I get a recurring fault where the mouse decides to block highlight all rows of a table view of a form. This is not constrained to Access specifically and appears in other Windows apps. as well.... No combination of mouse clicks/ key presses will remove...

Hello i have the following DoCmd proc. call : DoCmd.OpenReport strReportName, PrintMode, , strWhere, , "19000" [The OpenArgs parameter being "19000"] In the corresponding Report_Open event I have: Me.Caption = Me.OpenArgs But, when I run and inspect in the Report : OpenArgs is...

I have re-read Jack MacDonalds handy guide to Security (mentioned above), and I had missed out possibly the most crucial paragraph.... ie. Users of my top-level SUPERUSER group should also be members of the ADMINS group. Only ADMINS group have the in-built permissions to Add/Remove...

This is the manual that I read with interest that got me into this mess in the first place.... I will read AGAIN (with a little less interest, I might add) and hope there is something that I have missed. But what I cant understand with Bob Larsons's earlier posting is - what relevance has...

Thanks - but I already have - it doesnt make any difference....! NOTE : havent you got the shortcut text the wrong way round? - shouldnt it be the application, then the DB, then wrkgrp path????

Nope - that doesnt work. Added the hidden/system tables to the permissions for SUPERUSER / closed and went back in - same thing - user and group add/remove is disabled.....

Yes - I was aware of that. It is unique! Thanks

Thanks for the tips - I did find another posting with a download link for a PDF file with a little more detail on the points that you have raised here - thank you! However, having done all that - I now find that with the Admin group effectively disabled - my SUPERUSER account that is both the...

Hi there! I have an occasional issue with workgroup security, whereby if the network goes down when users are logged in using their workgroup userid /password - the 'network' workgroup MDW file location details are replaced with those for the local copy of SYSTEM.MDW. Subsequently, when the...

Are you able top post sample tables here for us to view / work with....?

Hi - You have allowed for the FromDate being the start date and also in the range between the start and end dates. You dont appear to have allowed for the other scenario where the FromDate may be outside of the start of the range, and so the ToDate needs to be considered to determine if the...

Just curious - have you got 'x' number of records with only 4 rows with the date equal to todays date? My guess is that your SELECT statement is calling GDT() for each and every record in the source table! Hence, you are getting an output of todays Date repeated four times..... where the Dates...

Your data example - can you explain in alittle more detail what the string of letters and number actually is. Is this the result / the figures you have to apply calculations too....?????

Perhaps you can post a copy of your calling query ? - from what you suggest it appears that your query is calling the function 4 times. You will need to define the LSQL string BEFORE opening the recordset though! Also the Date function will need to be defined outside of the quotes : ie...

You will not be able to update a recordset that is composed from two seperate tables, like you have shown since you are using the Group by clause.

Hi I have a database application that records production times against a jobnumber. During production time if an employee makes a c@*k up - the remedial work is booked to a REWORK id. This id is mapped to the original jobnumber. The problem I have is at report time. My report has a sub-report...