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 TouchToneTommy 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: Blorf
  • Order by date
  1. Blorf

    Database Corruption woes after installing 2019

    The switch to 64 caused similar sounding issues with 32 bit databases on my bosses machine. It took some time to figure it out, but as soon as we reverted to 2019 32 bit, all the problems went away. Was hoping it was just that for your sake, but alas, no. There Are 10 Types Of People In The...
  2. Blorf

    Database Corruption woes after installing 2019

    Did you switch from 32 bit Access to 64 Bit Access? There Are 10 Types Of People In The world: Those That Understand BINARY And Those That DonÆt. http://www.thelegacyreturns.com/
  3. Blorf

    CreateObject("CDO.Message") Do not keep a copy in sent items

    Thanks for the help anyway. I'm not married to the code I'm using, so if there is an alternative that supports this, I would certainly try it. If you have a suggestion I would appreciate it, I will give google a try also. Thanks! There Are 10 Types Of People In The world: Those That...
  4. Blorf

    CreateObject("CDO.Message") Do not keep a copy in sent items

    Hi. I don't have to set any references, so I believe it's CDO for Windows 2000. Server is Gmail. Thank you. There Are 10 Types Of People In The world: Those That Understand BINARY And Those That DonÆt. http://www.thelegacyreturns.com/
  5. Blorf

    CreateObject("CDO.Message") Do not keep a copy in sent items

    Hello. I'm using CDO.Message to distribute auto reports. My email sent folder over time becomes too large and I have to go in and delete old messages. I was wondering if there is a .item that instructs the e-mail server not to store a copy of the e-mail being sent. Thanks in advance for any...
  6. Blorf

    Hi All, Firs I will be grateful

    The first challenge I I think is that your start date, though earlier than your end date, may have a later time then the end date, so if you don't do it right, you will get negative hours. In the sample code below, I am giving two dates, June 3 and June 9, clearly 6 days apart, but the way my...
  7. Blorf

    Form Field limited to 255 characters

    Me.txtOrgChange.Value = DLookup("[Note_Text]", "dbo_Job_Operation", "[Operation_Service]='" _ & Forms![frm_ChangeEntry]!Operation &"'") Looks like your field criteria [Operation_Service] is a text field, so your dlookup needs to have the form value in ' (apostrophes) There Are 10 Types Of...
  8. Blorf

    Sub Reports in Access 2016

    Does either the parent report, or the sub report, when opened desperately, ask for the value? If so, look to see that all of your bound fields have matching fields in their respective data sources. Is either report based on a cross tab query? if so, does the cross tab rely on a filter from a...
  9. Blorf

    Errors, I believe related to Macro security

    is it just one machine giving the errors, or did something happen to the entire database? There Are 10 Types Of People In The world: Those That Understand BINARY And Those That DonÆt. http://www.thelegacyreturns.com/
  10. Blorf

    I have an access database that has

    Your form is named Prep, and it is open when you run the report? Also, is your text box text2 formatted as a short date or some other date, not general text? There Are 10 Types Of People In The world: Those That Understand BINARY And Those That DonÆt. http://www.thelegacyreturns.com/
  11. Blorf

    Report: CanGrow Issue - Works on Some machines and not others

    I have no idea why, but that worked. Thank you! There Are 10 Types Of People In The world: Those That Understand BINARY And Those That DonÆt. http://www.thelegacyreturns.com/
  12. Blorf

    Report: CanGrow Issue - Works on Some machines and not others

    I've been reading about Cangrow, there are a million threads out there, but none seem to apply to my issue. I have a report, with a text box in the detail section, set to CanGrow Yes. The text box is growing as needed on about 1/3 of work stations, and fails on the other 2/3. What makes this...
  13. Blorf

    DoCmd.RunCommand acCmdRecordsGoToNew

    Most common cause for #Name is a form field is bound to a field name that doesn't exist. Second, if the field is calculated and calls on a field not there, or calls on it's self, those will do it also. There Are 10 Types Of People In The world: Those That Understand BINARY And Those That...
  14. Blorf

    DoCmd.RunCommand acCmdRecordsGoToNew

    That would do it. Make table queries do not bring along any indexes or constraints. There Are 10 Types Of People In The world: Those That Understand BINARY And Those That DonÆt. http://www.thelegacyreturns.com/
  15. Blorf

    DoCmd.RunCommand acCmdRecordsGoToNew

    Open your query directly and see if you can make edits. If not, the query is your problem. In order to edit records in a query I think the join has to a unique index on one of the two tables. Don't remember all the rules but I think this is going to be your problem. There Are 10 Types Of...
  16. Blorf

    Inventory

    Library Master, Utilities, rebuild Sort Files for Purchase Orders. It will ask if you want to recalculate on order quantities. Do this only when you have a fresh backup. I'm told it can do damage, though I have never seen it do damage personally. There Are 10 Types Of People In The world...
  17. Blorf

    Insert BLOB in SQL server

    I have used functions found here successfully with SQL server 2014 and access 2013. http://www.ammara.com/access_image_faq/read_write_blob.html There Are 10 Types Of People In The world: Those That Understand BINARY And Those That DonÆt. http://www.thelegacyreturns.com/
  18. Blorf

    Run-time error '3065' Cannot execute a select query

    how about trying DoCmd.RunSQL (strSql) instead of trying to execute? There Are 10 Types Of People In The world: Those That Understand BINARY And Those That DonÆt. http://www.thelegacyreturns.com/
  19. Blorf

    Receipt of goods reversal.

    You can do a return of goods entry. There Are 10 Types Of People In The world: Those That Understand BINARY And Those That DonÆt. http://www.thelegacyreturns.com/
  20. Blorf

    Run a Dos .bat batch file from Access

    Us old people call it a DOS prompt for the same reason we say Video Tape when we record videos on or phones. Command Shell, Digital Camera. We know what we mean. There Are 10 Types Of People In The world: Those That Understand BINARY And Those That DonÆt. http://www.thelegacyreturns.com/

Part and Inventory Search

Back
Top