Search results for query: *

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

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/

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

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/

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

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

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

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

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/

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/

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/

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

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

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/

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

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

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/

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/

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/

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/