Search results for query: *

How do I prevent this from happening: Run-time error '-2147467259(80004005)': The database has been placed in a state by user 'Admin' on machine 'LIBERTY-0D10453' that prevents it from being opened or locked. Here's the code that generates this error...

i have built some user documentation for one of my applications using msword and have, up to this point, accessed it through a label with code to open the document in word. problem with this is that the document, being something external, cannot be found if either it or the database is moved and...

i am attempting to fill an array of values used in my code with data pulled from a query or a sql string. i have successfully incorporated sql strings and even an argument-fed sql-string generator into my code, and have used an ado recordset and the 'getrows' function to fill an array with...

is there any (hopefully simple) way to create a drop-down list of values that can be selected to pass as an argument to a function? vba itself has several built-in objects and functions offering this sort of selection and auto-completion functionality, i and i'm wondering if i could implement it...

I have a form in which I change the properties of Accounts within a database I am working on. Some of these properties are dependant upon not only which Account is selected, but also which Entity it is selected under. Because of this I have set up two listbox controls (one to select and account...

I have a small popup dialog for removing items from a list that is opened by clicking on a "Remove Items" button on the main form. The popup then displays a list of items that can be removed, from which the user can select one and click on a button to remove it. This popup works...

I've developed a fairly sleek one-form interface for a reports generation database (by creating a subform with a source that is changed as the user clicks on a set of navigation buttons on the left), and would like to know if there is any way to embed or preview an access report within an access...

I am currently building a form to be used to allow users to add records to and remove records from a table (to be used as a more maintainable manner of defining relatively static query criteria than asking the users to directly edit a set of SQL statements). I would like to achive this by...

I am currently building a form to be used to allow users to add records to and remove records from a table (to be used as a more maintainable manner of defining relatively static query criteria than asking the users to directly edit a set of SQL statements). I would like to achive this by...

I have written the following code to automate an import process (from a user-selected .txt file). When I first tested the form (and the module that went with it), the process worked as it was supposed to and all data was imported successfully. At the time, however, I had to manually check the...

Is it possible to create a query or SQL statement using a full outer join in Access 97? I need to retrieve all records from both of the tables being joined - and not just those records which match along the joined field in both tables, or all records from one table and only matching records...

I am attempting to build an Access database UI which includes an input form used to enter one set of information for each customer in the database, and "units sold" information for ten services for each customer. I also need to retrieve this information by service and/or customer in...