Recent content by rabuayya

I am only learning :D Rami

Mark I found it. I just enclosed the text box values in "#" symbols in the code. I remembered that whenever passing dates to SQL statements they must be enclosed in #. So my code now looks like this: DoCmd.SetParameter "P0", "#" & Me.txtReportStartDate & "#" DoCmd.SetParameter...

Hi Mark. I see. I like this method. but unfortunately I am getting an empty report :( Not sure if it's something to do with the way the dates are set to the parameters or ... no idea! Thanks for your help

Thank you Plog. That works. I never thought about putting an aggregate in the report. One thing though! now that there is nothing in the detail section of the report, I have extra space between the lines in the report. If I set the height of the detail section to Zero, I get an error message...

Hi thanks for your quick reply. I am not sure how to add it since it's an aggregate query? Can you please tell me how?

Hello I am creating a database to track overtime for my employees. So I created 2 tables, one named EmployeesTable with fields (EmpID, EmpName) and one named OvertimeTable with fields (EntryID,EmpID,OvertimeDate,OvertimeHours). I created a query to return the total overtime for each employee...

Amazing. It works. Thank you.

I don't know if I can post on this thread considering it is ~8 yrs old. I just stumbled on it and it really helped me clear all controls in my form except for a listbox. I am trying to deselect the items in the listbox. My form contains text boxes and one list box. I created a btnClearAll...

GEEEENIUS GEEENIUS GENIUS! Thank you for this post! saved me hours I could have spent pulling hair trying to figure this out!:D

I would like to give an example: Assume these shortcuts for the type of doucment Receipts=Rt Invoice = In Letter = Lt Assume my database contains only the following tracked documents: Rt-08-01 Rt-08-02 So if a user is tracking a receipt (Rt) belonging to Department#08, the computer should...

Hi there, I have taken a course in Ms.Access where I learnt how to create tables, queries and forms. I don't have any programming background so I am using the Ms.Access interface to do everything without entering any codes. My project is the following: I need to create a database to track...

I tried 1/9/1434. The equivalent should be 10/7/2013 but instead, it come out as 8/7/2013. Thanks Rami

Thanks Mushtaq. That did indeed work. I just copied exactly the code in your example into my database. I noticed however, the Hijri date is off by two days, do you know if this can be adjusted somehow? Thanks Rami

Hi Mushtaq, I have tried to do that. But the computer reutrns a Syntax Error. Not sure what I could be doing wrong. What date format should the argument of the formula be in ? Is it possible to post a simple example of the usage of the formula? Thanks Rami

Thanks pr2-eugin, That worked perfectly. Although I used the same formula, I put in the expression rather than in the code. I don't really know how to use to codes so I just copied and pasted yours and it did the job. So I don't use Autonumber because sometimes I need to change the serial#...