Search results

I've been fiddling around with the Tools>>Security settings but I can't seem to find a way where only I can make changes to the database and the users can't just use the switchboard. If you are regular user you don't need password but if you are admin you do. How do I do that?

Thanks Murli.

How do I write a query to find the last audit date? Let's say the table looks like this (year,company,audit date): 2004, Company1, 6/3/2004 2005, Company2, 2/2/2005 2006, Company3, 3/7/2006 2008, Company4, 3/2/2008 Let's say I want to add a new record (in the year 2010) and pull up the last...

I'd like to restate my problem. Let's say I have 3 textboxes (txtA,txtB,txtC). Here are their values. txtA = Fail txtB = Fail txtC = Fail I want to check to see txtA,B,and C are all "Fail". Then I want to assign a value called "All Fail" into a separate unbound textbox if they are all "Fail"...

I think in the properties section of the textbox, there's a field that says "Format". Select something like "Fixed" or "General". Then under 'Decimal', specify however many decimal places you want.

Hmm,thanks but that didn't seem to do the trick...Here's what I have in my code for the "add" button. Private Sub Add_Click() Dim stDocName As String Dim stLinkCriteria As String Select Case Me.incidentResolvedYN Case False '--DoCmd.OpenForm "frm_addIncidentReport_page1"...

According to this code, I assume it's opening a form and linking the 'dateIncidents'. I want it to link another field as well. How do I modify it correctly? What I basically want to do is: 1) Click Add Record 2) It opens a new form that displays a bunch of new info to enter...which is related...

But is the rest correct? Because I'm getting one of those Enter Parameter Value boxes with "fail" written on it. Then another one. Then one that says "Yes" and one that says "No"...no idea why. I rechecked spelling and it seems fine. any idea?

This is what I'm trying to fit into the control box. Maybe there is a much better way to do it so suggestions are very welcome. I don't know if I can even use "!" in the IIF statement. And I think it's too long, so it's invalid. What I'm trying to do is to check if all those fields are passing...

Cool,that helped,thanks.

Thanks PH.

In my Control Source in a textbox in my report, this is what I have... =DateDiff([h],[dateTimeEmail],[dateTimeEvent])

I have two date/time fields with a date & a time (ie. 1/1/2005 1:00 am) I want to use the datediff function to calculate the different in hours between the 2 fields. I followed the MSDN instructions (aka datediff(h,startDateTime,endDateTime) but got an #error How do i fix this? Thanks.

Ok, the IIF worked great. Thanks RG. And thanks Alistair, that would probably be what I would've done if in VBA app. But this is different (control source deal).

I want to add a textbox to my forms that either says "Yes" or "No" depending on what a non-visible checkbox is. My forms look funny with checkboxes all over the place (Yes or No fields). My reports would look better with "Yes" and "No" rather than checkboxes. The question is, the control source...

Hey thanks again RG, that's a really useful page for me.

Yes they are from the same table. I'm going to take a look at your sample now.Thanks.

I looked at the record source of my 2nd form. It is the query for which I have parameter querying set up. (year,company name parameters....which come from the first form)

I have 3 forms. I open the very first one (main form). From there, I wrote a little VBA in the 'Add Record' button that if a certain checkbox in that form wasn't checked when I click 'Add Record', it would open up the 2nd form. The problem is, when I open up the 2nd form and enter info, the...

I noticed that when I enter: start = 12:00 am end = 1:00 am the duration is calculated to be... 0.04166667.... how's that?