Search results

I have two tables. A table called tblPeople, many-to-many self-joined through the other table called tblPeopleJoin. That means there are two joins between tblPeople and tblPeopleJoin. The two joins are 1) from PeopleID and 2) from PeepleID in tblPeopleJoin on PeopleID in tblPeople and...

This code by Jacob Mathai found in the code repository and pasted below, seems not to work. The first line does something good. The table opens in Access. The second line opens the Tools menu item in the VBE, and the third line opens the References menu item under Tools. To open a table in...

How can I maintain the current date on this date-picker that Miles O aka SJMcAbney provided? The value line doesn't want to take anything but a date-constant. It has not worked from the VBE either. Could SJMcAbney please help?

Does anybody know how to open a form in another database from a current database, filtered for the id of the current record? Much appreciated, Pierre.

I have a combobox limiting student slots to a certain number on a form 1;2;3;4;5;6;7;8;9;10;11;12;13;14;15;16;17;18;... Private Sub cboName_AfterUpdate() On Error GoTo Err_cboName_AfterUpdate Dim strSQL As String strSQL = "SELECT * FROM qryAssignmentJunction WHERE StudentID <=...

The large block of coding below successfully conditionally formats the StartDate field's backcolor to yellow from the beginning of the current month to the current date. Private Sub Form_Open(Cancel As Integer) Dim fcd As FormatCondition With StartDate With .FormatConditions...

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

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?

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

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.