Recent content by tabbytab

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