Recent content by BAzZ

Your right ChrisO!! I haven't used Access for about 4 years now, and I don't even remember which database that was from! Sorry JPM :(

Excellent! Thanks for that, something so simple, and bleeding obvious! Cheers (again!)

when i run the following off the click event of a button, I get a "Enter Parameter Value" dialog box with the value of "me.txtTypeOfArea" followed by the input text field. strSQLInsert = "INSERT INTO tblAreaTypeLookup ([txtTypeOfArea]) VALUES ([" & Me.txtAddTypeOfArea.Value & "]);"...

yep your right! in the VBA window, you need to add reference to the "Microsoft Word xx.x Object Library" (xx.x = Version of Word i.e. 10.0) (Tools->References...) Hope it helps.

Thanks for the reply Wayne, The purpose of it was to List staff members, in an easy to view list, and with the functionality of adding/deleting as needed. the staff members aren't really a major part of the DB, they are only in a lookup table for a combo box, i was trying to design a user...

Create a Word Template, with bookmarks in it (Insert->Bookmarks). The bookmarks are the place holders for the data from the database. e.g. If you want to insert someones first name create a bookmark called "FirstName" this will then get "txtFirstName" from the database. Save the template in the...

I have a form with 1 listbox, this is based on a table, with 1 field in it. what do i need to do, to be able to add and remove items from this listbox! Also with the removing part of it, removing many rows at once would be good aswell! Any help would be muchly appreciated.

that was it :) I new it must have been fairly straight forward. Cheers!

Hi All, I have a form that when loads, runs some VBA on the "On Current" event. Some of that code, fills in text boxes, with concatenated (?) strings. So every time I use the record selector and get to the end of all the records, the "On Current" fires adds the concatenated string (even if it's...

OK Wayne thank you so much for your help, I have it working the way I need! It's people like you that keep me coming back to this place, there is such a wealth of information! Cheers until next time BAzZ

Sorry WayneRyan my last message was misleading, I have set it up (from your last post) to open the forms as ReadOnly for Users, but how do I change the OpenForm Method for the 3 Editors who will need to Add/Modify Data? Thanks

Ahhhh, I understand now :o , I would like the forms to open in ReadOnly mode as the default behaviour, so there is no "login" for users, but I would like to go with what I said in my last post about having a button for the Editors/Admins to "login" and be in Edit mode, any suggestions on the way...

I'm not sure if we are on the same wave length, are you talking about Active Directory groups, that's what i was talking about, but after testing it having a readonly person access the database makes the file readonly for everyone. Is there another way to setup security, again staying away from...

I've created a form to search my database using the Query by Form Using Dynamic QueryDef. Everything is working fine, except... I want to setup file and folder permissions to let a group of Editors to "Edit" the records and everyone else to just have read permissions. I have this working up...

Hi, I was wondering if any one has used the "Query by Form Using Dynamic Query Def" (MS KBA 210242) to create a search form, which searches the main form and a subform within the main form. Currently it works fine to search the Main form, but if I put any criteria into the sub forms to search...