Search results for query: *

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

This would be an example tblOrders OrdDate <--- First part of primary key OrdID <--- Second part of primary key StaffID <--- Foreign key to tblStaff TableID tblStaff StaffID <--- Primary / Foreign key FName LName SSN Now if you wanted to get the info from tblStaff you would join it like...

You have to make something trigger the specific code that you want run. Like when you push this button, this code will execute. You have a few differnt functions in the code listed. Would need more info on what you are doing. cainebean

Couldn't you make a table with the two fields you need then link all of the other tables back to the first?

I think you are going to have to check every table and every field in the tables to get the info you need but I'm not 100% sure. cainebean

You can import regardless of who was in the database. Especially since you are importing. The way I understand it is you would only have a problem if the records you are importing are on the same page as someone else using the same records. Since you are importing this shouldn't happen...