Search results for query: *

Hi, I was wondering whether its possible to save the log to a specific folder, eg D:\SAS-Log, after a process has completed. Is this possible and do you know how to go about it? Thanks for any help provided. Regards tubbsy123

Hi, I've been using some code to dynamically create a button in an excel worksheet based on the output of a case statement. The code is as follows: Sheet1.OLEObjects.Add ClassType:="Forms.CommandButton.1", Left:=0, Top:=0, Width:=126.75, Height:=25.5...

Hi, I need to populate a macro variable, filedate, with the following saturdays date. It needs to be formatted as yyyymmdd. The following code is how far I've got. The &filedate. variable doesn't work correctly when run using %put. I get todays date and part of the code, eg 20100223+(7-2). I...

Thats great. Thanks Tubbsy123

Hi, I have some very large datasets (roughly 35 million records in each) and need to count the number of records present within them and store it as a macro variable. I currently use either proc sql or proc freq to do this. This takes a long time run. Is it possible to take the rows value in...

Hi Chris, This is really good but seems to only allow me identify the location of the file rather than the actual file name, eg Data20090301.txt Can this code be adapted to allow for the actual filename to be output. Regards Tubbsy123

Hi, I'm having problems with some code. I read in 6 text files using a wildcard. There are many more files in the root folder that are not read in. I need to write the filename of each of the files that are read in into a new column in the dataset. Any help would be greatly received. The...

Thanks dblan this code works really well. kdt82 using the x command and 'shutdown' doesn't seem to work. Thanks for the post though. Regards Tubbsy123

Hi, I am having trouble writing some code that shutsdown my PC after completing an automated piece of code. The idea is that once the code has finished the PC shuts istelf down. Does anybody know how to do this. Any help would be greatly received. Regards Tubbsy

Hi, I have two Access 2003 databases. The master is Export_Process.mdb and the other is DBExport.mdb. I need to delete the table, tblCampaign, from DBExport. But the initiation must come from the database, Export_Process.mdb. The deletion will be run as part of some other code. The location...

Hi, I have an excel spreadsheet with 9 fixed columns but a variable number of rows. I have written some code that changes the formating of each cell and this works for the variable number of columns. I am having problems trying to get the code run for the 9 columns instead of the one where the...

Thanks Everybody Thats Great tubbsy123

Hi, I have a very basic query which turns the visibility of items in a form on or off depending which button has been pressed. The query fires on click. A condensed version of some of the code reads: Private Sub btnElecBack_Click() picGas.Visible = True btnElecTotal.Visible = True...

Excellent, thanks very much Tubbsy

Hi, Someone in our office added to a database password to my Access Database. Now I cannot open it. Is there any way to get past this password and turn it off? Thanks for any help you can give Tubbsy

Hi, I have a table with 1,700,000 records in. A small cut of it is shown below (there are 5 more columns): ACCOUNT_ID BILL_DATE BILL_TOTAL 7900000097 30-Sep-03 25.6 7900000097 24-Nov-03 37.21 7900000097 23-Feb-04 71.2 7900000160 08-Mar-04 150.91 7900000160 20-May-05 108.95 I need to select...

Hi, I wonder if you could help me. I am making a query which creates 3 tables. I come from an Oracle SQL background, where you can write multiple Create Table queries. Unfortunately this doesn't seem to be the case with Access. Can anybody explain how to do this in Access please? A simplified...

I have tried doing that, but I couldn't get it to work. This is the SQL statement which I used: SELECT 2003.ID, 2004.ID, 2003.Name, 2004.Name, 2003.Year, 2004.Year FROM 2004 INNER JOIN 2003 ON 2004.ID = 2003.ID WHERE 2003.Year <> 2004.Year; Have you any tips on how to make this work? Thanks a...

Hi, I have a table which is the result of two merged tables containing 2003 and 2004 data. The merged table looks like this: Merged: ID Name Year 1 John 2003 2 John 2004 3 Mark 2003 4 Adam 2004 I am trying to retrieve ID, Name, Year for all records. Unless there...