Search results

Thanks zambam, but that didn't work. I should add that even if I go into Access and try running a Macro that sets the warnings to True, I still receive no warnings. I physically have no way of setting the warnings to true. Thanks! Big Jim

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

Pat, My boss went on for 20 minutes about how you must be a programmer and how he should be able to do anything he wants with Access. (my boss is a financial analyst / auditor) After a cool down session, he told me to try just linking the SQL Server table into Access and run my updates to the...

Thank you Pat for the very informative answer. I have to stick up for myself and say that along with MIS degree, I got the 411 on normalization. However, my boss is not normalized on many levels. :) Your logic makes sense, and I will share this with my boss and hope we can fix the table...

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

Thanks FOFA, but it is only the UPDATE queries that come in as ALTER PROCEDURE. I am guessing it is because the SQL is different for running an UPDATE statement in Access and SQL Server. I really have no idea. Thanks again! Big Jim

Hi Chunyih, How far have you gotten in your examples sited above? At what point did you need help? Thanks, Big Jim

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

Private Sub Form_Timer() Me.TimerInterval = 0 If blnOpenLoad = True Then DoCmd.OpenForm "frmAudit_Load" End If End Sub Set Form 1 timer to something and have a variable in the on load event determine if the new form needs to be opened. The timer runs, turns the timer off...

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)

Many thanks Wayne! Big Jim has learned alot today thanks to you. Regards, Big Jim

Hi Wayne, Thanks, as that makes great sense when dealing with recordsets and controls. I will be able to use that in the future. However, what about variables? Is there a control array or something for variables? I am looking to set strB by referencing it in strA. strA (which has a value of...

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

Ah, Big Jim thanks The Stoat for his wise advice. :) Thanks again! 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 Scott, I am just trying to send an Email. Thanks for replying. Big Jim

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

Thanks dcx693 The number of parameters will vary from query to query with hundreds of variations. Is there a way to do this without having to write out each possible parameter? Thanks again, Big Jim

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