Search results for query: *

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

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

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

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

Morning, I've searched through the related threads on this topic but still can't get my date range to work. I wrote a macro to create the filter and that all works fine. However the filter (or more specifically the WHERE clause) doesn't get the data I know is there. Previously I typed in...

Hi there, I know it's not a very original topic, but subforms are getting me down. I've searched through previous topics and can't find anything to match my query (is that a reserved word?) I have a form "ActionDB" which contains two subforms: 1. ActionIn 2. ActionHist ActionIn is a single...