Search results for query: *

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

"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!

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

If I have an api that is used by a few different forms, should I put it in a global module or in each form. Will it run faster if placed in each form because because it won't have to access the global module is what I trying to ask I guess. Thanks cm

I use SQL to make this table on our AS400 CREATE TABLE POLICIES (SMCONR CHAR (2), SMPRFX CHAR (4), SMPLNR numeric (9), REFN# numeric (11,0), PSAGL3 CHAR (3), PSAGL2 CHAR (6), PSAGL1 CHAR (9), TERM_YY numeric (2,0), TERM_MM numeric (2,0), TERM_DD numeric (2,0), TRX_YY numeric (2,0), TRX_MM...

I'm trying to find out how I can from dB "A" get the total number of Database Objects in dB "B". I have to collect some stats on a lot of databases and I'm trying to find a way to automate this process. Any help would be appreciated. I know how to get "A's" when...

When I look at the SQL of a query and try to return to design view I get an error saying it can't find the callback or macro fDesign. I've uninstalled and reinstalled Access 97, tried to change the recordlocking options and I'm checking into a corrupt NT profile. I don't think the NT Profile...

I'm making an auto logout form that will use the timer event. I was wondering if it uses a lot of the systems resources. We have an old computer that is dedicated to one access application and it will use the form. Just trying to figure out just how bad this will slow everything else down...

I need some input.... The company I work for uses Access 97, an AS400 mainframe, and we have a few things using a SQL server...We have an MIS Dept that takes care of the "big" stuff. I work in the accounting dept and I use Access and VBA to handle all our Db needs... It is slow, and...

I have a record that is locked and it gives me a message that this record is locked by another user. There isn't another user in the database! Does anyone out there have any suggestions on how to unlock a record that is locked? Thanks, CM

If you have an index set for a table in one database, and in another database you are linked back to that indexed table, does the index apply to the linked table. thanks

I have this array, which someone else designed: Dim EPArray(1 To 9, 1 To 3, 2000 To 2003, 1 To 12, 1996 To 2003, 1 To 12, 1 To 5, 1 To 4) As Single This array loops through millions of records and collects the info. The problem is that it needs to be Dim even more that it already is. When...

I have an array Dim EPArray(1 To 9, 1 To 3, 2000 To 2003, 1 To 12, 1996 To 2003, 1 To 12, 1 To 5, 1 To 4) As Single that loops through a file and collects the info. Well the array gets to large and give me a memory error. So I thought it would be best to use a counter and when it got to a...

I am trying to re-work someone elses code because we have a problem with 2 arrays in the code. EPArray(Stateindex, Polindex, EffYear, EffMonth, PolYr, PolMth, CompanyIndex, CovgIndex) This is just to show you how bid this array gets. It loops through about 1 million(this can be as big as...

I am using Excel 97 and I want to be able to use the contents of a cell in the footer. Ex: A1=tally I want to be able to make a reference to that cell in my footer and have it display on "tally". It is really easy in Lotus but I haven't figured out how to do it in Excel. Thanks!

If you set warning=False and set hourglass to T in your code and have an error statement like Form_Open_Exit: DoCmd.SetWarnings True DoCmd.Hourglass False Exit Sub Do you have to reverse the initial settings in the body of the form or does Access go to Form_Open_Exit everytime it exits? I...

I setup Access Security and almost everything works correctly. Here is my question. When I try to Access my secured dB it asks me for a login and password. I have 2 different levels of access setup. I can login into both levels(groups). But when I try on login from someone elses computer it...

I have a main database that gathers info for 5 other dB's. I link into the main dB from the 5 other. I want the 5 other to be able to access the info in the main tables but I don't want them to be able to change the data in the main table. Any suggestions? thanks