Recent content by klfduncan

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

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

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

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 ?

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

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

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

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

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.

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.

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.

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

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

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

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