Search results

Hey I have a change password validation form. Standard setup with OldPassword, NewPassword, ConfirmNewPassword. In the underlying table the password field is limited to 10 characters. In the form I of course have the textboxes marked as password input mask. I would also like to limit the...

Sorry I do not understand. You need to be able to have design access to the mdb. In my example below I just put the code in a form with two command buttons. One makes it topmost the other takes off topmost. You should be able to customize it to your form easily. Just call OnTop sub from...

FloBob, Test this out. There are of course ways to get around it being on the top but for most part this should work for you. Bleh it is so much harder to do some of this API work in Access than VB. -nate Option Compare Database Option Explicit Private Declare Function SetWindowPos Lib...

If you are using a macro to run the queries in succession you can choose macro option "SetWarnings" and set them to off. Otherwise bring up the Options box. Go to Edit/Find tab and uncheck the box that says Action Queries.

FloBob: I believe the only way to make it the topmost on your desktop is to use API calls. If you are just beginning in your programming I would not suggest using them tho as it can really hork your computer if you do something wrong.

Friggin awesome. Thanks a ton for finding that.

Yes all options in the startup dialog are disabled. As I cannot make an autokeys alt-tab function I guess i will have to check keystrokes in all the forms and see if the alt-tab combo is used. If there is some DB property i am missing that disables this i would love to know. I have scanned...

Sorry i don't have a lot of experience with this but something to try. Change that last statement to SendKeys "password {enter}", True It could be that the sendkeys is processing the {enter} before the text? I don't much care for sendkeys so I am not 100% positive on this but give it a whirl.

You are selecting the records and copying them right? Sorry have to ask i know i mess up that way sometime when getting upset. After you have them copied to the clipboard highlight the first row (blank) in new table. Then paste it in. All should work quite well.

Not really sure how that happened. If you cannot figure it out what we did here as a similar "fix" was: 1. Copy (ctl+c) the old table. 2. Paste the old table and select structure only. 3. Open old table and new table. 4. Select (in your case) records 1 - 79 and then paste them into the new...

Go to Tools | Startup and on the right side you will see "Display Form/Page" select the form from the dropdown that you want to see when the database is launched.

In access 2k you can tab to a control in runtime. Hit ALT-Enter and bring up the property sheet for that control. I have been trying to eliminate the ALT-Enter combo with AutoKeys but it will not allow me to use that combination so now i am very not happy. If anyone has an idea i would be...

Yeah sorry all the menu bars are gone except my custom ones. Shift has been disabled. The company does not want to use workgroups. It is pretty secure except for the possibility that they can open that Property sheet.

Anyway to disable this in Access 2k? I can disable the alt+enter functionality but is there a way for me to lock it down completely. I do not want them to be able to open it and then look through the various autokeys and other macros. Thanks -nate

If InStr(Text1.Value, "-") Then MsgBox "No dang -'s" End If Substitute Text1 with your textbox's name. You can stick this snippet in a command button validation or in the textbox's BeforeUpdate Event.

Sorry Greg i do not know why it would show a number instead of the location like you want. On a side note if you are adding information to this text file rather than creating a new one over and over you will want to open it up "For Append" rather "For Output". "For Output" will overwrite it...

As far as I know you cannot automatically update the form with the new table fields. Access is not going to know that you had field [CompanyName] but now it is going to be known as [CompName]. I would just make sure that this is how your tables are going to be known from here on out and that...

Sub fWriteSomeText(sFileName As String) Open sFileName For Output As #1 Write #1, "bleh some text" Close #1 End Sub As well you can substitute variables to print out as well Sub fWriteSomeText(sFileName As String) dim sCodeListing as String sCodeListing = "bleh some code"...

Check out this link http://www.microsoft.com/AccessDev/Articles/GetzCh10.HTM

Nevermind i was being too complicated. I will just have AutoExec macro do a runcode. Thanks