Search results for query: *

I have created a small database in Access 2013 with several web forms that are shared through a SharePoint site. I have a continuous form with a dropdown box in the header which acts as a filter to allow the user to filter the records. The AfterUpdate macro uses the following code: SetFilter...

I currently have a small MS Access application that allows the users to import data from text files, run reports or other functions on the data, and then export the data back to a text file for archiving purposes. However I am running into problems when the user tries to export a large table...

I have a routine set up that allows the user to browse for a local text file and then click a button to import the selected file into Access. This works great for delimited text files but I need to also allow the users to import fixed width flat files. I cannot setup a Specification file since...

I am currently using a form in Access (Office '03) to allow the user to import data from various Excel files. This is done using the TransferSpreadsheet method. However, after the data has been migrated an instance of Excel remains open. This becomes problematic when the user tries to use...

I am using an ActiveX DTPicker control to allow the user to add new dates to the database. However, when the screen opens I want the date fields to be blank so that the user is forced to select a date. The problem is I have not been able to find a way for the DtPicker to display a null value...

I am using VBA code in Access 2000 to import a user-defined spreadsheet into the database. This is working great except the Excel instance does not close. When the user then tries to move or delete that Excel file they receive a message that the file is still in use. Currently the only way...

When it came time to deploy our Access 2K application we decided to use a .mde format because it was my understanding that they cannot grow in size the way that a .mdb often does. However, we have recently discovered that the .mde files on the users' PCs is growing in size as it is used. In...

I created an Access application in 2000 that runs a complex report which must be formatted at run-time. This has been working great in Access '00 but I recently converted a copy to Access '02 for several users who use Office XP and the app. stopped working. When the report is run it opens but...

I am trying to build a menu in .net using a treeview control populated by an XML file. This XML is divided into several sections since the same xml is used throughout the application. It is indexed by Area, Application, and Page. I need a way to filter the treeview to only display nodes that...

I am trying to build a menu using a treeview control populated by an XML file. This XML is divided into several sections since the same xml is used throughout the application. It is indexed by Area, Application, and Page. I need a way to filter the treeview to only display nodes that are...

I have a module which creates an ADODB recordset from a small SQL statement. I then need to find a specific record within the recordset. I started using the find operator of the recordset to do this and it worked. rsGetReading1.Find ("sys_Requirement_ID = " & intReqID & "")...

I am in the process of converting a large Access 2000 based application to Access 2002 and .adp file format. I've noticed that in .adp local queries have been replaced by views and stored procedures. I'll admit views are better for returning data from the SQL server but many of my forms rely...

One of the databases I support uses linked tables so, to keep links up to date code was added to automatically relinks the tables to the SQL Server back-end through an ODBC connection. This code was developed and working great in Access 2000 but since we have converted to 2002 I just get an...

I have two areas of my application that open and access a second .mdb file which is shared across the LAN. This was working great in Access 2000 but fails in Access 02(XP). Through Microsoft's webpage I found that this error (err. no.-2147467259, MS doc no. 286126) is documented but their...

I currently have the functionality in my application of allowing the user to select an individual's information and click a Form Letters button. They can then pick from a list of form letters shared on the network. Once they've made a choice they can click the merge button which opens a shared...

I have a form that creates controls at run-time based on criteria from the user. The controls being created are command buttons and I would like to add a small piece of code into each button's OnClick event as they are created. Access will let me do this with a macro but I would much rather...

I'm working on creating a sort of virtual seating chart for use with large numbers of people in various amounts. I would like to set up the code so that at run-time a small command button is created for every seat in the room. I found code to do this using the CreateForm method but I need this...

I am working on an Access application that is completely transactional meaning that it uses ADO recordsets instead of linked tables to access and modify data. This approach is working out well but I cannot figure out how to create an unbound report that connects itself to a recordset in the...

I have a combo box whose rowsource needs to change based on a selection from the previous form. Since my application isn't using linked tables I need to do this with an ADO recordset. Does anyone know of a way to assign a combo box's rowsource property to a recordset? I appreciate the help.

I am making a small Access application for a project. Due to the security level involved I cannot use linked tables so I need to make the application completely transactional. However, the Database I'm trying to query is on a Sybase server. I have tried to write query statements but have not...