Search results

Hello, Access 2016 Three tables: tblPositive (has one field PosWord) tblNegative (has one field NegWord) tblTargetText (has three fields: Chapter, Paragraph, TargetText) Goal: I would like to have a query look for all the PosWord in TargetText and return those records. I have tried...

Hello, I am working with two tables in Access 2016. Table 1: has only one field, called "word" (no primary key) Table 2: has three fields, one is auto pk, another called "chapter" and a memo field called "text". I am trying to create a query/form that takes Table 1 "word" value and looks...

Hello, I recently updated my subscription for Office 365. Access 2013 to Access 2016. I have a fully functional database I am working on. When it updated my Access, I went about working in the database as usual. I did not Save As to 2016, it just saved as normal. My problem: It lost all my...

Access 2013 I am trying to create a query that will provide the turn over status of a unit. There are four statuses a unit can be in: Occupied, Ready to Rent, In Renovation, Out of Service. My setup query's data is: 7249 Occupied 9/1/2015 8/19/2015 13 7249 Ready to Rent...

Access 2013 I am trying to format a field within a report. I have the event on the On Format of Detail. Two fields, if one is greater than the other, make the font red, if not, black. Here is my code: Dim ct As Integer Dim tc As Integer ct = Me.TextOverUnder tc = Me.TextAvg If ct > tc...

Access 2013 HELP! I have been working with the toolbars. I added code to turn off and on. Working fine. But now when I go into design view, while toobars are showing/on, the properties window will not work. Are any database I open or create. The tab order works, so I know it isn't the whole...

Access 2013 I am wondering if there is a way to apply a graphic for my database for the database and forms. I know Options allows you to browse and select your icon for the database. But I don't want the users to have to do so when they copy the database to their harddrive and link it to the...

Access 2013 I have created some graphs on my dashboard. I have parameters set: users can change the data of the graphs by selecting different parameters (fields, combo boxes, frames, etc.) There are four categories (series): In Renovation, Occupied, Out of Service, and Ready to Rent. Each...

Using Access 2013 Trying to create a chart in Access on a form. My first question, how do I access the data while in the chart software? I know I can use the properties to get to the query, but double-click in chart, and I cannot locate the data series to manipulate. Second question: how...

Hello, I am using Access 2013. I am trying to create a query that will count the days difference between two dates. The dates are in the same field. I want to group by Region. So: tblRegion = RegionID tblStatus = StatusDate I know how to use the DateDiff when it is two different...