Search results

I have tried to enter some code into the NoData event on one of my reports, the code is as follows. Private Sub Report_NoData(Cancel As Integer) MsgBox "No Data" On Error Resume Next Cancel = True End Sub I can run this code and it works fine but when i try to save the report i get an...

I currently has two tables with related forms that are linked through a field named Equipment Type. The Equipment form has fields called Equipment Type, ID, Validity and certificate number. Every so often the validity and certificate fields will need to be edited however it changes the...

Currently I have a text box in a report and i was wondering if it is possible to change the height, width, top and left values and the size of the text within the text box based on a string in another textbox. The strings can be TTC, DVM, SYF etc. and are not long or complex. The reason for...

I currently have an Information form linked to an Information table with a combo box linked to an Employee table containg Employee Name and Employee Image. I am trying to figure out a way that once I select an employee name from the combo box the corresponding image will be shown in a report...

Hello, I'm a beginner in using VBA and was wondering if anyone could help in assisting modifying some simple code. The code i have at the minute does the job that I intend it to do however it is on a predefined file. Private Sub Command27_Click() Dim FileName As String Dim f As Integer...