Search results

I would like to add a "training" feature to my project. My project is a Access 2016 split database on one computer with only one user logged on at any one time. I thought of adding a user "training" which when logged on will take a snap-shot of the back-end, and restore it after logoff. I...

Today is 13 May and this code is supposed to return the date of next Monday (19 May) IIf(Weekday(Date())=1,Date()+1,Date()-(Weekday(Date())+9)) but it returns 1/5/2014 (Thursday May 1), when "Date" = 13/5/2014 (Tuesday May 13) My begin week is Sunday (1) , Any ideas? Cheers...

Here is the code: Private Sub Form_Load() Dim rs As Recordset Set rs = CurrentDb.OpenRecordset("select * from tblpatient, dbOpenDynaset) If Not (rs.BOF And rs.EOF) Then rs.MoveFirst Do While Not rs.EOF ' do stuff...

I am trying to hide a text box based on the contents of another text box in the same report. Here is the code: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If IsEmpty(Me.DocFullName) Then Me.Text55.Visible = False Else Me.Text55.Visible = True End If End Sub i.e. I want...

I have a text box controlled by a hyperlink field in table Patient. I would like the text box to change colour when encountering an "N" in field REG2012 of that table. I have used Expression is [Patient]![REG2012]="N" but did not work. Any assistance will be greatly appreciated. Cheers...

I'm from the land downunder. I have been dabbling in programming for many years, going back to the early Fortran days. Recently I have taken on managing and developing a few db's for some clients. While researching problems, I have found many answers here in this forum. So here I am. With a...