Search results

After adding the continuance character, that part seems to work, but now the SelectRecords() Public Sub referred to in the combo's AfterUpdate event, seems to have a bad section. It refers to a ReplaceWhereClause function, which does not seem to exist in the book, which is highlighted and the...

It says compile error, syntax error, and the whole block under "Error Handler" is highlighted. What I did then, was to make a continuance character after that block, and it worked, but there is now another problem. see next post. Error_Handler: MsgBox "An error has occurred in this...

This code comes out of an example in one of my books, of a combobox with ALL at the top of the drop-down list. SelectRecords refers to a public procedure. Can someone tell me what is wrong with the code? Please. Private Sub cboActivityType_AfterUpdate() On Error GoTo Error_Handler...

I am doing it on my home network with my own computer and my wife's. All the tables are on a regular Access database with extension .mdb - using the Jet-engine. You can then have many front-ends with tables linked (File-Get External Data-Link) to this backend. As I am learning Access, I have...

Thank you very much, Docman, that is great, but my real problem is: I have difficulty conceptualizing the uses of recordsets in VBA programming, as opposed to VBA-programming not declaring recordsets. What is the practical value of programming on recordsets? What do you use recordset VBA for...

Recordsets seem to be a cornerstone of Access VBA. The books have pages and pages of examples without ever clearly telling a novice what it is used for. Could someone please explain what they are used for, then going through the books may make more sense?

Sorry guys, but I thought my question was so similar that I thought it would be inappropriate to create a new thread. Now it has become inappropriate anyway, because my discussion is all over someone else's thread.

Thanks for helping, dt01pqt. But I am not the original poster I don't want to go to a specific field like the original poster, but want to see the last 8 records in the subform, when it opens. That is probably the second part of what he wants. There was nothing else in the form's load event...

But even if that works, and I think I know how to do it now, going to the last record: By putting the GoToRecord in every cmd_Click event for the change of RecordSource, New Question: how to show the last 8 - 10 records, instead of only the last one?

I have an extra complexity. Buttons on the subform changes its recordsource property as required, so I'd like for each change in recordsource, to show the last/bottom records instead of the top. I tried the following code in the OnLoad event, and it works there, but only at the initial Load of...

Continuous subform must open at the bottom. I'd like to ask what I think is the same question. How in a long continuous subform in chronological order do you make the subform open showing the last records instead of always opening at the top? I tried the solution posted above in the subform's...

Thank you, Rich. I have worked on it and came up with something that works, but it is not as elegant as yours. Do you think using Select Case is an OK solution too, or is some of it redundant? Private Sub Form_BeforeUpdate(Response As Integer) Dim mbrResponse As VbMsgBoxResult Dim strMsg As...

Access 2002 There are 4 fields on my form, StartDate, StartTime, EndDate and EndTime. EndDate + EndTime should always be larger than StartDate + StartTime. The first message box in the code below takes care of that. A second message box has to come up as soon as the difference above is 6...

No form header/footer. If there should not be a (sub)form header or footer, you can set the Visible property of the header and footer to No, once you have gone View-Form Header/Footer in the main menu of Access, just to do the calculation. The reference to the text box on the hidden (sub)form...

Doing it with Date and Time. I use this example, subtracting Date/Time, summed it in the subform header or footer and transferring it to the main form. This goes in the Control Source Property of the Text Box called TotalTime in the subform header or footer, which is called frmActivities...

Too big a wrench. okay monkeytunes. That is what I wanted but something else went wrong, because now the drop-down doesn't work anymore. I'll try and see what it is.

Like label No, that is not what I meant. What I meant is I want a description of the type of elements inside the combobox before you even get to the combobox. It must look like a label with a descriptive string inside it, before you drop it down. People often cannot understand me. I must have...

I've seen our moderator Miles'O Philes refer us to the Help-file of the Object Browser in the VBA-editor several times. I cannot get mine to be active. All I get is a blank screen in the Help-window. How do I activate it? It would obviously make a BIG difference in my learning curve.

freed from Access I think roadie jack is talking about creating an independent program, free completely from the Access clothing.

Title line for drop-down box. How does one put a description for the kind of forms to open inside the undropped drop-down box instead of using a label; meaning it must show before and when it has received the focus and before the choice is made?