Recent content by braimi

Thanks a lot DCrake and banana.... I got the report working now and I solved it by telling Crake's last solution. Thanks guys

Thanks Banana... I actually want the id to be returned for printing current records. because in query the table.field=[forms]![formname]![field] and unless the field on the form is not updated, I can not print current record. All it shows me a blank report without any data on it.

I am using a bound form which is bound to the table in mysql where primary key field exists

I can understand the example you have given and really thank you for the nice support. You are right that my vba knowledge is very poor but if you can just do some more help in this so I will be able to resolve the issue. Can you please guide me that how can I use this function and where I...

thanks for your prompt reply DCrake... would you mind to please tell me in little more details. because I am not an expert just a basic user of access.. Thanks

Yes it has a primary key and I have solved the issue. problem was that one of the field was set to required while there was no box to enter the value on the form for that field. but I am having another problem now. that is printing with current record. The form is based on the table in mysql...

Hi, I have linked the tables from mySQL server. I can view the tables but when I try to insert some new record using Access forms, I receive error that INSERT ON LINKED TABLE "TABLENAME" FAILED. Please help me out of this. Thanks

Thanks its all because of your help because the first problem where I got stuck with printing of current records was really making me to get rid of learning access. but you helped me and I was able to learn some more when you showed me the solution for that. Thanks once again.

Thanks Bill.... I have resolved the issue... To restrict the user to today or next date is just simple that in Validation Rule of the field I just entered =>Date() and that solved this problem and with where clause also the statement was easy WHERE...

Thanks a lot Bill.... It really worked great..... Now another question that how can I use the following where clause in query Where RemittanceDetails.RemittanceDate=[forms]![frmDayEnd]![SelectDate] - 1 I actually want here that when user selects a date on DayEnd form and when he clicks...

Hello Thanks to both of you Ashraf and Chergh. I have solved the search form issue but I am having another question that is I am stuck with updating a field record with a field from another table. I have two different forms. Form 1: DateId(AutoNumber & PrimaryKey) SelectDate (Date/Time, Format...

Update a field from another table field only for new records I am stuck with updating a field record with a field from another table. I have two different forms. Form 1: DateId(AutoNumber & PrimaryKey) SelectDate (Date/Time, Format "Short Date") DateChanged (Date/Time, DefaultVaule= "Date()")...

Thanks a lot PNG... I solved other forms issue... I need to create separate query and report for each form and in each query I have to set criteria for RemittanceID for QrySender for SenderDetails form = forms!SenderDetails!BeneficiaryDetails!RemittanceDetails![RemitterUniqueId] Thanks for your...

Yes I checked it. It is working fine on RemittanceDetails form but try to click the same button from the main form and you will find that it asks for the remittanceid and doesnt work. Also just to be sure that when you click the preview report button, does it take long to preview the report or...

Thanks for the great work but I just downloaded the attached access file and tried to run it, now it is showing only one record in the print report preview but I feel you didn't check that the record it shows everytime is the first remittance record. try to change the remittance instead of 1st...