Search results

Thanks so much for your time guys, I did google the question and didn't really find any answers so I thought I would reach out to the members here, looks like there isn't an easy way like the fox example I gave. I'll take a look at the links posted here and have a good read as i'm keen to learn...

the work is already done... we run many processes for many clients using a wide range of tools, Access being one of them. I had to run these for a colleague today and just wanted something like this: select URN,name,tablename as tablename from job12345 (the bold part is where I want the...

Hello Doc Man Seems like a strange thing i guess, let me explain... I work for a data processing company, we receive a file each day/week/month from one of our clients, we then import into Access, process and prep the data to meet posts standards - this goes on to produce personalized mail...

selecting pretty much the whole file and then exporting as text - this is then consumed into a mysql database - the table name is used to reference the source of that batch. so not really a working Access system as such - the data is only required for a couple of months and then deleted, this...

Hi guys I hope this hasn't been asked before, I did look... I would like to return the table name as a field in the query, I know I can type it in but I have many tables to run this on and sooner or later ill get it wrong so I would like to return it from a system variable if possible. I'm an...

thank you :)

Hello can someone help me with this ... I'm new to access, not programming, please see the code below (i know it's full of rubbish etc, I'm just testing the framework...) JoinName is the function I'm working on, test is just to fire it, eventually, I want to pass fields from a table and base...

Hello I'm originally from the UK and currently live in New Zealand. I'm an old FoxPro programmer (actually still am) I've been using FoxPro for some 30+ years but as time goes by and software changes Fox doesn't, so it's come time to change (should have been writing this years ago)... I work...