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:)

Thanks Ed It works a treat Another learn't tool in my toolbox Regards TabbyTab:)

Ok . I am trying to step through a sequence of text boxes on a report to allow me to format / enter data into them. There is other data of the report that is bound to a query. So text boxes are named L for level S for score So 1st row is L1S1, L1S2, L1S3 ..L1S6 and next row is L2S1, L2S2,L2S3...

Thanks guys .. my mind (what little there is left!) has gone blank - not that I'm very familiar with techi stuff in the first place. So I have Dim ctrl(36) As control For x = 1 to 36 ctrl(x)=Test&x Next So I want to fill array with Pos 1=Test1 Pos 2=Test2 Etc How can I do that Many,many...

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:)

ARRGH... Not I hadn't - thankyou Sometimes the vertical learning curve is too steep! Thanks again 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...

HELP! I sussed this one out before but upgraded(?) to NIS 2007 and now can't get odbc to work. Anybody got a solution. Regards TabbyTab :)

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 :)

I have now got the import to work. I did 2 things not sure which one cured prob. 1. Norton NIS - Antivirus Options > NAV > Miscellaneous / Unclick (switch off) "Turn Office Plug-in On" 2. The other thing I did was recreate an ODBC profile under control panel / adim tools / ODBC. 3.Reboot PC...

Hi IntentDriven. I have now got the import to work. I did 2 things not sure which one cured prob. 1. Norton NIS - Antivirus Options > NAV > Miscellaneous / Unclick (switch off) "Turn Office Plug-in On" 2. The other thing I did was recreate an ODBC profile under control panel / adim tools /...

I have just posted "ODBC Import Fails After upgrade to 2003" (27TH June). It looks like we have the same / similar problem. I upgraded my machine last week and got all the latest office updates from the net. Does this mean anything? TabbyTab :)

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...

Cool! That fixed it. Many thanks Borislav

I now realise that the "chopping" of my text is not random The length of the text field after the update is either 34 or 32 characters. So text field Good at focussing on what needs to get done. Getting to results. Motivate others to achieve our targets. When I run update <tablename> set...