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 Rhinorhino 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
  • Content: Threads
  • Order by date
  1. 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?
  2. 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...
  3. 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
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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