Search results

To see if a record exists or not can be quickly don eusing the dcount function if dcount(recordname,tablename,where condition) <> ) then it exists else it doesnt. if it exists then populate the form using me.recordsource else popup a message saying nothing found I use this in my search...

Hi, Have a look at my attached alphafilter example I did for other people it can be used in multiple forms etc. Searching is also catered for. I hope this helps you. The attached database is in 2003 version but it has been used in 2007/10. Regards Tony

Can you please be a bit more specific. When you open the database there 31 records, Click D and you filter down to 2 records, press the All button and then there are 31 records.The fSetFilter procedure in the FrmAlphabetSelecor is only 6 lines have a look and see if there is a problem but it...

Okay I finally figured it out. In case anyone is interested. =fSetFilter([ActiveControl]) To send control use [ActiveControl], for a form use [Form] In the function refer to it as Public Function fSetFilter(ctl As Control) If wanted to pass form and control then...

Thanks but what I am after is a simpler approach to standardise the calling of a function. The name of the control is what I use to get the tage of that control in the function. I simply what to develop a statement such as =FSetFilter(control) instead of =FSetFilter([A]) for a button control...

Hi, I wish to send a control name or tag via the onclick event. I have posted an alpha filter example (see http://www.access-programmers.co.uk/forums/showthread.php?t=190087) Essentially I pass the litteral value of the control (i.e. A) to a filter. What I want to do is simply pass the...

I have been using this for some time now. It is a subform based on the alpha filter macro and removes the need for having multiple macros. It is a form whereby the only thing you need to do is on frmalpha... whereby you specify the frm and the field name you wish to filter on. remember to set...

Hi I am using the ever standard alphabuttons macro that has been around for years. Is there a way of (on a form) entering into a text box someletters and passing that to the macro to fileter the records? I am thinking of something along lines: ApplyFilter LIKE...

Thanks for all your help

I have never done that before. What I was looking at is placing an individual figure say Feb(month 2) in a text box. The query is mainly used for a calendar year summary so I was looking at placing the values on a form in seperate text boxes. Tony

Just another related question. How do I reference each of the values to populate a textbox on the screen??

I have now found a solution. Hope someone else can use the solution to learn from (I certainly did and thansk to those who helped): the union query: SELECT TBL_Inquiries.refyear, fsqlmonth([DateNotified]) as Dnotified, "inq" as tablename FROM TBL_Inquiries UNION ALL Select...

Thanks for that. I am still having a bit of trouble fitting where the Datenotified comes into play. I have constructed the first query to provide all records for the pivot table but am having trouble doing the transform and pivot side of things. The first Query (Union) is: SELECT...

Hi I have a number of pivot table queries which I wish to combine so I can develop one pivot table for multiple table results. Here is an example of one pivot query-note each query works TRANSFORM Nz(Count(fsqlmonth([DateNotified])),0) AS [The Value] SELECT TBL_Inquiries.refyear FROM...

If anyone is still interested I just posted an access catalog program which will read MP3 ID1 and 2 tag information and then catalog it. You will find it in this forum. Cheers Tonez90 Sorry Here is the link: http://www.access-programmers.co.uk/forums/showthread.php?t=187853 I have just...

Hi I was asked by a couple of people on how to use MS Access to do some cataloging of disks. The attached file is very simple DB which is aimed primarily at cataloging MP3 files (and identifying those with parts of the tags missing). It is still in development and and can be improved upon...

Thanks for all the responses

Try this one. I found it somewhere some years ago. Hope it helps Setting up the Outlook VBA code Open Outlook Go to the menu item Tools / Macro / Visual Basic Editor In the VB environment expand the project node (usually called 'Project1') Find and open the module 'ThisOutlookSession' (double...

Thanks for the reply but I must be having a dumb day as I cant eem to get this to display anyfields that can be used in VBA. Does anyone just have a list of email fileds?

I am developing a scheduling database and wish to read in emails. I can get the email into access but am uncertain about the field names. Below is the code I currently have and I am after a list of the field names used in MS Outlook email. If someone can help with these names I would be...