davidcairns

The important things for the noob are ALL_TABLES ALL_TAB_COLUMNS ALL_OBJECTS ALL_VIEWS note all of these have a version for the user you are logged in as USER_TABLES etc. There are quite a few more (ALL or USER is required), _CONSTRAINTS, _SOURCE, _INDEXES to name a few. Have a nose around …

I would normally never recommend splitting tables in this way, but if you must the easiest way to create and maintain access objects from VB is using DAO. Look specifically for the following methods .CreateTableDef .Fields.Append .CreateField to get at the existing column list use .TableDefs("your current table").Fields

I'm assuming you're referring to the exe file produced when you compile your project. The project can be given an icon in the project properties.

Break like the wind - Spinal Tap

Are you actually saying you don't want to use ActiveX to do it? because uploads can be done without that by using an input of type="file" and a form enctype="multipart/form-data". Doing this yourself is a lot of work but ABCUpload is a server side component for ASP that will do …

There is no one command to do this, you could write a PL procedure to do it, or generate the SQL statements from USER_TABLES. Alternately some IDE's provide an easier way.

Include a reference in your project to the Microsoft Word object library, then use the word object to open the document and interact with it

You would be better off using SQL server utilities for backup and restore, You could probably build a DTS package to perform the operation for you.

For uploading there are two options. 1. Purchase an upload component, I recommend ABCUpload but it's not the only one out there. One of my sites uses ASPUpload, but I find the other one more functional and easier to use. 2. Find the upload code on the web, it's out …

It's definately Oracle. The first statement there is not actually valid, it's just describing the existing table for you The next one creates an incrementing sequence, however I would never use a trigger to implement it as you can't find out what the value of the sequence is without requerying …

I'm not going to do this for you but I will give you some starters 1. You don't need a function as using the - operator returns the answer in days: [INLINECODE]returndate - duedate > 7[/INLINECODE] 2. For the first part use the LIKE operator 3. Look into the GROUP …

Hi Rob, First off I need to know how you are storing the trainer details, are they in text, xml, html or a database (Access, MySQL, SQL Server etc) If you want to put them in a database then what you use depends on you ISP (if you use one) …

You haven't included a control in your project that isn't available on the target machine?

For dtPicker you can use the dtPicker.Format to set it to whatever you want, including dtpShortDate and dtpCustom. If you use custom then dtPicker.CustomFormat can be set to any format (including "dd/mm/yy") however this will then ignore the users regional settings. Hence short date is probably the best choice for …

Hi Smiles, First of all, you have created a function with no return value and you are not using the return anyway. VB allows you to do that but you shouldn't anyway. Change the funtion header to Public Sub Calculate() Second, if you are in a .bas file (module) then …

A couple of suggestions 1. Ensure all tables have a PK 2. Merger EMPLOYEE with EMPLOYMENT DETAILS, they have the same pk and are 1 to 1. You could have separate tables if an employee held multiple positions over time 3. Link ACCOUNT to CUSTOMER, the customer has an account, …

If you don't want to use a control (I never use one) then simply add Microsoft ActiveX Data Objects 2.1 Library in references. Then use the ADODB.Connection and ADODB.Recordset objects. See here for a run down of ADO [URL]http://www.w3schools.com/ado/default.asp[/URL] And here for an Access (or any other) connection string [URL]http://www.connectionstrings.com/[/URL] …

This is just the declaration of a windows API call. The library is gdi32 (usually found at c:\windows\system32\gdi32.dll) and contains a number of functions usable within your code. One of these functions is GetPixel, which returns the RGB colour value of the pixel found at point x and y of …

Use the onClick event of the radio button see here [url]http://www.w3schools.com/htmldom/event_onclick.asp[/url]

Personally I tend to agree with Kevin, though perhaps not so vehemently :) Rep is something you can only truly collect with personal experience and discussion. Some random rep gained from one or two posts will never convince me that someone is more or less knowledgable, only through my own …

You are absolutely correct, fixed arrays cannot be assigned as a whole but dynamic arrays can. If you wish to assign a fixed array you have to do it one element at a time.

If you have a specific issue then post it here, but please first go and give it a try yourself. I don't mean to be harsh but your effort is required before we will offer ours Thanks D

I'm going to assume you are an Access programmer. I'm afraid VB won't do this stuff for you, you have to do it yourself. Having said that it is far more powerful and robust than Access and if you get it right will work much better. Cheers D

Or you could determine what doctype the html uses (xhtml strict would be ideal) and use an XML parser to cycle through the nodes. Having said that if the html is always that simple the instr and mid should be sufficient for the task at hand. Start with "ticker=" and …

instr can be used for both your problems. Syntax: INSTR([start], fullstring, findstring, [compare]) start is an optional integer parameter that specifies which character to start the search at (the default is the first) fullstring is the string to be searched findstring is the value you are looking for compare and …

