Recent content by MelissaKT

I have a treeview control on one of my access forms. The first part of the code that I use to populate the control is working fine. However, the second part, or the child portion, isn't populating like it should. It actually acts more like a parent. I can't see what's wrong - maybe I've...

The View is a simple SELECT: SELECT RequestNumber, BudgetAccount, MonthlyPOID, TypeOfService, AmountOfService FROM dbo.tblRequestDetailsReoccuring The MonthlyPOID is an int identity field. (I wondered if that was the problem) The data was pretty simple stuff: The Request...

I set up a trigger on Friday, hoping to have a history table on my database. The trigger seemed to be working fine. Then, I started getting THOSE phone calls. We started getting the error: the data was added to the database but the data won't be displayed in the form because it doesn't...

I've just found some good information in a book called VBA Developer's handbook by Ken Getz. Here's what I've got so far: In the Dialog Form that allows the user to choose several different budget accounts, I have Dim i As Integer Dim strSelectedTEMP As String strSelectedTEMP = "" With...

I am attempting to use arrays for the first time. I've scanned this website and looked at Ken Getz's Developer's Guide. I'm really confused. Here's what I'm planning on doing with the information - maybe somebody can come up with a better idea? I have a subform that has a PO number combo...

If ([NCRRD] = "") Then MsgBox "Complete Response Required by Date", vbCritical, "Error Message - '" & strUserName & "'" ElseIf ([ResponseReceived] = "") Then MsgBox "Complete Response Received Date", vbCritical, "Error Message - '" & strUserName & "'" ElseIf ([ActionCompleteDate] = "")...

I know I'm probably just missing something, but I need some assistance! I have a form with a subform on it. It's a payroll type form. If the user's regular hours > 40, then the before update routine of the subform fires - this brings up a dialog box that asks if they want paid, comp or to...

I opened the stored procedure to show all of the records, then clicked on records -- Maximum Records. Then I saved the changes.

I use a combo box to help locate records on an unbound form. The combo box is based on a stored procedure that has over 40,000 records. I have set the maximum records for the stored procedure to 0 but can't get the combo box to show all of the records. I'm sure that I'm just overlooking...

I figured it out! The combo box was set upon a table that has Vendor ID, Vendor Name and a delete flag. The sql statement for the combo box was basically "SELECT vendorid, vendorname from tblvendor where deleteflag = 0". Well, the default value of the table wasn't set. SO, it wouldn't let me...

PHV, Thank you for responding. That still doesn't work. It goes all the way through the routine and then, when it gets to "exit sub", the error "The text you entered isn't an item in the list" comes up. I just don't understand why it isn't working. I saw on a Microsoft Web site that...

I could really use some help. I can't figure out what I've done. I did a database upgrade, but copied most of my forms and code so it wouldn't take so long to finish. One of the things that I copied was a not in list event that worked fine in the old database. The not in list event is...

Boy, great minds think alike! LOL! That is kinda what I finally did. I didn't create a temp table. After working with comparing the two recordsets, I decided that it would just be easier to bind the form. This form starts out as a search form. They locate the property number that they are...

Joe That makes sense! That would also take care of the performance hit that I was worried about. Thanks a bunch!

I may have completely misunderstood what you said (it is Monday, after all! LOL) but I have an unbound form. When changes are made to that form and the save button is clicked, the values are written back to a table - tblPropertyInfo. Because I want to make sure that I can keep track of...