Search results for query: *

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

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

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

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.

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

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

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.

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

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

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;

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

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

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

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

Worked great, thanks!

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

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

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

Hi, I am trying to create a summary report. The fields I want to summarize are in a Yes/No format. I have a query behind the report that pulls all of the fields that are Yes. It is set up like this... SELECT tblEnforcement.[103], tblEnforcement.[103CR], tblEnforcement.[6RK], * FROM...

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