Search results

Ah ... I just learned recently that a subform can't receive the focus so there ya go. Glad it worked out for you. -dK

You could set up a query to refer to the input box when the user click's 'Go' and then use the result of the query to populate the form. Also, you would need to provide error-trapping for this if no records were returned to alert the user of this fact. The combo box idea has a feature called...

I would guess that these steps .... 'Replace record navigation tools with save/abandon new record controls DataEntryDisplay 'Remove the new record command button from the header cmd_NewRecord.Visible = False could be the issue. I am assuming that the DataEntryDisplay bit is a function that...

So once you had 1000+ records in the database, you would expect the user to get it right every time? So the expectancy would be that the user would have to memorize every entry in order to use the db? Or, you would right extra code to do a fuzzy search that responded with a Did you mean record...

Just a swag here ... is the button Default property set to Yes? If so, try setting it to No to see if that cures. -dK

Hmmm. Try explicitly declaring the recordset? Dim rs As ADODB.Recordset -dK

I think the detailed explanation uses something like this ... can't recall. If not, this link has an example in the first link on the page that is a great to use. I've used it to open records on the same form and a different form. The modification from one or the other should be clear once you...

There is a way and going to give it a go from the top of my head of how I have done it before. If the subreports are infinite size - meaning your report could span many pages, I would resized the subreports so that they are a thin line and set them 'to grow'. Then on top of the line, I would...

Just stabbing here .... why not use your code on the AfterUpdate event of Me.intVolume and Me.lng_Expected_Duration? In this manner, you're not dependant on moving records but only when either field is updated. Of course, you would probably need to use the Nz() function to wrap these in to...

You can use the built-in filters if you would like - you can search the Help files to get you on this path. It could be complicated if other people are going to use the database. Another way to 'search' is presented here with a sample database and lengthy explanation. I normally use something...

I'd probably start with the query wizard to set up unmatched records. If you run from the Orders table against the Customers table and perform an unmatch against the FK of the customer in the Orders table and PK of the customer in the Customers table, this should return all of of the customers...

Here is the best resource I've ever used. It is well documented and provides notes to know how to use. The first part will tell you where to call the function and to trap the error. HTH, -dK

Ah ... too much in '07 for me to go about trying to learn a whole new one. Besides, convincing IT departments to go to '10 (and companies to purchase) until there is a 6 months gestation on the first SP would be too big of a bull for me to wrestle. I know the ones I work with just went to...

I don't know him ... personally ... yet. :D -dK

I think some do - as a just in case, I've zipped up and attached three calendars that I know have some data entry pieces in them. These are some that I had downloaded doing some research into some calendaring functions. Perhaps the Lady can pull and stitch different aspects of these together...

Not sure. I am a bit confused on what you are trying to do so perhaps posting a graphic of a before/after with everything all organized and maybe some dotted lines to help us see what you are trying to do will get a more defined response. Can do it in Paint or something as long as it is in a...

I have no idea. But the idea I do have is perhaps to start with Leban's conditional formatting sample. Try to find something in there that might lead you down the right path. Perhaps a worst case workaround is to establish the case of the last record and input that as the condition for that row...

Hahahaha ... yeppers!

Not sure what you are really asking for here. Could you diagram out or something what it is you are trying to accomplish? -dK

You can. There are alot of samples here that might provide some guidance. Lots and lots of options ... :eek: -dK