- Modules / DAO / VBA

Thread preview

Thread	Last Post	Replies

Dlookup	22 Sep 2007 00:31 GMT	1
Is it possible to use Dlookup in a field on a report, that uses a field in the report query for criteria? i.e. not alter the report query to do the Dlookup.
Adding a record to a subform	22 Sep 2007 00:00 GMT	1
Hi all,. I have a small issue I would like to resolve with VBA. I have a form which it's fields are bound to a table. Within that form is a subform which is a subtable.
Export SQL stored procedure to Excel file	21 Sep 2007 23:44 GMT	1
I am having problems exporting a stored procedure's results to an Excel file... I've done this many times successfully, but never had to introduce a variable. Now that I've introduced the variable, I'm having problems. It is presenting the error listed below on the last line ...
Unbound Control - Intermittant failure	21 Sep 2007 21:30 GMT	7
I have 2 unbound controls on my form- which constitute a date range. I am running about a dozen reports with the underlying queries using the two dates. Everything works fine until I close the database and then open it again. When I put in my date range in my unbound controls, ...
Connection to Linked ODBC Tables	21 Sep 2007 20:02 GMT	2
I have a Access database with Linked ODBC Tables. Every first time I open the form that uses these tables the ODBC connection Dialog pops up asking for a password. I can manually enter the password and get thru. I would prefer to hardcode the user name and pasword into the
! Clear Text Boxes	21 Sep 2007 19:32 GMT	1
I have a simple form with text boxes for data entry and I would like to set up a button that upon clicking would clear all of the text boxes. Can someone send me the code for this please? Thanks,
Windows Installer message	21 Sep 2007 19:30 GMT	2
I I posted this issue few weeks ago; unfortunately I didn’t receive any answer. I have the following issue: I have ms office pro 2003 installed on the computer.
Use VBA to Delete Forms/Reports on another Database file	21 Sep 2007 18:37 GMT	1
Can you advise how to us VBA to delete the Form/Report on other Access Database files? I know how to delete in CurrentDB, but I want to delete on other database. Thanks
searching text dao, array?	21 Sep 2007 18:22 GMT	2
Good Day, I need a little help. i have a column in a table, that needs formatting. I need to look at each record, the inspect for certain characters, and if there so delete the
can you send two objects in one email using the sendobject	21 Sep 2007 14:58 GMT	4
I want to send two queries in one email using the sendobject, is this possible?
using file command in main toolbar	21 Sep 2007 12:24 GMT	2
want to use a command button on a form that will allow me to use file in the toolbar to import a file. how do i code in vba? thanks
ADO Recordset	21 Sep 2007 12:13 GMT	6
I'm retrieving records from a back end Oracle database. Normally I set up a DSN and use the Microsoft Oracle ODBC driver and get what I need via a pass through query. For whatever reason, setting up this DSN isn't working, so I'm pursuing another option.
qdf Object Variable Error 91 problem	21 Sep 2007 12:08 GMT	6
Hi there, I am trying to create a query with SQL and keep getting error 91. My code is below. 1 Dim db As DAO.Database 2 Dim qdf As DAO.QueryDef
Suppress "Enter Parameter Value" Msgbox	21 Sep 2007 04:55 GMT	5
Is there any why to suppress the "Enter Parameter Value" msgbox? Thanks, Ron
Textbox data in VBA	21 Sep 2007 03:10 GMT	2
Hi, I am extremely new to VBA and I am a little confused. I want to take user input from a textbox on a form and add it to a constant number, then store that sum in a table. How can i do this in Access 2007? Thanks for the help. I looked for similar questions asked previously ...