Activity Stream

Right before the docmd.runcommand accmdsortascending, set the focus to me.stepid

Can you send me the db as well thank you, eversworldtv@gmail.com

Yes, I would agree. However, I would also expect future C&R tasks to successfully complete if: this is in fact the name of the temporary file, and it...

What an intriguing idea! Just create a small Access form which could come and go. I'll try it out, but if it's too much hassle I'll just stick with...

New database attachment

Study the format function from the previous code Replace Me.lstChooseDates.ItemData(i) with the date variable you want to format. Unfortunately...

That was the problem. It works as your form did now, except for two things: I'd like the format in the listbox to be "DDD, mm/dd". And the bigger...

Where would you get the info if you are doing this in Access? You must have tables for Address?? Also, the contents of the pallet come from...

Hi Orange, I have already posted a picture of what I need the finished report to look like. Our Production team are currently doing it on...

Field could also be referenced in a combobox rowsource string.

My suspicion/guess is that that file is deleted once the C&R is completed successfully.

A sample of desired output based on given data would be helpful. Can build a mockup in Excel. None of the Encounter records in database have value...

Interesting -- the file database.mdb is not listed in the folder, yet the error still occurs: Any attributes that need to be cleared for it to...

The temp database created during a C&R is called database.mdb (even if the file being compacted is an ACCDB file) and is in the same folder

I can't tell for sure without seeing your database but it sort of sounds like the listbox column count, column width, or bound column properties...

perhaps you have previously filtered or sorted on this field and it is still sitting there in the query properties

Yes, I suspected that. The function I suggested would use the PalletQty and the TotalNumber of Items and tell you how many pallets were required.It...

message boxes are a MS creation - a windows system object, nothing to do with access or vba. It may be complex vba can change the attributes (I'm not...

Thank you for your response but I am a novice access user I went through the examples you provided and understood that I need to use sub queries but...

not sure - think it is the same name as the db plus something like 'backup' suggest order your files in date order and look at the ones for the...

Copying to another folder did the job. I'd still like to find & delete that temp DB in the original folder. Any idea what the name would be? Any...

Is this a prompt you want to eliminate or you want it to show in the query output? I presume parameter is on Criteria row. You could also...

Yes, new topic probably should have new string/thread. Click the 6-point start at lower left of post.

kd2017, your solution works perfectly in your ListBoxDemo file that you sent. I copied the procedures from the class module in your db and pasted it...

Ah, that's why I couldn't get it to accept the actual ("Brisk") text stored in the variable. It seems there are both a single quote and double quote...

Try to use Count>1 in your totals query (for the part type field). Cheers,

Can you please clarify if you want to file the attachment or the actual email message itself, which I think would involve automating Outlook...