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

Resolution: DoCmd.OpenReport stDocName, acViewPreview DoCmd.SelectObject acReport, stDocName

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

Thanks for the response. The only thing in there is "HEX", I'm sorta using similar to using the TAG property of a control. As for the error msg, it is as I stated in my original post but unlike normally, it doesn't take me to code where the error is hightlighted. Again thanks for the response.

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

Thanks very much....works like a charm

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

OMG....that's what it was....but why? I don't understand the difference? Once it worked on the OnClick event, I tried it in an OnExit event and it worked there also (one less move the user needs to take...as the only thing on this tab is the list box, so trying to avoid the need for them to...

No that didn't help....I'm attaching a very very stripped down version of the db. I had to delete every peice of data in the tables to get it small enough. In tCSMGoals you need to input a couple of test records. Thanks so much.....

Paul, Thanks for your suggestions...and yes I did know the list items start at 0....guess I was so determined to figure out the 2nd issue and lost my mind on the 1st issue. As far as the 2nd issue, I didn't realize the error (effeciency) I was making and did as you suggested for sTemp = sTemp...

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