I have a query please.
I have 2 databases, one SQL 2000 and one SQL 2005, When I right click on it and go to properties the is a field labelled "Space Available" and mine is 0.00 Mb.
The system is working fine though.
Also if I click on "Files" my "Autogrowth" column is set to By 20 Mb...
Hi there
I am a bit of a novice in this but hope you can help.
I am use SQL 2005 and have a table with 4000 lines in it. One of the columns should be a number count from 1 to 4000.
I would like to know how I could check with some sort of SQL script that there are no gaps within it, and if...
Hi
I hope someone can help, I am not an expert with SQL so bare with me.
I am using MSDE 2000 on an XP PC.
I have been given a mdf file that I need to look at the data.
So far I have created a database using enterprise manager of the same name as the mdf file, I then Stopped SQL and copied...
Great, Thanks for that, I have now got the value coming out of the function.
Could you now please point me in the right direction on how to populate a colmun in a table.
Sorry for being a Numpty but I am an amature at this.
Thanks for all your help.
Thanks for that, I have now Put the code together, See below
My only problem now is how do i get it to apply to a specific colmun in a table. the below code works fine as a one shot test.
Private Sub Day_Calc_Click()
Dim startdate As Date
Dim today As Date
'Dim RELOGDATE As Date
Dim...
Hi
I wonder if anyone can help me.
I have an Access 97 database, with a date field in it. I have to come up with some code that will find the amount of "work" days (Monday to Friday) between this date and todays date and then take one off that number.
I have not realy done any code on access...
I am still having a problem, and below is a bit more information.
I am trying to open an xls spreadsheet (which was created by Access 97) from a macro in Excel 2003. The spreadsheet will not open and gives me the error. "Run Time Error 1004, Method "open" of object "Workbooks" failed.
Below is...
This is the bit of code I am using to open the file.
When it gets to this it displays an error message trap that is written into the code. Which is also below
Workbooks.Open FileName:= _
"T:\G2 Service\Relogs\Data Files\Crystal Call Analysis G2.xls"
ErrorRoutine:
'MsgBox "An error...
Hi All
I have written a macro in Excel 97 to open several XLS spreadsheets and extract the data. This works fine.
We have now been moved to Citrix and the Office version is 2003. I have tried to run the same macro within Excel 2003 and it will not allow me to open the excel files.
I have...
I have now got to code working below to send an attactment with a subject line and body. Although it will only work with a single e-mail address. if i put in the name ofa Distribution list it does not work.
Can anyone give me any pointers how to sent the mail to a Distribution list.
Sub...
I have a macro which will e-mail an Excel spreadsheet.
I am using the line:-
Application.Dialogs(xlDialogSendMail).Show
I know there are arguments you can add to the end such as e-mail address, subject line.
can anyone advice me on the way to do this, i need to include "E-Mail Group"...
Could someone please advice me on a bit of code to run in a macro that will check for the existance of 3 other excel spreadsheets before the macro trys to open them.
thanks.
Sorry guys, I still can't work out how to code the lookup and then do an autofilter in a macro.
I have the basic understanding of the VLOOKUP command and i can use it to search for a particular entry.
but how do i check for an invalid entry ???????????
I have 1 column of data to lookup, and a...
I have tried a Case statment, with the last statment coping the unrecognised code into an array.
This seems long winded. hoping there is a simpler way
N.B. I am no programmer so i have limited knowledge on this.
I am writing a VB macro in Excel 97, I have a column that should only hold 12 different strings
E.g. A through to L.
Can anyone advice me on a short peice of code that will check that there is nothing else in this column apart from what should be. (A to L)
Thanks.
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.