Search results

check out the help file for the sendobject method and action it is really very comprehensive. A fragment of code from a recent project is as follows strMailText = "Invoice Number; " & strInvoiceID & " Customer Number; " & strCustNo & " Date; " & datDate DoCmd.SendObject acSendReport, ...

have you checked out the "docmd.sendobject" method? This works perfectly for me to send emails from access . Details are in the access help file or of course you can search this site for a number of threads on the subject.

Ali if memory is a string then Me.memory = Me.[Compilation_Form].Form![TD] + Me.memory.OldValue should be Me.memory = Me.[Compilation_Form].Form![TD] & Me.memory.OldValue if on the other hand it is a numerical value memory should be dimensioned as a integer / long etc

Bruce First step is to try and identify the line of code causing the error. Hit the debug button on the error msgbox which will take you to the relavent line of code. Have you tried setting a breakpoint and then stepping through your code you can then check in the locals window the actual...

If you need to check for an empty field you should use null or isnull or not isnull etc (exact syntax depends on where you use it). Note that ReqField = null wont work null is not a value so you have to test for null eg if isnull(ReqField) then..... An alternative approach is for example the...

For lots of info on this subject check out http://search.microsoft.com/search/results.aspx?qu=dao+to+ado&View=msdn&st=b&c=4&s=1&swc=4

as long as you explicitily declare that you wish to use a dao function should be OK eg dim rsTest as DAO.recordset ( this is good practice anyway). As to the future search the site and you will find discussions on this topic by those far better informed than I . I believe that you can run DAO...

This recent thread has details http://www.access-programmers.co.uk/forums/showthread.php?t=80918

Surely all you have to do is include the reference to the DAO library and then all the DAO stuff will work properly. I have DAO code working perfectly OK under 2003.

If understand you correctly what you are trying to do is create a record that relates back to another record that doesn't yet exist which clearly is a bit of a problem. The record in the table related to the main form must be created first before the records in the sub form can be created.

if request_ID is a string then syntax should be be ....Request_ID=""" & Request_ID & """". If this does not work one approach that can work is to build the query in query builder check it gives the correct result and either copy the SQL or by using a combination of steping through the code in...

Ade Couple of threads that I contributed to on similar subject http://www.access-programmers.co.uk/forums/showthread.php?t=78400 http://www.access-programmers.co.uk/forums/showthread.php?t=77869 not sure if they are directly relavent but they might help

Thanks for this idea. I didn't use a public variable as this would mean creating a seperate module but created a hidden field on the form and then referenced this field in the on format event.

I have a form which allows users to create a report by specifying various criteria to be included/excluded. The report is then created using "docmd.openreport" using a where condition based on the users selections. I would like to print the where condition on the report for reference and cant...

thanks for that works fine

I want to create a query and exclude fields which contain a certain string however I cant get this to work. I have tried NOT "Against" , NOT LIKE "Against" , <>"Against" ( "Against" being the relavent string) but all with the same result ie the datasheet view returns no records desipte there...

I had exactly the same problem and after a lot of head scratching spotted that the table field was set to text not number , quite why it works for single digit numbers I dont know

I took a suggestion from Pat Hartman on a different thread that variables that needed to be shared between forms could be stored on a hidden form and adapted it slightly as the as the form were the variable is returned ( from a combo box) is always open at the same time as the form where the...

Thanks for the reply. Solved problem by using a hidden text field on one of the forms and returning the variable to there.

I have a question related to declaring variables in code related to forms. I want to share a variable between two sets of code on two seperate forms. I have made a declaration "Public GstrType As String" in the general declarations area of one of the forms but it does not seem to work, I get a...