Search results for query: *

Hi, I've used VBA for Excel in the past, and I'm going to be working on it in Word now. Current version here is 2003. Now I did a search and found all the "unzip" threads that dealt with using the winzip command line program. In my scenario this is not as feasible, as everyone has word and...

Hi everyone, (does this apply to this forum??) I'm starting to use VB.NET i figured it wouldn't be such a bad transition after all the VBA in Excel and a some in Access i've been doing. But i'm getting stuck with all these components available. Two questions: 1) To display a simple table...

Hi everyone, I'm starting to use VB.NET i figured it wouldn't be such a bad transition after all the VBA in Excel and a some in Access i've been doing. But i'm getting stuck with all these components available. Two questions: 1) To display a simple table in excel, one where there is a...

Hi, I have a database that has entries, Date and Tag and Value. It is from a Historian and it only recorded values at certain intervals if they where a certain distance away from the previous value, ie. deadband. In any case, I'm gathering information on a particular tag for a particular...

Hi, I think i'm a little lost. I was hoping to be able to save information once the Excel sheet is open... I have a userform that display's a set of default values in the text boxes and list boxes. I'd like to be able to save the previously selected choices so that they appear instead of the...

Hi, i'm used VBA in both access and excel. It seems by far easier to "access" the VB environment in Excel than any other MS App. I'm assuming you can use VBA in other apps from MS Office 97. But, how do I access it in Outlook. I managed to look at the drawing of a received message code. Ie...

Hi, i've found a way to change the footer values, and I run this at the 'on_open' event of the workbook. The only problem is that this is a bit slow... The code is here: With Unit1.PageSetup .LeftFooter = "&12" + ThisWorkbook.Path + "\" + ThisWorkbook.name End With My...

Hi, i'm making a script in vba to automate the data gathering of quite a bit of information and putting it into respective excel sheets. Vba in Excel, using Office 97. The script connects to Access 97 to run some SQL and then return values. It seems (from what I've seen and other than the...

Hi, i currently am working on some excel code that connects to a database and returns some values. Problem is it is a huge database (Access) and it takes some time. If I run the queries from within Access I can still do some stuff in the background (highly reduced in speed, but still somewhat...

Hi, I'm going to be making a "script" of sorts that will run many SELECT statments, but these SELECT statements will be using a query as the table...or selecting a query, however it is said. ie. SELECT * FROM thisQuery (which is a query defined in the queries section of Access 97) Except...

Hi, i'm wondering if there exists SQL code to determine the date difference between successive rows. For example, a query I have would return something like this: (where VAL > 500 but notice the GAP that says there are 14 entries that were not included ie, VAL <= 500) If I want to determine...

Hi, I have all my data in 3 databases each with one table (all of them are defined the same) Pretty much just, ID, TAG, DATE, VALUE Each database has a unique autonumbered ID... Anyway, to run a query for all of them I have been using the UNION operator. Basically, Select * from T1 where...

Hi, I have a couple of huge CSV files and I want to count the number of lines/rows in the file. Each CSV file is preeetty huge, so even opening them in Notepad takes 30 seconds to a few minutes depending.. Also, there are a few. And for the sake of data integrity i'd like to count the number...

Hi, i'm trying to combine some tables, but they aren't in the same database... Trying to do this all automatically as well :D So anyway, I found (in tek-tips :)/used some code to update different access databases and I also have some code to combine tables using CurrentDB. They are below...

Hi, this is probably super simple but i'm still a newb.. Anyway, i'm trying to get the current directory that the VBScript is running from... I saw something akin to: Server.MapPath(".") but umm.. I'm not doing this for ASP or any web stuff, i'm trying to copy files from the current directory...

Hi, I understand you can link tables from other databases into the current one... Is it possible to link information from another table in a different database to the table within the current database. ie. 3 separate databases contain exact table columns except rows are for different dates...

Hi i'm trying to change the type of a column in a table but i'm getting a "not enouph disk space/not enouph memory" error. How might I go about getting around this? Can i break the table up in chunks, do it, then join them together again? (I'd like to know how to do this regardless as I have 3...

Hi, i've come up with a problem that I hope VBscript may be the answer too. I've never created my own VBScript and am interested in finding out more... (beginner stuff first) But, ATM I have 1.3 gigz worth of CSV text files that I need to convert the dates off... Files are formatted as such...

Hi, this may a bit OT .. But while trying to import a CSV file I get an error as the wizard cannot distinguish the date. Format looks like this: TAG,DATE,VALUE UNIT1_A5272019,6/29/1993 8:48 AM,3 UNIT1_A5272019,6/30/1993 12:00 AM,3 ie. MM/DD/YYYY HH:MM AM/PM I tried the advanced tab during...

Hi, this may a bit OT .. But while trying to import a CSV file I get an error as the wizard cannot distinguish the date. Format looks like this: TAG,DATE,VALUE UNIT1_A5272019,6/29/1993 8:48 AM,3 UNIT1_A5272019,6/30/1993 12:00 AM,3 ie. MM/DD/YYYY HH:MM AM/PM I tried the advanced tab during...