Recent content by camollie

  1. C

    Field Data Type Issue

    thanks for the ideas - I will take this info and try to build a work around - I'll let you know how it goes fingers crossed
  2. C

    Field Data Type Issue

    Hi AllI have a problem - I am importing an excel *csv file and the import works fine with one exception relating to 1 data file field.In the table I have the Data Type defined as "Short Text" the problem I have it would appear Access is trying to be clever on the input and thinks this particular...
  3. C

    Import .txt rather than .xlsx

    Solved - thanks ArneLpg - you got me heading in the right direction (ended up settling with *.csv as that appears easier for IT. Stuck with original script with you DoCmd knife and forked in - thanks for your direction:Public Function ImportDay02() Dim strPath As String Dim strFile As...
  4. C

    Import .txt rather than .xlsx

    Hi - I have given it a go but nothing happens, no error message, no debug, just dead - do I need to specify "specificationFile" ? would it be more practical to import files as .csv format??? - based on your experience/best practice ?
  5. C

    Import .txt rather than .xlsx

    Many thanks for swift reply, I'll give it a try and see how I go - thanks again
  6. C

    Import .txt rather than .xlsx

    Sorry for format of posting - trying to sort justification
  7. C

    Import .txt rather than .xlsx

    HiI have a number of modules to import “.xlsx” files – which works all though I sourced this code from a forum and I think it was originally written to loop the import function for all files in the folder I have a separate module for each file I want to import as defined by the “strFile Like...
  8. C

    Export 2x Tables to predefined tabs in Excel in single operation

    I'll give it a try - many thanks
  9. C

    Export 2x Tables to predefined tabs in Excel in single operation

    Hi - I tried this code but still had the same problem of Excel opening a new instance for each table export process and it wouldn't copy into existing worksheet but create a new one with the suffix 1, eg tab1 - however the code below did/does work for me but it just doesn't automatically open...
  10. C

    Export 2x Tables to predefined tabs in Excel in single operation

    Many thanks for speedy reply - I'll let you know how I get on - thanks again.
  11. C

    Export 2x Tables to predefined tabs in Excel in single operation

    Hi All I know this is a topic that is regularly touched on and the current solution I have has been put together from snippets on this site but it doesn’t quite tick all my boxes. It relates to exporting table records from 2 separate tables into an Excel workbook, into predefined worksheets...
  12. C

    Lookup Common Product in different tables and calucate difference in Values

    Hi All To Start, I am no coder, though I am learning as I go (mostly be Frankenstein others coding) to get the results I need, though I have now hit a bit of a roadblock. I am trying to calculate the daily change in stock qty and stock value at PartNumber level. My source data is a rawdata...
  13. C

    Lookup IIF query???

    Hi Plog - Many thanks for your prompt reply and help (even though you may feel you haven't done anything - you have:) ) Think I was over complicating matters and have a brain f*rt. it was just a relationship link between two of my tables. The next stage of development will be to remove some...
  14. C

    Lookup IIF query???

    Hi All, I am just a beginner and I have a problem. I am building a db in 2007 and in the source data there is a date field which has dates into the future but I only want the query to run with dates from the current and previous months. I do not want the user to have to stipulate the date...
See more
Back
Top Bottom