Search results

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 :)

Hi Guys, Hopefully someone can help me out, I can't seem to get my head around an issue i'm having with a DSum, the statement is: =DSum("[Amount Used]","[tbl_Rwk_Used]","[Cage Number]='" & [IBC_Number] & "'" And "[ID]=" & [ID]) I've tested both statements separately and they work ok, but as...

Hi Namliam, I'm trying to defy the logic :p I need it to incrementally sum the values rather than add both 20%'s. I'm trying to make this: The pink line is produced by the DSUM function, I got lucky in this chart that there were no duplicate count values

I've been playing about with my dataset, to try and draw some more charts. I seem to be having a problem with DSUM grouping values and then adding their combined sum. e.g ErrCode: Count Percent Cume 9 6 30 30 5 4 20 70 2 4 20 70 PP 1 5 100 CP 1 5 100 7 1 5 100 3 1 5 100 11A 1 5 100 11 1 5 100...

Excellent Frothingslosh, That worked Beautifully, It was working backwards for a minute then i realised i made a **** up in my original expression "<" instead of ">" I just need to figure out how to draw my chart now :D

Hi Again Guys, Another problem i'm having, is i'm trying to create a frequency distribution chart. The Partition function i'm using works to an extent but i need to omit some bins from my chart. This is the Partition Expression i am currrently using: Result Group...