Search results

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...

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...

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...

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.

Request a little assistance. I’ve created a field within a form in MS Access that allows me to disable Check boxes when selecting various values within the same field. For example, within the field [Shop] there are three values; “ShopA”,” ShopB”, and” ShopC”. When selecting either of the fields...