Recent content by arnelgp

share us the real excel template.

you may also check this one. i added another dummy table (dummy2). using union query will fail if you have lot of stopNumber on your table and the Union query will increase the the sql string and eventually will fail.

then you are just Duplicating the infor already on the other table, thus, wasting space on your db.

you may try: If CurrentProject.AllForms(stDocName).IsLoaded Then If CurrentProject.AllForms(stDocName).CurrentView = acCurViewFormBrowse Then If Forms(stDocName).Visible Then

you don't need to Save the Full Address in your table, since it can be derived from the Other table. just link the two tables together using a query and use the query as the recordsource of your form.

you get the access path: syscmd(acSysCmdAccessDir) & "msaccess.exe"

try this: Sub SendEmailWithThunderbird() Dim thunderbirdPath As String Dim recipient As String Dim subject As String Dim body As String Dim attachmentPath As String Dim cmdLine As String ' Set Thunderbird executable path (adjust to your installation)...

just test if frmActivitiesEdit is open:\ If CurrentProject.AllForms("frmActivitiesEdit").IsLoaded = False Then DoCmd.OpenForm "frmActivitiesEdit" End If Forms!frmActivitiesEdit.RecordSource = "Select * from qryActivitiesEdit Where ActionID = " & Me.txtActionID

use your Control not the fields in your table: Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer) Me.Lvl1Img.Visible = Me.Lvl1Chk Me.Lvl2Img.Visible = Me.Lvl2Chk Me.Lvl3Img.Visible = Me.Lvl3Chk End Sub

you may try this on the subform's Current Event: Private Sub Form_Current() Dim bolVisible As Boolean With Me bolVisible = (.Recordset.RecordCount > 1) !FirstRecord.Visible = bolVisible !NextRecord.Visible = bolVisible !PrevousRecord.Visible = bolVisible !LastRecord.Visible...

don't forget the blowout..

means a woman/girl/transgender. maybe attributed by Elvis Costello: She may be the face I can't forget A trace of pleasure or regret May be my treasure or the price I have to pay She may be the song that summer sings May be the chill that autumn brings May be a hundred different things Within...

then you already have Duplicate JR_ID on JR_TrClassesT table. what the code is doing is adding (if it does not already exists on JR_TrClassesT) the 12 records you are looking for. next it uses an INNER JOIN (meaning only those 12 JR_ID should be included). but you said more than 12 are being...

who is mr.B? i hope not the Mr.B with the Teddy bear.

will that mean we will see more of the "when i was in the navy.." thing? :LOL: