Search results

Good Morning Everyone! Here's my situation: I have a form that updates User's information. The recordsource is tbl_User. tbl_User has the following fields: pkUserID--Primary Key UserName--Name of User UserID--User's Login ID fkDeptID--Foreign Key to tbl_Dept--ComboBox for the department the...

How can I set the form to background when opening a report, w/o using IsLoaded to visible. I don't want the form invisible, I want it set to the background of the Opening report. Thanks

I have a report where the underlying data is a crosstab query and based on user input of time frame. The crosstab query: "Column Heading" is GOAL. A GOAL is selected by the user and can be "MET", "NOT MET", and "PARTIALLY MET". The problem is this: User selects a time frame, if the GOALS...

Good Afternoon, I know there is very nice code to apply to an Access db that can log ALL users out after a specified amount of time. What I'm searching for is to an adaptation of the code that would log off A SPECIFICuser. There are times when A user has a problem, the IT department needs to...

Good Morning, I need to run a process with certain fields from a specific table. I thought the best approach was to create a collection using tableDefs and am way out of my league here but giving it a shot anyway. The only fields I need to run this process on within the table are the fields...

OK....so yes...I am a dummy....and need help to cure this headache. I have a user that MUST insert time.....in Minutes and Seconds only. I set the field to short time. However, whenever the user inputs anything over 24 (minutes) a message appears "The value entered for this field isn't...

I find myself using crosstab queries frequently and am baffled about this one issue. If anyone as insight to this, I would love to hear it. For the recordsource for the crosstab, I use a query, for this example, I will call it query1. query1 will have the following criteria in a date field...

This is driving me NUTS!!!!!!!! I have the following code that works great ..... with 2 small exceptions Private Sub lstGoals_AfterUpdate() Dim ctl As Control Dim varItem As Variant Dim sTemp As String Dim DB As Database Dim rst As Recordset Dim iRN As Integer Set ctl = Me.lstGoals '...