Recent content by Tony

Works AWESOME! Thanks PBaldy!!! R, Tony

Request some assistance, I created a button with the following vba action statement Private Sub Refreshtxttrig_Click() DoCmd.RunSQL "drop table [Table Name]" Exit_CmdImportExcel_Click: End Sub (This statement deletes a specific table within access.) It works well, except when the Table...

JANR, It worked! Thank you very much for the input. R, Tony :)

Thanks guys for the quick responses. I've tried inserting the expression in the format section of the properties sheet, as well as the the criteria section of the querry table, but no results. Could you talk me through the steps of how I would apply these expressions? Thanks again for...

I'm currently having trouble with the Cdate(expression). I don't quite understand how to apply it. I have a table that contains a field titled LD with the following date format: "2011-01-12 11:00", but in text format. Does anyone know How to eliminate the time and convert the text date...

Not a school assignment Sir. Just tring to create an extra feature on a form. Thanks for your help though. R,

Gentlemen, Yes I understand there are several other ways in Lieu of the countdown, but it's the countdown field on a form using MS Access that is the requirement. Thank you for the suggestions, however, as indicated earlier, details explaining the how to.. would be very much appreciated. R,

Yes, the countdown would have to be continuous as oppose to starting over every time I open up the form. I'm counting down the time for our family vacation.

I would like to create a text or label field on a Form that can display a countdown (Months, Day, Hours, Minutes, Seconds) based on a predetermined date. I've viewed several threads w/respect to countdown timers and DateDiff VBA codes/modules and to the novice user, they all seem very...

PBaldy, -I created a new Text Box in the report. -Selected the Tex Box and Placed the following code, =Right([Acct],4) in its Control Source of the property sheet. -Replaced the "FieldName" with "Acct". -Works GREAT! Thank You. Tony

Pbaldy, Thanks for the reply. Could you elaborate a bit more though. Where exactly will I be placing the code and how. Appreciate your help. Thanks, Tony

Good Day, Request a little assistance. Does anyone know how to change the format (appearance) of a field containing a number (i.e., acct # 1234-678-9123) so that it appears like this; xxxx-xxx-9123 or 9123 on a report? Thank You.

Good Day, Request a little assistance. Does anyone know how to change the format (appearance) of a number (i.e., acct # 1234-678-9123) in a field so that it appears like this; xxxx-xxx-9123 on a report? Thank You.

Ithelp85 Try the following code by opening the property sheet of the Form and placing it in your VBA code via the "On Open Event": Private Sub Form_Open(Cancel As Integer) DoCmd.ShowToolbar "Ribbon", acToolbarNo End Sub

Mr. Wilkinson, You are one GREAT American!!! It works well. Thank you for your help. Respectfully, Tony