Search results

LOL I love technoids. Give em a problem, even a silly one, and they will find a solution. Thank you. All this just because I had a silly (crazy?) idea to ensure that there was at least one embedded space in the name. But as someone pointed out to me, that would also mean that I could not...

PS: I'd be happy to email you the database if you would like.

I will now tell you of my trial. I'm sure you are right, I am just not understanding. On my form I have two boxes. The left box says "seat_person_nm". the right box says "seat_person_nm". the right box shows the field named seat_person_nm in my database. if I show the property sheet it says...

NEVER MIND: got it fixificatified

or to give a different example, if I start out with a database record with three fields named A, B and C and then after I build my form I change the names to B, C and A respectively, I'll be eternally hozed and should start over? Correct

so to attempt to summarize. If I want it to be as though I started from scratch, then I must start over. ONLY then will the text-name shown in the Property Sheet be the same as the text name in the area of the form displaying values and there is no other way to make them the same except to start...

I have a form. I want to move a field and it's label. I need to unhook it from the other fields or I can't. I found this post on another forum: http://us.generation-nt.com/answer/unlink-objects-form-help-164524811.html It says, in part, When you create your form, before you do anything...

a further follow up if I add a new field to the database and then stick it onto the form how do I get all the naming correct? More and more it seems that the answer is to just start over but before I throw out what I've done and start over, I want to be sure.

Been gone a while and just now back. I will attempt to reply. I am not clear on most of what you said. I will try to say it again. Please understand I am attempting to avoid all technical terms (which have precise/narrow meanings) and use common English terms. When I look in Design view I...

A very interesting thought. Unfortunately it makes handling SOME names more difficult. Robert N. Jones R. Norman Jones R. P. Jones Rev. Robert N. M. I Jones VI (the name of a brother of a friend of mine who's father didn't like the military rules and named his kid with two middle names and a...

Most gracious. I'm not asking my questions well so I will try again being more specific. I have a form. When I look in Design view I can see the label for the field: seat_nm. I can see the Name of the field on the form: seat_nm. But if I look in the Property Sheet the name is still the old...

Thank you for your most kind and gracious effort, alas as I will attempt to explain it is no help. You wrote In the forms/reports you must manually restore the control sources to the (renamed) fields. I have no idea what "manually restore the control sources" means and even less information...

Thank you. I continue on.

As I proceed with my development I continue to rename fields. The effect of those renames is unclear to me. They seem to effect some things and not others. What rules do I need to know about renaming the fields in my database and the effect on the forms I'm working on.

I am now attempting/failing to use the suggestion I have placed the suggested solution InStr(Trim([seat_person])," ")>0 into the "validation rule" I did it wrong as it is not working and rejects everything. Sorry, I do not understand. Could you tell me what I am doing wrong.

found and fixed thanks again

I wrote The desktop icon for the database moves every time I open/close the database requiring that I continually move it back. Is that a design feature or have I done something wrong? The answer was You're automatically Compact/Repairing. Check your options and take that off if you don't...

Thank you. if I were to purchase a book to answer all my questions, which book would you recommend.

I have two numeric fields: num_council and num_council_districts num_council is entered first num_council_districts has this edit: >0 And <="[num_council]" however it stops everything clearly I'm not understanding something basic

this was posted: you need to put the control name in square brackets What is the difference between a field name and a control name? When must names be in square brackets?