Search results

Hi, I have run into a issue when trying to use the DCOUNT function with multiple criteria. I wish to simply count a number of records that match two criteria. The table is a simple list of a directory list of files and I wish to count those files that are mp3 (and then sum up their sizes). I am...

Hi I have allocated a function (event) to a control on a form (i.e. =PopupCalendar([Screen].[ActiveControl]) on the event 'On Dbl Click'). The issue is that the database is quite large and the function is used on a lot of forms. I want to rename the function to say fn_popupCalendar to make it...

Hi I have a database I use at work to store conditions placed on a licence. I have a word template that I use to print out the licence but I am having trouble printing multiple conditions. Each condition is given a number and can be up to around 50. I can place the first condition in the...

Hi all, I have an accident database that I am trying to write a pivot query for. the following works: TRANSFORM Nz(Count([I_BA]),0) AS [The Value] SELECT TblMonthlyInjurySummary.I_BA FROM TblMonthlyInjurySummary WHERE ((TblMonthlyInjurySummary.I_Date) Between #7/1/2000# And #6/30/2011#) GROUP...

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...

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...

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...

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...

I am developing a scheduler program which will also read emails from MS Outlook. I am after a list of field names (such as SentOn, SenderName, To, CC, Subject, Body, Unread etc) I have only found a few like the ones listed above. Does anyone have a list of the actual field names I can use for...

Hi, I have developed a form with a drop down combo box containing information gleened from a SQL. Infor contained is recordID, CompanyID, CompanyName and Sitename (all on one line). There may be a number of sites for each company. What I am trying to do is take the contents of the line...