Search results for query: *

Hi, I am having a problem in Excel. I have been asked to create a survey in Excel that we can mail to users. I would like to use 4 scored radio buttons with different score values. The survey would look a little like this ("o" denotes an unselected radio button and "@" a clicked button)...

Can I save Crystal XI reports as v10? I am about to buy Crystal Reports and would like to buy version XI but I will need to be able to write reports back to version 10, as this is the version that one of my clients use. Should I get v10 or can I go straight for version XI and put off...

Can anyone help Is it possible to lock a combo - box in excel based on an if statement when a worksheet is opened For example On open If A1 > 0 then lock Combo Box Can someone advise suitable code for achieving this Many Thanks

Can you please help I have a Macro that seems to intemittently fail when opening a form. The Macro is quite complex and it would be difficult for me to elaborate on the detail but are there any standard problems that can cause this to occur such as conflicts or Macro too long etc. Any help...

Can anyone tell me if you can concatenate results from one control in a form with text on a label on the same form. It would be very much appreciated thanks

Can anyone Help I have the following problem; I have a form sourced from an underlying table with two controls which, for simplicity, I will call control A and control B. I am defining an input mask using the set value on a macro that says. If Control A = "London" then set [Control A].[Input...

Can you please help I have two controls on a form, sourced from an underlying table. Selection of the first control defines the input mask of a second control through a macro. However I would also like to autopopulate part of the second control from the first so it would go something like this...

Can you please help I have a sub report within a report that does not have or need a child field to the main report. When I run the underlying query, the subreport produces three records which is correct and when I run the subreport on it's own, three records are produced with no extra pages...

Can you please help I heve a database and after much testing I would now like to implement. I have cleaned all test data from underlying tables and would like to reset all autonumbers to 0 on all my tables. Is this possible Many thanks Njwcad

Can you please help I am trying to open a form in edit mode so it shows all records, having previously set the form to add only (but can't remember how I did it). I am opening from different locations that are both set to pen the form in edit but to no avail. I assume have set something on the...

Hello can anyone help Is it possible to set a 10 second timer in excel that delays conditional formatting of one cell by 10 seconds following a result from another cell using VB code Any help would be greatly appreciated Many Thanks

Hope you can help. I have created a report in which the contents span two pages. However, it seems to have four pages in which the contents are duplicated on pages tree and four. Is there any way I can limit to two pages? Thanks

Can you please help I amd trying to open a record on a form from a pop up form access through my database switchboard. It is intended to work something like On database opening - switchboard opens (works fine) Click find record on switchboard to open pop up form (works fine) Select record id...

Hello Hope you can help again I have a text box on a subform whose record source is from the underlying table. I would like to automatically input a value in the text box based on a query. I have tried to set the default value on the underlying table and in the text box property but it doesn't...

Can you please help I am running a query that sourced from a number of tables and results in say 10 columns of data. I would like to be able to combine the first 4 columns into 1 (they are all the same format). For example - first query Column 1 Column 2 Column 3 Column 4 Other Columns...

Can you please help, I have a command button in my first form that when clicked, opens a second form in Add mode but can't seem to find the code for this Any help would be appreciated Thanks in advance

Can anyone help I would like to define different input masks in a subform text box but based on selection from a combo box on my main form so, for example; If main form combo box = A then input mask on subform text box = ***space** If main form combox box =B then input mask on aubform text box...

Can anyone please help I am trying to place a combo box on a form (sourced from a table) that allows users to add new entries that are then added to the dropdown list the next time the combo box is used Thanks in anticipation

Can anyone help! I have a table based form which I would like to lock when all boxes have been filled in / completed. I have tried doing this through Macros and have spent two days continually tweaking the Macro to get it right but realised that there may be an easy way to do this such as some...

Can you please help. I am trying to requery a control on a subform after a change of a control on the main form. The query works once when I make my first change (after opening of the form) but will not requery if change the control on the main form for a second time. I have tried macros such...