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 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...
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 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...
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 & " - " &...
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...
I have the following code
' Set Variables
strSQL = "UPDATE " & strQueryDef & _
" SET " & StrColDest & " = (SELECT " & StrColSrc & " FROM " & strQueryDef & ");"
' Insert Records Into Table
DoCmd.RunSQL strSQL
This code takes a column...
Hi All
I am trying to get a prompt in MS Access that prompts the user to select an excel file in a particular directory and import it into an access table.
I have been messing around with the code below and have one issue and one question
' Declare Variables
Dim Filename As Variant
' Open...
Hi,
I am doing a project that involves exporting a queries Results from Access into an Excel Sheet and formatting it.
I am getting an error on the second time running the code which says this
Error 462: The remote server machine does not exist or is unavailable.
This I have found out from...
Hi,
I have 2 queries, One which gives me three columns of data and a second one which inserts nulls based on an "iif" statement and giving me a new table.
The SQL for the first table is
SELECT DISTINCT C1.customer, C2.attributeFROM myTable AS C1 INNER JOIN myTable As C2 ON C1.Customer <>...
I have a SQL problem
1) I have a customer who has multiple attributes in a table
2) There is more than one customer in the table – so many customers many attributes
3) I need a query (this will involve a sub query) which will take all the customers in the aforementioned Table and spit back...
Hi All
We currently have a production live system which contains many tables which i need to roll up into summary tables
This needs to be done so we can build reporting web pages off them and not impact the live database
To do this i was going to use a stored procedure
The procedure was going...
For (var i =1; i <= ActiveDocument.Sections ["Results"].Columns.Count ; i++)
{
ListBox1.add(ActiveDocument.Sections["Results"]columns[i].Name);
}
Can anyone see it
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.