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!

  • Congratulations strongm 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: *

  1. Bill6868

    Importing Objects from Acess 2016 ti Access 2013

    I have an employee that I’d like to enroll in online Access classes. There are downloads involved in taking the classes from this particular vendor but the classes are in Access 2016 and we use 2013. In general, would anyone in the Tek-tips forum community know if importing objects from 2016...
  2. Bill6868

    Query Expression Question

    Thanks Andy. Here's the expression: Age: (Now()-[DOB])/365.2425
  3. Bill6868

    Query Expression Question

    In a query I have an expression that calculates a person's age based on today's date and their DOB. Is it possible to create another expression that calculates all these people's ages and gives me an average. Could I do this at the query level or do I have to do it at the report design level...
  4. Bill6868

    Access 2013 - Network access was interrupted....

    Thanks Andy. I'll have to wait until after the Christmas holidays to get back to the office but I will forward your links to our IT.
  5. Bill6868

    Access 2013 - Network access was interrupted....

    At my office we recently upgraded to Access 2013. All my Access databases are "timing out" and "freezing" on me after 15 minutes or so. Here's the prompt message I get: "Your network access was interrupted. To continue, close the database, and then open it again." OK; Help Of course when...
  6. Bill6868

    The Future of Access

    I'm always hearing stories about Access being phased out, discontinued, no longer supported etc. Any feedback on this? I have a lot of Access databases I've programmed over the years that are still in use, both at the office and at home. I'm using Access 2010.
  7. Bill6868

    Report Number Count Expression - Question

    I have a report with rows and rows of record lines. In my field [LastNameFirstName], I'd like to write an expression in an unbound text box (for the report header)that would give me a number count of all names in the report, but I need the expression to eliminate the duplicates from the total...
  8. Bill6868

    File Size Clarification For Access 2007

    I'm the only one using the database so I'm not too concerned about splitting it at this time. It has a lot of .jpg photos which is adding to the size. I have used the compact & repair procedure for years but in this IT environment I have been unable to do this. The process freezes up on me...
  9. Bill6868

    File Size Clarification For Access 2007

    Thanks missinglinq. From what you mention I was able to view the system objects in the Objects Pane, but it wasn't until I ran a report in the Database Documenter was I able to see the file sizes of these objects. Even that was confusing...it tells me the file size is, for example, 8 or 128 or...
  10. Bill6868

    File Size Clarification For Access 2007

    When Googling for Access 2007 files size limitations I am told that the file space is "2 gigabytes, minus the space needed for system objects". Not sure what they mean by system objects. I thought queries, forms, macros, reports were the system objects. Would someone be able to explain a...
  11. Bill6868

    Where Clause in VBA for Sub Command_Click()

    JR.. I figured this out: DoCmd.OpenReport "rptAvery5160", acViewPreview, , "(((tblConstituents.ProfileType) = 'Individual') AND ((tblConstituents.Status) = 'Active') AND ((tblConstituents.EmailOK) = True) AND ((tblConstituents.[SCP-M]) = True))" "Individual" needed to be 'Individual' as well...
  12. Bill6868

    Where Clause in VBA for Sub Command_Click()

    Thanks jr. I wrote this: DoCmd.OpenReport "rptAvery5160", acViewPreview, , "(((tblConstituents.ProfileType) = "Individual") AND ((tblConstituents.Status) = "Active") AND ((tblConstituents.EmailOK) = True) AND ((tblConstituents.[SCP-M])= True))" but I'm still getting that nasty compile error...
  13. Bill6868

    Where Clause in VBA for Sub Command_Click()

    I'm having trouble with the syntax of a WHERE clause. I need to open rptAvery5160 in print preview WHERE tblConstituents.Profile Type = "Individual" AND tblConstituents.Status = "Active" AND tblConstituents.EmailOK = "Yes" AND tblConstituents.SCP-M = "Yes" The two yeses (EmailOK and SCP-M)...
  14. Bill6868

    DMax Question

    Thanks Duane. That'll work. Much appreciated. Bill
  15. Bill6868

    DMax Question

    I need to have this form, that when it opens, it opens up to the highest record number [RecNo] that is in the table. The data type of the field [RecNo] is a long integer. I'm guessing a DMax "On Open" event but not sure what to write. Any suggestions would be most appreciated. Bill6868
  16. Bill6868

    Query Quirk

    MajP - there are no space(s) before the A. I changed the station's name to Westport Cooperative Services A and now I don't have a problem. Still a mystery as to why the "A Westport Cooperative Services" criteria line failed when running the query. I dunno. Thanks for everyone's input...
  17. Bill6868

    Query Quirk

    Duane, I understand what you're saying about parameter prompts and I don't generally do this, but this is a report I'm creating on the fly for a purpose we only use once a year. Next year it will be something different. The report is only for me and not my users. Bill
  18. Bill6868

    Query Quirk

    Skip, The SQL in this field on the criteria line simply reads (for example) "B Westport Cooperative Services" - this work fine, as with any other station name I type in - it's when I enter "A Westport Cooperative Services" that no records are returned. It does not like that my first word is...
  19. Bill6868

    Query Quirk

    I have a field named [Stations] in my table, in which resides the names of our service stations I.e. “A Westport Cooperative Services”, “B Westport Cooperative Services”, “Spectrum Home Health”, “Don Bosco Center” etc. I want to filter by station, so in the criteria line of the query (which is...
  20. Bill6868

    Count Expression in a Report’s Unbound TextBox

    Thanks Duane - much appreciated. Bill

Part and Inventory Search

Back
Top