Search results

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

Deleting the link then displayed all the sub form records for every record in the main form, I fixed this by adding the communityID to the query "qrySearch". Just need to get the Search part for the sub forms figured out...

I can't attached the database due to file size restrictions, I have deleted everything that doesn't count including, the main form, copies of the sub forms, these were straight copies with all the fields unbound, deleted most of the records, deleted the embedded bitmaps, ended up deleting the...

I'll try and tell you a bit about the forms and the search. Under Forms, I have a main form, two subforms, a search form based on the main form, and a results form (also based on the main form) which displays the search results, I have also copied the two sub forms and pasted them with search...

Alright, the error message has stopped, you were right about the control name and the subform's name being different. The only thing now is, if I enter some criteria into these sub forms to search by, it seems to skip over it and displays all records of the main form, and leaves the subforms...

Ok now it's got the error message saying it can't find the field 'frmSearchHousing', which is the subform, and when I click debug it highlights the top line of the IF statement. If Left(Forms!frmSearch!frmSearchHousing.Form![Type of housing], 1) = "*" Or...