Search results

For anyone who is interested, I have managed to find a solution for this.... I've used the code on this website: http://access.mvps.org/access/tables/tbl0009.htm and then in the AutoExec Macro I've added RunCode function and fRefreshLinks() to call the function. This seems to sove my problem...

The problem I have is that the form that opens with the database is a split form. In the split form a have a field with an embedded macro that will open another form based on condition ="[ID]=" & Nz([ID],0) If I don't go into the Linked Table manager i get a #NAME? error in that field...

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 Thanks for the reply, I think I'm being daft here. But this won't work as part of a query expression. How should I apply this? Many Thanks.

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...

Re: Split Record seperated by ", " Apologies, I did try to edit the title, it was "," Thanks for your input, I have managed to solve by using the method posted here: http://support.microsoft.com/kb/95608 and gemma-the-husky - For the record, I just tried your solution and it did work, Thanks.

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...

Thanks V Much for the link, I tried it out and was getting a few problems, but found something else. I manage to solve my problem with the following method: http://www.accessmonster.com/Uwe/Forum.aspx/access-queries/1479/concatenate-records The posy by "Sidney Linkers" did it for me! :)

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...

ChrisO, I put the egg timer code back in and it works brilliantly! Many Thanks.

I agree, sounds a better way of doing things. I'm a complete newb at this so my logic isn't the best! How would I amend my code to do a check for the csv at the beginning?

Appologies, bad writing on my part, to clarify: If they select not to retry and want the code to stop.

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've found the problem, there was some rogue data in there such as '.A/Mgt/1' As I am not intestested in this data I have filtered it out before running the query, Thanks again! Was driving me crazy trying to figure it out, you nailed it in one!

I'm back again, if i change the query from a select query to make table I get the following Error "Run-time error 9: Subscript out of range" Public Function ParsePorts(AnyString As String, Element As Integer) As Integer Dim MyArray '/Drop any leading dots AnyString = Replace(AnyString, "."...

Thats exactly what I did! Renamed it and it's all working now! :) Thanks ever so much for all your help! Much appreciated.

I think I need 10 Posts before I can see attached and embedded images :( I've copied and pasted the SQL into my query but I am getting a "Undefined function 'ParsePorts' in expression. I have checked for typos and haven't found any. The code is definately in a module and saved. Any ideas? Thanks.

Hi, Thanks for the code. Step 3 is missing, I'm still in the dark in implementing the code, I've been playing around with no result. I'd just like to point out that the .csv file is already in the DB and gets imported to the database from a sever via VB code linked to a button on a form. If...

Thanks for the prompt reply! 1) Yes, the backslash is the constant delimiter through that field for every record. But not the file. 2) Yes, they are all numeric values 3) Yes the files contains colum headings. 4) attached is a spreadsheet which shows an example of what I'm trying to achieve...

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...