Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. klfduncan

    Cannot unload a form

    Hi, I'm calling a backup procedure which copies the entire subject database to a new location. I'm running this procedure from a Form "Switchboard", which calls a procedure in a separate module, callBackup, which has the procedure makeBackup. on the form Switchboard: Private Sub...
  2. klfduncan

    Sharing and Replication

    Hi, realise that it's kind of a large subject, but I want to share my Access database over the country intranet (140+ countries) and am thinking of trying to achieve this through server-based replication. Does anybody have any good links to internet pages on how to do this, or do people know...
  3. klfduncan

    Adding a dynamic text box to a report

    OK. I've managed to get it to work by specifying the path Forms!ReportSwitch!Filter in the 'Control Source' property of the text box in design view of the report. It works, but I don't understand why I couldn't just code it in Visual Basic - any ideas? Thanks for both of your help by the way -...
  4. klfduncan

    Adding a dynamic text box to a report

    Yes. Do you think it would be better to write code in the report itself, something along the lines of: ReportOpen() Me!PriorityTxt = Forms!ReportSwitch!PriorityFilter ?
  5. klfduncan

    Adding a dynamic text box to a report

    OK. How about this: Dim stCaption, stWhere As String If IsNull(Me!PriorityFilter) = True Then MsgBox ("Please choose what priority leads you would like to view from the combo box at the top of this window") GoTo Exit_ActiveLeads_Click End If stWhere =...
  6. klfduncan

    Adding a dynamic text box to a report

    Hi, here's the full code: Dim stCaption As String If IsNull(Me!PriorityFilter) = True Then MsgBox ("Please choose what priority leads you would like to view from the combo box at the top of this window") GoTo Exit_ActiveLeads_Click End If...
  7. klfduncan

    Adding a dynamic text box to a report

    Sorry, the line of code was just so that I could check the breakpoint and what values were held in the fields. It's just confusing that when the report opens, the PriorityTxt is empty. Yet when I press the 'Open in Design Mode' button followed immediately by the 'Open in Preview Mode'...
  8. klfduncan

    Adding a dynamic text box to a report

    Nothing at all. When I put a breakpoint in the program and check the values by hovering the mouse pointer over the code, the following values appear: Reports!ActiveLeadsCond!PriorityTxt = Null [Forms]![ReportSwitch]![PriorityFilter] = 'Monthly' I put in a line of code and put a breakpoint on...
  9. klfduncan

    Adding a dynamic text box to a report

    PriorityFilter is a combo box with the following values: Daily Weekly Daily and Weekly Monthly All The where clause is dependent upon the input from this combo.
  10. klfduncan

    Adding a dynamic text box to a report

    Yeah it is. I put a breakpoint on this line of code Reports!ActiveLeadsCond!PriorityTxt = Forms!ReportSwitch!PriorityFilter and it's definitely aware that Forms!etc contains the word 'Monthly' but for some reason, it refuses to populate the PriorityTxt field on the report.
  11. klfduncan

    Adding a dynamic text box to a report

    Hi Ken, sorry the second line should read: Reports!ActiveLeadsCond!PriorityTxt = Forms!ReportSwitch!PriorityFilter i.e. I'm trying to do what you had suggested by setting the control source of PriorityTxt on the Report to the field on the form. I still can't understand why it doesn't work.
  12. klfduncan

    Adding a dynamic text box to a report

    I manage a database which lists possible business leads. Each lead's priority is measured as either 'Daily', 'Weekly' or 'Monthly'. I then produce a report which displays the leads according to which priority is required, as defined by the control Me!PriorityFilter on the ReportSwitch Form. My...
  13. klfduncan

    Accessing and updating data in unopened tables

    Hi all, What is the correct syntax for accessing data in an unopened table? E.g. I have open a form bound to the table 'Customer'. It has a field called 'orders' in which I put the number 'x'. I want to create 'x' new records in the table 'CustomerOrders'. The two tables are linked by the...
  14. klfduncan

    Updating all records in a subform with value from Parent

    Hey PHV, thank you so much for this. I tried to give you a star, but my work browser said something about SpyWare. Not only does this work great, but with this I finally have the syntax to manipulate the recordsets - you don't know how many wasted hours I've spent trying to sift through Access...
  15. klfduncan

    Updating all records in a subform with value from Parent

    Hi all, I have a form, LsEdit, containing a WinLikely field (a number). LsEdit contains a datasheetview subform (continuous) containing 'x' number of fields, ConDet, each of which has a field percChance. These are linked by a one-to-many relationship on RefNum. I want to update all 'x' number...
  16. klfduncan

    Manipulating table data without relying on invisible controls

    Thanks VBSlammer. I haven't been able to put that into the new DB yet, as I'm rather busy but it looks great. Thanks for your help and I'll reply if there are any problems. If not, I gratefully appreciate your help. But now... I'm off to the HK7s to drink myself silly, so don't expect any work...
  17. klfduncan

    Manipulating table data without relying on invisible controls

    Thanks VBSlammer. I was unaware of that and thanks for the tip on naming conventions though I may be a bit far down the line for changing those at the moment. Right. Now for the (at least what I think) toughie. LeadForm is populated and controlled by LeadInput. Is there any way which I can...
  18. klfduncan

    Manipulating table data without relying on invisible controls

    Hi all, Ref: I am using Access 2002 OK. I want to change the data in a table (LeadInfo), which has 60 fields and populates the form LeadForm . The only way I can do this at the moment is to have a control in the form, non-enabled and invisible and using some form of AfterUpdate Event...
  19. klfduncan

    Date Range - filter doesn't work

    Cheers mate, it's just a bit confusing when the dateValue function returns it in British.
  20. klfduncan

    Date Range - filter doesn't work

    I should also add that I'm using Access 2002. I use the valueDate() method to convert from "September/3/2004" to a useable date, and it always returns it in British form: "03/09/2004", which are the settings in my control panel. Do I have to use American format to make this work?

Part and Inventory Search

Back
Top