Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ddub
  • Order by date
  1. ddub

    Stored procedure timeout property

    Thanks Remou, Your post gave me an idea and this is the code I put in the Open event of my form to make it work: Dim cmd1 As ADODB.Command Dim strSQL As String Dim rs1 As ADODB.Recordset Set cmd1 = New ADODB.Command strSQL = "spFindDuplicatesPMP" With cmd1...
  2. ddub

    Stored procedure timeout property

    I have a form in an Access 2000 ADP that has a stored procedure as its recordsource. How do I increase the timeout period before the stored procedure times out?
  3. ddub

    Decimal parameter for stored procedure

    Hi Jim, I tried both of your suggestions, unfortunately, still got the same error message. The value of prm10 was 2.25. Here's what I changed the code to: prm10.Value = CDec(Me.Priority) If you can think of any other fix, please let me know. Thanks, ddub BTW, in the SET and DIM statements...
  4. ddub

    Decimal parameter for stored procedure

    Hi, I need to insert a new record with a decimal value into a table after a record is created. When my event code runs, I get an error message that says "The precision is invalid." I am using an Access 2000 ADP project front-end to connect to my SQL Server 2000 back-end. The...
  5. ddub

    Non-breaking hyphen

    Hi beetee, That would seem like an option, however, that textbox can contain variable length data and so I won't know when a hyphenated word will occur. Since it's the report that users are having this problem with, I guess I could size the width of the textbox in the form to the same width as...
  6. ddub

    Non-breaking hyphen

    Hi, Does anyone know if it is possible to put in a non-breaking hyphen into a textbox so that text looks like this: something something-50,000 instead of this: something something - 50,000 Thanks, ddub
  7. ddub

    Setting value of a main form control from a subform

    My bad. What I coded should have worked and indeed did after I updated my stored procedure recordsource to include the txtControl field's control source. Oops.
  8. ddub

    Setting value of a main form control from a subform

    Hi, Could someone tell me how I can set the value of a control in my main form from an AfterUpdate event in my subform? My simplified code in the subform event is as follows: Dim strControl as String strControl=&quot;Something&quot; forms!frmMain!txtControl=strControl <---Here's where it...
  9. ddub

    Uppercase character limitation for textbox?

    Thanks for the suggestion Cosmo, I didn't get to try it though because I did my own workaround. In the view that's the recordsource for my report, I created a field called UPPER(Description) that I aliased to ProjectDescription and then used this field in my report. Your way with the unbound...
  10. ddub

    Uppercase character limitation for textbox?

    Hi, I am having a problem uppercasing a bound textbox in my Access 2000 report. When I put a '>' in the format property for my textbox, it seems to uppercase the first 250 characters then cuts off the rest of the text. At first I thought that the CanGrow property of my textbox was set to No...
  11. ddub

    Total a group header field

    Hi Shirley, Can you explain what you meant by &quot;as default=1&quot; when you said to put the FY1Amt in the group footer? Thanks.
  12. ddub

    Total a group header field

    Hi, Is there a way to get a total for a field in a group header and put it in the report footer? I have a bound textbox called [FY1Amt] in the group header and in the report footer I have an unbound textbox with the control source as =Sum([FY1Amt]). I'd like to have the report add up all the...
  13. ddub

    HasContinued not working?

    Hey Paul, it worked great! Thanks for all your help, you get a star! ddub
  14. ddub

    HasContinued not working?

    Thanks for the advice but unfortunately, I think Paul is correct when he said that HasContinued has never worked. Even moving the code to the On Format event did not work. If anyone has a workaround to this problem, please let me know. Thanks again, ddub
  15. ddub

    HasContinued not working?

    Hi, I need to be able to not print some fields from a group header if the detail records span more than one page. For instance, if group record AGR100 has detail records that go over one page, I don't need to show the field txtBaseFY1A in the group header for AGR100's subsequent pages. The...
  16. ddub

    Syntax question for INSERT statement

    Thanks for both tips, aalmeida and tlbroadbent. The syntax from aalmeida worked for me. I had tried it the way tlbroadbent had suggested earlier, but it would not work. Maybe this was because I gave the users only the db_ddladmin role and not db_datawriter also.
  17. ddub

    Syntax question for INSERT statement

    Hi, What would the proper syntax be if I wanted to replace 'smith' with the current user name in the following INSERT statement? INSERT INTO smith.tblTemp SELECT * FROM tblSource This statement is part of my stored procedure that allows whoever's executing it to create a table and then...

Part and Inventory Search

Back
Top