Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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