Search results

Great thanks for your help. I will look at this information and see how I get on. Thanks

I have perhaps misunderstood how cross tab works. I thought this was like a Pivot Table in Excel. Okay so the table the data comes from is much bigger and the column headings in A - Zare as follows: Site, Building, Building 1, 2, 3, 4 etc Building Residential, Location Parent...

Hi - I am trying to create a crosstab query to attempt to replicate a Pivot Table in Excel. I want the cross tab to look like this Work Description Condition Code Cost of Work Building 1 Replace windows B £20,000 Building 2...

Great - thanks all for your help

Thanks - that’s sorted most of the issues out. Some of the control boxes have an @ in the format and the drop down doesn’t give me any options to change. Any ideas on what’s causing this?

Ah I see - so how do I change the format of the specific fields in the form so they show the date rather than just the number?

Hi, I have a linked table in Excel which is the source for my data. When I review the contents in the Access Table - it all seems fine and the formatting of dates, currency, numbers with commas etc all matches the Excel spreadsheet. However, when I change into Form View, some of the items...

You're right - I've just got this to work It was bringing the hyperlink text through before but working now - thanks for your help.

Thanks - think this is all a bit too complex for me I am afraid. I will just leave the Hyper Link out of the form. It's not that critical that we have it. Thanks for your help anyway.

I've tried following the instructions in the go hyperlink link but still not working im afraid. I am a complete novice so probably me doing something wrong. sorry don't understand what you mean by a 3-part hyperlink string or SQL?

Hi - the Access table is linked to a table in Excel which has the header Lease. Within this column in Excel (AO) most (but not all) of the rows have a hyperlink which leads to a folder where the lease for the property on that row is saved on the network drive. So in access I want to have a...

I don’t have this on my form - just in the source table

That’s strange because that’s the column in excel that contains the hyperlinks for each row?

Thanks - okay so this is what is now showing. Is that right? Lease is the column name in my excel table. The control source us set to Lease. Private Sub Text172_Click() Application.FollowHyperlink [Lease] End Sub I am getting a message saying Run time error 94 - invalid use of null. Any...

Okay I see, sorry what is the FollowHyperlink method and how do I use this in access?

Yes I think so - sorry new to all this.

Hi - I have a current table which is linked to excel. In excel I have a column which contains a hyperlink to a specific folder for each row. In Access I want to have this hyperlink on a from so that each record has a link which points it to a different folder on my drive. In the design view...

Okay - I have now managed to sort out the image issue. I added the text of the file path and set the Source to this column in the excel table. I now want to add a hyperlink into the form to link to a folder. I need this to be a different hyperlink for each record on the form. I can't...

Ok thanks - so just to make sure I am clear. My record source is set to the table which includes the column containing the hyperlink so I think this covers the last point. In terms of the Control Source, I put the =formula below into this but substitute where you have shown an ex with the...

Ah right, I've found this. I have tried linking this to the photos column in my table but it still doesn't seem to be working. I think it might be an issue with the excel table the database is linked to. The photos column in this has hyperlinks to the folders containing the photos, not the...