Search results

When I do that, I get no notification of the inability to insert the record.

RE: [Forms]![webPW]![textEmail] [Forms] tells you it is looking at a form. ![webPW] tells you the name of the form is webPW ![textEmail] tells you the name of the object it is looking at is textEmail. Therefore, you are looking for the text in the object textEmail on the form webPW. My...

That code is correct, assuming each of your variables in it are declared. Morgan

I am tryng to take the records from one table and insert them into another using a recordset and Docmd.RunSQL "INSERT..." I don't want the "You are about to insert 1 row..." so I can use Docmd.SetWarnings False but I DO need to know if the record won't insert due to violating the unique key on...

Great. Thank you both for the help!

OK, any ideas how I would create one that would allow unlimited dollars and only 2 decimals, but would accept any of the following as valid? 1 1.2 1.23 11111111111.2 11111111111.23 I tried #.## but it only allowed 1 dollar number.

The problem with that is if I enter 1.234 it will show 1.23 but MsgBox Me.TxtBox will show 1.234 I need to actually prevent any more than 2 decimals, not just format it so it looks like 2 decimals.

How can I ensure that my user enters a value that would be valid currency? For example, I would accept 1 or 1.2 or 1.23 but not 1.234. If I set the textbox format to Currency, it shows 1.234 as $1.23 but the .text is still 1.234. Thank you!

Thank you, I will give this a try.

Is it possible to change a field name in a table via code?

I have added a TreeView to my form. When I try Me.TreeView. to get the available options, some items that I know work do not appear, such as .Nodes Anybody know why this mught be?

No further explanation required than that...

Hmmm... I deleted the form and created a new one and :D it is working now... Wierd:confused:

3 times.... This only happens in A2K. I have A97 installed also and it works fine.

Glad it worked for you! Too bad I can't type: what does "sabve" mean, anyway? :D

Assuming the form is bound to a table (or query) try: DoCmd.GoToRecord , , acNewRec That should move to a new, blank record and automatically sabve the one you were working on.

I added a button to my form via the wizard. When I got to the end and clicked Finish, I got a "Subscript out of range" error. I was forced to cancel out of the wizard. Now when I try to use the wizard I get the same thing. No big deal you say. Don't use the wizard you say. Well, If I...

Thank you so much!! Once again, you have saved my skin!

How can I either prevent or trap when someone is trying to delete a record using my form by clicking Edit/Delete Record or the red >X on the toolbar? I don't want users deleting records!! Thanks!

Perfect!! Thank you do much! (I know about Date, it was just to keep the example simple...)