Recent content by jjlogan

SOLVED: Thanks for the quick responses folks. Duane, I tried copying the Debug.print and got the same error messages, but in the sql copied I saw the error... stood out like a sore thumb - It was in the ORDER BY clause. I had an unassigned field RespOrg (cause of error); this field reference did...

Thanks for the input. 1) I did try your suggestion using the alias and still got the Error message: field RespOrg could refer to more than one table in the From clause. 2) So I then tried using the lookup table instead which holds the field RespOrg also; I used the full [Table name of...

So much fun when have limited time and get these errors. I create an SQL in the Report-Open event. It's a simple Select query with FROM two tables INNER joined and then three other tables in LEFT JOIN. I keep getting the error that "field RespOrg could refer to more than on table in FROM...

Thanks MagP for the input. I am currently not able to work the project I talked about, but will try your If table open logic as soon as I can, and will respond. JJL

Been working on this problem for a full day. Using Access 2016 with file formats 2003. Database file is on shared department network. I have a form with vba behind that upon clicking Start button, about 30 queries run in sequence saving us about 4-6 hours every time we do a What If (previously...

For some reason, my code below for DoCmd.RunCommand acCmdCopy is not only copying the text box contents into the clipboard but also opening a folder on my network (where I can then Ctrl-Paste into the Search box in the opened folder). I am now trying to change the folder location (new year) but...

Thanks for the practical advise. I will look into the recommendations like for pivots, sql server, etc. Jeff

What I do know is how to design tables and relate them in normal structure rules. Of course, design of all types of queries (select, action), report design, form design, etc. And I write modules in VBA and ADO and DAO. I also do use import/exporting to Excel. But what I don't use much is...

I would like to dedicate some time to learn the advanced features of Access 2010 that I have not had to use in my job of creating a few databases and automating them. I'm sure there are more features I not aware of and want to use company funds this time to advance my knowledge. I have read at...

I will try that, but will have to wait a few days as have other top priority work scheduled. What I see in this problem is that 2010 version is not working the same as 2007 version (which does the sorting). So, your suggestion here may be what 2010 version needs in order to sort. Thanks. I will...

Unfortunately, these changes did not cause the 2010 version of Access to sort. I again went to my 2007 version on another computer and ran the same report in the same Access file on network - and it sorts just fine. [my selected sort was by job code, then by a field for absolute value of line...

A little more clarification, then will show some more code: I can open this Access file (.mdb), which is on our group's network drive, from my computer with Access 2007 and from my new computer with Access 2010. The sorting runs perfectly when I use Access 2007 to open the file, but no sorting...

I created an Access report 4 years ago using Access 2003 that is not bound to a query but using VBA to create SQL record source and also perform sorting - all based on user-selected fields and values they type into my dialog form (e.g. Accounting key contains ....) and Sort By ... (combobox)...

MajP - Yes finally. Your solution worked. Created clean db, imported objects in (that took a while but allowed me to clean house), then ran the automation and no Error '5'. Thanks, Jeff

OK and thanks MajP. Will give it a go. Clean db. Jeff