Hi Shan Roy, Glad to hear that it works. However, when I saw what I had posted, I realized that it had a redundant 'If,Then,Else' clause which I should have...
Bill and all, Since the subject was brought up, what are the differences between Access databases and SQL databases? Where is a good source to begin? ...
Hi Mike, if your function has no parameters, it will evaluate the same for every row ... and this may not be what you want. If it is, all you have to do is put...
Hi Clive, I too had understood and ignored that clause when I read Ur code 1st time and I'm sorry for not letting you know that. Thanks (Shan Roy) Clive...
I'm working in Access 2000 and cleaning up data imported from excel sheets where the date was entered both as a date and as a date range (ie. 1/1/01-1/6/01 or...
Crystal, I copied the below syntax in the criteria section of the query object and got the error, The expression you entered contains invalid syntax". Please...
She misunderstood what you were asking. You want getCntlDate( ) in the criteria. It's too easy that's whats messing you up. Myra C. Symons-Kazanci ... From:...
Hi Mike, 1. Please post the code of your getCntlDate() function. 2. Tell us where getCntlDate() is getting it's input from if it is not obvious in the code. ...
How much data. If it's not too much, fix it. Do a query that pulls up the non dates and fix them. If you see patterns use update queries. It seems to me...
For how much, about 8000 records total of which I'd estimate at least half are giving me the data mismatch error ... I have the original data in one field and...
I double checked on that and it's still returning data mismatch error and stopping. ... -- ¤´¨) ¸.·´¸.·*´¨) ¸.·*¨) (¸.·´ (¸.·`¤ Shay...
Hi Mike, in your function, you are assigning a non-existent field in the recordset to your return value this: getCntlDate = rs.Fields("cntl_ effective_ date") ...
Clive Why not just use that line directly in the query? I don't see a need to call a function to do it. Or am I missing something? Regards, Bill Mosca,...
Hi Shay and Others, I have been working on this for a while so here goes. I have tested it with a mix of values. These are the functions that I came up with: ...
Hi Shay and Others, Here are the fuctions updated to handle single dates. I have posted the lot rather than updates. Note that I based them on the expectation...
Hi Bill, You are right Bill. The way I read it was the function output was needed for a variable. My function started off life with a lot of tests and quite a...
Hi Mike and All, I thought I had sent this message but found it still in NotePad. I had gone off to check what I was going to write and forgot about the...
Is there a way to distribute "automatic updates" (or patches)to an existing program that was produced with MS Access 2003 Developer? I developed a program...
You could still split it. Even though it's packaged. (the advantage would be you'd only have to redistribute the little one) In past with a built package...
Hello All - I am new to access (familiar with Oracle and some sql server). I am working on a project where I want a user to enter a store # and a date and then...
Brian I assume you split the database. And I assume you did not change the table schemas. How do you wish to check for updates and send them out? The internet?...
Hi, I wanted to transfer query to a particular range in the excel workbook under "sheet1". I am using this code to transfer this. DoCmd.TransferSpreadsheet...
Brian I didn't read this post before I responded. Because the database is not split, you will have to write code to insert all existing records into the new...
Clive The OP did say a variable was to be used, but as we worked our way through it, it looked to me like it was not necessary. Some of our threads are like...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
