Recent content by Accessbeginner34

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?