Search results

Does anybody know if it is possible to populate a date field based on the calendar function in outlook? I have a call handling database and am wondering if there is anyway to use the calendar function within outlook to populate our date of attendance field within our database. Any idea?

Is there any way to format the result when using Now() in VBA Private Sub cmd_Today_Click() tbo_DateTo = Now() End Sub I am using the above code to put todays date into a textbox on a form, but it gives me the format dd/mm/yyyy hh:mm:ss. I simply want dd/mm/yyyy.

I have a form that I want to use in order to work out a global figure for average travel time for my engineers (data coming from another database). I have a form with two text boxes, which allow the user to define a date range. This links into my query which works fine and returns all records...

I am system administrator for a small, very rigid call handling database. I want to know if there is any way I can find out who is logged into my database at any time (live check). The database runs from a .mdb file but there are no tables in the database that I can find where this info is...

Is it possible to display the user name used to log on to windows on a form? I have used the following code to get the machine name to display - but some machines are old and have new users..... Private Declare Function apiGetComputerName Lib "kernel32" Alias _ "GetComputerNameA" (ByVal...

Does anybody know of a site where you can download/modify/use pre-made databases files? I am looking to create a basic database to store survey details about signage on site for 200 sites. Details i need to include are Site, Sign, and Components.... I think the database itself would be fairly...

I am trying to change a text field (that has been used to store Dates) into a date/time field so that I can sort it correctly However, when I try and change the data type, It gets to about 90% on the progress bar then tells me that my system does not have enough memory available, and that an...

I have a list of sites (approx 15,000) that I need to update. Basically, against each site we store a region code (HR1 - HR7) and we have decided to increase the number of regions we operate with. I have created a spreadsheet that states the post codes included in each new region (NR) and now I...

I am creating a small Access application that will allow me to update my Call handling system's site table. It uses an mdb file, and I wish to add new sites (from new contracts) to the SCSite table. I recieve regular updates of new sites from existing customers, so want to create a simple macro...