Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: powerlock2005
  • Order by date
  1. powerlock2005

    Importing .csv in access (new rows only)

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

    Importing .csv in access (new rows only)

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

    import from excel to access

    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?
  4. powerlock2005

    CSS Problem

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

    Move Current record from Main AND sub form to another table

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

    Send Email from a Continuous Form

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

    Send Email from a Continuous Form

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

    Show record from date field

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

    Show record from date field

    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?
  10. powerlock2005

    Show record from date field

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

    Query/Report

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

    Query/Report

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

    Query/Report

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

    Query/Report

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

    Updating MySQL Database using .asp

    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"...
  16. powerlock2005

    Lookup Table

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

    Required Fields

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

    Required Fields

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

    Required Fields

    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:)
  20. powerlock2005

    Required Fields

    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,

Part and Inventory Search

Back
Top