Search results

I'm sure this is really simple, but my mind is frying trying to solve this. I've a list of wav files in a folder located at D:\My Documents\Mail Alert Sounds\ . What I've set outlook to do is to play a sound located in this directory every time I receive an email. The tricky bit is, that I want...

I want to connect as and when needed to an external database, in order to use it's tables to populate my drop down boxes. I can connect and disconnect no, problem, but have been warned that this may cause expensive overheads regarding bloat etc. Someone mentioned creating a query to connect to...

I'm sure this is possible, but I can't find the formula anywhere. I've a table that stores records by Financial Year Date. I've got a Field YearStart which always contains 01/04 and whatever year, and a field YearEnd which always contains 31/03 and whatever year. What I need to do, is via an SQL...

Bit of a long one I'm afraid. I've got a database storing details of people applying for a scheme. I cycle my Applicants via code through a series of SQL Statements that return "Pass" or "Fail" decisions. I'm well versed in the old "Too Few Parameters 1 Expected" and have managed to get round...

OK, OK I know this is easy. I've even done it myself before, but I can't remember the code for it. I have a very small number of users, around 5. I've got a table called TBLUSERS which holds various information such as Their Direct line number etc, and their login names. What I'm getting at...

Hi Everyone, Small problem. Most of my forms use Queries, not saved ones, but the ones that you use with the query builder when you click on recordsource. This appears to slow the opening of the form down incredibly. The main query that causes the problem, is a query on one table that has an...

I need to find out how many records an SQL query returns. I don't want to have to create a normal query, or a temporary table. I need this to check for duplicates, by checking if a name exists in my name table and a Postcode/zipcode exists in my address table. Please help. Thanks

I want to check for duplicates using Dcount. I've got a table which holds names, and one which holds addresses. What I basically need to do is join somehow the statement below. As a match has to be found in first the name table and then the address. Then if it returns 1 or more I know that there...

No urgency. I'm just writing a load of modules, and am trying to be really economical with space, and write as much of my code as possible only once. What I have which I'm really curious about is a Yes No MsgBox, which I want to, depending on what it is asking at any one time, run different...