Search results for query: *

I need to limit the processing power devoted to a process ? This particular process has a unique login and tends to run large xml uploads to the database whereas the other clients are accessing the database on a single record basis. these clients get huge - 3minutes per web page - slowdowns when...

You need to use the rs.movenext command in the else portion of your if statement and encompass the whole if statement in a do loop along the lines of 'Do while not rs.eof() if statement blah else blah end if loop this way the process will compare key and password...

cannot find now to control the horizontal spacing of objects. Most other report writers i have used allow the user to make horizontal (and vertical) spacing equal. Where does Crystal Reports allow this please?

Can anyone tell me how to reference a public folder from an outlook process? so far i have: Set myNameSpace = GetNamespace("MAPI") Set mySourceFolder = myNameSpace.Folders(mySource) where the namespace find the personal folders and mysource is a string variable containing the...

Try using the bulk insert on a named range. I dont know the Bulk Insert SQL process too well but in Excel select all cells on one sheet that have the data that you require. Next go to the Name Box (directly above the spreadsheet area - to the left of the = symbol) and type in a name <NO SPACES>...

Not a problem in this instance, I have logged in and have created my own shared folder for the contacts so permissions are not a factor. I am stuck with the code to point the .save action to the shared folder rather than my own personal folder.

I am writing a module to export Contact details from an Access97 database to an Outlook folder. I have succedded in sending the details to my personal contacts folder but they need to go to a public folder. How do i set the code to find this folder and create the new items there? I have created...

kirk, thanks for the offer. email on it's way !!

Thanks for the suggestions so far. The compact did not have any effect. In my original question i did not mention that data from one table is being retrieved through an odbc link. I dont think the sql string length is an issue as the query runs ok and the report is based on that query. The data...

I am trying to create a report that compiles data from 4 tables. there are approx 290 records returned in the recordset with 48 fields involved (many yes/no, others text). The query runs quite happily but the report returns 'run time error 7799' - &quot;this form or report is based on a query...

It is simple to protect your code in Excel. Go to the VBA editor view (Alt + F11) click on the tools drop down menu and choose VBA Project Properties. In the next dialog there is a Protection tab which lets you enter a password and lock the project for viewing. Ticking this box and setting a...

Telsa, thanks for the recommendation, I have never heard of the product - where,who,how much ? J

I tried posting this question on the IIS forum but have failed to get any responses - are they less helpful or less talented than the people who use this one ? never mind , here's the question that foxed them !! &quot;Our company has an intranet running on IIS4. I need to get statistics from the...

Our company has an intranet running on IIS4. I need to get statistics from the server regarding most popular pages etc. I have tried to ste the logging to ODBC and created an ODBC DSN for the file. The system has created an access mdb but it is empty. How should i proceed? I do not want to go...

I am trying to create a form in access2000 to allocate tasks to an office group. Tasks are collected over an intranet into the database and need to be sent out to outlook2000 users. I can create tasks for all users except the user that is doing the allocation. I cannot get the...

I think that you may have ommitted to reference the excel application. When in the module view Go to Tools / References and check the Microsoft Excel row. When you go back to the module the xl...... code should allow excel functions to work effectively :-) Father Jack

At the risk of having thousands of responses, Can I ask what people would rate as a good Access VBA reference book. I have Access 97 Bible (prague and irwin) which is becoming less and less helpful as I progress. I have particular interest in replication,VBA and application development.

Thanks all. This is what I have ended up with - because chris came up with the goods 1st: Function x() Dim a As Integer Dim t As String Dim myrndnum As Integer Dim mysql As String, mysql2 As String Dim dbs As Database Dim qdf As QueryDef Dim rst As Recordset Dim qdf2 As QueryDef Dim rst2 As...

I am new to Access VBA having spent several years programming Excel VBA. I am trying to write a small module to create 8 char passwords. As a start I have created a table with 2 fields and 36 rows.field 1 - key. field 2 chars a - z and 0 - 9. I have a sql string to query the table for the...