Search results

I have a query that gathers information from the tables in my database and returns something like this: Field Pest 1 Insect1 1 Insect2 1 Insect3 2 Insect1 2 Insect3 2 Insect4 Field and Pest are fields in two separate (but joined) tables. Field exists only once in its...

What am I doing wrong here??? DoCmd.RunSQL "DELETE tblScoutingRecords.*, tblScoutingRecords.[Record Number], tblFieldRecJoin.*, tblFieldRecInfo.* FROM (tblScoutingRecords INNER JOIN tblFieldRecJoin ON tblScoutingRecords.[Record Number] = tblFieldRecJoin.[Record Number]) INNER JOIN...

Hello all, Thanks for all the help on other subjects and threads. Here is another interesting question: Is it possible to reference the value of a control in the current record of a subform that is in continuous view from another subform without using DLookUp to reference the value in the...

I have an interesting issue where one of my subform's Current event is executing twice. Here is the event: Private Sub Form_Current() DoCmd.SetWarnings False DoCmd.RunSQL "DELETE tblFieldListPopulation.[Field Number] FROM tblFieldListPopulation" DoCmd.RunSQL "INSERT INTO...

I've seen and read posts regarding filtering of combo boxes, but haven't seen one about filtering based on prior entries of that combo box... Let me explain: I have a subform in continuous view on my main form. The combo box in question is in the subform. I'd like to be able to eliminate...

Hello all, Is it possible to keep the date picker button (adjacent to a date field) visible at all times? I see the options in the property sheet of the date field for never showing it and showing it for dates, but there is no option for that particular property to be always visible. I am...

I am creating a database to keep pest scouting records in order to determine which pests are above my company's thresholds - to make recommendations for combating these pests. Scouts are sent out into fields to search for these pests. They require different information based on which pest they...

Ok, so before I waste the afternoon trying to accomplish something impossible in Access: Is it possible to have a continuous form with a control layout that is determined by the value of a control in a current record without changing the layout of the rest of the controls on the other visible...

I have a report which details the cost and amount of chemicals being applied to a farm to combat target pests. This report is grouped by [Target Pest].Value which ends up displaying the report as a groups of records grouped on individual values from [Target Pest]. This is the expected and...

I have this as the control source for a text box in the detail of a report: =[Rate]*[Acres Sprayed]*[Cost/Unit]/(Len([Combo50].[Text])-Len(Replace([Combo50].[Text],",",""))+1) In layout view, it shows the correct values as currency, in report view I get the #Type! error in that control. How...

Guys, Can someone post code for counting commas/specific chars in a string? i.e. String = " A,B,C,D " CountCommas(String) would return 3.. ? My brain is beat for the day..

Hey guys, I'm attaching a copy my db for your review. If you can, please check out the structure of things, and suggest any changes. I'd greatly appreciate this. The main form I'm looking for critique on at this time is frmScoutingRecords. Let me know how I'm doing, if you'd be so kind...

I have the following form: Is it possible to have the form duplicate each data entry object when the + button is clicked at the bottom right of each 'subform' (not actually subforms)? I have some data entry that I'd like to manage in this manner. I'd like to be able to make a flexible entry...

We have a database on a PC located on our network. The database is located in this computer's shared folder. Another database grabs data from this database occasionally. We're running into a problem where we cannot open the DB located in the shared folder (permissions granted) without it...

Is it possible to make a path or a shape in access? I'd like to do some graphical representation of some data and change colors of the shapes based on given values that would correlate to the shapes. Any ideas? Thanks in advance, John

I currently have a fully functioning, shiny, brand new database that my users would like to be web-accessible. I understand some (all?) use .NET to accomplish this. Could the answer-er of this question please outline the following for me: 1. Steps necessary to accomplish this task. 2...

I'm currently designing an inventory control database for an end user who is having trouble transferring his Access 2007 Professional License from his old computer to his new one. In the event that he cannot get the activation code, will his version of access be able to utilize the functions...

I have a form containing two sub forms. These forms contain boxes that are bound to tables which contain required fields (as defined in the table design). On entering/exiting form/subform focuses, a warning is displayed if the required fields in each form/subform are empty/null. A few ways...

Would it be possible for me to create a 'Select All' button for a combo box which contains multiple values and allows multiple selections? If so, how?

I've come to the point in the design of my chemical database where I will be generating recordsets of data which represent fields on a map and the re-entry date of the fields (date at which it is safe to return into a field after spraying a chemical in said field) . I have an ESRI shapefile...