Search results

I have a report that has a number of groups in it, with each group having its own On Format code. One of the groups is causing me some grief (although, it could be other groups also, and this is simply the first group that I have spotted it with!). The code for the problematic group is as...

I have a report that has two fields - [TS] and [AltTS] TS will always have text in it, whereas AltTS won't necessarily have anything in it. In the event that there is nothing in the field [AltTS], I would like a textbox on the report to show just the value that is in the field [TS]; However...

Works perfectly, thank you :)

I have a text box that I would like to conditionally format depending on a couple of factors, but I am struggling to work out what the expression would be to do so, not least because I am not the best at conditional formatting in Access. I have a field [StartDate], and I would like the...

I had jumped the gun in saying I had fixed it, because I hadn't. I now have it working, but tried so many different things that I now cannot remember what the SQL was to begin with to compare with the now working SQL to see what I changed to make it work :o Thanks for your help Minty :)

I have a combo box which is used to select records that meet a specific criteria - there may be more than one record that matches this criteria, and I want all of those records to be selected. The field that sets the criteria is called BulletinNumber. This works perfectly well, however the...

I have a few different reports that open depending on which is chosen by the user - the user selects their chosen report name which then is passed forward to a small form via OpenArgs, they then choose which record(s) ahould be in their selected report and the report runs. All of the reports...

It is the oppposite way round I'm afraid - the conversion to PDF is changing the UNC file path from a local address (which it should be) to a web URL. I have done a bit of Googling, and it appears that I am not alone in this happening with documents converted to PDF - what I can't find if there...

Do I need to put file:/// ahead of they hyperlink address to make it work?

:banghead:This is driving me mental! I had it working, with a cloned copy of the hyperlinked files stored on my USB stick for testing - all good. So, I went ahead and changed the hyperlink that gets saved to the correct one for our network...

Thanks :) It is on my other PC which I have left in my office for now - I will have a crack at it tomorrow.

acNormal as far as I am aware is the one that will make the report print - however, taking a second look at your code it appears that the report is already showing on screen? If that is the case, then I would say your second code should use the DoCmd.PrintOut method: expression...

I have a report which is grouped on a field which shows a Day Type, and I would like the background colour of the group to be changed depending on the value that is in the field. For example, if it says Saturday, I would like the background of that section of the report to be light green; if...

Private Sub Command118_Click() Dim strDocName As String Try this: Dim strWhere As String strDocName = "rptTransCalcTruck" strWhere = "[ID]=" & Me!txtID DoCmd.OpenReport strDocName, acNormal, , strWhere End Sub

Sorted it, a wee bit of code and it works fine

I've removed the hash at the start, and the links stop working on the PDF report. I have a feeling I am going to have to code my way out of this?

Your idea with the textbox might well be the way to go then

Just a very quick guess off the top of my head (and I am no expert by the way), but how about setting the combo value = Null at the end of the code for the After Update event?

I have a form which creates a hyperlink based on the information that a user enters (filenames); when the hyperlink text is stored, it does so with hash tags at either end, which resolved my earlier problem with PDF reports where the hyperlinks wouldn't work. Now that they are working fine...

I've found it! I had originally set the field types as text, and when there was only the one record in the table, I changed them to hyperlink. The fields that contain hyperlinks have the hyperlinks added to them programmatically based on values that are set on the form that feeds the table -...