Search results

I have a table called tEm. The fields in the table are BusKey, AnnEm, OzEm, UpEm, MaintEm. I need to create a table that combines AnnEm, OzEm, UpEm, and MainEm into one field. Not one record, but one field. Example below. tEm BusKey AnnEm OzEm UpEm...

Is it possible to link to a Microsoft Access Query as an external data source? I know how to link to a table from another database, but not a query. Any ideas?

I've seen some older threads with this problem, but no real solution. I have placed text in the controltip property of a button. However, when the mouse hovers over the button, nothing happens. I've tried bringing the control to the front and that has no effect. Any ideas? Thanks

I'm not sure what happened or how. I opened a form that I hadn't used in awhile and it closed down my database. I figured it was corrupt (not sure how it go that way since it worked fine last time I used it, and I hadn't made any changes to it) and copied over it with a its backup from a...

I am using the dateadd function to add and specified number of months to a date. However, I would like to add full months rather than an average number of days. For example if I have a date of 6/30/08, then I want to add 6 months to it and end up with 12/31/2008 rather than 12/30/2008. Thanks...

I created a crosstab report from a crosstab query using the example from the solutions9 database. I have one little hang up. If I run the report, I recieve the error "Jet database engine does not recognize '' as a valid field name or expression." From reading, it appears that the problem is...

I have two memo fields in my report. When the report is previewed, they show up with a special character similar to below. The query that the report is based on displays fine. When the query is ran from the control source of the report the special characters are also displayed there. Ą#ą...

I've looked at multiple threads concerning working with null values and how to get a hard number in place of the #error message. I have tried multiple ways and none seem to work. Am I overlooking something. In my query the Column ABC comes up with a number from a calc in another query or...

I have a query that pulls up data from two different plants with inspection dates. I'd like to place a conditional date range in the criteria. I tried IIf([assetarea]="West Plant",Between #6/16/2008# And #12/15/2008#,Between #2/20/2008# And #8/19/2008#) The query returns with no records...

I have a form that is unbound. Information is entered into the form which populates a subfrom via a query and when the Save button is clicked an append query is ran to add the records to the final table. I have a listbox on another form that displays all the records in the table. I need to be...

I'm using the following code with a listbox and the Cool search tool. The search is working fine. The problem occurs when I try to click or double click a filtered record to open another form and I get the errer "Runtime error 7591. You entered an expression that has an invalid reference to the...

I have a query that has InspID, InspDate, NextInspDate, Emissions (calculated by multiplying timeelapsed by associated InspDate Result) I have another query based off this query that sums the Emissions between two selected dates. This works fine as long as the dates I select are actual...

I'm pretty sure this is possible, but am having trouble figuring out how. I have a combobox that lists values from a query. The values are passed as parameters to the report. There are 5 values in the list. When any 3 of the 5 values are selected I need to change the report parameters to include...

Let's say I have a query on a form that returns results. Is it possible to double-click a record in the recordset and open a form. I am currently doing this just fine from a listbox, but am wondering if it is possible from a query.

I have several hyperlinks linked to an excel file on an internal company server. The problem is this. I can open and view the first hyperlink I click on with no problem. However, after I close the new window and click on a second hyperlink, the new window freezes up and won't display it's...

I have a query that calculates elapsed time from TimeIn and TimeOut formatted to hours and minutes. I need be able to mulitply the elapsed time by the hourly wage in order to find the hourly pay. How do you format the time so that it is compatible to multiply with the wage? My SQL statement is...

I currently have two queries. One calculates emissionsperhour based on a results field and the other calcualtes emissionsperperiod based on the emissionsperhour query and the inspection date. I need to go a little deeper and seperate the emissionsperperiod into two categories. Category 1 will...

I have a main form with tabs. On the third tab I have two subforms which are invisible. There are two checkboxes on the mainform. Each checkbox makes one of the two forms visible. When a form becomes visible, data can be added to the form and is put into a table upon clicking the Save button. I...

Here's the situation. I have a calculated value in an unbound textbox (avghcppmw). I want to run a query (qinsphistory) in which one of the fields is the value of the textbox (avghcppmw). Is there any way to pull the value from the form and display it in the query. I'm assuming not. I also...

On my form I have a listbox "Insplist" generated by a query. The listbox shows the types of inspections available (there are 5 unique inspection types). When a value from the listbox is double clicked, I want it to open the corresponding inspection form. At this point I can only get one form...