Search results

Hi, I am running Access 2010. I have a database that serves as a backend stored on a network drive which can be quite slow. The problem I have is that everytime I open the front end database (stored on my computer) I have to open the Linked Tabled manager to refresh them. Is there any code...

Hi All, I currently have a field (Allocation) in access that contains information like the following 123456: 1/1/2/1 73846272:1/3/4/1 726353- 8/9/4/1 27364521-3/5/1/3 I have build an expression: Number: LEFT([Allocation],InStr([Allocation],":")-1)This would work great if I knew all the records...

I have a query that when runs return data like the following Field 1 | Field 2 Jon | 123456, 12345678, 234567, 987654 Bob | 457891, 73892, 635279 There will only ever be a maximum of 8 records separated by ", " in Field 2 and so far I have tried the following mudule with no luck. Public...

Hi All, I am after some help with a query. I curruntly have some data which is displayed as the following: Record: Name: Name: 2 Bob 2 Bob June 2 Karen 2 Frank I have lots of data...

I currently have the following VBA Code linked to a button on a form. Private Sub UpdateDBbutton_Click() DoCmd.Echo False, "Importing latest data to DB, please be patient..." DoCmd.Hourglass True 'turn on the hour glass ' The following Code Deletes all records from Port Usage Table...

I have a table that has the following content in it. Field1. .1/1/1/1 .1/1/2/1 .1/1/3/1 .1/1/4/1 and so on... I want to split the records across 4 new fields so it becomes. Field 2, Field 3, Field 4, Field 5 .1, 1, 1, 1 .1, 1, 2, 1 .1, 1, 3, 1 .1, 1, 4, 1 I import this field from a .csv file...

With reference to the attached spreadsheet. I have 2 fields of data (Equipment and Port) Each piece of equipment has a varying number of ports and am trying to think of a query that will exclude the last 2 ports on each equipment. On the attached spreadsheet shows in more detail what I'm...