Ive created several queries which work well. I can import using a macro (or manually) into a table (transfertext). Once data has been imported I run several queries (working again with Ma...
I'm working with Access to connect to an SQL database.
I have a connection string like this:
Dim SDK As ADODB.Connection
Set SDK = New ADODB.Connection
Call SDK.Open("Primaver...
I am working on a large Access Database using a lot of Visual Basic. Somehow, (over the last year) something changed and the function "MsgBox ()" is now displayed as LOWERCASE throughout my e...
How to combine 2 similar access tables into one new table
I have a code which loops thru the current continues form all records and if the check box which is found on the form is false, it updates a tblProject with some data. In some instances the lo...
I have to insert a table in the body of an Outlook 2003 email with vba. The table will use an MS Access query for data. Can anyone please help with the relevent code.
Thanks in advance...
database and screenshot also attached for the sake of clarity
My current understanding is that the code pasted below is what sorts the form. What has been most recently activated is sorted...
Hi Experts,
The code snippet below is used to populate a Word table from within Access. It works fine, except that the table exists in the Word Template and sometimes the recordset will not...
Hi,
Please open frmPatients. In the Lab Work user can enter lab date and LabInfo. but when
the user double click on the the LabDate to enter Lab detail. I get an error that says:
Yo...
I have figure out how to use DLookup to seach for one criteria but not two together.
FieldOne FieldTwo
12ABC12345 A01 Every FieldOne has multiple FieldTw...
Hello,
I have a button [cmd_newPHI] on a form. When a user pushes this button I would like the message "Do you want to add a new patient?" With the message box options being yes or no. If t...
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 got a copy of database which have calendar like forms to enter data. I attached a copy of the database here. There is something wrong with the Date, The Date in the frmInputBox does not corr...
I want to write some code like this:
sSQL = "SELECT Format([OrderValue],'0,000.00') As Expr1 FROM..."
then open a recordset to write this value into a Word document.
The problem here is the...
this code works well for me to count the records and open up a Msg Box
is there a way I can re set the code to re cound again after the 10 records has been counted, maybe on a button or af...
How do you calculate a field based on the results of an "autoincrement" field
I want to auto calculate a field using the character "X" plus the value of ID (autoincrement)
Hello Experts,
I found this code on the site. Itworks great, but I need to open the database in another location: "R:\Nutrition\RICA Nutrition Center.mdb"
Thank you for your help.
James
The attached code sends an email when the button is clicked. The body of the email is all strung together. Is there a way to put in extra lines in the body so it's more legible?
Is there anyway to import a SpecificationName from another database or create it from scratch using VBA and inside of an Access.Application object?
I know how to go into Advanced settings a...
I am getting a complie Error Object required.
This code is for Access and it is suppose to log into and navigate to a portion of the site where I can download information to be used in othe...
i need a variable to be available to all forms in an access database
i created a module and inserted a public sub that sets the string variable to some text but when i call the sub from a f...
Hi,
I'm trying to open a Word Doc from a list box. It begins to open the file and then stops with a Runtime 5174 Error, which says "This file could not be found (c:\//program%20files/conta...
I am using the Outlook mail object to send EMail programatically from an Access app.
Outlook must be open for .Send to work.
How do I find out if Outlook is open. I need to open a messag...
Can anyone help me to write three functions in vba access in order to extract the name like the examples below into last name, first name and MI?
the format of the name is "First Name", "MI...
I would like to create a list of Tables in an Access database along with all of the indexes for each table. Is there a way to do this?
