Recent content by Mark_

As an option, you can create your "Repairs" as a text string. You would then pass your string as the last parameter. This would allow you to skip creating an attachment. Something like strBody = "Tenant " & frm_repairs.Tenant & " in building " & frm_repairs.TenantAddress & vbCrLf & _...

Giant benefit to using the OS login is you don't have to develop security. You have a major corporation working out how to keep your system safe.

Were this to be me, I'd copy in the contents, process, then mark each file as "Read Only" and "Hidden". That way you can't copy over them and you don't get them in your list next time you run through.

I prefer something that involves a rapid oxidation reaction myself...

Isaac, are you referring to the Spanish in Novella's or the Spanish in the street? They can be as different as the Spanish spoken in Puerto Rico VS that spoken in El Salvador. Due to immigration, even the Spanish in LA is different than the Spanish in Tijuana. Spanish is about as mixed as...

Uncle, now share that to explain "This is why we have no problem with contrarotating propellers".

Is this for display in a report or on a form? Are you already able to create the start/end dates for each task and set up the dependencies?

I'll second MajorP's suggestion as it will make troubleshooting far easier. Create the query, look at the results, walk through your results to make sure they match what you NEED to count.

This SCREAMS to me that you will want to have a child table that holders Address. This is where you can specify the Company name, the First/Last name, the attention line, and any other relevant information. For an order, you then select WHERE the order is delivered. This can then even be defined...

Possibly implying you've been wanton in your behavior?

Best one was from an instructor who used to work here. He'd refer to himself as a "hardware installer". People in his field knew exactly what that implied and appreciated his humor. Fact that he's brilliant and could explain why things were the way they were helped. For those who needed a more...

There are 10 types of people in this world. Those who CAN read binary and those who can't!

OTHER way to fix this is to add the DataMode option after your filter. This is incase you need to selectively choose add, edit, or read only for different users/situations. DoCmd.OpenForm "form0_AddEditJob", , , "JobID=" & JobID, acFormEdit

Only issue I've ever had with bar code readers is some don't include a return or CR/LF when scanning. Just something to keep in mind and warn end users during product setup for their scanner.

As this is for permits, fees, and the like, is your accounting required to break out when the debt is incurred by the resident as well as when the expense is paid? Are you having to break out the sources? For example, trash or sewage charge that is periodic, has a date due, and that has to be...