Search results for query: *

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

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

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

I use a new ADODB.Recordset 'Find' method to move to a specific 'Part Number' in form. Occasionally, I will get a 2001 error 'You canceled the previous operation.'. I've bypassed the Before_Update and On_Current code to exclude that from causing the problem. It's an Access 2003 .ADP database...

I've a set of stored procedures that operate without error from the application and query analyzer. When the job is scheduled it fails without any real description of the problem in the Windows event log. What would be a good method to troubleshoot these failures? These procedures perform...

I'm creating a form that uses a Table (ProjData) in DataSet11 that is relationally bound to a Table (ReportData) in a datagrid through a relationship (ProjectReports). According to an example I am using, simply binding the grid to the relationship (ProjData.ProjectReports) will cause the grid...

Yesterday my Access project (adp) was working well using a listbox with the RowSource of 'EXEC spFillLb1 @TOP=50'. This successfully allowed me to set whatever stored procedures I needed and still pass in parameters. I've moved the SQL Server database to a SQL Server (SP3) from my MSDE (SP1)...

I've run into a problem with assigning the MultiSelect property of a Listbox in VB code. The error 2448 states 'You can't assign a value to this object' on the code below. According to the Access help files for MultiSelect, this is exactly the format for assigning a value to MultiSelect...

I'm Attempting to learn VB.NET and have been receiving the error described every time I try to build a Windows application. It errors out in the vb.net generated code for initializing the components. The application failing was a very small application (FileSystemWatcher) documented in the...

Macro security for Access 2003 has different levels of security which can be selected by the user. Anything above 'Low' will prompt the user with security warnings which are unsettling to a casual users. I distribute an Access 2000 database with macros that cause a few warnings to appear...

I've built a .dll from .NET using the System.IO.FileInfo namespace that builds a solution but, when called from VBA, generates and exception. It's a very simple class but has me blocked. If anyone could provide me an answer I would appreciate it. Request for the permission of type...

I'm attempting to open a .mdb file using a username/password, connect over a link with a connect string using a username/password and retrieving data from the SQL server with a Login/password. If I logon using a privileged username/password, have the connection set to the same...

I have an app that is migrating from Access .mdb to a linked connection with SQL Server. The security workgroup still requires a logon but the linked tables use a DSN connection with their own UID and PWD (ODBC). How does the Access front end with security work with the SQL Server links. When...

I'm trying to run a report from a form in and ADP project that connects to SQL Server. The report RowSource is a stored procedure since I can't get the .filter on the report to work from VBA. When I run the report manually it prompts for each of the parameters for the stored procedure but I'm...

I am transitioning from using Jet to SQL Server and a .adp file and T-SQL Stored Procedures. I would like to open a report from the form and refine the scope of the report. One way is to set the RecordSource for the report to select all items and in the Report_Open event set the filter from...