I have a recordset based on SQL connecting to AS400. How can I COPY that recordset to a real Access table without having to read/write each field/record? Anything similar to COPYRECORDSET in...
I use Windows Task Scheduler to call an Access Visual Basic script file that runs an Access macro each night. When I come in each morning, the database is closed, but Access is still open. W...
My problem is the Query Main_People_Form_Email has a few nested queries under it that do general filtering but also filters based on Forms that are open on their screens. It seems dao no long...
Help please tried this in so many ways with no luck need to open form based on 2 criteria
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmMRepoComplete"
...
I would like to see the items on top sorted by when they were last made 'active'. Also notice how the items in the top half of the form scroll down below the middle brown area. I would prefe...
Hello, thanks for reading.
I'm trying to incorporate an HTML editing form in to my database, I'm using Stephen Lebans' editing form which uses the Microsoft Web Browser control to edit the ...
Hi Experts,
I am new to Experts Exchange and need help creating a query in MS Access 2003 which inserts a new row in an existing table for ID1, ID2, Start Date, End Date and Quarter End Dat...
I am trying to create a Totals Row in an Access Query, but having trouble.
Here is what my table looks like:
QAAuditor Auditor Manager Total ...
I have a select query for the rowsource of one of my combo boxes and I'm not sure what I'm doing wrong, but it seems to be selecting all the records regardless of the "AND IsNull(DateRec)" sta...
Hello,
I am attaching the code. So basically I found this code "http://packetguy.blogspot.com/2005/06/excel-xirr-and-xnpv-functions.html" and modified it a little bit to fit my needs. I put...
I'm using access to create a database and its been a couple of years since i've developed an application. I want to know how to pass a SQL statement to a function that will then open the SQL ...
I need to round the amounts listed in the query TasksLogPeriod, field durationTime 'up' to the nearest positive integer as represented by hundredths of a minute.
The intent is that this wil...
Hello,
I was hoping someone can assist me with my code. I have built a form for our users where they can copy and paste data in certain fields (fields are in datasheet layout). The code check...
I have a number of RDC users that fail to properly logoff their RDC sessions. I'd like to be able to do the logoff programmatically via Access VBA. My research so far has proved fruitless. ...
i want to get a field value of a subform.
I get the "No current record", when I try to access it.
via
Form_subform.Recordset("FIELD")
in the first form code
the record is displayin...
Hi
I've attache two files:
Excel: This file illustrates what I want to do. I have a list of investment returns for each month; I pass these returns into an VBA Array where I can then per...
I'm working on an MS Access application that cycles through email addresses and sends an email w/attachments using the CDO message handler.
It works great for email addresses on the local ser...
I have imported an outlook 2007 contacts list into Access. I want to use the categories field to query on.
Many contacts have more than one category. There is only one category field so al...
I was handed a Access 2003 DB that was about 80% complete. I have been finishing it up the last month and learning the database and how the app functions.
It is a replicated database.
...
Dear all,
I would like to know how to relate 2 tables in access. I am relatively new with access and I have tried everything and searched for related articles but could not get it to work. I ...
Hnasr created this database for tracking tasks. He has spent an obscene amount of time on it and has done a great job! His form is SLICK and is the real fruit of this project.
What I wo...
Hello,
I'm trying to get a word document to auto-save to a specified directory on close. I have generated the following code:
Private Sub Document_Close()
ActiveDocument.SaveAs "C:\O:\U...
What is the differences, advantages, and disadvantages between Me.Undo and RunCommand acCmdUndo? I'm using both in my code.
How do I setup a combo box that is populated with MAC addresses to ignore the pre-amble that finds the closest match after each character typed or scanned?
Sample:
As the user types 232 it...
Hello. I would like to have the following process execute everyday after midnight with no intervention from me:
1. Run an existing MS Access 2000 query. (This database resides on one of our...
