Search results

Somehwere in your code you have: Me.cboJobDetailsEndDate.SetFocus Just delete it i presume. ________ Hemi Small Block

There is no need to post twice. :rolleyes: ________ Scripps-booth

Does anyone have a database those does a credit score. :D ________ NO2 REVIEW

Import the data, use a update query that deletes the last three charachters. Then change the field type in the table once everything is done. ________ Kd80

If i knew your option box name i could of used a case select satement, but the below should work, and acCmdUndo is what you were looking for. Private Sub cmdJobDetailsUpdate_Click() Dim booJobOpen As Boolean Dim booJobClose As Boolean Dim strAnswer As String booJobOpen = Me.optJobOpen.Value...

What is so wrong about using 1? ________ Indica strains

There has to be a better way than sending keys, explain what each part is doing, you could probably just use "better" vba to do what you want. ________ Colorado Dispensaries

There are two kinds of strings: variable-length and fixed-length strings. A variable-length string can contain up to approximately 2 billion (2^31) characters. A fixed-length string can contain 1 to approximately 64K (2^16) characters. :D ________ Lincoln Navigator Specifications

Who said anything about being mean. :p ________ Mflb

Private Sub txtACNumber1a_Change() If Len(Me.Me.txtACNumber1a.Value) = 4 Then Me.txtACNumber2a.SetFocus Me.Me.txtACNumber1a.Enabled = Flase End If End Sub Just make it so that when it does equal 4 it moves on and locks it, but if they do move on without you can use a case stament to...

That would work, but what if the staff accidently forgot to add something? ________ On Porn

Doesn't anyone bother to search? :confused: For lazy people-> [Click] For smart people-> [Click] ________ Colorado Dispensaries

What do you have time for? Is the database already created? ________ EASY VAPE REVIEW

Did you miss the recomended read list on this forum as a stick? :confused: http://www.access-programmers.co.uk/forums/showthread.php?t=56711 ________ Moroccan cooking

Private Sub Form_Load() Me.TimerInterval = 3200 DoCmd.Hourglass True End Sub Private Sub Form_Timer() If Me.TimerInterval <> 0 Then Me.TimerInterval = 0 End If DoCmd.Hourglass False DoCmd.Close DoCmd.OpenForm "frmMain" End Sub ________ THINKMILL

Try this out, it should help you: CLICK ME! ________ Jimny

My favorite! ________ Deluxe

Conditional formating is what you need if its continous forms, should work like a charm. Not sure if you can hide it, but i believe you can disable it. ________ Ford del rey

Criteria for DateofBirth: >DateAdd("m", 18, Date()) ________ Learning disorders advice

Im assuming the first password is to "Ok" the compact & repair, cause it could possible be moving data around. The next one could be checking if you really want to close, cause if you do it will delete the ldb file that it created. ________ Ponton