Search results

  1. AC5FF

    Rearrange Table Data

    I am going to work on this as I have time Lagbolt.... Thanks! This is pretty much going to be a one-time thing; or could be a once a year thing. For right now, I ended up running a simple update query; I just had to edit/re-run it about 50 times.. LOL I needed the data re-formatted for a...
  2. AC5FF

    Rearrange Table Data

    LagBolt I hope that you had this VBA laying around and didn't have to spend much time writing it! This is going to be a good oportunity for me to learn a little on how to incorporate VBA into my DB. I am a very green novice when it comes to VBA. I know a lot about programming and how to...
  3. AC5FF

    Rearrange Table Data

    Sorry - Been a crazy day at work and I was unable to get back to here... Lagbolt - I completely agree with you. That is why I am trying to get the data restructured into a format I can easily use within the database... The original data was put into a 'spreadsheet' format in Excel for ease...
  4. AC5FF

    Rearrange Table Data

    Sorry; Part #'s are column headings and Weight is listed down the first column. The data (prices) are figured by looking at where the weight and part# intersect.
  5. AC5FF

    Rearrange Table Data

    I thought I was in for an easy task today - but I'm hitting that dreaded stone wall again... I have a table of data that has been imported from Excel. The data is formatted in the table as such: P A R T ___________________ W / E / I / PRICES G / H / T / As it sits, there are 53...
  6. AC5FF

    Linking Tables

    I should probably add - I'm working in Design View for creating my queries; I've not quite graduated to writing them in SQL.. :D I've got the books, and I practice, but I have not gotten proficient yet for writing complex queries .... :D
  7. AC5FF

    Linking Tables

    Maybe a better title... Linking tables when fields are not an "EXACT" match... Will this be possible? I have two tables, one is an inventory table (INVENTORY) that keeps a running total of each stock number's inventory. A second table defines (PARTS LIST) what stock numbers are required per...
  8. AC5FF

    Excel Acting Wierd.............

    Thx for the tips... Bob - I seem to be able to get out of this if I get into the task mgr with CTRL/ALT/DEL or I can also get out by taking my mouse to the task bar and right clicking on the Excel button and closing it there. I have never had to resort to a complete restart - thankfully...
  9. AC5FF

    Using Excel Data in a query

    Sorry for the delay in a reply here --- work has gotten out of control the past couple weeks... The way i understand this -- Excel is the criteria, and Access will hold the source information. I've done something like this in the past with ... i think it was vlookup function. But that was...
  10. AC5FF

    Excel Acting Wierd.............

    Just curious if anyone else has ever experienced this problem with Excel (running Excel 2000)............ Occasionally, when I am highlighting a group of cells, and attempting to scroll at the same time, Excell 'locks' up in what I can only think to call 'selection' mode. I.E. everywhere I...
  11. AC5FF

    Using Excel Data in a query

    I am in the process of re-vamping an outdated and severely flawed inventory database. I currently have an Access DB that runs inventory control, but an Excel spreadsheet (x10) that contains all the individual inventories for reporting. The end goal is to get rid of the Excel files and move to...
  12. AC5FF

    Importing Data from Excel is missing a field?!?

    100% sure this import is a spreadsheet. I have others that are CSV and TXT that have import specs (Spent ages trying to get that working right!) but this one is a spreadsheet.
  13. AC5FF

    Importing Data from Excel is missing a field?!?

    I hadn't thought about just 'linking' in the spreadsheet... Hmmmm Might have to give that a try. I don't really like the idea though because of the way our network is set up. It's not if, but when computers get upgraded they are just pulled out and replaced. Each computer has it's own...
  14. AC5FF

    Importing Data from Excel is missing a field?!?

    Looking at things again it appears to me like the wizard isn't even seeing the last column in the spreadsheet. But I just can't figure out why. There's no special formatting on this particular column - or any others for that matter. I have selected the whole spreadsheet; changed formatting to...
  15. AC5FF

    Importing Data from Excel is missing a field?!?

    I'm loosing it.... The field that won't import is the last field in the excel sheet. There are added fields after this one in my table - but those are added through update queries in the macro. I attached a sample spreadsheet - just removed all the data except for 2 rows...
  16. AC5FF

    Importing Data from Excel is missing a field?!?

    Okay I am stumped on this one... I've got a Macro that imports data from an excel spreadsheet each morning. Up until yesterday morning this has worked flawlessly. I can't seem to find any reason it would have stopped working - but.... The import step still works - to an extent. The excel...
  17. AC5FF

    Copy Table Problem

    Importing the table gives the same error. I did find a way that appears to work (still checking things out). But if I take the corrupt db and export the file to Excel, then go into my backup and import from Excel that seemed to do the trick. The corruption problem does not appear to be...
  18. AC5FF

    Copy Table Problem

    I could have sworn I have inquired on this problem before but I could not find any information... Soooo Here we go again! :rolleyes: Occasionally - due to computer issues or whatever - my db has crashed/locked up. To get things back up and running I use a previous day's backup copy and then...
  19. AC5FF

    Excel 2007 Conditional Formatting Gripe

    LoL.. Thx Brian!
  20. AC5FF

    Conditional masks

    Worked like a champ!!! Thanks!!
Back
Top Bottom