Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jjlogan
  • Content: Threads
  • Order by date
  1. jjlogan

    Specified Field Could Refer to more than one table

    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...
  2. jjlogan

    DAO Execute Make Table Query Error if Table Exists

    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...
  3. jjlogan

    DoCmd.RunCommand acCmdCopy

    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...
  4. jjlogan

    Best training for Advanced Access - online or instructor-led

    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...
  5. jjlogan

    Access 2007 to 2010 OrderBy in VBA Not Working

    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)...
  6. jjlogan

    Run-time error '5' Invalid procedure call or argument

    I suddenly started getting this error message after my database has been used for years. Each year we copy the last mdb file and load the current year's accounting data. The problem is occuring in my user interface form when user clicks a button to run a history report for the natural class that...
  7. jjlogan

    Object Dependency repeatly prompts for OK to search

    Object Dependency feature used to do automatic refresh when I select a different object to check on. Now, it prompts me each time for OK response and then goes through search routine showing progress bars. My Access 2007 has Options / AutoCorrect Tracking set up. I am working in split database's...
  8. jjlogan

    Find A Folder Programmatically

    I have researched posts on this forum and Google, but no help yet. Would appreciate your input. Using Access 2003 where the user would like to open Windows Explorer folder (or go to it) based on a text box on the current record of an Access form. Each record represents a different audit data...
  9. jjlogan

    Global Modules - cannot delete, rename, or cut

    In my Access 2003 database, my global modules changed (by some process) so that I cannot delete, rename, or cut them out of the db. I want to delete them so I can import fresh copies from a save db. Any understanding on this would be appreciated. Jeff
  10. jjlogan

    Migrating to Access 2007 But Keeping 2003 File Formats

    My question is about affect on vba coding: The company has been waiting for our department to let them install Office 2007 (upgrade from Office 2003). We have four important multi-user Access 2003 databases with significant vba automation. I've read MSDN's article on "Transitioning Your Exisint...
  11. jjlogan

    WithEvents ... As ControlInReportEvents ??

    I have a report that shows a property in Object Browser that is strange and I can't get rid of it: the property is named "myParameter" (this is the name I gave a parameter long time ago) and this property is defined at bottom of browser as "WithEvents myParameter As ControlInReportEvents." I...
  12. jjlogan

    Syntax Error in From Clause - Insert Into

    This is mean. I have code behind a form that runs action queries (make-table, append, ...) to automate about 30 steps. One section of code includes an ADO recordset open statement that executes an Insert Into SQL query: Here's a snipet (after dim'ing etc.): Set con = New ADODB.Connection...
  13. jjlogan

    Access report doesn't exist; No Module Found error

    Hello all, I've searched google and this forum but no answers: My Access 2003 database suddenly won't allow users in because they get immediate error "No Module Found" and also a related error "The report name 'name of report' you entered in either the property sheet or macro is misspelled or...
  14. jjlogan

    Using a parameter against Expression in Query problem

    I've searched google and this forum without answer. Problem: I want to create a query to feed report in which one of the three selection criteria is that Absolute Value of an amount field (UCACurrent) is >= a parameter value as provided by report user (parameter is [Enter lowest absolute value...
  15. jjlogan

    Access Report Control Date With 2-digit Year

    I haven't been able to format a report control used to display a date field; I want the report just to show mm/dd/yy and not mm/dd/yyyy. If I specify a ControlSource as FormatDateTime([my date field],"mm/dd/yy") I get "Error" in report. The table format for this field is Date/Short. I've...
  16. jjlogan

    Automating Manual Access Steps

    I am not getting consistent results in my tables after running a subroutine that performs about 35 Access steps (instead of doing them manually). I'm wondering if anyone has experience with this type application (basically automating manual steps)? Background (sorry for lengthy): The Access...
  17. jjlogan

    Using Subforms to Add Table Records

    I am developing an Access 2003 (SP2) project that has two tables (in particular) with a one-to-many relationship. The two tables are populated at the beginning of the year with downloaded data from Accounting's table of Job and Subjob codes on the corporate network; my application will use the...
  18. jjlogan

    Programmatically change label caption on form

    This should be easy, but not working. I've set up a form in Access 2003 which includes a label to give information associated with each record, e.g. the records fall into three categories and let the User know which category: if category A, then I make the label visible and want to show the...
  19. jjlogan

    Relational data in VB6 Without Database?

    I would like to prepare a VB6 application where the user collects data and can later print reports. I normally use Access but want to do this in VB6. I would like to know if I can use some type of joining of data sets; i.e. keep data on separate objects in separate text files - probably Random...
  20. jjlogan

    In shared database, can single report be shared?

    Five years ago I created a shared database on network (tables are not split off) and still being used today (now in 2003 version Access). I have always used a separate query and separate report for each user. It's a pain updating the reports because I then have to copy/paste the changed report...

Part and Inventory Search

Back
Top