Search results

I don't have an Ipod or other music player. My home stereo is a 30 year old Nachamichi and I prefer the sound and ambience of vinyl. I think my car radio works, or at least it did 3 years ago. I have a cell phone and I know how to make a call with it, which I've done 5 times so far in a year...

At some point, you will need to archive old bookings off to another table/database; so make sure you have a date/timestamp of last activity or status change.

What boblarson said. Print is an external OLE/DDE function and macros don't handle them well. Besides, even if it did work, odds are good it won't with the next upgrade.

Has it actually completed your print request when you get this message?

Format of that field in your import table definition?

I'm under the impression that Access uses the date format you choose as your Windows default.

Thanks a lot, guys. I see how to make that work, now.

That seemed kind of odd to me.

Well, thanks! That seemed to be a little too simple.

I'm not very good with macros, as you can probably guess. My import macro works fine, but I can't get it to run a VB sub very well. I tried an "Open Module" action in the macro, but it pops up the VB window so I can run the sub procedure manually. It works, but it's not too impressive to show...

I have a macro that imports some files and massages data. It works fine except for a couple things. The possibility exists that the data being imported will contain some crap that will cause an import error table to be created. I don't care about the table, so I have a "delete object" action for...

Thanks a lot! That's the last thing I would have thought to look at.

When I create a database in Access 2007, the table view is in full screen mode and I can't change it to windowed mode. I can't find a way to view two tables side by side.

I tried the self-employment IT consulting route for several years. I earned a decent income, but on an hourly basis I could have done nearly as well working at MacDonalds. The problem is if you are selling, you aren't billing and if you are billing, you aren't selling. So, you need to work a ton...

Re: Error Message: " is not valid name. Make sure that it does not include invalid I get the same error just by selecting the table name; I don't even get as far as selecting a field.

I'm glad you found it because that's not something I'd have ever guessed. The times I've experienced things similar (sort of) have been timing related.

So, the problem occurs because the affected report is not the current active object?

Are all reports are created by one action and if so, what would that action be?

After looking closer, "make table queries" are probably a bad idea. You can do it with a simple VB routine. This assumes a detail table (DtlTbl) of Desc (text,50) and Number (text,50) and summary table (SummTbl) of Desc(text, 50) ,Cnt(long integer) and Number (text,255). The detail table should...

You will need to restructure your tables or do some "make table" queries to accomplish what you wish. Also, your counting is wrong or you wouldn't get 0 values.