Search results

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

I've code to send multiple emails to a list, but I don't read in the "Body" from a word doc. Instead I generate reports that get sent to individuals and attached. Yes, very doable with classic outlook. I'm DREADING if they decide we MUST use new!

I'd suggest you work through your business logic first. Is Revenue just assigned to a client OR is it linked through something like a purchase order, payment for service rendered, transaction fee, or some other source? If the answer is YES, then you need to put in the middle part first. This...

You would need to get state legislators and academics to stop pushing them. I've a feeling it would be easier to push urine back up a urethra!

ellucian. If you know, you know. If not, be grateful! Has the wonderful look, feel, and helpfulness of a 1970's terminal program. Would probably be easier to use if they actually let us see the documentation for it!

When it first came out I asked ONE question that told me it wouldn't work; "Does this mean each UIC will get its own server to run it?". If they had set it up where each member's information was kept at their UIC and only summary data was pushed up, it would have worked. This is kinda how...