Search results

Hi I am using the following code to create a csv file on the desktop using a query Set wShell = CreateObject("WScript.Shell") path = wShell.SpecialFolders("Desktop") Set wShell = Nothing DoCmd.TransferText acExportDelim, , "qryexportcsv", path + "\export" & Format(Now(), "ddmmyyyy_HH:MM:SS")...

Can anyone tell me how to write a date to a one cell table named tbllastsync the field name is datelastsync it looks like this datelastsync 01/01/2005 the table has no primary key I just want to store a date there so if it were updated now I would like to update it following the running of...

I believe its something like char then a char number to specify what you want to use hth rob

Hi, I have a combo box and I widen it past the length of the widest entry. It still seems to want to put some of the entries on another line. Why is this and how can I stop it from happening? thanks Rob

Hi I would like to ensure all fields on the form are filled before a user exits the db. I have a quit button on my form and it is there for people to exit entirely from access. I need to validate the form and display a message if not all fields are filled. This way i will safeguard against any...

Hi How can I get a button to work which would clear my entire form including all textboxes and cbo's. I cant get the textboxes with calculations in the control sources to go blank! thanks Rob

This is my new code I need it to give itself the name of the current date.csv It already gets its path to the desktop so that will be just right Dim path As String Dim wShell As Object 'New wshShell Set wShell = CreateObject("WScript.Shell") path = wShell.SpecialFolders("Desktop") Set wShell =...

Hi I need to output myself a csv file of all information since the procedure was last run (i.e - any new data since the last export to csv was done) I have created an unlinked table to just contain a single value in a single row holding the date. For the first ever press because there will be...

sorry. I need to work out how to do it :)

I would like to create a subform containing information relating to the choice in a combo box at the top of my form. The cbo is named cbosite, all the fields to fill are from the same table as the source table supplying the combo. Thanks Rob

I have a combo on a form that will allow me to choose a site from the dropdown. This is based on a table and will create a record when picked of a number relating to the primary key in the combos source table. I have another combo which I need to only show values related to the first combo...