Search results

Thanks Tony...this should get me started.

Hi there, I did some searching in the forums, but couldn't find anything on this issue. Does anybody know if I can search from my access database into a directory of word files and search each file for keywords? I'm thinking if the keyword is in the document I would check off a field in the...

Hi there, I need to use the createfield method which I can do, but I'm having a problem dynamically naming the fields based on users form input. Does anyone know if this is possible? Basically I have a form with a date range (2000-2005) specified by the user and when I run the report I need...

Hi Pat, Thanks for your response. The ProjectOfficer is in a column on the form I'm opening(frmGrantInfo) and is already showing in a control. I don't want the form to open at all if the CurrentUser is not the Project officer for the frmGrantInfo. Basically I have a number of ProjectOfficers...

Thanks Pat. I'm going to have refer to a DAO.Recordset field because the user will be opening the form base on a different Field (GrantTitle) not the Project Officer. So I'll have to query out the record for the selected GrantTitle then check the Grant's ProjectOfficer against the CurrentUser...

Thanks Pat, So I'll have to use "CurrentUser" in my code? If I want a Project Officer to only see data that he/she's the project officer for I would have something along the lines of this.... If CurrrentUser = rst0![ProjectOfficer] then DoCmd.OpenForm Else msgbox "You do not have...

Hi, I searched the forum, but I didn't find anything on this. Is there a way to get record specific security with Access. I don't think there is, but wanted to know if anyone knew for sure. Thanks, Full Williams

Rich, Thanks for the response. Is this a different method compared to the Debug.Print method? Also I figured out my problem if anyone's following this thread. I only wanted to check the specific tab's controls for changes so I had to specify by doing this: Dim pge As Page Set pge =...

This might be a silly question, but how do you get the Debug.Print "Texbox " & ctl.Name to actually show up on your screen? It's not doing anything for me right now. So I can't figure out which control is giving me the problem. Thanks, Full Williams

Okay I solved the Name issue, at least I think I did. Now is getting caught up on an AutoNumber field. I'm trying to workaround this by using an If Then to identify the control, but it's not working. Any ideas on how to identify a control. ctl.Name = X doesn't seem to work. Full Williams

Mailman, Thanks for the response. Good point on taking out the extra code. The code is now actually stopping on a textbox control which has an expression that can't be edited. The expression is combining FName and LName. I'm getting closer, any other thoughts. Thanks for your input...

Hi, I'm getting "Run time error '3251' Operation is not supported for this type of object" on the: If ctl.Value <> ctl.oldValue then line. I'm asking the user if he/she wants to keep the changes made to the form. If not then replace the changes with the old value. This code was working...

Thanks Travis. Got it to work. Had to take out the rst1.update as well. I think with ADODB you need the .edit and .update just not with DAO. Thanks again, Full Williams

Hey there, Can someone take a look at my code and let me know if they see anything wrong. I'm getting a message that says: "Update or CancelUpdate without AddNew or Edit" Here's my code: Set db = CurrentDb Set rst1 = db.OpenRecordset("tblTable", dbOpenDynaset)...

I usually create a report that has all the info on the form in it and add a "Print" button to the form for the user to print out the report. Not sure if this is what you're looking for, but it's always worked for me.

Autoeng, You might have to copy and paste the link into your browser. If that doesn't work let me know your email address and I'll send it to you. Full Williams

I was having problems getting my database secured, so I was going to join that SECURE.mdw file that was on the shared drive so that anyone that attempted to open that database through Windows Explorer or File-->Open in Access on the users machine would get prompted for a password. I know this...

No I haven't. Since I'm able to access the database through a security shortcut I've put this issue on the backburner. I think my first step might be to reinstall Access. Do you have any ideas? Full Williams

Okay got this to work finally! For those that are following this, the reason for importing all the objects into a new database is so that the Database Owner is not the Admin anymore. That did the trick for me. I found an interesting document breaking down Access Security for those looking to...

So I found this on MS support site: http://support.microsoft.com/default.aspx?scid=%2fsupport%2faccess%2fcontent%2fsecfaq.asp#_Toc493299709 Microsoft Access 97 and Microsoft Access 2000: The Security Wizard is supposed to remove the Open/Run permission from the Users group, but fails to do so...