Recent content by HiTekRedNek

LOL!, thousands our hours, I wish to even get a few hours to spare per week lately. I hope you don't mind me asking another favor. How would I go about migrating this code to an UPDATE query? I tried to do it but I'm getting syntax errors. I think I am a bit off with how I am putting the string...

That worked! JHB, you've been a great help! I wish I had those kind of skills with MS Office products. This forum is one of the best for quick reliable support on the internet. Thanks!!!!

The code I am trying to run is a simple Select/From SQL query to match partial data between 2 tables, ignoring everything after a period separator in one of the tables. Here is the code: SELECT Prod_This_Week.[System Name] FROM Prod_This_Week LEFT JOIN Inventory ON Prod_This_Week.[System...

I am trying to run a query in Access 2010 but I am getting an "Invalid Procedure Call" error. I searched online and found that this error can be caused by broken references. I opened the VB editor (Alt F11) to search for "Missing" references but I do not see any. These are the 4 that are...

A colleague of mind suggested just to normalize the data in excel before importing by using "Find and Replace" on the extension, replacing it with a blank value. A simple but effective solution, however it would still be cool to be able and figure out how to do this in Access without having to...

I'm getting "Invalid Procedure Call" when executing the query.

Thanks for giving me some hints. I've been unable to get this to work but I think I'm on the right track. Here is my SQL code with the correct names of the tables and columns: SELECT Prod_This_Week.[System Name], Inventory.[CI Name] FROM Prod_This_Week LEFT JOIN Inventory ON...

I am working with two spreadsheets that I have imported and would like to know if there is a way of finding matching data between two columns. The tricky part here (well for me anyways) is that the columns have similar data but one has a period separator with an extension value that I want to...

No replies!!! Just to explain a bit further here are what the columns look like in order. 1. System Name 2. Assignment Path 3. Agent Version (deprecated) 4. Last Communication To test my issue I imported the Excel data into a new Access table and in 2 different places the fields are out of...

Hi, I've been using MS Access 2007 for years to manage some Excel data. running some queries etc. Just recently I've been encountering problems when importing data into an existing table. When I do it now, I get a "Subscript out of Range" error. To troubleshoot, I imported into a new table and...

Hi, I have 3 seperate spreadsheets containing server information. There is a column in each of the spreadsheets with a header called hostname. I import the 3 spreadsheets and create 3 seperate tables. Table_A Table_X Table_Z Table_A acts as my master table. I would like to run a query to...

Thanks for the idea. Do you know of a good cross reference link or resource that has a thorough but easily explained summary of how to use all the statements and how to construct them?

Hi, I would like to hear some suggestions regarding the best way to learn SQL. I am not from a programming background but I know a bit of VBScript for systems administration purposes. I own Office 2007 and use Access and Excel. I know Access has alot of SQL functionality but I have never used...

It worked like a charm. Thanks!

I'm weak with VBA. I think it's time I learned. Now only to find a good book or resource for beginners. I value your suggestions.