Recent content by jdawg_1989

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