Search results

OoRah! Fizzio! Much obliged!

1. I use the following to enter comments into a field and have it feed over to a locked field. User's enter comments in the response field, the comments feed over to the history field where it's stored and displayed in chronological order. The comments in the response field are then deleted...

Thanks, Fizzio; At this point, I only need it to read the table, but I've also been looking for a way to perform the second option. This would give me the "hotword" functionality I described above. But I haven't gotten that far yet. If you can recommend something to do that, I'd gratefully...

I managed to do this lsat night, so if you would like more data in addition to DBL's sample, feel free to email me. Stephen [This message has been edited by StephenB (edited 05-10-2002).]

Sure thing, I've put you in my address book. If you don't hear from me in a while, drop a note. And if you come up with anything that works, please let me know. Stephen

Thanks for responding, Fizzio. What I mean by "reading a table" is this: currently, using the code (above in the first entry), I'm able to make field A change back color when field B is populated with my name (Black, Stephen). Ideally, I would like to replace "Black, Stephen" in the above...

Silly Question: Have you set the "Multi Row" property on the tab control to "Yes"?

My apologies, Lissy. I had forgotten you were using a command button. I haven't had much of a need for passwords, so I haven't used any of the security wizards in the past. I just used created a database password on a db and the text was displayed with asterisks. The input property is on the...

Sorry, I haven't got the specific code you need right now. I'm working on something similar myself (regarding conditional formatting) and I've learned the code I have so far by trial and error. When I accomplish what I'm trying, I can email you if you like.

Go into design, Double-Click the field where you enter the password ( or click on the field and click the "Properties" icon on the toolbar.) Once properties is open, click on the all tab, "Input Mask should be the fifth field property down. Click at the end of the property field for Input Mask...

What version of Access are you working in?

Still hoping someone can offer some advice on the above, however since I'm starting off with small amounts of data, I'm willing to add other names along with mine onto the code. I'm willing to add "Doe, John" to: If Me.[Submitter] = "Black, Stephen" Then Problem is I can't figure that one out...

Thanks, Audrey. Sorting in design worked like a charm. Thanks, again. Stephen

I have form frm_qry_tbl_survey that's based on qry_tbl_surveys which is primarily based on tbl_surveys. tbl_survey has field [physicians] which is set as a combo box that pulls a list from tbl_physicians. The field feeds through the query onto the form. I have set tbl_physicians to sort the...

I'm trying to get the backcolor on a field to change in response to an entry on another field. I have [Date_Submitted] set to change to red when [Submitter} is "Stephen Black", else [Date_Submitted] is green. (This may not make sense, but I don't have the db I'm going to use this on ready, so...

Elana; Thanks for the tip. Is "Database Normalization" and in depth topic or is there somewhere you can recommend I look for information. As you can probably tell, I've learn Access piecemeal and wouldn't mind learning more about the topic. I'm also interested in why it's not a good idea to...

Elana: The name of the control source is [AVG]. That's the name of the field on the table as well. Chris: Thanks! I looked up fieldsize properties on Microsoft help and changed the field size to "Single". I'm getting the correct returns. Jack: The Microsoft article was very good. It...

I have five fields on a form called [A], [b], [c], [d] and [AVG]. I would like [AVG] to be the average of the four other fields. I using "[AVG]=[A]+[b]+[c]+[d]/4". However, that's rounding the answer up to whole numbers even though I have both the table and form fields set to "Decimal: 2" on...

How about using tab order? Set the tab order to default to a locked field first (like the record number) and the user will have to tab into the one field they can edit. Also, if you have room and feel that another field won't clutter your form, you can add an unbound field for today's date...

I'm almost positive that I've seen a posting on using task scheduler to start access and email a report at a certain time of day. Does this sound familar to anyone or can anyone give me some advice on how to do it? I've been serching for hours for this posting and I can't find it. I...