Search results

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

Dear Ms.Access most powerful experts, I have a problem over which I have lost a lot of hair trying to solve. It may be something simple to you. I have a table containing list of items and form to enter New items. (a sample database is attached) Each item has an Id (ItemID), and when...

Okay, I am sorry, perhaps I am a complete amature at this. I thought I could do it myself from that point but I guess not. I tried to implement a macro in the NotInListEvent to create a new reocrd when the user enters a value that isn't the list. I went to the design view of the subform from...

Thank you very much Okay,That makes sense to me. I think I get it. I will try and will post back shortly. Thanks once again. I really appreciate your help!

If I understood you correctly, that mean the user will have to enter each item twice? Once to identify it and the second time in the list. Is there a way such that the user will only have to enter the item once in the list and it will simultaneously be created in the its table? thanks

Okay the three table structure seems to be working! It's a pretty aweosme feeling. Thank you! I have one problem though: I created a form out of the tblList for users to enter the data for each shopping list. However it seems that they can't enter any new items in that list yet since the...