Search results

What is odd is that when I hover the mouse pointer over the linked tables it show: ODBC;Description=XYZ;DRIVER=SQL Server;SERVER= XYZ;Trusted_Connection=Yes;APP=2007 Microsoft Office system;;TABLE=dbo.tblPledgePayments

Linked tables.

cheekybuddha, Here is the entire string: : strCn : "Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=J:\Reports\Request\Egate\ETest.accdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database=C:\Users\seminr01"

cheekybuddha, Sorry, I ran Debug further down and got the following screen shot.

Here is a screen shot.

cheekybuddha, Yes, the current project points to the SQL tables since they are all linked tables. I added the Debug.Print code but when, I step into the code with F8 key it does nothing.:confused:

Hi cheekybuddha, I did add another parameter that, I realized I needed which I did not include. I added the other parameter to the Access code and I got this error message: Run-time error '3210': The connection string is too long. The connection string cannot exceed 255 Characters. Here is...

cheekybuddha Thanks for the code looks great! Sorry, I did not send the correct script. The changes you mentioned, I had in the production script. I implemented it a bit differently but with an error. Perhaps you can see it. Here is the code: Private Sub btnCS_Click() Dim cmd As...

Hi Form Masters, I developed a stored procedure that will populate an SQL 2008 R2 table based on the parameters selected in an Access form. I'm not sure how to implement the passing and call to the sproc. Simple put the form collects the pledge amt, the number of payments, when the payments...

Absolutely true must be normalized but I inherited it this way and just need to fix the sum issue for now. Ranman256 said that the text boxes should have a different name than the field name. The names were the same so, I changed them from PP1_Amt to txtPP1_Amt ect. Now, I get #error. Any...

This problem is from the post 'Write Conflict' which needs its own post and attention. The original issue was using subforms on the same data source which caused a 'Write Conflict' This was resolved by using a tabbed control on the main form to logically segregate data. But this has created a...

The method that missingliq suggested works perfectly. No more 'Write Conflict' issues. I start with my main form visible and all the others invisible. When data enter is needed in an other tab it becomes visible and the main tab is made invisible. But this has created a new issue. The following...

Hi Form Masters, In order to better organize data entry into more logical chunks, I'm converting several forms into a tabbed form. The existing form works fine but when, I move the controls into the first tab the event code is no longer available for the various controls that, I have moved...

missinglinq, I did as you suggested, added a tabbed control with 3 tabs on it. But, since my main form is completely full, I placed it on top of the main form and set it's visible method to False. So, when, I need it I turn it on and then have a button on it to turn it off after data entry is...

missinglinq, Your solution worked nicely but a control is now miss-behaving. What is interesting is that it worked fine in the not best practice form that, I was using that kept getting 'write conflict' errors. Any way to the problem. On the first tab named Pledge Schedule, I collect the dates...

missinglinq, That is an interesting suggestion. Do you have any examples or links to such?:o

The database is split in that they are all linked mssql tables. Can this be split any further?

Hi Form Masters, I have a form that handles most of the fields in a table but some of the fields are on a separate form that segregates the fields logically and are entered into another form. The relationship of this information is one to one with the information on the main form so they are in...

I have an sql linked table that has a bit column used to indicate that a job is complete. The default value is always 0 (zero). On the front end there is a check box control to change the row to complete. Since, the only time both choices are available is when records are complete, I set up a...

By stored procedure, I mean ms sql stored procedure running in sql server 2008 R2. I would like to process the outcome in a msgbox.