Search results

I've just tried to simplify it and it still doesnt' work...I tried: StoreID.Value=cmbStoreID.Column(0) and it still breaks....

Thanks for the reply! I have tried this: Private Sub cmbStoreID_LostFocus() DoCmd.RunSQL ("UPDATE tblMasterEvaluations SET (StoreID = '" & cmbStoreID.Column(0) & "')") End Sub everytime I try to test it, it wants to close / repair my database...any ideas why?

Is it possible to update 3 fields from one drop down box? the drop down box's sql is as follows: SELECT [tblCurrentRoute].[KFC ID], [tblCurrentRoute].[PERIOD/MONTH], [tblCurrentRoute].[PK ID] FROM [tblCurrentRoute] I would like to update the following fields on tblMasterEvaluations...

awesome link!! That made it exactly what I needed (A00000)...and, i bookmarked it. Thanks!

blarg! I was just told that it is different now (gotta love it!!) Now it need it to be at least 6 characters and no more than 7 characters. Any idea on how to do this one?

answered my own question...I made the windows border style set to none nad it works just fine..thanks!

If you set your form properties for pop-up and modal to 'Yes' then the user won't be able to use the right click and close...this works well. However, it opens up too big (or too long) as the bottom of the form is underneath the taskbar of my machine...any ideas on how to get it to be the size...

I figured this one out...Just did <99.99 (i'll probably chagne that) but it worked. Thanks!

Perfect! Thanks a Ton!!!

I had a similar question answered by using the input mask; however, it won't work for this one (money field) I wish to have a validation rule that shows the dollar amount can NOT be more than 99.99 (or, 2 digits for dollar, 2 digits for cent) How would I go about doing this? Is there anothe...

That works our perfectly! Now, how do I get teh focus upon entering in the text box to be on the left hadn side? currently, it is on the right and the user has to click Home or left arrow to get to the beginning.

I have a text field that is entered in by my users...it has to be a letter followed by 6 numbers...how do I go about ensuring this is entered in correctly in the validation rule portion of the text box?

That code is over my head unfortunately...what would I do with it? would I put it on every form I wanted this to happen to at the top? What would I say to tell it to disable the right click / close feature? If they close the form, then I want whatever data they entered in the form to be...

I searched teh forums and only found disable right clicking for menu shortcuts...I wish to disable the right click on the taskbar of windows (next to start key) and disable that close function...basically, I only want the database able to be closed unless my close databaes button is pushed. I...

Is there a way to disable the option to right click on the database (on the taskbar) and then select close? I want the only way to close out of the program to be if they click my close button which I have made.

Perfect...absolutely perfect. I can't see any reason why the user would enter in dummy null data now... i think I have all angles covered :) database X is disabled form X is disabled upon closing database, it cancels what they did (for accidental openings / enterings) upon submitting it adds...

Perfect!! I think I am just going to do dissalow the close form option and add that code so only way they can close the form is to cancel what tehy put in..perfect!! Now, one last chance they have to close the form without updating is if they close access in general...is it possible to remove...

I am actually now looking for something a little further with this code....Now, I have disabled the close button and have placed a command button on the form to close. Its labled (cancel and exit)...so, what i wish to do is cancel any data that has been entered in the form thus so far. The...

that works perfect! Thanks! This along with not allowing the form to be closed (unless I click a button to close it) works perfectly...thanks!

I have a simple data entry form...when the user enters in something and tabs to the next field, it automatically adds the data into that field. Is it possible to dissalow or turn this automatic update off? I ultimately want the user to complete the whole form, then click submit. At that point...