Search results

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

Thanks to Travis! I have been trying to figure out how to debug for a while, but because I hadn't changed my error handling, I never could figure out what was wrong with the code. I really needed those instructions to get me through it. And, thanks to llkhoutx! You were right - I was...

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

Yeah, it makes sense, as you explained it. Not sure why MS does it that way, b/c it does get confusing when all of the tables except the [Switchboard Items] table are in the be. It makes the Database Splitter wizard not fully functional when you have that table. Guess it's just one more...

Yep, that's it! [Switchboard Items] table is needed in the front-end in order to make changes to the Switchboard Manager. Thanks Pat!

I am using A97 also. Should I move the table to the fe???

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

Sort of - What I am trying to do is figure out when mid-year performance reviews are due, which are based on an employee's status (either Exempt or Non-Exempt). If Status = Exempt, then review will occur on 07/01/OfEachYear. OfEachYear needs to roll over to the next year when it passes for...

Ok, I figured out the problem. Expr1 was adding 6 months to the HireDate, and then formatting that to be mm/dd. Expr2 was using Expr1 to add the correct year (either this year if month/day had not yet passed, or the next year, if it had passed). What was happening was that when HireDate was...

Hmmm, I'm not sure if this is really what I wanted. When I say I want to sort on Expr2, I don't want it to affect the SQL statement. I am trying to do column sorting in the datasheet view (selecting either Sort Ascending or Sort Descending when I right click on the column). I have used these...

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] & "/"...

Oh, good, thanks for the tip on the nz() function. I really didn't see the purpose under the current circumstances. But, I'll probably use it in the future! I don't know how many if/then statements I've done concerning null values!!

Works! So - the query does work afterall. I was switching between the design view and datasheet view to make sure that the data was showing up in the AnnualReview column. It wasn't, so I assumed there was something wrong with the query. I really did NOT want to execute the query until I knew...

Tried the sql in previous post, with the nz(field1,x) function. All returned records still come back blank. The WHERE condition is working (# of records are reduced by the LastReviewType = 'A".) But, the rest is not........

Ok, more questions. Is this how my SQL statement should look???? UPDATE tblPerformanceMgmt SET tblPerformanceMgmt.AnnualReview = nz([tblPerformanceMgmt].[LastReviewDate], Null) WHERE (((tblPerformanceMgmt.LastReviewType)="A")); But, I'm not sure if I really need to use this function...

1. Both fields are Date/Time datatype. 2. Field2 (i.e. LastReviewDate) has data in the records. However, some of the records are NULL. Does that make a difference???? ------------------ You Said: If so try the Field1 = nz(Field2,"15-Sep-03") to see if if the date you specified is written...

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

The Number of Columns are correct. The Bound Columns are correct. Remember - this problem only occurs the 2nd time you try to change the value of the combobox within the same record. I'm stumped!