Search results

Hi I have some data that includes records for each day of the year. The records will change from time to time assuming a new record is reached for a particular date. I would like to be able to do a query using two combo boxes 1)cboMonth 2)cboDay and using these two comboboxes do a query using...

Good morning everyone, I have a bit of code that I have recycled on a few buttons that all work fine. However this one bit of code associated with this particular button I cannot seem to get to work properly. As I said I have used code nearly identical to this on other buttons that works just...

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

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

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

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

Good day all, I have a database with several tables, forms, reports, and queries. I would like to create a form that include a textbox and a command button. What I want to query is all people with the Last Name of (whatever value is in the text box) from the table 'Spotters'. I have included...