Search results

Thanks theDBguy. This issue was linked to the fact that I am trying to hide rows that have "yes" in the completed column. I have tried doing this with the following VBA code: Private Sub Command119_Click() If Me.Completed = "Yes" Then Me.Completed.Visible = False Else...

Hi all thanks for the replies. The current DB is based off a table however I have read that they should be based off of queries. Have I got the wrong end of the stick here and it is ok to base it off of a table?

Hi! I am new to access and I am really struggling to understand some concepts. I am trying to create a to do list (attached) and I am struggling to understand whether the form should be based off a table or a query? I have tried using a query however I cannot add data, only view it. In this...

Thank you for your reply but I want users to just enter the year.

Thank you! That worked great

Hi, I am having trouble filtering my continuous form via an unbound text box by just typing in the year. the textbox is cntrlDate, and the field I want to filter is [SurveyOn] (Please ignore the gibberish text and 2nd filter button, this is still a work in progress) Any help would be...

Hi! thank you both for replying. I work for a radiation physics company in which we monitor the dose of radiation in a particular room, routinely every 3 years. We have customers that have individual premises, departments and rooms. These departments may be 'Radiology' or 'X-Ray' and the rooms...

Good Evening All, I apologise I am very new to the access world and I am having issues relating relationships within my database and would appreciate any help you could provide. Please see the relationship format for my db below. I am having issues relating the table surveys to the...