Search results for query: *

Hi, I want to create a conditional format to format telephone numbers. Basically our phone numbers are made up of the code and the telNo. Normally the code doesn't have a 0, but sometimes it does, normally the telNo doesn't have the code but sometimes it does. What I want is a formula to...

Hi, I am new to Crystal and was wondering if there was a way to set control properites in code. For instance how to set all the lines in Detail to "Extend to bottom of section when printing" or to set all the text boxes to "Can Grow". Doing each one manually is a bit tedious thats all. I need...

Hi, I am using a parameter query in Access based on values on a form. I want to use an if statement to determine which part of the query is ran. i.e. if forms!frm.control = "this" then select * from tbl else select * from tbl2 How do I do this? Thanks Ian

Hi, I am using the Brainstorming Shapes in Visio to do a SSM conceptual model. I like the way the way the the connector and lines move around objects placed in their paths. Does anyone know how I can get a line with a single arrow head to work in the same way? Cheers Ian

Hi, I have OCRed a scaned doc into Word, that went well. However for all the text it has created a style with a shading of white. I can manaully remove the shading easily enough, but every block of text has its own style so it would take a while. How do I modify all the styles in one go...

Hi, Following importing lots of new data I have found that some of my queries only work after I "re alter" them in QA. By "re alter" I mean that I edit it and then run it without making any changes. I expect the problem was caused by the import, but why do I need to "re alter" my queries for...

Hi, I would like to restore a previous backup of my SQL Database to a separate database so that I can take some data from it, without effecting my current database in any way. Every time I try doing this there is a warning saying that I am overwriting the current db. How do I get around this...

Hi, I am using Access 2003 ADP with a SQL Sever 2000 BE. I am trying to set the FilterName of a report at runtime, so that I can use the same report with different data. strQryName = "qryJournalMailingSheet" strDocName = "rptIssuesToSend" DoCmd.OpenReport strDocName, acViewPreview...

Hi all, Every now and then some of my unbound forms get a recordsource which looks something like this { ? = call procGetPersonByID(?) } This prevents the form from opening and I must manually clear the record source for the form to work. Does anyone know why this happens and how to prevent...

Hi, I am using Access 2003 with a SQL Server 2000 backend I am having problems setting a subform's ADODB recordset in VBA. For a normal form I have used 'Set Forms("frmSearchPerson").Recordset = rsSearchResults But I can't figure out the syntax when it is a subform. I have tried the...

Hi I am using Access 2003 with a SQL Server 2000 Backend. I am doing a system for a publishers. One person can subscribe to one or more journals. Each Journal subscription consists of the current volume and previous ones. Each volume consists of issues. I want to have a tabbed page a) One...

Hi, I am using Access 2003 with a SQL Server 2000 backend. I want to use a single Report with several different queries, one at a time. I have the code: DoCmd.OpenReport "rptJournalMailingLabels", acViewPreview, "qryJournalMailingCurrentIssueSingle" But this doesn't work. How do I...

Hi, I am making an Adp using a proc as the source for my continous form. I want to be able to access a specific unbound textbox on a continous form so that I can put a value in it. However when I try to do that all the textboxes are filled with that value. How do I access a specific textbox...

Hi, I have just converted an Access Mdb to an ADP, using Access 2003 and SQL Sever 2003. I have a problem with one frm with a subForm, the records are not filterd, so all the records in the subform are shown, not just the relevant ones. The subform is populated using a proc which is a union...

I am using Access 2003 and I have a cluttered form and I would like to add existing controls to a Tab Control, but unfortunately I can't find a way of doing it without creating new controls. How do I add existing controls to a Tab Control? Thanks Ian

Hi, I have a continuous form with orders in it, description, price etc. I want to have a field in the footer which will show the sum of the prices, =Sum([txtPrice)] but this shows #Error. I would also like to do a count =Count([txtItemID]) but this doesn't work either. I am sure that I...

Hi, I am writing a report in Word 2003. I am using Heading Styles for the different sections and using Outline numbering. I am using "Include Chapter number" for captions of figures. 1 Figure 1-1 2 Figure 2-1 Figure 2-2 However on one of the chapters the number doesn’t appear, but instead a 0...

Hi, I am using Word 2003. I have Cross-References to other parts of the doc. I can update them manually, by right-clicking, update, but I would like them to update automatically as I make changes to the doc. How do I do this? Many thanks Ian

Hi, I am having trouble using OR in an If loop. I have if (cboCeaseType.SelectedValue.ToString () == "2") or (cboCeaseType.SelectedValue.ToString () == "5" ){ do something } else { do something else } It doesn't like this. How do I have an OR in an If loop? What should the above be? Cheers...

I have a database where the users work from a queue. They hit a button and the next record opened in a form. I have an attibute "open" which I set to true when the user opens the form, using recordsets and update. The problem is that the update is too slow and more than one user can...