Search results for query: *

Hi I would like to create a simple database that can store links to scanned copies of a document (in PDF format). I would like the users to select the document from a database form and then it can be printed but with a 'watermark' that contains one of the database fields (batch number). I'm...

Hi - OK I found a solution: First delcare the external dll: Public Declare Function LogonUser Lib "advapi32.dll" Alias "LogonUserA" (ByVal lpszUsername As String, ByVal lpszDomain As String, ByVal lpszPassword As String, ByVal dwLogonType As Integer, ByVal dwLogonProvider As Integer, ByRef...

Thanks Remou That worked great! (Didnt decrease the filesize as I read about on a few posts after your tip - but it worked and that thats all I needed!!)

Hi, Im trying to develop an application (database) for use on a common / shared PC where I need the application to be able to check (authenticate) a user based on their windows username and password without each user loggin on and off every time. i.e. the PC is logged with either user A or a...

Hi, I have a 'typical' access database in FE/BE style with some basic VBA coding for form buttons and a few precedures and functions in a module called Public_functions. I have (obviosuly) made many changes in the code over the development phase without any issues. Now I want to add a few lines...

Hi is is possible to disable the start-up warning message that a database is read only? I have the usual front/backend with security perssions set so that the user cant accidently delete the front end - but this means that on opening the database the default 'read only' message and beep occurs...

Hi Hap007 Thanks - will give that a go.

Hi, I have a somewhat similar situation, I have done 1,2,4,5 along with stopping people pressing shift at start/up etc. However just did a bit of playing and realised that I can just open up excel, go to Data, import data, new DB query then point it to either the MDE or backend and edit all of...

Hi Ray, thanks for that The reason I wanted to check the username & password again is so that in areas where there is a shared PC, like in a laboratory there are often several users who might need to access the database but not want log out of windows and log back in first (due to running other...

Hi, Is it possible to use the logonuser call in advapi32.dll just to check that a username and password are valid. I want to allow access to a database on a shared PC by simply 'asking' windows if the username and password are correct. I dont want to do any impersonation or anything just...

Hi PH I didnt explain myself well - sorry! I need each row of the recordset to calculate the average of the last 25 records - so for record 50, its calculates the average of records 26 to 50, for record 51, it calculates the average of records 27 to 51 and so on. Easy in Excel but how can I...

Hi, I need a query to find the running average and running Standard Deviation of one of the fields of the last 25 records in a table. Is this possible? I though that I could create a query to seqentially number the records (somehow?) then link that to a query that has the criteria (<= No and...

Hi I also have this problem - I know what is causing it, but not how to solve it! If you look at the linked table in Design mode you will see (I beleive) that that field is a number field when it should be text - hence anything Access cant convert to a number gives the error. What I dont know...

Hi Ph Thanks. How would I include that code on the data access page or in the HTML code of the page?

Hi, I'm trying to write a data access page that includes data related to the current logged on user. I have a combobox that pulls data from a query that uses the Environ("username") i.e. the query in SQL view is: SELECT Personnel.Manager FROM Personnel WHERE...

Hi Vector I have managed to sort the problem, dont know how but it works. I uninstalled the OWC 10 that I downloaded from the web and installed a copy from an Office XP CD instead - this now works fine. Maybe you can try the same.

Hi PVS/4946 - Thanks I have tried both OWC10 and OWC11 and MDAC2.8 and am using IE6. Any other suggestions?

Hi Mike thanks for the help. I created the database in 2002 with a grouped data access page for data entry. Then I linked this page to a copy of the same database converted to 2000 and it all works fine on a system with 2002 installed but on a system with 2000, I get the following message...

Hi - on reading the help files, it seems to suggest that you can use an Access 2000 web page on a system with Access 2000 but that you wont be able to edit the design in Access 2000 (that would be OK for what I want). I have tried this though and cant seem to get it to work - even after...

Hi I have a very similar problem that I would like some advice on. I have used some VB code and the sendobject function to send a notification email (no attachment, just a title) and have the same problem, once one mail is sent, Access wont send any more without exiting the database and...