Search results

Brilliant - Works well. This raises some further questions. I noticed the UI has a 'Disconnect User' feature - Which has not been developed, how this actually possible to do? I also noticed that the computer name being picked up is actually the server name, making it difficult to identify...

Afternoon All Not sure this is possible, lets say: - I have a backend database (local tables) - Someone links to the table so they now see the data in the local tables Is it possible to see if anyone has linked to them? I understand the database can have a password which can put a stop...

Looking for some advice and hoping this is the best place to ask. I work on a team where we have over 70 applications spread out in the company, we receive emails to the inbox reporting faults, or problems and our team put these right. We are now looking to reduce traffic to the inbox by...

Thanks for the reply, ill probably stick with the split database now. How would you refresh a table for another user is they are manually double clicking the table to open it? My initial thought was that manually double clicking the table to open it would 'auto refresh' it.

Hi Minty, Just want to thank you for the quick responses and recommend, and correct way this should have been setup. I have split the database and the problem is resolved, rookie mistake eh! Thanks again for the help and your time

Hi Minty We are sharing the same database Cheers

Morning all Hopefully I am posting in the right area for this. Go easy on me in case I use the wrong terminology when explaining my issue, I will try to break it down in points for ease of understanding. Example: - Both me and another user has an access database open - I complete a form...

I believe I have tried that but still to no avail unfortunately: Set SourceRange = xlSh("ID").Range("B1:B2") Set fillrange = xlSh("ID").Range("B2:B20") .SourceRange.AutoFill Destination:=fillrange

Hi Minty Hope you are well. Id love to be able to do that but the code I have picked up to make the changes have somewhat confused me so I am trying the exporting in to excel. What the below code does: - 1: checks items in 3 listboxes and compares it to 3 tables to find any item that doesn't...

I've had some trouble all week sorting through my code to update an Excel document This time, this is my trouble: Set xlSh = xlWB.Worksheets("ID") Set Selection = xlWB.Worksheets("ID").Range("B2") With xlSh .Range("B2").Value =...

I see, thank you Final question if you don't mind. the formula now successfully goes in to Excel, however the cell the formula is in is showing a #REF! If I double click the cell then press ENTER, the formula updates and works. Know a way how this can be done automatically?

Thank you JHB - That appears to have worked, as simple as that then lol Quick follow on question though, why do I not need to use xlAPP on the below: .Name = "ID" .Select .Range("A1").Value = "FullFITID"...

Yes, when running the code its highlighting the top line: Public Sub ExportQuery(ByVal Query As String, ByVal ShowToUser As Boolean, ByVal TabName As String, ByVal TabCount As Integer, ByRef xlApp As Excel.Application, ByRef xlWB As Object)

Thank you, doing that highlights this section: .ActiveCell Followed by this error:

Thank you Mark I got it working with the following: ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC1,INDIRECT(""'""&Index!R2C2&""'!""&""$A$2:$D$1000""),2,FALSE)"Another issue I have noticed is that the code works every 2 times, the first time it will work, bit...

I think this is the correct one, trying it now: "=VLOOKUP(RC1,INDIRECT(""'""&Index!R2C2&""'!""&""$A$2:$D$1000""),2,FALSE)"

@pbaldy: Typed in a cell it looks like this, and works: =VLOOKUP($A2,INDIRECT("'"&Index!$B$2&"'!"&"$A$2:$D$1000"),2,FALSE) @minty: Thank you for this, I tried it but the same thing happens

Okay so I thought I was on a roll today (not needed to post all day, ha) Im transferring an Excel formula from Access-Excel, however VBA thinks I am using the ' to comment out part of the code. The Code: ActiveCell.FormulaR1C1 = _...

Ideally delete every tab apart from one called 'ID'

Thank you, wouldn't be to sure how to do an overhaul unfortunately