Search results

Thanks. At this point in time I really don't care about the activity stuff. I had to shrink my current db down so i just created this one and didn't pay attention to what i put in the table. You're right, activity should be in the separate table. So putting aside activity stuff, I'm thinking...

Thank you so very much for doing this, Phil! I really appreciate it. My manager has been on me all day for this. I do have a couple of questions. 1. With what I see, I don't really need a request start/request end dates. 2. It seems like this is not based on the StaffID, just StaffName because...

I have been struggling with this and I’m wondering if you could possible give me a head start on what I need to do. I created a little database to replicate what I need done. I’m not sure if I need to create a query to check for the date conditions or if I need to create “BeforeUpdate” event and...

Thanks, this helped a lot. Now I need to figure out how to replace your +-90 minutes with 2 sets of dates. I have a start, end date variables and requestedstart,requestedend date variables.

why are you using that code line? <>[Forms]![frmOrders]![OrderId] what purpose does it serve?

What does this statement do in a query? <>[Forms]![frmOrders]![OrderId] I'm not sure what <> stands for. Thanks.

This was very, very helpful! Thank you for going out of your way and posting this. I really appreciate it! Now I need to figure out what you are doing. Thank you again.

I have a form where user picks start/end dates for a certain person for a certain task. What I want to do is to check and see if that person is already doing something on a particular day. I’m storing all the start/end dates in a table where I have employee ID as a foreign key. Is there a way I...

Thank you for suggestion. I've never worked with modules... I guess I better start, so I will try this. Thank you again.

That worked great, thank you!

for the On-Click event for that button: Private Sub Command53_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmMain" DoCmd.OpenForm stDocName, , , stLinkCriteria DoCmd.Close acForm, Me.Form.frmAddNewClient End Sub

I get an errr/msgbox when my main form comes up that says: application-defined or object-definer error.

On all of my forms I want to put a button - back to Main menu. With this, I want to open the main menu form(which I know how to do that) and close current form (which I don't know how to do). Could someone please help me. Thanks!

Thank you! That works.

I changed it to a Totals Query, but if I have more than 1 time entry (different dates) for 1 person, it just sums the hours worked on that day and not total hours for that person. Did I do something wrong? Thank you for all your help! Attached is what my query looks like now.

I have this query that I'm tryin to create a new field in - Total:Sum([Hours]) For each person I need to know how many hours they worked. I'm linking to a SQL server table which I created a query from and now trying to add this field Total into this query. It is hard to explain the problem I'm...

Can't believe it was so simple... Thank you!

Thank you, that worked great!

I have a form and when it loads, I have combo0.visible = false. A user then goes and checks for something on another form and once that is done, I do this: [Forms!frmProjectStaff!Combo0].Visible = True and then close previous form. This is not working, which I'm sure the coding is incorrect...

Shouldn't this statement open my report? DoCmd.OpenReport "rptPersonCheckAvailability", acViewNormal For some reason it keeps sending it to the printer instead of openning it up. What am I doing wrong? Thanks.