Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. paulfenwick

    Printing PDF documents with a 'watermark' from access

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

    Determine if user is vaild without logon to windows again

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

    Runtime memory error

    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!!)
  4. paulfenwick

    Determine if user is vaild without logon to windows again

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

    Runtime memory error

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

    Disable start-up warning

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

    Is this a reasonable strategy for protecting the database?

    Hi Hap007 Thanks - will give that a go.
  8. paulfenwick

    Is this a reasonable strategy for protecting the database?

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

    Checking the credentials of users using windows (logonuser)

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

    Checking the credentials of users using windows (logonuser)

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

    Average and SD of last 25 records

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

    Average and SD of last 25 records

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

    #Num!

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

    How to use Environ function in data access pages

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

    How to use Environ function in data access pages

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

    Using Access 2002 web data pages in Access 2000

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

    Using Access 2002 web data pages in Access 2000

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

    Using Access 2002 web data pages in Access 2000

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

    Using Access 2002 web data pages in Access 2000

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

    SendObject Macro - Access 2000

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

Part and Inventory Search

Back
Top