Search results

You've not given very much information for anyone to go on here. In order for a dap page to update, the table needs a Primary Key as far as I know. You could check this for a start.

You need to write some VBA to handle this. You can check the current date for which day of the week it is with the Weekday function. You can then use the SendObject command to send the email. Have you written any VBA before?

...Bart Simpson I believe. I have something similar on my email disclaimer just to draw attention to how ridiculous they all are;

Create a query from your table with surname and forename. Use the code below to get the Filepath. PictureFilename: "D:\images\"+Forename+"_"+Surname+"_.jpg" Create another query, with the one you just made, and the table with Filepath and OLEFile. You can link the PictureFilename field from...

If you have now separated the names, you only need to use the code in point 4 in a query. You should now use that query inside another query which will match up the filenames with the pcitures.

It may be an idea to split them into two fields; I think its better that way. You might not get exactly the results you need first time with this, as you may have middle names, but as a start; 1. Find the first space in the name field; FirstSpace: InStr(1,[YourNameField]," ",1) 2. Then use...

Do you have surname and forename in seperate fields? Its still possible to do this if you do not have it set up this way, but it will be much easier if you do.

How far have you got with the code?

Yep, and thats exactly what I meant. All buttons have code behind them. You need to write the VBA to do what you want, then "attach" the code to this button.

You've not really given enough information to answer the question here. How do you know someone has ordered an item?

I'm slightly confused by you saying you have recreated a form in Snapshot format. As far as I am aware, Snapshot format is for a report, not a form. I will presume that you have the report created. In this case, I would use DoCmd.OutputTo to create the snapshot report, then DoCmd.SendTo to email...

Take my posts however you like. I don't criticise the people who help me. I shan't bother to help you again.

This sentence doesn't make sense. I presume you are talking about the form? I am still unclear as to what you mean. There is no need to "Submit" data in a form linked to a table. If you want to give a message once data has been written to a form/table, you can do so with events. Anything is...

If you link a form to a table, the data is written without you having to "submit" it. If you want an unbound form, then you can create an Append Query, which will add the information for you. You can create a message box to alert the user this has been done, also an Append query should prompt...

"The Brain" has a lot more eye candy; I've never used it though. http://www.thebrain.com/BrainEKPtour/ekptour.htm I do use IQNotes on my PDA. I don't know whether "free" is a requirement for you. I believe there is a "non-PDA" version of IQNotes...

The "OpenReport" method will open reports with whatever filter you require (just search in the Access help for the syntax). A little polish on your english may help you in getting replies; what you describe isn't exactly clear. Remember people here are dedicating their time and expertise for...

You don't have to create the query; just use RunSQL to create your recordset, then close it when you have finished. It seems to me from your code you know what you are doing. Just search the forum for "Recordset" and I *think* most of the examples are done this way (i.e. without actually making...

Try "IsNull" instead of ="" see if that works.

Use the date functions; you can use Month(YourDate) MonthName(YourDate) Year(YourDate) To get whatever you need.

Not that I want to argue this thread, but to those of you asking why; It is the relative width of vocabularly of the english language that is held in high regard in *some* circles. English has many more words than other languages, for example in Spain, many people from Scandinavian countries...