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. scking

    Finding a Record Existing in a Form

    I've discovered the solution. Using the BindingSource.Find("PN", "167-84C") returned the index if it is found. Then simply using the CurrencyManager to reposition to the found index works marvelously. But it's not terribly well documented. From any open form example: frm.FindItem("PN"...
  2. scking

    Finding a Record Existing in a Form

    I'm attemping a simple task which is causing me problems. I want to be able to move to a record which meets certain criteria (not filter). The criteria would be something like "PN=XYZ". The BindingSource.Find seems to find an index number but the BindingSource.Position = foundIndex isn't...
  3. scking

    Synchronizing a Combobox to the Record

    I had this in the back of my mind but was expecting (read hoping) for a simpler method, maybe using databindings. I'm going to implement this and appreciate your comment. --------------------- scking@arinc.com ---------------------
  4. scking

    Synchronizing a Combobox to the Record

    I've used .NET comboboxes which are bound using the DisplayMember, ValueMember, and SelectValue set. These display all values from a validation table. I would like to be able to select values synchronized to the record. So, for a specific Project code it would select ONLY those verions that...
  5. scking

    Using Combobox

    I'm having a problem selecting a value from a validation table and saving it to the data table. I set the DataSource to the validation table and the DisplayMember to the field I want displayed in the combobox, and the ValueMember to the field I want stored in the table. Now I set the Data...
  6. scking

    Recordset Error

    I've been working with ADODB for years but found one today that has me perplexed. I connect to a SQL Server database from an Access ADP file. The stored procedure works from Query Analyzer, returning >2800 rows. When I execute the command object and open the recordset I get no errors during...
  7. scking

    Textbox Cursor

    Thanks TheAceMan1 and pampers. I've been using Access since it was first release and there are still situations coming up new where I can learn from others experience. Thanks. --------------------- scking@arinc.com ---------------------
  8. scking

    Textbox Cursor

    Actually, if you set the locked property you can't select from a combobox. But, if you use the screwdriver cursor you can't enter anything in the box or edit it. They need to be able to select a combobox item but not change it. Neither locked nor enabled properties fill the bill...
  9. scking

    New records disappearing, modified records okay

    If you requery the main form as you are implying the form will move to the first record each time. If you do a Me.Requery at any time you will have this problem. I'm not sure that you do but it's worth a try. --------------------- scking@arinc.com ---------------------
  10. scking

    forms not behaving.

    Your explanation is not clear. Please clarify or you will not get many responses. --------------------- scking@arinc.com ---------------------
  11. scking

    Subform Refresh

    One way that verifies the main form is open first. If FormIsOpen("frmPprEditDev") Then Dim f As New Form Set f = Forms("frmPprEditDev") f.sfrmPprUsage.Requery End If OR Forms("frmPprEditDev").sfrmPprCompLinks.Requery...
  12. scking

    Combo Box Selection

    Your post was somewhat confusing. Do you want to filter the records based on the rev# or goto a record with that rev#? Is rev# unique as in a key? To goto a record based on the rev# you can use the recordsetclone and the find method to goto it. If you want to display all the records which...
  13. scking

    Textbox Cursor

    We have controls that can not be updated by the user and would like to change the cursor from an IBeam to another type so they are unable to enter data. It seems that there is no standard property for a textbox to allow the user to define the cursor in design mode. I'm looking for a procedure...
  14. scking

    Unrecognized Format error on 2003 MDE only

    I searched the knowledgebase and the article I found said this issue, or an issue producing the same error message, was fixed in Office 2003 Service Pack 2. The article claims this problem may occur if the original database file was created in Access 2000 and then converted to Database (Access...
  15. scking

    UserIsMemberOfGroup

    Jerry, I pasted the SQL into Access 2003 and changed variable TheUser to 'Admin'. The error said Access couldn't find the table. Then I set options to show all system objects and MSysAccounts was not visible. Is this solution based on a specific version of Access? Even if I'm doing this on...
  16. scking

    Unrecognized Format error on 2003 MDE only

    In the Options\Advanced tab what is the Default File Format? Just wondering if a default on the front end of "Access 2000" would fail if the links connected to an Access 2003 formatted .mde file. --------------------- scking@arinc.com ---------------------
  17. scking

    UserIsMemberOfGroup

    According to http://support.microsoft.com/dllhelp/default.aspx?l=55&fid=197954 the dao360.dll file is distributed with Microsoft XP Service Pack 2 which seems as current as possible. However, as a developer who gets calls from users, there have been a number of instances where their systems...
  18. scking

    UserIsMemberOfGroup

    For years I've successfully used the subject function to return a boolean yes/no depending on whether CurrentUser was a member of a specific group. Well DAO did some things I'm having trouble replacing and the function is heavily into using the DAO libraries. I know ADOX has User and Group...
  19. scking

    Binding Combobox

    I'm attempting to bind a combobox to store the values in tblProblems.VersionID and display the Version value from the tblVersions. The VersionID field is a foreign key to the ID in tblVersions. Currently I have the combobox displaying the versions in the dropdown which is what I need but when...
  20. scking

    Project on the Web

    We have a requirement to develop the capbility to display Project schedules on the web. Our current application has user-defined views, tables, barstyles, filters, and VBA code to manipulated status columns built into the tables. I assume that there are server-based controls that would allow...

Part and Inventory Search

Back
Top