Recent content by Kodash

No, the plan was Navigation for general use, and the link as just a one off project, I building on what I found here: https://support.microsoft.com/en-us/kb/177475 Where the /cmd would be "3" for example. Then Autoexec opens the form where [ID] = 3 So a button that sends the mail on the form...

The startup form is a navigation form for all the categories. I'm thinking a better path may be generating some command line switches

There may be an easier way to do it (or it may not be doable). My Goal is to have a button on a form, that sends an email via outlook (or Lotus Notes in an ideal world) with the record ID of the form, so the recipient just clicks the link and the DB opens the form on the correct record.

It's a Microsoft Access Form shortcut file When you drag a form to the windows desktop and that's the file extension it's given.

Hi Guys, Is there any way to add parameters to a .maf shortcut? I'm thinking, I may be able to email the link to a form to someone, with the correct ID. But I'm assuming this isn't an easy thing to do?

Hi CJ, I'm pretty certain everything else works, just this bit. I can get it to read the tags just not fill them. I may change the typename function, tbh it's an expansion on a sample on the internet ;/ The reason I need to old values, is because of the way the person who handed it to me set...

Hi Guys, I am having a little problem with making an audit trail for a form with some unbound text controls on it and wondered if you could point me in the right direction. Since .OldValue won't work on unbound text boxes, google suggested that I put the old value in the control's tag...

Hey Guys, Has anyone had any experience with using the IBM Lotus NotesSQL Driver? The reason I ask is my company is making a part of our access database obsolete and moving it to our Domino server. I've done a little bit of Notes development before but Access is by far the best way to manage...

Yes thank you very much. I should be able to take it from here

Jdraw that's essentially exactly what i was on about lol

Please Find attached. Also to give credit where it's due, the whole database was developed by a third party (I dont know if by sharing this I've just plagiarized the guy :confused:)

boerbende, I don't think Columns will work I'm afraid. The plan is to use each row as a set of variables in another application (NiceLabel if it's of any consolation)

It was handed to me. The data in the table is used in a report elsewhere so I can't really change the layout. Im looking into Split() at the moment, am I on the right track?

Hi Guys, Im not sure if this should be here or in vba? I have a table that contains a memo that is delimited by line breaks. For each of these breaks i need a new record in the query results that i can then use in a Labelling application. My current query looks something like: ID | Product |...

Thanks plog. Took a couple of seconds to sort out after you cleared it up :)