Recent content by Alastair

Hi David, I know it's been a while but I have only just got around to trying your code. I just needed to make one slight alteration. For anyone else whose interested here it is: TempVars.Add Rs.Fields("My_Var") , Rs.Fields("My_Value").value The .value is needed adding after the last value...

David, Wow that was quick - I will give this a try later thanks very much for your help!!

David, Thanks for your post! What you suggest sounds promising. I have tried the following code, but I am getting an error I'm sure it's some syntax wrong somewhere: Private Sub DefineVars_Click() Dim dbs As DAO.Database Dim rsTable As DAO.Recordset Set dbs = CurrentDb Set rsTable =...

I have a table which is formatted as shown: ID, My_Var, My_Value, Notes This table holds variables that I want to declare to use throughout my application. I have been told in another thread that tempVars are the best way to do this. I have written the following code, which works on a limited...

Hi Megamef, Thanks for the info, that sounds like it may work for me. I will take a look at this when I get a bit more time. One thing that I have been advised to do is to use tempVars rather than Global variables, this may help you with your question with the Report. Unfortunately I can't...

megamef, Mind me asking how you defined your global variable from your table? I am trying to do something very similar. But still haven't managed to figure this out, I did start my own thread on this subject but so far I haven't received much response. Perhaps we can help each other?

Hi Pat, Thanks for your reply, sorry for my late response I have just got back from a weeks holiday. Can you explain a bit more how a bound form would do this? I haven't heard of this before.

Thanks for the responses, I wasn't sure that the way I did it in Alpha Five would work with Access. TJPoorman - Thanks for the link but I think that is too advanced for me at the moment!!! spikepl - I suspected after a few attempts to reproduce my Alpha Five code the other night that this may...

Hi Uncle Gizmo, Well I like Alpha Five don't get me wrong but, I have struggled considerably over the last 3 months getting answers from the company regarding purchasing runtime licenses and reporting a number of bugs. I felt very let down by the responses I've had - none of the bugs have been...

New to these forums so I hope I am posting this to the right area? I am in the process of learning Access again after an absence of around 9 years off and on. My new project is to adapt a DB I designed in Alpha Five to work in Access I have version 2013 but at work we are still using 2000! I...

New to this forum only found it last night, while I was looking for some information about declaring Global variables... I have worked with DB's for quite a few years now, first DB I designed with Access 2000 is still in use to this day (quite basic - but still useful). I moved for about 9...