Search results

  1. E

    Location Query

    Sorry, I just realized that the previous code was the wrong one. This is the correct one. <code> Private Sub Command16_Click() 'DoCmd.OpenQuery "qryCreateKML" 'Export data to text file Dim MyDB As Database Dim MyRS As Recordset Dim fld As Field Dim strText As String Dim MyTableName As String...
  2. E

    Location Query

    and apparently I forgot how to post code. It's been a little while.
  3. E

    Location Query

    <code> Option Compare Database Private Sub Command33_Click() DoCmd.OpenQuery "ENTERYOURQRYORTABLEHERE" 'Export data to text file Dim MyDB As Database Dim MyRS As Recordset Dim fld As Field Dim strText As String Dim MyTableName As String Dim QryOrTblDef As String QryOrTblDef =...
  4. E

    Location Query

    table name = fcc_info_tbl Column Count = 11 Column 5 = 'Latitude' Column 6 = 'Longitude' Next post i make will be with the code that someone graciously posted
  5. E

    Location Query

    Hello Everyone, I need some help with something. I was looking on this wonderful forum and I found some code that someone posted which was awesome because it was for creating/plotting locations in Google Earth which is what I"m planning on doing. The one thing that the code didn't have in it...
  6. E

    Auto Fill null values

    Thank you for the information and asking what my end game was for that. I appreciate it.
  7. E

    Auto Fill null values

    I have a question about filling null values I don't want them to show up as "0" I want it to say "not available". I have a table that has a whole bunch of licenses and license renewals. If license hasn't expired, it hasn't needed a renewal therefore leaving a blank value in my license renewal...
  8. E

    Sorting

    what I was trying to do was be able for the users to select the station that they want and give the functionality of being able to click a button to give them an over view of the configuration but I just realized, why not just put a button at the bottom that brings them back to the home screen...
  9. E

    Sorting

    Cool. restructuring. lol It's a good thing I'm not that far into this thing.
  10. E

    Sorting

    I may need to give a little bit more detail actually now that I play with this a little bit more. I have a form called "Site_info_frm". It basically gives a general overview of all the "out stations" so to say. Then at the bottom of the page, I have created command buttons that will open...
  11. E

    Sorting

    I have a database with a whole bunch of our out "stations" so to say. Some of those places have equipment that I want displayed on a form that I am making called "BP_cnfg_frm". Not all the stations have the equipment at them so I need some error handling for "what if the user selects something...
  12. E

    Remove record

    So, instead of removing them, I can just set it up so that they don't show up in a list once they hit the "expiration" date? Do I need to configure that in the Table or on the form?
  13. E

    Remove record

    What would I need to do to hide the person after they leave? Lets say I knew the date that they were going to be leaving (I know being fired is unpredictable) but statistics show that people usually hold a job for between two and five years. if I had like a date three years from the date they...
  14. E

    Remove record

    Hello everyone. I have a table that has a list of all the people that work for the company. I have a form that I want to use to easily remove people that have the misfortune of getting fired. I have a button that is labeled "remove" and the "on click" event, I used the wizard "delete record"...
  15. E

    SetFocus on query result

    I have a query that is ran when I click a button. the result pops up but it comes up behind the form and i need the focus to shift and have it be up front. Private Sub Command11_Click() On Error GoTo Err_Command11_Click Dim stDocName As String stDocName = "system_qry"...
  16. E

    Input Mask/Validation Rule

    So I have "launched" my application as a "beta" version in our office and the first person that tried to use it (my boss) wanted to be an original and try to "stress" test it. He has enough knowledge of stuff to get him into trouble but needs a true IT like myself to get him out. Well, a few...
  17. E

    Query an email address for the "To" line in an email

    I figured out how to do it. For everyone else that is reading this; for the body of the email, if you put quotations around the words that you want to be said and then concatenate it with the expression of the field you want to show up. Example is shown below. Dim olApp As Outlook.Application...
  18. E

    Query an email address for the "To" line in an email

    I can't seem to get the body portion to work though. It wont populate with the field I want. .Body = Me.Combo14.Column(5) Error Received: There is an invalid use of a null value Then I tried this: .Body = Me.Combo14.Column(5) "Follow the link to your assignment" And I get an unrecognized...
  19. E

    Query an email address for the "To" line in an email

    So I got the "To" part to work but I can't get the body to pull up information from the form.
  20. E

    Query an email address for the "To" line in an email

    So I got the "To" part to work but I can't get the body to pull up information from the form.
Back
Top Bottom