Search results

Hello, Big Jim here: I have an Access table with 135K records in it which opened very slowly. Could take 30 seconds for the hour glass to finally pop up and then open the table. When I made a new copy of the table, records and all, this delay went away. I'm running a process that executes SQL...

Hi, Big Jim here: Not even sure how to write this one out, so I will just explain like the simpleton I am... I have a .jpg file (guess it could be any format). This file has some odd-shapes in it. I would like to be able to click on these odd shapes and assign them properties. You know, name...

Hello, Big Jim here: I am attempting to use Visual Studios 2005 and SQL Server 2005. It appears that I am missing The Visual Studio Template for "Integration Services Project". Any idea where I can get this? I installed a full (everything checked off) version of SQL Server 2005, and this...

Hi, Big Jim here: I am attempting to use vba in Excel to make a connection to Access XP. I have established the connection, but I am getting an error while attempting to add a new record to my Access table. Specifically, here is my problem... 1) Excel cell has a value of 4.1234 2) Access table...

Hi, Big Jim Here: I was hoping you guys would have a recommendation. Do you know of a book or web site that offers workbook examples to help practice learning how to understand existing databases? My biggest problem with databases has never been designing them but learning how to follow...

Hello, Big Jim here: I would love to know a way to view the properties and methods of an Active X component. Is there a tool that tells you what all of the properties are? For example, I am using a Windows Media Player in a web page. I got it to work thanks to copy and paste. It came with...

Hi, Big Jim here: Most bizarre problem. I open Access from VB using the following code: Public gAccess As New Access.Application gstrDatabaseFullPath = [Whatever database I am opening.mdb] gAccess.OpenCurrentDatabase gstrDatabaseFullPath gAccess.DoCmd.SetWarnings True...

Hi, Big Jim here: I am really not sure where to ask this one..... My boss and I are in a jam. We have been using Access to run a reporting process, but one of our tables will exceed the maximum fields allotted this month. Our thought, dump the table into SQL Server and use the GUI interface...

Hi, Big Jim here: I used the upsize wizard to upload my Access XP database to SQL Server 7.0. Everything looks fine except that the action queries all came through as ALTER PROCEDURE stored procedures. Why would they come through as ALTER PROCEDURE and not just as stored procedures which...

Hi, Big Jim here.... Any ideas on how to load and setfocus to a new form during the on load event of another form? I load and set the focus, but then the on load event of Form 1 finishes running and the focus returns to Form 1. Any thoughts? Thanks in advance, Big Jim (Access 97)

Hey Big Jim here! Is it possible to reference a variable from a variable? Example: Dim strA as string Dim strB as string Dim strC as string strA = "strB" Value of strA = strC 'In other words, setting strB = strC using the value of strA Did that make any sense? Thanks in advance! Big Jim

Hi, Big Jim here, I did not know how to articulate this well, so I hope it has not already been posted 1,000 times. Suppose I was running Sub Procedure A and called Sub Procedure B. Procedure B gets an error, and my error handling causes Proc B to end and return to Proc A. Is there an...

Hi, Big Jim here: I am attempting to open a Lotus Notes database using VBA. Here is part of my code: Dim session As Object Dim db As Object Dim doc As Object Set session = CreateObject("Notes.NotesSession") Set db = session.GetDatabase("", "") Do Until db.IsOpen = True db.OPENMAIL Loop...

Hi, Big Jim here: I am running an Access query from Visual Basic (not VBA)...the query has a user defined parameter in it. However, when the query runs in VB, the Access window does not notify the user to switch to Access to enter the parameter. Is there anyway to force the Access parameter...

Hi, Big Jim here: I have created links from SQL Server 7.0 in my Access 97 database. I believe I have done everything right: 1) user has read\write privilidges on the table 2) I created a primary key on the table 3) I also refreshed the links after they were created Yet still the linked table...

Hi, Big Jim here: I have done some searching and found lots of interesting little tidbits of information on this topic, but I thought I would ask here and see if there was something major I was missing... I have sql 7.0 tables \ views linked into Access 97. They are linked over a network from...

Hi, Big Jim here: I was wondering which was the better way to add or delete a record from a table in this situation: I have recordset A and recordset B. Both recordsets pull records from Table1. I make a change to data that was in recordset A, and that change should be reflected in recordet...

Hi, Big Jim here: Can anyone tell me the difference between these two pieces of code? *********************** Dim rst as recordset Set rst = currentdb.OpenRecordset("SELECT * FROM MyTable") Label.Caption = rst!Field *********************** Dim rst as Recordset Dim strField as String Set rst =...

Hey, Big Jim here: I have a listbox whose RowSource is set to a query. When I press a button on the form, the RowSource changes and the listbox should fill with thousands (7,000+) rows. However, it only populates the first 20 to 30 rows. Is there anyway to force the listbox to populate with...

Hi, Big Jim here: I am trying to find a way to create an incremental counter for a query which will be appended to a table. For example: Rank Name 1 Bob 2 Kevin 3 Mary Where Name is all of the data I have. I cannot use an autonumber, because I have multiple queries...