Search results

spikepl - As I am new to the world of Access I tend to do things the 'brute force' way. If you can show me a more elegant way to search my database I would certainly be interested in what such a query would look like. Thx.

Galaxiom - Not sure what that means. Actually I capture a total of 20 fields of information on my Detail Record form (including the five plant names) and I created a 21st field where I concatenate all 20 fields into this one 'super' field. Bob Larson showed me how to do a string search on...

gemma-the-husky - I like to use my own navigation buttons because I often do more than just go to the Next or Previous record. For example, the user can select up to five plant names each with its own field/dropdown box. Before I save the record I concatenate all five names into a sixth field...

Thanks again for all of your suggestions - they worked perfectly! I even figured that there must be a 'Locked' keyword and was able to lock all of the fields on my Record Detail Form so users with Read-only access could view the data. This saved me from having to create a separate Form for...

Great tips, thx! I will certainly give them a try and let you know what I find.

missinglinq - Great, thanks, can't wait to try it on Monday. Is there a way though to actually hide a command button on a Form (make the "Visible" property = "No")? I have a Form which allows users to Add, Change and Delete records but I want to limit these actions depending on the user. It...

Hello, I’m sure this must be a common problem but I can’t seem to find a simple solution… I created a Form to display the record details of a Query. I have four command buttons (First Record, Next Record, Prev Record, Last Record) to scroll through the records. The problem is when the EOF is...

missinglinq - Thanks for the tip. I am an old COBOL programmer from the 90's and always appreciate a good tip or trick. I am constantly amazed at how versatile and robust Access is. My next task is to link each detail record to a jpg photo. I have some ideas I want to try but if they don't pan...

Thank you all for your help and info. The SaveRecord command worked perfectly and I was even able to insert the command into the Macro which opens the DetailRecordForm (so I did not even have to write a VB program). Also, FYI, I did get the Form.Requery command to work. I was originally coding...

Ken - Interesting, I am still learning Access so please bear with me. I am trying to avoid closing the Form, will this command work if I keep the Form open? Also, the Form lists about 25 records, how will it know which record to save? I will give this a try and let you know what happens. Thx.

Hello, I created a Tabular Form (called TabRecordForm) which consists of seven columns of data. I locked the last six columns so that the only column the user can modify is a check-box field in the first column. The idea is the user checks the records he wants to display and then clicks a...

CBrighton - Sorry for taking so long to get back to you but I just wanted to tell you that DoCmd.OpenForm statement working perfectly! I pass a 'SelectBy' and a 'SortBy' parameter to a Module and then depending on the combination of these variables I open the Form with the appropriate...

CBrighton - Thanks for the tip, I will give it a try. I am not doing anything fancy, all of the filters (queries) have already been created, its just a question of which one I want to open the Form with depending on a passed parameter. I can use the 'Macro language' method I explained before...

I created a Form which I want to open with one of four different filters (depending on how I want the data to be sorted). I also created a generic filter (called ‘FilterForm‘) which I will always use to open the Form. I want to create a Module to replace FilterForm with one of the four sort...

G37Sam - I was thinking of writing a Module to delete the record but figured Access might just have a switch to turn off the 'Add'. The DeleteQuery would work better than the Module, thanks for your help.

Hello, I created a Form to add records to a Table (Data Mode = 'Add'). After I open the Form (using the 'OpenForm' command) I intialize several fields and I have a 'SaveRecord' Command Button to save the records. My problem is if a user opens the Form and then immediately exits (using the...

vapid2323 - Actually I was running the query from a Macro (not a Module) but found the 'SetWarnings' keyword (which I set to 'No') and inserted it just above the 'OpenQuery' keyword and it worked perfectly. Thanks for the help!

I created a simple update query which I run from a command button on a form. When I click on the button I get prompted by two Access msgboxes saying that I am about to update records and I have to click 'Yes' on both msgboxes before the query runs (which is rather annoying). Is it possible to...

Bob - Defining the field as Variant seems to have done the trick, thanks for your help!

I have a ComboBox on a form which shows a list of valid names. After a name is selected I run a Macro (using the ‘AfterUpdate’ option) which in turn passes the name to a Module for further processing. If a name is selected from the list everything works fine but I have some users who use the...