Search results

@BlueSpruce What is the business driver for employees to enter these contracts? Is this something that management can control with proper rules? I am guessing someone is doing this to pad their pay. If this is true, proper response from management should be termination of the employee for...

@mfk5331 I would make sure exactly how they want to track statistics for KPIs. Normally instead of saving a "Shift" in your values, you can either store each value with the date/time it was entered (say amount of a sale) or a date/time for each shift start so you can track statistics from one...

@OP, A couple questions that may dictate your approach. 1) Do you need to associate physical items (inventory, vehicles, what not) to a given transaction? If yes, you'll need to work out assignment and roll back if the customer doesn't go forward with the transaction. This pretty much requires...

For normalization, instead of saving "SUPERVISORCODE_I", you would normally save the AutoNumber ID for the record.

Additional item you may want to check into. What happens if a user prints your report to a PDF then sends the PDF to the printer? Is that out of scope of what you are trying to catch?

Easiest way is to make sure your source is distinct. Not sure what you are really trying to do with this as it looks like you are parsing out part of field after selecting. Is that something you could break out before creating your list?

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.