Search results

Oops I had the syntax wrong and backwards. I am still getting a data mismatch error when it comes to some rows. Not sure which cause there are 50,000 records and it the quesry will run for 3 or 4 seconds before it runs into the troublesome fields. I am thinking as a work around to just add a...

I have an address database where people have been allowed to type in any characters they want in place of just leaving a missing field blank. For instance the Zip code was not a required field (don't as me why because I don't know. It just wasn't) so over the years when the person entering the...

I think you are right and that is how I had it, well almost. I had some additional relationships added to the interim queries that was goofing it up. After I read your post I went back and took another look, which prompted me to remove the relationships I didn't need. Anyway I think I am...

I am trying to consolidate data from a proprietary database that was built for a DOS based point of sale application. The database is basically a series of flat files. I have managed to get the data into SQL Server but I am having trouble getting the Joins correct so that the data shows the way...

I got it now. Thanks!

Here are three threads that should provide everything you need to do what you want. Access Email Question Automatic Emailling from Access 97 Emailing Reports

Yes, unfortunately for me, someone else usually sets up the databases I work with. So I have never been forced to learn the correct way of doing it. I know I should take the time to learn but I have spent the last couple of years trying to wrap my mind around VB.Net, Crystal Reports and the...

I need some help setting up the relationship for this database in a VB.Net/Access project I am working on. Currently the relationship looks like this: Now I need to add one more table that will have a one to many relationship with the (history?) table: The history table has the...

I have no way to change the data structure. It is a very expensive commercial application that my employer is using. I am bascialy just importing a couple of tables from the app into mine and then trying to create a customer follow up list. As you can guess when we want to create mailing labels...

I am pulling data from an application that allows duplicate customers (Not sure why but it does). Here is my SQL as it is: SELECT CUSTOMER.FIRSTNAME, CUSTOMER.LASTORCOMPNAME, CUSTOMER.ADDRSTR1, CUSTOMER.ADDRCITY, CUSTOMER.ADDRSTATE, Left([ADDRZIPANDEXT],5) AS Zip, HISTORY.CLOSEDATE...

Lets say that you have three textbox fields on your form. The fields are named txtEmailTo, txtSubject, and txtMessage. You can fill your SendObject command with values from the form fields with the following code. Dim strToField as String Dim strSubject as String Dim strMessage As String ' use...

Kodo have you seen this thread? New look of the forum and Mozilla / FireFox. I am not sure that it applies to what you are saying but I was a bit put off by the new look until it was pointed out to me that I had the wrong theme selected. Again not sure it applies but I thought I should mention...

Graham check your references to make sure that DAO is checked and that you don't have any shown as missing. You can check references by opening a module and then going to the menu under Tools > Reference.

Darn. I thought that maybe since you helped me with that one you could possible tell me how to run a DTS package from a VB.Net form but since you have never used SQL Server you are probably not going to be able to answer that one. :D Anyway thanks again for the above help. I have been stuck...

Thank you Mile-O-Phile. You get two points for this one because you actually helped me solve a bigger problem I was having with getting what I wanted out of SQL Server's Enterprise Manager for some Crystal Reports I am working on. THANKS AGAIN!!!!!!

I have a query where I need to check for a null in a numeric field. I did a search on this forum and found several threads with the answer. However, for some reason I can't get it to work. What am I doing wrong here? Vendx: IIf( isnull ([Vendor],999,[Vendor]) All I need to do is put a 999 in...

Thanks Jon K that worked perfectly.

Mile-O-Phile the table is a "batch" table meaning that it is a temporally storage place for some data that will be updated with other criteria and then uploaded into a SQL Server database. Each week (that is until we are working in a 100% SQL environment) the batch table will be cleared of last...

ghudson thank you for the clarification.

I am looking for a way to load a MDE from a Visual Basic .Net application. The MDE is an Access 2000 version and all the clients on my network are using Access 97. From this thread I found out that you can use a run time switch to overcome the version problem, however I am not sure how to set...