|
MapPoint/Access API
Does anyone have any links to some documentation of the API(s) required to
use VBA to communicate with Map Point? I am working on an Access app and have
done the basic function of exporting route-related data to a CSV file for
import to MapPoint; however, I cannot seem to locate even a list of the
methods available or references required when programming Access/VBA to
communicate directl...
|
3 |
10/22/2008 5:42:01 AM |
|
|
Finding a table in a table collection...
Hello,
I would like to know how I can do the following task. I would like to use
code to find a table with a specific name in my list of tables in my current
database. If the table is found, then refresh link to another table. If the
table is not found, then create the table in my current database.
Thanks for your help....
|
4 |
10/22/2008 4:34:26 AM |
|
|
Linking Access DB with Excel Spreadsheet
Hello, I come from a strong background in Excel VBA Programming... but am
not quite sure how to accomplish this in Access.
I have an Access DB with 13 fields. Field 1 is an ID field. I want to
search Column 1 in an Excel Spreadsheet (which is also an ID column) and if I
find a matching ID, I want to update the corresponding fields in Access, with
the row in Excel. I hope that made...
|
3 |
10/22/2008 3:06:02 AM |
|
|
VBA code to import table via query
Hello -
I need VBA code for MS Access to import a table using an ODBC datasource
(DNS). I need to import the table with a basic query of Select * from
TableName Where DateOfService = Today - 1. I need it to arrive in the MS
Access database as a table.
If this is possible, can anyone send me the code or point me in the right
direction of where to get the information?
--
Sheldon...
|
2 |
10/22/2008 2:46:22 AM |
|
|
How to Turn a Record Of Data Into Something Else
I completed a query that seemed to work except for the fact that it
became too complex and Access simply refused to run it. I tried
splitting it into parts but it was still too complex.
Here is the problem. I have a record of data for On Hand (goods in a
warehouse) and Projections (predicted needs) per month. So for one
record (an SKU, five or six keys) I may have these for units (OH = On...
|
6 |
10/22/2008 12:32:36 AM |
|
|
Send Instantiated Report
Hello Everybody, Please any help on This:
I have a base report which I reuse for different type of information, I just
instanciate it and reformat some fields as required. And when i try to send
it by mail, on snp format, Access attaches the base (original) report. It's a
problem cause the base report has for example 8 pages, and the instantiated
report that i get on screen has 2 o 3, pag...
|
4 |
10/22/2008 12:28:12 AM |
|
|
Combo box value
I have a combo box that looks at an orders table. I am finding that I have
set up the table wrong or I am doing something else wrong. For example is I
am to call order PO1234 there could possibly be 50 lines on this specific
order and in the past you can see the Order Number and the specific line in
the drop down and can select it and that information would fill in other
order details....
|
2 |
10/21/2008 11:01:16 PM |
|
|
Field contents as variable
I have a field that contains the name of another field that has the Visible
property set to NO. I want to set the Visible property of the contents to
YES. Below is a basic sample of what I need.
Field1 = "Field2"
I need to have the equivalent of Field2.visible = true.
Thank you in advance for your help....
|
13 |
10/21/2008 8:25:31 PM |
|
|
Snapshot Report
I am using the below code:
Public Function saveRptsToSNP()
On Error GoTo ErrHandler
Dim rpt As Report
Dim sPath As String
Dim idx As Long
sPath = CurrentProject.Path & "\"
For idx = 0 To (Reports.Count - 1)
Set rpt = Reports(idx)
DoCmd.OutputTo acOutputReport, rpt.Name, acFormatSNP, _
sPath & rpt.Name & ".SNP", False
Next idx
...
|
4 |
10/21/2008 7:22:29 PM |
|
|
Automatically Updating Cost via Item reciept
Make an option to have cost prices automatically updated when Item Reciepts
are made.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsrea...
|
1 |
10/21/2008 6:45:03 PM |
|
|
Calculate Inventory Reorder Quantity Automatically via Usage
Make it an option to reset Inventory Reorder Point by calculating weekly,
monthly usage.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based News...
|
1 |
10/21/2008 6:39:23 PM |
|
|
Adding information in a table automaticly with just a few entries.
I am trying to enter 5 peices of Information and with this information Access
then Adds to a table that has 16 fields in it. I am not sure how to proced. ...
|
3 |
10/21/2008 6:22:43 PM |
|
|
Ways to keep database size small
Instead of constantly having to compact database, what is one way to use
tables, or temp tables differently in such a case that the access database
will not grow up so far. Right now, I have "delete * from table", then later
.... "insert into table from ...". Any suggestions ?
Tanks,
--
James...
|
5 |
10/21/2008 5:33:39 PM |
|
|
Check for file currently open
My database uses Jpg files for photos of employees. Since they are jpg files
I have to open each one when the report is printed. Memory issues require me
to print this report in three parts and then combine the pdf files created. I
need to check to see if the last pdf file being printed is complete, but I
have no idea how. I tried watching to see when the file was created by
checking to ...
|
2 |
10/21/2008 2:16:01 PM |
|
|
vb problem
hi all
this is my question
in Visual Basic 6 i have created a project that takes data from a MS access
Data base.
my data base has a table that contains a table with tree fields.
id,name,comments
now in the VB i have a form with a text field that takes the data from the
field "comments" from access and display them in the text box.
the problem is that if the field's content in comments...
|
2 |
10/20/2008 10:32:01 PM |
|
|
Adding an automation object
I know how to programmatically add an automation object using "References.
Addfromfile "object". However, I don't know what commands you would use to
FIRST test to see if the object is already there before adding. If I add an
automation object that already exists, it gives me an error. So I want to
test to see if it already exists. Something like:
IF Automation object doesn't exis...
|
1 |
10/20/2008 6:16:11 PM |
|
|
Copy recordset to a new row
In access 2003, I need to copy a recordset (which is based from a query built
from many tables) and all of these values are populate in a form, so I want
to build a VBA button so I can decide if I want to copy all these values into
the original tables generating a new row or record for each table that are
involve in the query. I did this task using copy and paste using the query.
Than in...
|
1 |
10/20/2008 6:01:01 PM |
|
|
deleting a relationship
How do I delete a relationship to modify the primary key information. Every
time I try to change it, it says I have to delete the relationship first.
Thanks,
Fred...
|
2 |
10/20/2008 5:54:24 PM |
|
|
Changing ODBC Connection between development and production
I know I've seen an explanation of this somewhere but I can't, for the life
of me, find it again now that I need it!
I have an Access front-end app attached to tables on a SQL server and I have
set up a number of functions to execute pass-through queries and stuff. What
I need is a way to change all the connection strings when I switch from
Developement to Production environments.
...
|
1 |
10/20/2008 5:16:01 PM |
|
|
Close button
Is it possiable to trun the form CloseButton off at the open form time and
turn it on in the middle of program after a Command Button is pushed. I tried
the following code and I get an error massage.
Me.CloseButton = True
--
arn...
|
2 |
10/21/2008 1:16:55 AM |
|
|
SQL statement in an external database...
Hello,
I would like to know how I can create and execute a Make Table SQL statement
in an external database from my current database via VBA codes.
Any help will be greatly appreciated. Thanks!
jpang...
|
2 |
10/21/2008 2:31:52 AM |
|
|
Increase MaxLocksPerFile registry
I get a:
Run-time error '3052' File sharing lock count exceeded. Increase
MaxLocksPerFile registry entry
when I rung this code:
Private Sub btnFixDNC_Click()
'Determine & assign the proper number AREA_CODE
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim strPrefix As String
Dim strNumber As String
Dim strData As String
Set db = CurrentDb
Set rs = db.OpenReco...
|
8 |
10/21/2008 12:54:56 PM |
|
|
After update issue
I have redirected this post from Coding to here...
I have a subform titled NewPartsSubForm. Within this form, I have a combo box
labled as Rtg_oper_num. I am able to choose from a listing of routings within
the box (I choose 100, 120, 140, 32156 etc from a listing). I want to
populate a Description filed within this same subform based upon the entry I
choose in the Rtg_oper_num field. I...
|
2 |
10/21/2008 8:08:48 PM |
|
|
frustrated with program
Thanks for reading my post.
Before I start, sometimes when I post on this forum and I get a reply I can
not open it up to view the reply. So I'm sorry in advance if I don't reply
back. I really need to see the answers so it will give me direction and
guidence.
Now to the problem.
I have a password form with 3 unbound text boxes. The usual User Id,
Password, and if the level is not h...
|
13 |
10/21/2008 10:34:38 PM |
|
|
How To Name Columns With Code
I have a query that has six key fields (Style, Color_Code, Lbl_Code,
Dimension, Size, and Year) and 12 months (Feb, Mar, Apr, May, Jun,
Jul, Aug, Sep, Oct, Nov, Dec, Jan). January is the last month of the
year, so January in the 2008 record is really Jan 2009. The query is
for users to enter Sales Projections.
Anyway, how do I get a query to return the months all on the same
record (not ...
|
7 |
10/20/2008 3:40:59 PM |