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 SkipVought 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: *

  1. Jorgandr

    T-SQL Cursor Question

    Is there a way to use a variable in the select_statement part of the DECLARE CURSOR? For instance I would like to do the following SELECT @SQL = 'SELECT [' + @FieldName + '] FROM [QueryName]' DECLARE CURSOR_1 CURSOR FOR @SQL However this does not seem to work. Is there any way to do this...
  2. Jorgandr

    Putting multiple values into one field

    Thank you for the information, however if had a report that had 12 fields and then the guarantor name, it looks ugly to group the records and only have the guarantor name on each separate line. It would look much nicer if they were all in one text field separated by commas.
  3. Jorgandr

    Putting multiple values into one field

    If I were to make a report that includes an intersectioin table in the query it would contain multiple records for a particular Field in the primary table. This would then make my reports show one line per record, when I'd rather have all the intersection field data in one field. Example...
  4. Jorgandr

    Not able to use right-click

    Somehow, I can no longer right click on objects in design view and get a menu in Access 2002. Does anyone know how to turn this back on? Thanks for any help
  5. Jorgandr

    Keeping <OPTION> Lists in a dynamically created List or Combo Box

    I have a page that has a 2 list boxes and a combo box. The first list box is populated from a database with all the names of our associates. The other list box is empty as is the combo box. Here are the identifiers for each item: List box #1 Available Users List box #2 Selected users Combo...
  6. Jorgandr

    Reducing One to Many Queries To 1 Unique Record

    Thanks for your help... I'm not sure if that will work for what I want. Ultimately I want to be able to display this on a report and include totals for loan amt and the such but to only display one line of data for each loan instead of multiple ones because there are multiple exception items...
  7. Jorgandr

    Reducing One to Many Queries To 1 Unique Record

    What I would like to know is if there is any way to take a standard one to many relationship and then displaying only 1 for each related item. For instance, say i have a table: Exceptions: ExceptionID <-- Primary Key LoanID <-- Foreign Key ItemID <-- Foreign Key Instead of in a...
  8. Jorgandr

    Printing Detail Record Fields horizontally

    I need to build a report from a query that has 3 tables joined, however I would like the 2nd level grouping to go accross the top instead of down. ex. Table 1 ------- Contract # AffiliateCode CustFName CustLName Loan # Table 2 ------- ExceptionID ExceptionCode ExceptionDesc ExceptionType...
  9. Jorgandr

    Getting Table and field names using VBA

    How would you get field names using VBA? I want to do this so that I can create a custom query builder that end users can use via a form. i have the table part of it. Function ShowTables() Dim mytables As TableDefs Dim currenttable As TableDef Dim currentfields As Fields...
  10. Jorgandr

    Capturing the submit button value

    Here's an easy test of the problem. If I were to write a simple piece of coding: <html> <head> </head> <body> <form method=&quot;POST&quot; name=&quot;test&quot; action=&quot;../testpage.asp&quot;> <table> <tr> <td> <input type=&quot;Text&quot; name=&quot;Test&quot;> </td> <td> <input...
  11. Jorgandr

    Capturing the submit button value

    I have some code: if not isempty(Request.form(&quot;Submit&quot;)) then do code end if This works if the user clicks on the submit button but not if they hit the enter key.. Is there a way around this so that it will always run that code in the if statement if they click on the submit or hit...
  12. Jorgandr

    Could not complete this operation because an assertion has failed?

    Anyone have any idea at all what is up with that error message! I am almost to my breaking limit here! I get the above error whenever I try to Save for Web in Photoshop 7.01 and when I try to open a file in ImageReady 7.01. I can open a file in Photoshop and then &quot;jump to&quot; ImageReady...
  13. Jorgandr

    Help on getting totals queries in Access 97

    I have a table callled classdate which contains these fields dateid classid instructor1 instructor2 instructor3 instructorcredit There can be as many as 3 instructors for one class on any date. One instructor could teach the same class just on different days. I wanted to develop a query that...
  14. Jorgandr

    Not displaying subreports when no data

    I have a report that has a typical Report Header, Group Header, Detail, Group Footer, Report Footer. In the Group Footer I have a subreport. I was wondering if there was any to reduce or eliminate the Group footer height if the subreport contains no data for that particular record. Thanks.
  15. Jorgandr

    Excel: Update Cell with VBA or Macro Help

    You'll want to add the following code after the loop to set F# to null if you delete all values in that row If c = 0 Then Cells(r, &quot;F&quot;).Value = Null End If
  16. Jorgandr

    Excel: Update Cell with VBA or Macro Help

    You need to put this in your worksheet code Private Sub Worksheet_Change(ByVal Target As Excel.Range) Dim c As Integer Dim r As Integer 'column number to start looking for not empty values (1 less than column F) c = 5 'Gets the row number of the cell you have entered/changed and stores it in...
  17. Jorgandr

    MS ACCESS HELP! I'm not sure how to write expression.

    Input masks are good except for the fact they do not give a very good explanation to the user if you do not enter in the required number of characters. With the Validation rule, you can insert your own message easily.
  18. Jorgandr

    MS ACCESS HELP! I'm not sure how to write expression.

    You want to do 3 things to force this and make it as easy to understand to the user as possible 1.) set the Field Size property to 5 - This will limit the field size to 5 characters but it will NOT check whether the user is inputting 5 characters however it will ultimately reduce the size of...
  19. Jorgandr

    Excel 2000 - Pause? Timer? ??? Macro

    you need to use the Application.wait command ex: code creates wordart Newhour = Hour(now()) NewMinute = Minute(now()) NewSecond = Second(now()) + 10 'specifies how long application is to wait waittime = TimeSerial(newHour, newMinute, newSecond) Application.wait waittime code deletes wordart
  20. Jorgandr

    Access 2000 - Change data type in Table

    Change it to a number type but make sure you change the Field Size option so it reads Double not Long Integer and it should keep your decimals

Part and Inventory Search

Back
Top