Search results for query: *

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

I have found a wonderful FAQ written by Michael Red. This is exactly what I need to do. HOWEVER, it was written for bound forms. Mine are unbound. My question is: How could I rewrite this to use it on my unbound forms? And CAN it be rewritten so that I can use it? The faq is faq181-291...

Thanks for responding again. I know I must seem silly but it's still not doing what it's suppose to do. I actually had used the replace function at one time(right after I got your answer) but it's a good possibility that I used it incorrectly! Anyway, I copied and pasted your code into my db...

Hey, thanks for responding. I'm still fighting with it. I try to work on it once a day - that's all my temper will let me try! Anyway, I tried the isnull statements. They aren't working. I think I'm going to have to trim the values or use a len function (i've tried this but...well, see 2nd...

Sorry for taking so long to answer...I had to go about this a little bit different because this stored procedure is for a list box. I wasn't if or how you could execute a stored procedure from a stored procedure? So, I just put the replace function within the current stored procedure that I'm...

I have a question that may seem kinda stupid but I have to admit that I've worked on this for several hours and can't seem to fix it. I have a list box that includes the physical address of a property. The physical address is made up of several fields so I concatenated the fields to make it...