Search results

Yes, Minty. Access will be running. pbaldy: I do not want this to run from Scheduled Tasks. Thanks for your replies.

Can access send an auto email from the database at a specific day (Thursday ) and time ( 4 PM )? I have to send this email from the specific computer - without user intervention. Thanks for your help.

I have to send an email when the data is changed in a specific field ( for example, a field data is changed from "Pending" to "Paid". Please let me know how to do this. Thanks for your help.

I checked there but I do not find a solution to Start with a specific letter ( in my case A or T). Thanks for your reply.

Hi, I have to add an Input Mask or force the user to enter in a specified format in a text field. The condition is, text should start with "A" or "T". The complete format is A-12345-67890 or T-12345-67890. Please let me know how to do this. Thanks for your help.

The user wants to avoid the extra step - saving and then opening. Thanks for the answer. I will go with this.

Report in PDF format Thank you, I figured out that I need to use sub report. I have another issue. Is there any way to open an access report in pdf format? I do not want to save and then open the report. Thank you.

Any help? Thank you.

Pease help me. I was able to create only 3 pages in access report. I am not able to go beyond 3 pages since the page footer is not moving down, means I am not able to drag it down. Am I doing something wrong here? It is a simple report of resume with only text boxes. My report comes...

Thank you for your replies Table: TblStock Fields: ProductCode, ProductAvaiable, ProductDescription Table: TblSales Fields: ProductCode, Customer, SaleDate Form: SalesForm with Recordsource-TblSales with the ComboBox for ProuctCode I wish to prevent the sales person to prevent...

I have TblStock with fields ProductCode (String) and ProdAvailable (Number). I have another table TblSales with ProductCode (String). I wish to check the record count of ProductCode in TblSales whether it is equal or less than ProductAvailable in TblStock. I wish to prevent...

Thanks for trying. There is no error message, and not working.

debug.print rst!PatientNumber show me the patient number "AS45362" Thank you

Thanks, I moved my code to the details section format event, not working.

Sorry, please read as they are not locked.

No they are locked pbaldy. they are not locked. allow edits is set to true. But the report's control source is another query. Is that a problem? My company wont allow me to send the DB. Sorry for that and please understand me. Thanks.

Thank you. No, they do not have control sources with = signs. Thanks for your help

No, all 10 text boxes are unbound.

Dear Sir, I have 10 unbound textboxes with the Tag Name "LoopID" in my report. I have to display the "PatientNumbers" field from the table tblPatient in those text boxes. Below is my code. When I run the report, I get the error message: Run-time error '2448.' You can't assign value to...

Thank you, I tried. Still it shows fields from top to bottom, not left to right. I changed number of columns to 4, row spacing 1", Column spacing 0.25", Column size 1", layout Across, then down. Please let me know where I am making mistake. Thank you.