Search results for query: *

hi guys, has anybody used this tool : http://www.greymatter.co.uk/Developers/GmHome/sr3_prdidx.asp?id=11756 its called Total Access Analyser. just want your opinions on it, is it worth purchasing ? thanks

gurus, if I click on my form, properties, data tab, I can allow additions here. I don't want to allow additions all the time, only when one button is pressed, can I set this to Yes then add the record, then set it back to NO via VBA ? regards, John

hello, how can I create a query to compare values. ? I have 2 tables new and old data, I want to compare the values in both the new and the old. ( using UNION is probably the best way) I want to count records and group by a field. then show the records if the count is different by twice as...

hello all, how can I write this array with this first row being blank ? (rs = select * from table) tempArray = oRS.GetRows() end if 'Create a temp. array of the select statement in VBscript. Response.Write(&quot;<scri&quot; & &quot;pt language=VBScript>&quot; & vbcrlf)...

hello everyone, For all my asp applications I create a login on my SQL7 server then connect using that. This is fine apart from I can;t see who is connected to the database when using SQL server enterprise manager. Is is possible to connect to the database using another way so the NT username...

hello, how can I submit a form by pressing the Enter key ? I have tried : <SCRIPT LANGUAGE=&quot;javascript&quot;> function enter(event,ourform) { if (event && event.which == 13) ourform.submit(); else return true;} </SCRIPT> <form method=&quot;post&quot; name=&quot;s1&quot...

hello all, How can I change the mouse pointer to an hour glass when some sql is running , then back to the arrow after the sql has run. ?

hello All, I use this code through most my access97 databases, but for some reason it doesn't work on one of my databases. run-time error '3077' Syntax error (missing operator) in expression. the code is : Private Sub List0_AfterUpdate() Me.Recordsetclone.findfirst &quot;[Companyname] =...

hello, How would I create a check constraint to make sure that before inserting the start date is less than the end date ? Also can I use this to display a message on an asp page telling the user the data is incorrect, or would I need to do validate the data on the asp page aswell. ? thank you...

hello, I am looking in my logfiles and it says the transaction logs for a database is full. I have tried shrinking the database. what else can I do ? than kyou for any info.

hello, I have some sql on an asp page I want to run, but not display the page. is that possible ? so far, I have a far, then click on a table row to email the name clicked on. also attached to the onclick event I run the page to add the email address to a database. this all works, but the page...

hello, If I use javascript to open a new window it works fine, but then if I use the same code to open another window from the window just opened, it opens the new window in the previous window. (how many times can you say window in one sentance!) <a href=&quot;#&quot...

hello, hope this is an easy one to solve. I have address fields, Address1, Address2, Address3, country, postcode showing them on a report for labels, but the labels have gaps where no data is in some of the fields. how can I removed these blanks, and generally make the labels look good...

hello, I have a table where some of the number fielda are chars and varchars. I am trying to change them to int, but get erorrs saying can't convert value 2.5 . how can I convert varchars or chars to ints if numbers with decimals are in the data .?

hello, how can I find out where the linked tables are from ? ps. I don;t have linked table manager installed sao can't find out that way.. thank you.

Hello, how can I expand on my A tag to open a new window with no toolbars ? <a href=&quot;http://localhost/Preview.asp&quot; target=&quot;_New&quot;> cheers for any help.

hello, I have created an sp to insert a record, but how do I only insert records if they don't exist in the database. ? CREATE PROCEDURE [sp_InsertLog] @username varchar(50), @link varchar(100), @Param1 varchar(50), @Param2 varchar(50), @SearchType varchar(50) AS INSERT INTO...

Say I have a form in my first Div and want to pass field 'Name' from it to the second DIV (this second div is to be the IFRAME) on the same form. how would I do that ? so far I have, <SCRIPT language=&quot;JAVASCRIPT&quot;> function validate() { var s = document.s1 s.submit(); }...

hello, I am trying to add a trigger so when a record is inserted, updated or deleted from one table, it will insert the record into another table. how can I do something like this. INSERT INTO Mutations (AddDate, Prov, Forename, Surname, Sess, SessConf, TermID) VALUES...

Hello, has anybody had any experience with running sp's from access ? how would I run this : spfinancestatementlink with parameter equal to : [forms]![test]![txttest1] I would like to attach this to a report, is that possible ? thank you for any advice / links.