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

  1. bitbuster

    more than 3 conditional formats

    Hello, The result of using the 'select case' in the 'on current' event is that the entire continuous form gets the formatting of the selected record. This does not replace the effect of conditional formatting. Any other suggestions? Regards, Bit
  2. bitbuster

    List in excel with more than one column

    Hello, Dropdowlists in excel are only linked to 1 column. You can however work around this. Add a column before your code and number each code from 1,2,3 to ... Add a column after the description and concatenate the code and the description in it. Now create a dropdownlist (forms toolbar) with...
  3. bitbuster

    search button to search particular field

    This means you didn't give the correct name of the field in the code. Check in the properties of the field for the correct name. Regards, Bitbusters
  4. bitbuster

    Using path names within the INDIRECT function

    Le, The indirect function returns "#ref" because the remote workbook you are referring to is closed. You could open them all before using the indirect function (e.g. with a button). Another solution you might use here is to create a little table on a new sheet with the team name in...
  5. bitbuster

    search button to search particular field

    In your code change the line with "Screen.PreviousControl.SetFocus" by "nameofthefield.setfocus" and the focus will be set on the correct field before executing the search. Regards, Bitbuster
  6. bitbuster

    Query is not returning data....

    Jef, Just replace the 'like "*"' with the name of the field you try to display and it should work fine. Regards, Bitbuster
  7. bitbuster

    Function for data of the previous record

    Darrylle, What I meant is that my solution requires creating an extra field in the table where you want to apply the function. This way of working is ok when that table is the only one where you apply the function. That's what I meant with a 'fixed table'. The disadvantage is that you have to...
  8. bitbuster

    Datasheet on a subform

    Hello, Datasheet is really it says datasheet. So when you want to start with lay out, use the continuous form instead of the datasheet. Regards, Bitbuster
  9. bitbuster

    Excel 2000 Question

    Hello, This can be solved easily with the Vlookup function, but as Skip mentioned you need a reference table with the values and the descriptions. Supposing range E1 to F10 contains the values to lookup (column e) and the descriptions (column f), the formula in A2 should look like this...
  10. bitbuster

    Function for data of the previous record

    Darrylle, Bookmarks are good when you use a form. I want a function that can be called from the expressionbuilder and can be used in a query. This query will be used for further calculations. I found something else but it requires creating a new field in the table and filling it up via ADO or...
  11. bitbuster

    List all functions in a Module(Here's a challenge! for you)

    Hello, I also have a solution. I may not have all the errorhandles covered but it is a lot shorter and simpler to handle for a beginning programmer: Dim mo As Module Dim stline As Long Dim stcol As Long Dim eline As Long Dim ecol As Long Dim line As String Dim strpart() As String Dim...
  12. bitbuster

    Running SELECT statement in VBA

    Hello, To run SQL from code use DoCmd.RunSQL "SQLSTRING". Regards, Bitbuster
  13. bitbuster

    Identifying duplicate records on same table

    Hello, You can create a query that checks if some of the fields of your table contain duplicates. E.g. create a query checking on duplicates for the address and date of birth (exclude student number and name). Except for twins this will give you the list of duplicates. Regards, Bitbuster
  14. bitbuster

    Regaining Control of a Secured Database In Access

    Hello, To open a secured database exclusively: 1. open the database via the shortcut containing the reference to the mdw file and user info. 2. Login to the database with your admin userid and password. 3. Close the database without closing access. At this moment your user credentials are...
  15. bitbuster

    Snding Meeting confimation from Access2k2 to Outlook

    Hello, You might want to try the 'outlook' object. First add the 'microsoft outlook object library' to your references and then you can start using code as in the example below. Dim objOutlook As Outlook.Application Dim objOutlooknote As Outlook.NoteItem Set objOutlook =...
  16. bitbuster

    Function for data of the previous record

    Hello, I want to create a function in VBA to display the value of the previous record of a field (except when it is the first record, offcourse). How can I do this so the function can be used in a query (via expression builder) and doesn't take too long to calculate (so don't let the function...

Part and Inventory Search

Back
Top