specification

  1. S

    Annoying Error When Trying to Reload Excel Database

    Cannot Define field more than once and The specification failed to execute. Try re-creating the specification I am simply trying to reload an excel file with the updated one, I've done it before no errors. I even removed the Auto Numbered ID and reran the load, same issue. if not this error...
  2. C

    Days between dates and color coding

    So I have specifation register listing 300 products, the date the specifcation was issued and the date the specification expires. Specifications expire after 3 years. I want to keep my specifcation file current by checking the difference between todays date and the expiration date. If the...
  3. C

    Import Specification -- Cannot Find??? I'm sure it's there!

    I'm trying to execute this line of code: DoCmd.TransferText acLinkDelim, "TheUploadSpec2", "ltUpload", upPath & upFileNm, True I keep getting Error '3625' -- Specification Does Not Exist. But I swear it absolutely does! When I go to External Data>New Data Source>From File>Text File...I click...
  4. B

    Conditional Formatting with Specific Text, relating to another cell value

    Hello, I am trying to figure out how I can have conditional formatting depending on text in one cell relating to value in another cell, but for several different items... for example DATA <tbody> Item Value 1 Value 2 Apples 15 43 Oranges 18 24 Bananas 7 34 Mango 3 8...
  5. H

    Excel : Reference : Object Model explained ?!?

    Hi there, Im trying to develop some Add-In for Excel (+ PPT) however, I often cannot understand the meaning / purpose of some of the object model methods and properties. Searching for the right method / properties really discourages me. Do you know any reference which explains the purpose...
  6. I

    Ms access Export Specifiction

    Hi All Ms Access Guru I've been trying to export only 4 coulmns i.e. c1,c2...c4, the last column c4 keep some null values , but I would like to to replace last column value if null = "" Sam value as TextQualifier During Export Wizard, (It does show me some output rows sample and in there it...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top