You're going to have to source the list from somewhere, ideally this would be a web service, but I haven't managed to find one yet :( edit - drat, beaten to it! edit again - found this one [url]http://www.webservicex.net/WS/WSDetails.aspx?WSID=17&CATID=7[/url]

I'm pretty sure this works with vbs files. Use the filesystemobject, open the file and read it in. Set objFs = CreateObject("Scripting.FileSystemObject") Set objFile = objFs.OpenTextFile(yourfile) Do While Not objFile.AtEndOfStream strLine = objFile.ReadLine ' do what you want with the data Loop

javascript doesn't have a native trim function, however this way does work [code=javascript]var trimmed = str.replace(/^\s+|\s+$/g, '');[/code]

The main problem with this sort of thing is asp is that you don't have data types for variables. That means whenever you do a compare to determine which radio button to select you must cast the data into the same types. Hence If databaseField1 = -1 Then Needs to …

1. If you are concerned about a security issue with authentication details you should limit access to the user table to the authentication and new user routines and use a view which exludes these fields for all other access. 2. It is usually better to use a user type, but …

First off if you want to run it on a timer use the timer control, then set the interval to 100ms and call the code that looks for the file in the timer event. Try that out and get back to me with what you come up with. Cheers D

By tabs do you mean 1. Tab order - the order the fields are selected when pressing the tab key 2. Tables of data 3. Cigarettes

Hopefully this gives you an idea :) If you are looking to output multiple tables then the best way is to use two nested For Next loops, the outer one having an iteration for each table (eg 1 times, 2 times, 3 times etc) and the inner one having one …

You have to write javascript on the buttons click event to set the checkbox. As well as this the checkbox should be disabled like this <input type="checkbox" id="yourname" name="yourname" value="1" disabled />

This is the code I use, very easy to follow [URL]http://www.mvps.org/access/api/api0001.htm[/URL] The relevant API is GetSaveFileName

You can get more controls in VB6 by adding them from the tools menu. I don't have the application in front of me at the moment but it will be the menu item next to references. You can also build your own controls and save them as an ocx file.

The one thing I've found odd as a new user is the existance of Databases under Web Development. It seems rather an odd place for it to go. I assume it was mainly because there wasn't the space on the top bar, but it seems to me that Software Development …

Try this [code=vb]Private Sub EMail_Click() Dim objXL As Excel.Application Dim objWB As Excel.Workbook DoCmd.OutputTo acOutputForm, "frmGlobalAdjustment", _ acFormatXLS, "C:\temp\granite\Global Financial Adjustment Form.XLS", True Set objXL = New Excel.Application Set objWB = objXL.Workbooks.Open("C:\temp\granite\Global Financial Adjustment Form.XLS") objXL.Visible = True Set objWB = Nothing Set objXL = Nothing End Sub [/code]

The best reference if you are already a programmer is [url]www.w3schools.com[/url] For some more lesson based stuff you can look at [url]http://www.webreference.com/[/url] I'm sure others will have used different (and probably better) sources but these two worked for me Cheers D

If you want to use triggers that is a database question rather than an ASP question, and it very much depends on what database you're using. Having said that most database triggers are designed to operate on table row changes, not on changes to system parameters such as date.

Certainly for client side scripting Javascript is a far better option, on the server side what you use is essentially irrelevant to the client so whatever floats your boat there. These days unless you are writing for a corporate intranet (and even then I would never recommend it) VBScript on …

It should use a type of datetime and a default of getdate(). I think the syntax was this [DateCreated] [datetime] DEFAULT getdate()

Without answering your whole question I'll give you a start You need 3 of the tables to find cost per hire - HireContract Staff Branch Join them to each other and you should then be able to find the contracts for each branch (join fields are StaffID and BranchNo) Give …

w3shools is pretty much the ultimate resource for web based programming. It's easy to find important things like method and property lists that most books don't seem to deem important for some insane reason :)

Use the filesystemobject. This page is for ASP, but it's basically the same [url]http://www.w3schools.com/asp/asp_ref_filesystem.asp[/url]

firstly put this above Unload Me Set objRecordset = Nothing objConnection.Close Set objConnection = Nothing Always close and kill all objects See what this does to it

Is this for VB or VB.Net?

A simple insert should do the job just as well. Assuming your table has the simplest possible definition Reconciliation table GLAccount TxnID ReconciliationType (Txn or Rec) TxnDate TxnAmount You could write it as follows (example uses two statements, you could use one with a union clause if you like) INSERT …

Difficult to answer this without the context, can you post the entire paragraph

You can subtract them (the difference will be in days, and include fractions if you have times). However you may need to use CAST and/or CONVERT to make it come out correctly. The following example returns 28.0 select cast(cast('01 Jan 2006' as datetime) - cast('04 Dec 2005' as datetime) as …