Search results for query: *

I have a button on a form - when the user carries out a certain task they click the button, this logs the time and date and task type etc. The following code is attached to the onclick event: Me.fldtasktype.Value = "Task description" Me.fldtaskCode.Value = "xxx" Me.fldUsername.Value =...

Hi I am using the following to produce a Week Number Column in a select query: Week Number: DatePart("ww",[MyDate],2) the above returns 05/04/04 as week 15 (date field is formatted to dd/mm/yy) Is it possible to add to the code to return (Mon) 05/04/04 as week 1 thru to (Mon)...

I am trying to error trap for an empty directory when importing a text file, the following code produces: runtime error 3001 Invalid argument, ( the transfer text line is highlighted) Where am I going wrong please? Function testing() As Long Dim strFile As String strFile =...

I have a table that is populated by a text import, I then run an update query to add data to the records just imported. I would like to have the default confirmation messages turned off ( for the update query) but have a custom message box telling the user how many records have just been...

How do I call a function in an update query? I am trying to capitalise names in a name field I have found a function that will do this named: Function proper(var As Variant) As Variant what do I enter in the QBE grid update to ? criteria ? Help needed please

I am trying to import a text file that is generated by another app' the problem I have is, that the files generated are randomly named the only thing that is constant - is the file extension which is .rnd. I have tried using: [DoCmd.TransferText acImportFixed, "myspec&quot...

Hi I import a text file into a table using the following attached to the on click property of a button on a form: [DoCmd.TransferText acImportFixed, "mypec", "mytablename", "e:\my documents\textfile.txt"] This transfers 3 columns of text into fields named...

I am trying to setup a staff shift rota (10 week cycle) what I would like to be able to do is enter a date in a textbox & use DatePart("ww",[mydate]) to get the week number. But I need to be able to link that result in [mydate] to the rota week number eg: if the result in [mydate] is...