Search results

Points taken. Will do.

Here's my code, to 'auto-generate' an e-mail, at the triggering of an event .... Public Function Email_Via_Outlook(varAddress, varSubject, varBody) Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem Dim objOutlookRecip As Outlook.Recipient Dim objOutlookAttach As...

Many thanks. I think that's what I'll do. Effectively create a second field, holding related letter codes, which I'll then sort on. There's a good site called 'Datapig.com' which provides video tutorials that seem helpful. ;)

I'd like to only output part of a field value to a Combo Box ( as it is, its control source, is set to this field ) The reason is, I have prefixed a single character a,b,c,or d - to the field's value, to ensure I sort the records in the order I want. However, I don't want or need the user, to...

First of all - you've got some serious variable creating going-on there ! Why not use Arrays, where you're storing the same field value in variables which all relate to one another e.g. in your case, Dim myvaraiablename1 as String/Integer or whatever, why not Dim myvaraiablename(8) as Array...

Sorry folks ! I've solved it - used Microsoft's web-site. The joys of 'trial and error', my main approach to programming currently ..... thanks anyway.

I'm not sure why you've provided two lines of code, where you've reversed where the object data and stored data ( variable ) should go ? It's always variable first ( ssSeqNumber in your case ), then where to find that information, in this case a field within a recordset/subform. Have you tried...

If you do a 'Not In List' general search ( try Microsoft's VBA or Access help on internet ) say google. It should show you the generic format for this Method ( it certainly can be done once you know the syntax ) As the event triggrers on your combo box, I think it's Click, but check, it compares...

I can't at the moment see what's causing this error message in my program. It occurs with the first procedure of the initial form, i.e. 'On Load' event, and then again on the next form opened from within that. I've changed nothing which the help description, says would have caused it...

I've set the Source object of a subfrom to a query, but would like the output fields to be in a text box(es) view ( as I know it will only return one record ) rather than a datasheet type view. It will not let me put text boxes on my subform - even taking away the object source. Any ideas ...

You're right. I've got a query that uses data from more than one table. If I could change some property or setting on the form ( that would allow me at least, to type text ) I could use events related to each individual text box/combo box, and VBA, to update that way. I find it difficult to...

Sounds basic I know ( and maybe should be obvious ), but how do I enter new data/records into my DB ? I spent a while ensuring the query my form is based on allows additions ( as shown by the last navigation button 'Add New' being active eventually). However, it just locks and accepts no new...

Many thanks for your advice, but I appear to have 'cracked it' now ( mainly by trial and error ), and am creating simpler Recordsets dynamically( in Form_Load events ), using values in queries set as Recordsources, to ensure I get the right records in the way I need them. It's all alearning...

Not that easy ... My Mainform does not display just fields from ONE table ( in this case CLIENTS being the 'main' table ) there are several tables linked by P.K. in their respective tables, indicating personal details relating to clients, in an obviously "1:Many" relationship ( i.e MANY Clients...

I have a 'DoCmd.OpenForm "frmAfAIS(test)", , qryTest', to open a form based on the Query ( qryTest ). It does this eventually, and in all other ways is perfect for requirement. The SQL for qryTest = SELECT c.Title, c.Forename, c.Surname FROM tblClients AS c WHERE c.Client_ID IN (SELECT...

I've discovered the difficulty. It's the keyword 'DISTINCT' in my query. I use it because it is pulling off a recordset of Clients, who have a 'case'. However, because any given Client can have more than one 'case' ( and do ), it creates 'repeat' records of the Client details ( which I only...

No it doesn't. It also prompts me for a variable.

P.S. I'm running Access 2010 on Windows Vista.

Yes it Does, and the 'AllowAdditions' property for the mainform is set to Yes ( along with all the other other record editing properties ) I've had an idea. Use the existing 'Query' I base my Mainform on to create ( using the template wizard form ) a new form. Ill try to work it out from there...

I'll remove th Requery. Not sure what you mean by opening the form in the " database window " ( If you mean opening it from the navigation pane - NO it still doesn't allow additions ) Thanks.:confused: