Search results

Main form: frmPhoneLog Hidden form: frmDetectIdleTime I have seen several other posts dealing with user idle time. I went to the ms kb and found code that detects user idle time. That code has the entire database close when the max time has been reached. However, I want only my main form...

I have a command button (cmdClose) that closes my form OnClick. I also have a Form_BeforeUpdate that checks to make sure a particular required field has been filled in. If it hasn't, it pops a message box to either set-focus to the field (click YES) or cancel the entire record (click NO)...

I have a form that has a couple of required fields (the fields in the table has Required set to "Yes"). They are: Caller Name and CallDtTm. After the Caller Name is updated, I'd like the CallDtTm set to Now(), only if the CallDtTm is Null or blank. (Basically, I only want the CallDtTm for...

Users are getting a "Form has changed" error when closing a form, even if all they did was look at data. There were no changes to the records, and they do not have access to make design changes. The database is split; both fe and be reside on a server. All users (approx. 10) have full rights...

I have altered the NewPageAfter for a group footer when it is the last group for the report because I want the report totals to print on the same page as the last group total. The code I'm using is: Private Sub ftrOperUnit_Format(Cancel As Integer, FormatCount As Integer) ' Sets the...

Actually, I don't know for sure if it is a requery problem.... Here's the situation: I have a form that allows the user to select a report from a listbox, and manipulate parameters that will be used when generating the report. At the bottom of the form there are command buttons - Print...

I am not sure what I am doing wrong here. The [lstReports] is a listbox on my form (string values). The value chosen is a name of a report, which could be "Employee Roster", "Performance Management Detail", or others. When I select Performance Management Detail report in my listbox, the code...

I am trying to pass a combobox parameter from a form to a query, which then runs the report. Generally I have not had a problem with this, until now. Form: The combobox, called [cboOverdue], has a Row Source Type of Value List, with "No" and "Yes" as the 2 items in the Row Source. I have set...

I am almost completely finished with my database, but I've been hit with an "Out of Memory" run-time error. The error occurs for only 1 report. I can do anything else in the db, except run this report. I have tried all of the following: 1) Shut down and restarted computer. 2) Compacted &...

I am having problems getting the syntax correct for the following code. I am trying to set the combobox [cboStartOperatingUnit] on the subform [frmReportsSUB]. The subform is located on form [frmReports]. The error occurs on the line with ***. The exact error message is: 2450 HR Database...

Here's what I am trying to do. Currently, I have 1 form. On the top half of the form, there is a listbox (lstReports) that displays a list of reports that a user can run. (The Rowsource for the listbox is: SELECT DISTINCTROW tblReports.ReportDescription, tblReports.ReportName FROM...

I have inherited this database with the following code, and up until today, it worked. Now, when the code is executed I get an "Error 3265 Item not found in this collection." I really have no idea what this means. And, I don't really know where in the code it gets the error (a user found it...

Finally, after two weeks of being scared of doing so, I split my database!!! I have read quite a bit about splitting in this forum, and one thing that I have read several times is to keep the [Switchboard Items] table in the front-end. When I split the db with the Database Splitter, it put...

I am having a problem with the following 2 expressions. The 1st expression contains a DateAdd function and is used in the 2nd expression. Expr1: IIf([FLSAStatus]="N",Format(DateAdd("m",6,[HireDate]),"mm/dd"),"07/01") Expr2: CDate(IIf((Format(Date(),"mm/dd")<=[Expr1]),Format(([Expr1] & "/"...

Help.... I have what I thought was a very simple update query - take one field in a table and move it to another field in the same table, under certain conditions. It returns the correct number of records, but the field is blank. Move LastReviewDate to AnnualReview if LastReviewType = "A"...

I have several combo-boxes on my form that give me the following error: "To make changes to this field, first save the record." This error only occurs when trying to change the value of the combo-box the second time within the same record. If I then save the record, and make the change to the...