Recent content by prgwhiting

Long filenames in batch files Actually you can do long filenames in batch files. I too for ages had kittens over the short filename situation with batch files, until someone pointed out that all you need to do is enclose the directory location and the file name extension etc in quotes. ie...

Ta very much, most greatful

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've got two fields YearStart and YearEnd. Also in this table are financial limits for these years. What I'm doing is running a query that makes a few calculations but only using the information relevant to today. I should mention that I'm using the British Date format dd/mm/yyyy. So basically...

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

Thanks a lot, worked a charm. I'll keep a copy of this, this time.

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

Thanks a lot, I've tried it but seem to be getting no response. I think maybe the problem is in my SQL. It's just occurred to me that I'm just using a Select Query as my SQL and wondered if that was maybe the problem. The query is below. SELECT TBLAPPLICANTS.LASTNAME1, TBLADDRESS.POSTCODE1...

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 forgot to mention that I've made a policy to only create my Queries in SQL, for security and neatness. This is a database that I've designed for a company that already has a database which I'm trying to Repair. This has around 100 normal queries, which due to the complexity and the poorness of...

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