Search results

Well, that's a good idea, but my user is a little needy. He wants the cursor to fall into the first 'real' field of the form. What do I do then??

Ok, I tried it. I didn't work. I was still prompted to enter a value. Once I entered a value, then the code worked, just like my original 'cancel' button. I don't know what to do. Here's what I am trying to accomplish: When a user opens that particular screen and they immediately want to...

Thank you everyone. I was in a meeting for the rest of the day on yesterday. I will try the code you sent and give a reply. Merry Christmas! ;))

I tried that. I didn't work.

Once I add an edit check to a required field on a form, how do I escape out of that field, and actually, the entire form by hitting the cancel button. I have noticed that I have to enter bogus data, then hit cancel before I can escape out of the field and/or the entire form itself.

Thanks! ;)

How do you unsplit a database?

How do I copy an existing data structure (not the data itself) from a table into an Excel or Word document for analysis purpose? I can successfully export the table into an Excel or Word document, but it brings over all data entered, which I do not want. I only want the field names in a...

Thank you! I will try this and let you know how it turns out. ;)

Hi. Can someone help me write the following code that works in FoxPro for Access: FINDME="42002" SELECT *; FROM uidata; WHERE ex1quart + EX1YEAR = FINDME ; OR ex2quart + ex2year = FINDME ; OR ex3quart + ex3year = FINDME ; OR ex4quart + ex4year = FINDME ; OR ex5quart + ex5year = FINDME ...

I am trying to. "User and Group Permissions". I chose the user and Identified what forms and reports they can access. I made sure they could not access tables or queries. But how do I create they own password?

I have created user groups and their rights, but I cannot seem to create a single user login and password. What did I do wrong? Thanks,

Here's the problem: I've created a cascading combo box and it works great! I bound the 2nd combo box to the field "county" in the table that is controlling the form. If I don't bound the county field, it will not keep the value selected. But when I bound the field, it still will not keep the...

Would you walk me through in setting that up. I am unsure as to how I would do that whereby it will ONLY show up on a report.

I think Batman's answer is close to what I am looking for. I'm not concern with the values stored in the tables. I am only concerned with the ones printed on the actual report, which should reflect 'apples', not '1'. How do I write code to show on report to specify 'apples' vs '1'? thanks, ;)

Here's an easy one? How do you define a value chosen from a check box? Example: If I had 3 checkboxes in my form and someone chose the 1st one for apples, how do I show 'apples' in my table instead of '1'? Thanks

I've already setup many edit masks and it works. How would I turn off the system error message and use my own?

But that will allow for any 3 character input, whether alpha or numberic ... correct?

I think this may be an easy question: In addition to validating a text field to ensure that a 3-digit number is entered, I also need to reject any alpha characters. Can I perform data validation on a numberic field? Please help. Here's my code: Private Sub Provider_Code_BeforeUpdate(Cancel...

You guys are cute! Is it that indepth to assign a button to cancel anything that was keyed in a form that also contains many required fields? Also, let's add fuel to fire: How can I disable functions while they are entering data, such as, advancing to the next record accidently? Isn't this...