Search results

John, I appreciate the quick response. Unfortunately, I am not looking for the 2nd to last record on a form. There is no form involved. I need to compare the last record for each location in a table to the 2nd to last record for each location, so I can evaluate whether the status trend is up...

I am trying to determine increased or decreased performance by comparing the last completed record for each location to the 2nd to last completed record for each location. Entries are made during the month, and then completed on the last day of the month. On occasion, a location my not get...

Never mind...I figured it out. For anyone having this same issue, me.Recalc does the trick.

On my main form I have a listbox that shows recent and upcoming student birthdays. When I add a student's birthday, I have a refresh button that should requery the list. Unfortunately, the refresh button does not work. (If I hit F9, it does refresh the list.) Here is the rowsource of my...

Perfect, Thanks! Sup

I have 2 forms that use a common subform. On open of the subform, I want to make a command button either visible or not depending on which form is opening it. How can I get the name of the Main form? Thanks, Sup

PNGBill - No reserved words being used. Bob - Unfortunately, the linked tables are part of a proprietary software package and are not under my control. I am stuck with double. Please note that when I make native access tables using make table queries, it sends the invoice# through as double...

I am having trouble displaying records in a subform where the record source is a linked table. I have an ODBC linked database that contains invoice records that are split into 2 tables. One table has the invoice header information (date, Inv#, Bill to, etc.) and the 2nd table has the line items...

That's the first thing that I tried but it doesn't work. I'm thinking that the problem is that I declared 'intAmtPd' As double and not As string. I guess that I can change it to string and then convert it to double after I get past the cancel button. Should there be a way to check for cancel...

I'm trying to trap the error 13 that occurs when the cancel button on my inputbox is clicked. I have tried several recommended methods, but none seems to work. This is the most recommended code: Private Sub chkPaid_AfterUpdate() Dim intAmtPd As double intAmtPd = Round(InputBox("Please enter...

Bob, Are you familiar with mz-tools? I have been using it for quite a while, mostly for error handling and message boxes. It also has a find and replace feature, but it seems to only look in the vba code. I've looked at v-tools, but I was concerned about having 2 add-ins that are so similar...

I have built a number of queries using the built-in function 'replace'. I have discovered that this function works fine in vba, but is causing problems in my queries. I have created my own 'replaceinquery' function and it is working properly. I would like to search all of my queries to...

I am currently using a SQL Server 2000 backend for my access application. The database has been on a shared hosting server for several years. I have been having problems with the host recently and have decided to move to a new host. I have 3 options, stay with 2000, move to 2005 or move to 2008...

All of a sudden, some of the forms in my application are not loading completely. For instance, a combo box that contains names (and should be filled) is empty, while all of the other controls are filled. The combo's row source query has records, but the dropdown is completely empty. We get no...

The OS on my hard drive crashed. I have installed a new hard drive and new install of A2K. I can still get to most of the files on my old drive. Is there a way to transfer the "tweaks", like no grid in design view and other misc preferences that I've made over the years, from my old install to...

I'm about to buy a new laptop. I was informed by a salesperson (that seemed fairly knowledgeable) that A2003 and newer will run on Vista, but A2000 will install but has problems. Many, if not most, of my clients are still running A2000, and so I prefer to develop their apps in A2000. I haven't...

Mystery solved! An unmatched query does indeed show 6 records where the Inactive field is Null. Meanwhile, in my regular query, Is Null returns 0 records and Not Is Null returns all 316 records. Thanks to everyone for helping me solve this, Sup

1 and -1 return the same 2 records. False & 0 return the same 308 records. = " & false gives me a syntax error. The only thing that works is <>True. I have to assume that the linked table must be holding a few records with the number 0 instead of 0 as False. Thanks for trying to help, Sup

I just created a table from the linked ODBC table using a make table query. As expected, 314 records show 0 and 2 show -1 in the yes/no field. When I run my query on this new table, =False now returns the expected 314 records. There must be something goofy going on in the linked table that I...

That's the issue, there are a total of 316 records. 314 show 0 (False) and 2 show -1 (True) in the Yes/No field. There are no other records. The field defaults to false unless changed to true. There are no null values in that field to screw thing up. How could = False not return all 314 true...