Recent content by cainemart

Thanks for replying with all of the useful info.

Please give me some direction! I am a programmer for the accounting department for a corp. I mainly do VBA, Access, and VB but I want to expand my skill set. I like the database programming I do, but I want to get into the visual side as well. So my question is, what should I study up on...

Thanks for replying

Why not use the Left("Your string", Len("Your string")-7)

"If you have a multiuser environment and want to speed it up, you can create class modules that represent your records as reusable objects. " The part about represent your records as reusable objects. Are they talking about your tables or just the specific info you are using at that...

I'm using 123 on an Win 2000 machine. Now all of a sudden when I highlight a cell, go to range properties, and select BOLD, I get an error saying "123 error, error log being created." Any suggestions would be greatly appreciated!

I appreciate both of your comments. I guess when I was asked the question I was thinking which would be faster! Thanks again. cainebean

We have an Excel program and imports bank text files and formats the numbers to be used in an Access database. So I suggested doing it in Access since the numbers end up in Access. But they told me that the same numbers were also used in Excel for some of their spreadsheet stuff... I was given...

When I get this message I close the database, restart my computer, then compact the database. This helps for awhile. cainebean

I don't use Oracle but I would think it would have an import or link option. If you can't import the tables that way, import them into a Excel file then import that file into Access.

If(MsgBox(“Question”, vbYesNo, “Question Title”))=vbNo Then Then send next message End if cainebean

Couldn't you get the min/max for the specific fields?

You create a form, then you use the toolbox to create a button. Then you highlight the button, right click and go to properties. Find the onclick event then put in the specific code you are trying to run. You have a bunch of different functions in the code you have listed so you can't just...

Couldn't you convert the 8 hours to minutes then add the other 30 minutes to this total then subtract the minutes you want removed? You might also check DateDiff in help. cainebean

I'm not sure what you are asking. If you expand on it some, I "might" be able to help out. cainebean