Just curious more than anything...
I have a split database on a Citrix network (6-8 users) and the FE/BE are in different folders. At times when I go to check on the FE folder I see a new database file will pop up from time to time (file name DB1).
I am unable to open the file. It doesn't cause any problems, but I does make me wonder.
Anyone else run into this?
Hi Folks,
I m stuck, I need help on resolving an issue regarding Combo Box. I have two combo boxes on one form. Both of them are binded with same table. One combo shows Class No and the other shows Student Names and their roll nos. My problem is that my first combo box shows Class Nos but the other Combo box shows all the Roll Nos in all classes. What i wish to see is that when i select a Class No lets sa Class 8 then the other combo may only show student's roll no and their names related to class 8th only, if its class 9th then only students from class 9th be shown. and vice versa.
I hope someone will be able to help me on this.
Regards,
Darno
Hey all,
I have been looking everywhere on a search form and its related queries / tables for a missing value / error that causes this pop up:
Enter Parameter Value
=Date()
The report opens fine once that parameter error is cleared, and I cannot find what it is refering to at all. Does Access have any tools to help me track that down instead of blindly looking at every component piece by piece and hoping to stumble upon it?
I found the code below to clear P.V. errors (I think anyway - I would rather figure out what is causing it, but after way too much time spent on it, I still have had zero luck), and I have toyed with this and am having no luck:
Private Sub Report_Open(Cancel As Integer)
On Error Resume Next
Dim ctl As Control
Dim var As Variant
Dim rst As DAO.Recordset
Set rst = CurrentDb.OpenRecordset(Me.RecordSource)
For Each ctl In Me.Controls
var = rst(ctl.ControlSource)
If Err = 438 Then ' Control has no Controlsource-property
Err.Clear
Resume Next
End If
If Err = 3265 Then ' Controlsource doesn't exist in recordsource
ctl.ControlSource = ""
Err.Clear
Resume Next
End If
Next ctl
End Sub
As always, any and all help is very appreciated!