Search results for query: *

Please accept my apologies if I have posted this to the wrong forum. I have developed a set of reports in MS Access which make heavy use of Access Basic behind the reports. I did this becuase I needed a custom graph and was not able to use templates. I want to migrate them to a hosted...

I'm sure what I want to do is very easy but evades me! Very simple form with one field text box named selectioncriteria. One bound query to the form field slectioncriteria. If I enter >1 in the text box and then run the query I want it to retrieve records where the bound field is greater...

Sorry if this is the wrong place to post. Can anybody recommend a MS SQL hosting company that is affordable, scaleable and most of all reliable! many thanks Regards TabbyTab:)

Hi Guys, I am trying to achive the following For x = 1 to 36 Dim ctrl_x Next SO I Dim ctrl_1,ctrl_2 where x is resolved to its number Any ideas Thanks in advance TabbyTab:)

I am totally new to Crystal so please be gentle! I have a Crystal report based on an Access query. If I update the Access query (add fields etc) I need these to be relected as to what fields are availbale in Crystal. I have refreshed is 'Database Expert' / 'Field Explorer' on both the...

Hi Guys I am totally new to Crystal. I am simply trying to put a text field in a report in the form of a bulleted list. How can I do this? The text is not sourced from an datasource Thanks in advance TabbyTab:)

Hi Guys, I hope this is the right place to raise this as it partly involves SQL. I have stored in a text field in a SQL database several sentances that I want to personalise with a person first name. Example of db record What do you want varfirstname to stop? I want it to display...

Hi Guys. I am trying to dynamically assign a filename when printing to file. If need be I'd be happy to rename the file after its printed but I just can't stop the dialog box "Print to file - Output file name" appearing. Any pointers would be much appreciated. Regards TabbyTab :)

Hi Guys. I am beginning to regret upgrading to MS Office 2003. I have a report that includes a subreport in the main report footer. All worked fine with Access 2000 but after upgrade when I run the main report the subreport does not show. Any suggestions? Many thanks in advance. Tabby Tab :)

Hi Guys I have just finished an upgrade from Office 2000 to 2003. When I try to import external data from an ODBC source nothing happens. Steps 1. Select "File / Get External Data / Import" 2. Select ODBC from the drop down list of file types AND THATS IT. The dialog box closes and you are...

I've searched archives and found some good stuff. However when I run on my table (field in ntext) update <tablename> set <field> = replace(cast(field as nvarchar),char(13)+char(10),'xyz') I seem to randomly(?) chop my text field . Any pointers Many thanks in advance TabbyTab :)

Hi guys I am totally new to javascript so excuse the crumby code.... I am trying to change the background color of an input box when a radio button is clicked. I am successfully changing the text in the input box when the radio button is clicked but have no idea as to syntax to change color...

Hi Guys I've been here before but cannot get the syntax right. On my ASP page I assign txtA1Grade="""Do Not Know""" Response.Write ("<input name=J type=radio title=" & txtA1Grade &"/>") All works OK - When you hover over radio button you get displayed "DO Not Know" If I assign...

Hi Guys As you will see from my question I know virtually zero about SQL. I have a hosted MS SQL DB. When I run queries against it using ASP I do not use the Owner name infront of the table name at all. When I download backup of DB and restore to local machine I must use owner in reference to...

I know this may sound a very simple and obvious question but I have had an error whilst updating a table that has caused me to question the obvious. What is the best data type for storing textural/ numerical input from a user (a bit like a memo field). The error I got was Microsoft OLE DB...

I am trying to test the state of individual radio buttons.. without success. What am I missing Extract of my code <SCRIPT LANGUAGE="JavaScript"> var counter=0; function J () { IF(document.forms[0].A.checked) { alert "Radio button A is checked"; }...

I am having a problem with a remote customer. They receive this error Javascript error error: web retrieval in progress This error occurs when the following fuction is called. <script type="text/javascript"> function forcesubmit() { document.forms[0].submit(); } </script> The same...

Hi Guys. My problem is testing the state of 6 indivdual radio buttons before I increase a counter. I call a funtion each time a radio button is clicked to increase a counter, however if the radio button is already checked then I do not wish to increase counter. As there are 6 individual radio...

Hi Guys I have a sql query that includes an email adress in the Where clause ie strEmail = xx.xx@xx.com I cannot get this to work. I've tried single & double quotes around the email address. Where strEmail = "xx.xx@xx.com" Where strEmail = 'xx.xx@xx.com' Any clues? Thanks in advance TabbyTab

Hi Guys I am having problems assigning the date to a variable. The source of the date is a recordset returned from a sql query. I have tried dtmJobStop= CDATE(RS("dtmJobStop")) but this has not worked and if I test IsDate(dtmJobStop) it returns false. If I Response.Write...