Recent content by snakeyes2002

r u attempting to add a third "N/A" value to a combo box, if so.. put.. SELECT table.fieldname FROM table UNION SELECT "N/A" AS BOGUS FROM table; in the rowsource of the combo box, replacing table with the table name and fieldname with the fieldname. else if you're attempting to show this...

i may be wrong here - just thinking: each file runs independently but more than one cannot run... em does some process lock the folder for access when either DSN is running? i'll see if i can recreate it... and get back...

Been a few days :D I'm back. I decided after a lot of further research into why I need to connect using ADo/DAO and why I need to use Excel. I created a new Microsoft Access Database with a connection to SQL Server - as in the relinker code before. Except I now connect READONLY! It was just...

are you attempting to attach multiple attachments on an email, depending on which items are selected in a listbox? i know how to do this, but only using outlook as a mailing program

wot i am trying to do may require me to use ADO 2.5 i think, rather than DAO to connect to SQL server. ADO, i think, has better options when extracting data and for entering passwords, however, I am still stuck as to how to specify a userid and password automatically without prompting the user...

make table queries? i have attempted this in the past with other database systems and i understand how it works. i will attempt it in work today and update. Before trying, i think SQL server will ask for a password anyway, given the track record. i will also bring back most of the code i use...

tried Dlookup? stTemp = DLookup("LocationName", "[tblLocation]","[LocationID]=" & lnLocationID) look up a table called tbllocation and return the value of LocationName where the LocationID = lnLocationID or use sql - i'll need more info to help further

during my research into the ways that the data can be used, and from what application a few ideas came to mind i thought about and actually designed a system that would use Access to export and manipulate Excel in the same way, however, due to the amount of information and the sensitivity of...

oops, i went a wee bit mad there - off on a tangent. were security is concerned - password security should be fine - i dont use any (any of the users using my system wouldn't have a clue how to delete a record, never mind a line of code) but, that's just my opinion. i'll look into some other...

maybe more work with a large company (Alfred McAlpine PLC) 4500 employees - i'll ask - no guarantees - for your link on the IT page. may be helpful

i'll help whenever i can first thing, great forum - massive archive of data! just joined today after visting several times, doN a search, finding an answer and *&^%ing off now that i have joined, the benefits are clear - another user replied with 30mins of first post -and although i am still...

on another note - do you trust the users of your database? or everyone that has access to it?

i take it that you have designed a front-end, back-end system? Your first database (back-end) contains all the data? and is protected with a password? and is on a network drive away from prying eyes? your front end (user database) looks at backend data using password? returns data...

The code in my mdb, the Relinker() to be specific took me months to create. On Startup, the Relinker code runs by: 1) checking the linked tables in the database 2) deleting all linked tables 3) look at the windows xp registry to check username and password for authentication (the password is...

ha ha ha is everybody in here so quick...! :D