Hi
I have a SQL Statement where i want to set the dates to be variable. The format of the dates appears to be timstamp i.e. MM/DD/YYYY HH:MM AM/PM
I am using the code below
database.col1 > = CAST (CAST (CURRENT_DATE - interval '7' DAY AS DATE FORMAT 'DD/MM/YYYY')||' '|| CAST('09:00' AS...
Hi All,
Basically I have macro that calls a function
I want to make this function as generic as possible for maybe someday being able to use it in future for something else
I want to pass in a variable of cell ranges like for example "A1:B2"
I then wish to subtitute the static "A1:B2"...
Hi Skip,
I have been told that we have to use the Chevrolet as its being used for all of our reports. This is just the first one that we are trying to automate. Do you know how to edit the labels with VBA?
Thanks
Hi Skip,
Thanks for the quick response. We are stuck with Powerpoint 2003 so im afraid I have to use the MS Graph Library to achieve this although im open to correction
Thanks
Hi All,
I have a report i am trying to automate. In essense it pulls data from MS Access, generates a pivot In Excel whose values i will then use to update several graphs all sitting behind a button.
I have encountered a problem i was wondering if you could help me with
The X-Axis on the...
Hi All,
I have the following function which I put together by skimming this very helpful folders. Basically from my understanding is the function creates a vbs script and kills the last Excel process which is perfect for my needs. My problem is it doesn't seem to activate the script on the PC...
Hi MrMovie,
Thanks very much for your feedback
I have fixed the syntax error you have pointed out but i have another error at line 7 Char 19 where it is expecting an end of Statement.
I have put in a ; but that doesnt4 seem to make a difference
I was wondering if you could see the issue.
I...
Hello All,
I have a VB script which deals in Processes. Basically we are using a third party application that allows you to interact with the Excel object but refuses to kill the object once it has quit excel. I have founda VBS script to fix this problem but would like someone to tell me the...
Hi All,
I have recently tried with the help of these forums to create a script that simply backs up a folder giving the user feedback by creating a progress bar.
My script is below. The error i am getting is on Line 51, char 4. Object required NS.
The error is puzzling because d'ont I create the...
Hi Skip,
Thanks for the prompt reply. However it is possible for A1 to have a value other than a number which is why i need to get the three conditions into the nested If statement
If i wasnt using conditional formating The formula would be something like below...
Hi All,
I have an excel worksheet that i want to colour code cells based on the values in them.
So lets take cells A1 & B1 as examples. Effectively what i want to say is
If value in A1 is 0
AND the value in B1 contains a value
AND this value is a number
Conditional Format it Yellow
Can...
I must apologize, The table is transfered into the Access Database
' Link Files
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, strImportTblNm, mstrXlsFile, True
' Transfer Selected Columns From Linked Table into Specified Table
strSQL = "INSERT INTO tblMCountPickIn ( SpecRecID...
Hi All
I have code which imports an excel sheet into a MS Access Database as a linked Table. I then have a Query which selects all the items in the table and inserts them into another table.
My problem with this is the user gets to select the xls sheet they wish to import. The SQL statement...
Hi All,
I have created a VBS script which is used for backing up peoples folders at the end of each night and moving them to an internal server within the company.
All works well but i was wondering does anyone know how to get rid of the message asking the user are they sure they wish to run a...
Hello Chaps,
I have a piece of code that loops through a recordset and builds a string. The recordset contains a list of errors on a production line for a particular manufacturer. My code is below.
Do Until RS1.EOF
ProdStrMsg = "Item: " & RS1!Code & " - " &...
Hi kjv1611
I have tried this. Unfortunatly once you select that the user cam insert columns, they are able to insert columns anywhere on the sheet not just in the unlocked cells. Once the Column has been inserted into the restricted section you are not allowed to edit it but i would prefer if...
Dear All,
I have a spreadsheet where i need to set that the user is unable to insert columns in one part of the spreadsheet but is able to insert columns in another part of the spreadsheet.
For example Columns A:D you are not allowed to insert the columns and anything after that you are
Does...
Hi All,
I am currently trying to create a button in Outlook that sets the font, size and colour of text when the user is replying to the message. This requirement came up when people starting adding fancy stationary that caused my user when replying to pick up the senders current font settings...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.