Recent content by belly0fdesire

I'm still new at this, so bear with me, please... I want the database to open to different forms for different users. I have a table that's called "users" with 3 fields: RealName, UsNm and Level. I want the Level to be what determines the formt that's opened, based on the username they are...

I am drawing a blank on how to get this to work. I have a table called StraightTime with the fields ID (autonumber), UserName, Date, and Hours. I want an On Open Event for a Form to append to the table, and have the following as the VBA code behind the event: Private Sub Form_Open(Cancel As...

Thank you very much. That worked perfectly!

I'm still learning here, so please don't get annoyed if I don't know what I'm talking about. I have a Module that I created that looks up a value in a table.. It is shown below. Public Function DescLookup() DescLookup = DLookup("[Projdescription]", "ProjDescTable", "[OrderN] =...

Ah... so that's what that means. Thank you very much for the help, it works perfectly.

I'm still a little new to this, so please bear with me. I've searched to no avail for what I am looking for, so if there is an existing thread and you would rather point me in it's direction as opposed to answering my question, that would be fine. I want one of the parameters of my delete...

Okay... NZ() around the formula... I got it.. as usual i figured it out on my own, but thank you to anyone that considered helping me.. EDIT: just saw your response... thank you very much!

I am using the following function created in a module: Public Function StraightTimeLookup(ByVal UName As String, _ ByVal dat1 As Date) As Integer StraightTimeLookup = DLookup("[StraightTime]", "StraightTime", _ "[User] = '" & UName & _...

I can't figure out what I am doing wrong... I want the query criteria to be defined by a combo box in the form. The user will select the criteria on the combo box, then click a button to run the query, however the query keeps coming up blank. [Forms]![UserReview]![Staff] is what I have...

alright... i figured it out... was really easy... I just made a module with a DSum function referencing the query I created... the code i used is shown below...thank you if you at all considered helping me. Public Function PointValue() PointValue = DSum("[Value]", "PointQuery") End Function

Okay... I have a production database that my office uses... Users select a OrderType from the dropdown list and it appends it to a table with their username and the date... each product has a different point value... I have another table with the OrderTypes and their corresponding points... I...