Search results

  1. D

    Returning Chart Ranges Inna String

    I know how to set a charts source data using VBA as in: With ActiveSheet.ChartObjects("Chart 1").Chart .SetSourceData Source:=ActiveSheet.Range(Cells(4, 22), Cells(I - 1, 22)), _ PlotBy:=xlColumns End With But how do I return with VBA the range used on the sheet for the source...
  2. D

    Dynamic Sorting...

    Say I have 3 fields in my table: FstName, MidName, LstName. I want to be able to dynamically change the sort order of a query to different sort orders using the same fields via a form. I may want to see the records sorted by LstName, MidName, Fstname; and another time see the list sorted by...
  3. D

    Sorting Complex Alpha-Numeric Strings

    Complex Alphanumeric Sorts One of the keys to understanding how to do this and why it works is to first realize that an Access ascending text sort will sort strings of digits perfectly well provided the digit characters are right justified. For example: tTxt 001 009 010 099 100 sorts exactly...
  4. D

    Dynamic SQL vs. Custom Query Function

    What I’d like to do is offer the user a search function for strings that may be present in a table field. I can think of two methods for doing this: using a dynamic query statement generated from code; or using a custom function call in a saved query. From reading the experts on this board...
  5. D

    Query Function Calls...

    Say I have a query that makes more than one function call to the same function in the Where clause of the SQL statement. The function calls would pass an argument such that the function parses a string (form value) into a public array the first time the query makes a call to the function and...
  6. D

    Conditional Formatting...

    I'm using Acc97 to design a db that'll be converted to A2k where I work. I need to know whether or not I can count on what I think A2k conditional formatting is capable of doing. I have a '97 subform that displays the first 10 records of a ~180 record recordset the user can scroll through from...
  7. D

    Subform Recordset not Updatable

    Hi, good people! The problem I'm having is that the query recordset for a subform is not updatable, and not because of the properties of the subform. This subforms' query consists of a main query with a nested subquery and the nested subquery in turn has it's own subquery. And to boot, the...
  8. D

    Checking controls on a form...

    An easier way to check txtbxs and cmbobxs on a form for null or zero without going 5(?) deep? Function ChkFlds(FormName As Form) As String 'Function ChkFlds checks each textbox and combobox control on the passed form object for 'null or zero values (zero values where applicable) and returns...
  9. D

    .ldb Lock File...

    Cannot open my "at work" db. I'd made a copy of a db I'd written at home (NT- Acc97) and placed it on the local C drive of my boss's networked pc (Win2000, Acc2000 - no problems at all converting) so's he could be satisfied I'm tracking the data. One problem is he was recently replaced with a...
  10. D

    .FindFirst Method syntax problem

    I've developed a form with an unbound txtbx and a subform that behaves exactly like the Access 97 Help Index pop-up form. The unbound txtbx is used as the look-up field for the records displayed in the subfrm where I display 4 records at a time. As in the help index pop-up form, the keystrokes...
  11. D

    Painting Troubles

    The following code is at the end of a On_Change Event procedure for a look-up text box on a form. A sub form (continious forms) contains the records to be searched (not really - I open a snapshot recordset in code that matches the records in the subform). With .rstLstNme ... lngCrntRec =...
  12. D

    Linking to JPGs

    I'd like to link a table and a .jpg file to an image ctl on a form. The user would like a procedure to browse through the .jpg files & select which picture should be displayed with the record in the table. The users tell me they're going to eventually end up with something like 8000 (8...
  13. D

    Formatting Report Data

    Is there a way to format data on a report based on the value of the data? I have an Excel spreadsheet that lists columns of numbers like this: 1 0.122 0.006 2.267 2.252 76.5 2 0.116 0.008 2.267 2.249 76.5 3 0.118 0.008 2.260 2.260 76.5 4 0.124 0.115 2.248...
  14. D

    Multiple criteria for Query from List Box

    I have a form with a list box showing the user rows he/she can select to generate a report. The user selects multiple rows (or one row, or no row) and those choices are used in another query to base a report on. In order to do this, the QBE criteria field has to call a function for as many...
Top Bottom