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 Wanet Telecoms Ltd 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: *

  • Users: Wolfen02
  • Content: Threads
  • Order by date
  1. Wolfen02

    Error on UNC mapping to drive

    I'm working on a multi-user database with a launch program that copies the FE from a network drive onto the user's harddrive prior to opening. I've used this method many times successfully. Current Issue: Database will reside on a shared network drive but we do not want the user mapped to...
  2. Wolfen02

    Access to Excel Automation Error

    I'm copying a recordset obtained from a subform based on parameters set on the main form into Excel. The Excel workbook has both a "dump" page for the raw data and a template. Based on the number of records, the template is copied as needed. It then inserts a set number of records into each...
  3. Wolfen02

    Compare 2 fields of current record on continuous form

    I'm trying to compare two fields (date1, date2) on the current record of a continuous form. If the user attempts to enter information into Date1 when Date2 is not null, an error message is produced. The code below works fine for single form, but does not distinguish between records on a...
  4. Wolfen02

    Auto-populate date in subform using OnClick

    I have a subform where I am tracking plan vs actual dates linked to the main form by a unique number. On selecting a date using a MS Date and Time Picker on the subform, the user should be able to populate the plan or actual fields onClick. Originally the subform was a popup and worked using...
  5. Wolfen02

    Urgent - SumIf being stubborn!

    I'm using the following formula in VBA to try to get the number of symbols in Range2 where Range1 is null. There are 5 possible symbols to be found in either range. The formula will only return zero. Where am I going wrong?!? s = Application.WorksheetFunction.SumIf(Range1, "=" """",Range2)...
  6. Wolfen02

    Excel paste error

    For some reason I keep getting one of those annoying "Runtime 1004" errors when attempting to use the following copy/paste method. Still learning and can't seem to figure out where I've gone astray. where r = last row of data on sheet1: For m = 1 To k If...
  7. Wolfen02

    Excel: Random message when select given range

    I'm able to generate a random message for a given sheet, but am blanking out on narrowing the event down to a range within the sheet. Also the rnd function is returning two messages after the first time run. Tried to set the integer to zero to no avail. Following is the code I'm using. Any...

Part and Inventory Search

Back
Top