Search results

Nevermind...I just replaced "Type" with the actual name in quotes. IE "AnEM", "OzEm", etc

Thanks for the reply...It looks close. How do I get the field lables from the old table to populate the "Type" field in the new table?

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

The query in question is actually a result from 4 other semi-complex queries and we would rather not have to recreate each of the queries in the 2nd database. Currently, the setup we have is thus: A maketable query in the 1st database creates a table with the current information in the 2nd...

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?

There's no such thing as a stupid question. I applied the hotfix and restarted my CPU as rural guy suggested and what do you know. It works. Thanks for seeing it through.

Just applied the HotFix...no luck

I'm using access 2003. The form has about 4 other buttons and a list box. I just tried the new form, new button thing and got the same result.

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 tried all of these things and no luck. I guess I'll just start from my backup. Thanks for the suggestions.

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

Thanks...I think that worked on most of them. What's the logic behind that.

I have the date 6/30/2008. If I add 6 months to it, I get 12/30/2008. I would like to get 12/31/2008 (the full month). Is this possible? Or something I just have to live with? Thanks

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

In your example, I don't want to show the columns for the 3rd and 4th quarters if there is no data for the period. The problem is, if I don't put anything in the query column headings property, then I get the "Jet database engine does not recognize '' as a valid field name or expression." error.

The headings are created by quarter. When I run the Report I want the column headings to be the same as the query depending on the date range I run the report for. In the query, everything comes up fine. For it to work in the report, I'd have to put the coumn headings into the query properties.

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 recreated the query feeding the report and it worked fine....I guess I had a corrupt query.

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. Ą#ą...

Thank you sir...That's what I was looking for. It's all working now.