Search results

I got it.. http://support.microsoft.com/default.aspx?scid=kb;en-us;Q236878

I didnt find answer to my question!.. Hope someone here can help.. I just added security to my access application... I have added a new user and gave all admin rights. Removed all permissions from Admin and Admins group. When I log on as this new user who is equivalent of Admin, I am able to...

Am I invisible ? Sometimes I wonder if I am invisible... I hardly get any replies to my queries here.. Can Anyone help?! Thanks :)

I have Access 2003 and I am trying secure my database. I read thru the posts in this forum and I created a new mdw file and new id..I gave this new id all the powers of Admin, so that I can take away all the powers from Admin user and Admins Group...but I am unable to change owner for the...

I have Access 2003 and I am trying secure my database. I read thru the posts in this forum and I created a new mdw file and new id..I gave this new id all the powers of Admin, so that I can take away all the powers from Admin user and Admins Group...but I am unable to change owner for the...

Hi all.. I have Access 2003 and my database is in 2002 -2003 format. MDE created using this DB is not working in a computer that has access 2002. It says something like 'Visual basic compile problems'.. Anyone experienced this problem? Thanks

The parameter you pass to FindFirst is a 'WHERE CLAUSE' without 'WHERE'.. so you can have 'last_name = lastname_TB and first_name = Firstname_TB'

We can only hope if KeithIT can come up with some solution to this problem. See KeithIT/my post in "Code Repository" category. Somewhere I found a suggestion to use AppendDocLink. It sounds like it may work. But I dont know how to use it. I tried but it didnt work. Thanks

Did you find answer to your question.. ghudson..I searched everywhere for help in sending a document link via lotus notes..no luck so far..I noticed that you asked this question 3 years ago..Did you find answer to your question. If So, can you please post it in the forum? Thanks

Hi All.. I am trying to use the piece of code that Keith(Thanks to Keith) had put in this forum that sends email via lotus notes. I can send attachments using his code. Can I send a link to a file via email ? I have a complete path to a file in my shared drive as follows "\\abcdef\xyz\_ABC...

Does anyone know if it is possible to send an email when a button is clicked?

Can Anyone help me! I am really stuck..I am not an access programmer..but trying to be one. In the above code what I am trying to do is, before adding or updating a record, I am checking if the record exists in the table. For that I am using FindFirst method of Recordset object. To create a...

Please see my code below: Set dbDOCS = OpenDatabase("\\xyzabce\abcd\myjobs\test_be.mdb") Doc_sql = "Select * from DOCS" Set doc_rst = dbDOCS.OpenRecordset(Doc_sql, dbOpenDynaset) DOCS_TYPE_strFind = " DocType = '" & DocsType_CB.Value & "'" DOCS_TYPE_rst.FindFirst DOCS_TYPE_strFind How do you...

SJ.. I am not an ACCESS expert..I only started programming access 2 weeks ago..I just found in the help and I thought I will need to open the database before I use it. So, I might be wrong. please tell me how I should do it. Thanks very much.

This is the code I have in OPEN FORM; I have the similiar code in all of my forms. Is it correct? Set dbDOCS = OpenDatabase("\\xyzabce\abcd\myjobs\test_be.mdb") Doc_sql = "Select * from DOCS" Set doc_rst = dbDOCS.OpenRecordset(Doc_sql, dbOpenDynaset) Thanks

This is what I am trying to do: I have backend in my shared drive and front end in my workstation. Front end database links to tables in backend database in Shared drive. Dont I have to use opendatabase ? Thanks

What is the best place to have opendatabase statement ? Currently I have opendatabase in all of my forms. I dont have any modules in my application. I am new to access programming. Is module really necessary in an application? If I can put the opendatabase statement in one place, it will be...

I have Access 2003 in my computer and I have developed an application which I want to share with my co-workers. But they have only Access 2000. Since MDE is only in 2003, I had to convert my 2003 application to 2000. Is there a way to secure 2000 application? I dont want anyone to change my...

Thank you Wayne..I think I didnt explain my problem properly. I had an INSERT SQL with this DATE field. When the date field is not entered then it has null and SQL fails. Now I have two SQL's one with DATE field, one without. So, I am OK now. Thanks anyways.

Hi all.. I have a DATE/TIME field in a table. I want this field to be optional. But when I try to insert a record without a date value for this field, the SQL fails. How do I fix that ? Also I want to display this field only if there is a valid date...How can I do that? Thanks in advance..