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 derfloh 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: *

  1. rasticle

    Opening IE w/ Google Maps

    I was unaware of that syntax! That would save some time. =) Thanks PHV.
  2. rasticle

    Opening IE w/ Google Maps

    I figured it out. I was calling the IE incorrectly. Private Sub google_Click() Dim vUrl As String vUrl = "http://maps.google.com/maps?q=" & Me.Long.Value & "+" & Me.Lat.Value & "&iwloc=A&hl=en" Call Shell("C:\Program Files\Internet Explorer\Iexplore.exe " & vUrl, vbMaximizedFocus) End...
  3. rasticle

    Opening IE w/ Google Maps

    Hi, I've look around and haven't found the answer I'm looking for. I'm trying to just open Google Maps in IE with a button in Access. I'm making some silly error that I can't seem to figure out. Just need a second set of eyes to maybe tell me what I'm doing wrong. Private Sub...
  4. rasticle

    Importing and mapping denormalized data

    I have already tried out the wizard and it seemed like that would be a quick easy way to do this type of import. I need to append the data to already existing tables and also keep the relationships between the contacts and facilities. I can't be this stupid. This has to be some simple fix.
  5. rasticle

    Importing and mapping denormalized data

    Right, so the actual facility information it in the correct format. But the contact information is repeated. So there could be many facilities that have the same person as a contact and since the data is in a flat file format the contact information is repeated. I need to get the contact...
  6. rasticle

    Importing and mapping denormalized data

    Hi, This is probably easier than I'm making this out to be. If I have a data table that is denormalized and I want to import the data into a normalized database what steps do I take? What I have is very simple I have a table with facility and contact information. I want to seperate the data...
  7. rasticle

    VBA script to export excel to cvs

    It is for a template to pass out to people to put data in a format for entry into a database. It is just easier to give people a button to push.
  8. rasticle

    VBA script to export excel to cvs

    I have the script running perfectly, but there is just one problem. In the event that someone enters a value with a comma in a cell it prints the csv file incorrectly. Here is the code: Public Sub WriteSheet(curSheet As Worksheet, pathstr As String, col As Long, row As Long) Dim txtStr As...
  9. rasticle

    Complex form filter

    I have resolved the problem. This issue was that, using Case 1, Case 2, and Case 3 was wrong for my situation. I needed to have the string value in the case. So I used: Dim myCriteria Select Case pick Case "IssueDate" myCriteria = "IssueDate" Case "InitActDate"...
  10. rasticle

    Complex form filter

    I guess I should also mention that the query behind the report is a simple one: SELECT tblEnforcement.initActDate, tblEnforcement.croDate, tblEnforcement.issueDate FROM tblEnforcement;
  11. rasticle

    Complex form filter

    Okay I have the code in and I changed it to fit my needs, the only problem is that I am getting a new error. =( I really wish I was better at this. The new error reads: "Syntax Error (Missing Operator) in query expression '(Between #1/1/01# AND #1/1/07#)'" This is the code I used: Dim...
  12. rasticle

    Complex form filter

    I do that portion the same way, with the start date and end date. But how to I make the filter form so that the user can select from different date fields for the start date and end date to pull from?? =/ For example have the option so that the user can sort start to end date from shipping...
  13. rasticle

    Complex form filter

    Or is there a good tutorial for setting up report filters maybe? Its giving me a huge headache! Thanks
  14. rasticle

    Complex form filter

    I guess it is not that complicated, but I have a report that I am filtering by date. I have it working fine. But I want to add the option to allow the user to select by which date they filter the report. Right now I have a filter form with txtStartDate and txtEndDate and in the query (I just...
  15. rasticle

    Help with using Count()

    Worked great, thanks!
  16. rasticle

    Help with using Count()

    hmmm.. I tried Iff([103]="Yes", Count([103]),0) but that just gives me a zero, even when it would count it correctly before. Essentally, if the query returns any records with "Yes" I want to count how many times. So if 2 facilities have a 103 law violation, then I want it to count 2, but if...
  17. rasticle

    Help with using Count()

    The query that drives this report pulls from the field 103. Where the value is "Yes". If the query finds records where the value is "Yes" then the report sees them and it cound appropriatly. If, for example, 103 did not have a "Yes" value in any record that is when I get the error. So I am...
  18. rasticle

    Help with using Count()

    On the form in the textbox I enter: =Count(103) and I get this error: "The Expression you entered contains invalid syntax. You may have entered an operand without an operator." I believe this is because the query is looking for all 103 where it has a Yes value. Sense there is no record in...
  19. rasticle

    Help with using Count()

    ...that pulls all of the fields that are Yes. It is set up like this... SELECT tblEnforcement.[103], tblEnforcement.[103CR], tblEnforcement.[6RK], * FROM tblFacility INNER JOIN tblEnforcement ON tblFacility.epaIDMaster=tblEnforcement.epaID WHERE (((tblEnforcement.[103])=Yes)) OR...
  20. rasticle

    Combo Box to Return Report Names

    How would select specific reports to put into the combo box? So that not all reports are pulled?

Part and Inventory Search

Back
Top