Search results for query: *

All, I solved the problem by just having a link to the .csv file. That was too simple. Thanks to all for responding.

All, I export a .csv file from a MySQL database each week. I would like to import the .csv file/spreadsheet into access, BUT only the newer rows, not the entire spreadsheet. Or If I import the spreadsheet, is there a way to just overwrite all the data that is already there? Please...

I would like to do something like this as well from a .csv file. Here is what I do. I export from a MySQL database every week and I would like to only import the newer records into my access database, not the entire .csv each time. How can I do this?

All, I am struggling with the following page which is done using CSS. The page is here: http://www.truenorthprograms.com/overviewskills.htm. The part of the page I am having problems with is this linked area: • The 5 Secrets to Gaining Aligned and Committed Action Through Truly Great...

Try this: DoCmd.RunSQL "INSERT INTO tbl_name2 SELECT * FROM tbl_name1 WHERE someID = " & Me.someID & ";" DoCmd.RunSQL "INSERT INTO tbl_subname2 SELECT * FROM tbl_subname1 WHERE someID = " & Me.someID & ";" MsgBox "The records have been successfully copied" Hope that helps.

When any record is changed when the user opens the form, but i want to capture all the records that the user changed when he is trying to exit the form into an automatic email that is sent to me......again, i know how to do the email part, but i need help with the other part. Is this enough...

All, I have a continuous form whith about 5 fields. I want to be able to send email when any field on any record is changed. I don't want to be an irritant to the user by sending an automatic email everytime a field is updated. I want the email to be sent that has a .snp file attached...

THWatson, Thank you so much for your help. That work PERFECT. I will give you a star!!! Have a great day!!!!

THWatson, I used the following in a query: results: Between [dateBilled] + 60 And [dateBilled] + 89 I get the following error: The expression you entered contains invalid syntax. You may have entered a comma withoug a preceding value or identifier. How do I correct this problem?

All, I have a field called dateBilled and dateDue. The dateDue field calculates 90 days from the dateBilled date (=[dateBilled]+90) I want to be able to show a record on a report once the dateDue field date is 30 before the actual due date, and continue to show on the report until the...

dhookom, I am sorry it took me so long to get back to you, but here is the SQL view: SELECT tblProducts.ProductID, tblProducts.FamilyID, tblProducts.ProductName, tblLicense.LicenseType, tblLicense.LicenseNumOps, tblInstallation.VersionNum, tblInstallation.System, tblInstallation.Install2...

Yes I did dhookom. Instead of typing all of that, I just cut it short. Sorry about the confusion. So now what?

Greg, I get a result of -1, and if I put anything other than ...("d",-1,[dtLicenseBegin]), I still get -1 as a result. Meaning if I put -2, -3 , -4, etc., I still get -1 as a result. I am simply trying to show when the 60 day period starts, I need to start showing the record in a...

All, I have a query (qry_license) that is tied to a table, and two fields I will be referring to are: dtLicenseBegin and results. I have this expression for the results: results: DateAdd("d",-60,[dtLicenseBegin]) So if I enter a date of 12/6/05 for the dtLicenseBegin, the results field...

All, I would like to update my MySQL database from a field called: regID, which is an auto_increment field, using a .asp page. This is the code I have that connects and adds to the database: <% ConnString = "Driver={MySQL};SERVER=localhost;DATABASE=gsgevents;UID=name;PASSWORD=password"...

All, I have a registration form that is in .asp, and I have code to connect and add to a MySQL database. A person fills out the form and hits the submit button and their information gets added to the MySQL database. Once the information gets into the database, a lot of the information is...

Maybe that's why the date didn't show up correctly in the MySQL database when the form is submitted. I changed it based on what you provided. Thanks for that heads-up!!!! Have a good day Dan.

Hey Dan, I ended up using the below: <script> /*Current date in form credit: JavaScript Kit (www.javascriptkit.com) Over 200+ free scripts here! */ var mydate=new Date() var theyear=mydate.getYear() if (theyear < 1000) theyear+=1900 var theday=mydate.getDay() var...

Dan, I changed the order around to meet this requirement: yyyy/mm/dd, but I need double digits for the mm and dd, and I don't know how to get double digits. Maybe I can search around the internet to figure that out, but Man I really appreciate you assisting me with this:)

Dan, I have another one for you, if you can help me. I have a field called: dateEntered. I would like for that field to automatically have today's date. How do I do this? Your help is greatly appreciated. Thanks,