Activity Stream

Thanks orange. I will try this tomorrow morning. As mentioned in my other reply, it's not a single field that is too big, but all the fields together...

Thanks Micron. The source is a SQL statement. None of the columns are too large by themselves, but all of them together are longer than 1024...

Thank you all for your replies Ajax, Minty, and of course Micron. I finally figured this thing out after hours of screwing around. There is...

I'm sorry I was not very clear. I have added 3 other attachments to help explain. (1) 44.5 hours is a result from when I started my employment....

Trying to understand... In your report, you have 3468...... 15-Jan-21 ............... (TOTAL TIL 44.25 + 14.5 = 58.75 HRS) The 14.5 hours...

It want matter when an error is detected they will just change the Quantity On Hand to the actual Quantity, the will essential just be using the app...

Have you tried using DoCmd.TransferText rather than your own vba? Sub expLongText() DoCmd.TransferText acExportDelim, , "Query59LongText",...

The source is what, a query? AFAK, you can export more from a table if the field is memo/long text than you can from a query.

Nothing attached.

Another option would be a 2 field table (NumMonths, txtDescription) and a combo box. NumMonths txtDescription

attachment for some reason the file will not upload will try again later

you could try what is called an upsert query which will add new records and update existing ones in one hit - syntax is along these lines UPDATE...

Hi all, Sorry I took so long to respond, working during the day and doing this at night, I have reposted the database for your review. This...

I would use an option frame with 2 option buttons. Option labels indicate the value. The chosen option is passed to the frame. The best benefit to...

On the other forum it is a 'sub' question based on post #9 to the one asked here originally. In my opinion you have missed out a step or two so have...

As Micron suggested, if your database is not normalized, you'll be in a continuous process of work arounds. Tables and relationships are based on...

That is all very well and good, but some would think you did a disservice to those that were helping you here but more so at AWF since you posted...

Thanks for the reply Micron! Yep...I understand the philosophy behind cross-posting. This is why I came back here to thank VLad and Ajax for their...

that "other" place is here...

You will get more help if you post a zipped copy here. You might be the most honest person in the world but you are asking us to follow a link. Some...

If I could put it another way it would be that typically, you use one thing but show another. Often 2 or more columns are used in a combo but the...

To access my program the e-mail is gearysonya@gmail.com

@Gicu That is a much better approach, as it does not matter what field is filtered then. :cool:

Vitals By Sonya Geary. med_help1 is the main page in the print out. add_help is the form basis of current symptoms. Next we have 3 sub...

***UPDATE*** Thank you Ajax and VLad for all your help! I really appreciate everything you guys have done to help me out. You taught me quite a...

Unless you have a very compelling reason to not normalize it (like a boss who says "don't") then you really ought to stop now and fix that problem....