Search results

Thanks SOS I actually got it working with the code that I had tried originally. It turns out that my report had come corrupt somehow, luckily i had a backup of the system. However i will still take your suggestion and try and work with it

maybe i should try to reword this better. I have a combo box in an Information form that once selected fills other fields in the same form. Thiese values come from an Equipment Type form. From time to time i will need to edit some of the details on the equipment form. However at present...

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...

Thanks very much Graham, got that working fine!

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...

Thanks for the reply trevor, but i tried your method and got an error say the me.imageFieldName.requery could not be found. I have changed it to refect my own fields name

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...