Recent content by natep26

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.