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,
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...
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,
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.