Search results

Yeah that shows up. I have included a screen capture attachment. Thanks again for all the help.

I did add the code. I also have the cboCounty and the cboCity 'Bound Column' property set to 2. The initial problem seems that the cboCity will not populate after changing the cboCounty 'Bound Column' property to 2. Not sure why that is. I am not sure I put the code in the correct place but...

Thanks for the quick replies. I thought that perhaps it had something to do with the 'Bound Column' setting. However when I change the 'Bound Column' value to 2 instead of 1. The cboCity will not populate. Any ideas on why that would be. Any thoughts as to why the cboCity will not retain...

I have two problems with my database. The primary table of concern is the table named 'Spotter'. The primary form of concern is named 'SpotterForm'. There are a few primary queries of concern also they are, 'qrycboStatesOnCountry', 'qrycboCountyFromState', and 'qrycboCityFromCounty'. The...

Many thanks for the assistance bob. I am still unclear as to why the Private Sub cboCountry_AfterUpdate() Me.cboState.RowSource = "SELECT tblStates.States FROM tblStates WHERE tblStates.Country = " & Me.cboCountry & " ORDER BY State" Me.cboState = Me.cboState.ItemData(0) Me.cboState.Requery...

I must be more tired than I realized. This time with attachment.

Sorry about the delayed reply. I was just getting off work when I noticed your post. I have now converted the database into mdb (2003) format. Again thanks in advance for any assistance.

I thought I knew how to do this but after several hours I am still unable to figure where I am going wrong. I simply have several tables tblCountries, tblStates, tblCounties, and tblEntity Info. I also have a form frmTest. I have tried different ways of implementing the cascading combo boxes...

I am not sure where to begin with the question. So I will begin by trying to describe what I have and what I need. I have a table (tblSpotter) with Info about people, i.e. First Last Name, address, phone, etc. I have another table (tblStormVer) that List phone calls received. The idea is that...

First off thanks for the reply. I initially had that line as you suggested. In fact, I simply commented it out but otherwise left it there. But I still get the same error stopping on that line of code. Specifically the error I get is Run-time error '3270' Property not found. Aside from that...

So I have this simple database with different stations and precipitation data. I am attempting to create a dynamic query 'on the fly', so to speak, that uses a combo box to select a particular month from a table. There is a command button on a form with attached code. The code is supposed to...

I have more than one attachment on a couple of records in a table. My problem is trying to display 2 attachments on a form. For example record 1 in tbl1 might contain 2 jpg attachments. I would like to be able to display both attachments in frm1. I thought it would be rather straightforward...

Well I searched everywhere or so I thought. I went so far as to delete every single thing off of the form, but still got the error. Then I accidentally was clicking on the form in design view and noticed the Property sheet for the form. There is was a reference to the field that did not...

So I have this database that I have been working on. There are fields for Latitude and Longitude in both decimal and degree minutes seconds format. Initially I was entering each of these values separately. But in the last few days as I began actually putting a lot of data into the table I...

I am attaching a zipped file of a sample database. It took me a while to delete sensitive info and replace with bogus data. I believe all of the personal info has been scrubbed. After you unzip go to the form named 'Login'. Don't forget to enable content on the security Warning thing...

I am not sure if all of the functionality will be there with the mdb filetype but here goes nothing. Please disregard the login screen that comes up. I am working on this still but to use the functionality of the google earth mapping open up the form titled 'frmReports' there are a number of...

I am attaching a sample database. On the form 'SpotterForm' some of the addresses may not map correctly. The reason for this is I had to change names and some addresses are just made up. So it will launch but may come up as address unknown or something like that. Also on the form...

"DanielsKMLtest" is a query. The code posted above actually works. I was modifying it for use with a different query. I did finally accomplish part of what I was trying to. I will post the code shortly for any interested parties. I am still trying to sort out a few other things. Namely...

I have a couple of different forms. On one form I have cmd button linked to the following code. Private Sub Command5_Click() '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 Dim...

Not exactly sure what I was doing wrong. I started over with a new form and applied the combo boxes and everything worked. I must have inadvertently left something out the first time. Although for the life of me I cannot figure out what it was. :o