Search results

OK, I might not need to have any text showing, so that will mean that I can set the fore and background colours to a solid colour, and all the user has to do is click the block of colour. Something else I can't fathom though - the report has a number of textboxes, each bound to a hyperlink...

As it happens, I do have the alternative text stored in a field in the same table (it is used elsewhere for another purpose). I did a very brief bit of reading earlier and saw Hyperlink part, but I couldn't quite work out how it was to be used?

I have made a bit of progress - I had the field type as Text in the table, which was causing the problem. I now have a report that outputs in PDF that has clickable links :) Now the golden question - is there a way to change the text that is displayed, preferably related to part of the...

Evening all, I am at the point of giving this a shot now, but seem to have hit a bit of a wall. I have created a report, and it has text boxes each bound to their respective fields and they are displaying the hyperlink correctly. I have set the field property as Hyperlink, Always and have...

I have got that bit thanks, and it opens just fine to the desired record; I had other events that fired off the original text box (Before Update) that updated another table - they are now chucking their toys about a bit, but I am getting there.

Doing it via SQL works perfectly, thank you. Having a wee bit of a battle with the subsequent events now, but I will (hopefully) work those out.

I tried declaring RouteRecordsID As Field, but it still baulked at it? Would be handy if I could get that code working though, as much for the learning opportunity as anything. I am selecting the record by DMax to find the Primary Key, and want to copy most (if not all) fields across with the...

I am starting to wonder if I am going about this the wrong way - would SQL be a better way to achieve this? But then, would that not require a load of DLookups to get the data for each field? :o

I am getting a 'variable not declared' error on the line: rsCopy.Findfirst “RouteRecordsID=” & ToCopy RouteRecordsID is the primary key of the table that I am wanting it to find?

Ah, in which case I would be better off putting a hyperlink in the report that links to the network location that contains the second file? I'm afraid it needs to be as good as it possibly can be, as there is a significant amount of detailed drawings and plans. Thank you :)

OK, I have had a bit of a read, but am unsure if I am understanding it correctly - the code I think I need is something along these lines? Dim varRoute Dim ToCopy Dim ToPaste varRoute = me.txtRoute.Value ToCopy = DMax(“RouteRecordsID”, “RouteRecords”, “Route=’” & varRoute & “’”)...

I have a small bit of code which exports reports directly as PDF to a network folder; on occasion, there is a supplementary document (almost invariably PDF, and can be forced to be so) which should go along with the report being exported. Is there any way possible to either attach the entire...

I will need to read up on Recordset.Clone - thank you :)

Does that work to clone a prior record? Essentially what I am trying to do is allow a user to 'import' data from a prior record, to allow them to edit that data to bring it up to date; by the time that the user will be doing this, they will already have created a new record (or if they...

Is there a way to copy the data from an existing record, to the record currently being viewed? All data with the exception of the primary key would be needed, and the primary key number would be set as a variable by DLookup.

Figured out why - I had the code firing too early, which meant that RRID was null, hence the syntax error. :o All good now :)

Works like a charm! Thank you :) This one came back with a Syntax Error, no idea why?

I am trying to have a Before Update event update a field in a table, but I must confess I have never used VBA/SQL to update a table in this way. I have tried the follwing (trying to guess my way along), but I get an undeclared variable error which highlights the table name: Dim...

Ah, I have just gone off on the Sharepoint path - sorry. It's the first time that I have used Sharepoint, but it looks handy. The only slight problem might be that the other users might not have Office installed, and therefore won't have Sharepoint.

I have a very small Access database that I would like to make available to others via the web (currently four people); the reason for using the web is that they are at various points in the country. I have a WDMyCloudMirror which I believe is up to the task, but I have absolutely no idea how...