|
Connection string for database on another web server via IP
I am using .ASP and I want to connect to the MS database which will reside on
our internal server.
I have an IP address to point to that directory.
My .ASP page will reside on our ISP's server that is hosting our site. Our
internal server can support access and our ISP can support ASP.
What connection string do i use to make the database connection, using my IP
address?
Thank you f...
|
4 |
23.09.2006 02:23:53 |
|
|
Send data from Access to Excel
windows 2000 excel / access 2002
Trying to send several groups of data to excel. Want to be able to create
and name the worksheets from the program and put the data on the worksheet.
I have been able to send one field but not all the fields.. I think I do not
know how to work the objXLRange.FormulaArray = Array(varResults).
Does anyone know where I can read more about transfer data ...
|
2 |
23.09.2006 01:27:25 |
|
|
DoCmd.TransferSpreadsheet
I'm trying to transfer data from Access to Excel using
DoCmd.TransferSpreadsheet, I want to use a select query but it send an error
message, I can use already defined queries or table names, but for some
reason it won't let me use a sql select statement, eventhough it says I can
do so in the help file.
THIS DOESN'T WORK:
sSQL = "select * from qry_ANYQUERY"
DoCmd.TransferSpreadsheet ac...
|
2 |
23.09.2006 00:58:37 |
|
|
Access 2002/2003 Error during VBA compile
I get an error when I reference functions such as Left(), Mid(), Date(). The
error handler loads the reference page and it indicates "MISSING: FILEMGMT ...
Any ideas on why the system is not accepting these common functions?
Bill...
|
2 |
22.09.2006 21:21:02 |
|
|
[Table].[Field] Substitute Variable
I'm trying to substitute a variable for a field name. For example, I have a
table with columns labeled 1,2,3,4,5....12. I have a combo box on a form
named Dashboard with the months of the year and the stored value is 1-12. I'm
trying to get a query to read [Table].Form!Dashboard!MonthID rather than
hardcode [Table].[1], for example. Any thougths? Thanks!...
|
2 |
22.09.2006 21:19:01 |
|
|
How do I trap dsofile method errors with VB or VBA?
I am using dsofile to collect MSword and MSExcel summary properties and save
them in an ACCESS .mdb. Generally it works fine but on older excel and word
files, I get an summaryobject method error, which I have been unable to trap
with on error goto errorhandler. I can go to debug but have to manually set
the next command to the first command line in the error handler since the
goto doe...
|
1 |
22.09.2006 19:13:02 |
|
|
Code to retrieve domain?
I need a snippet of code that will retrieve the current domain that the user
is logged in as.
I have some code that grabs the user name, but I don't think it grabs the
domain.
Thanks!
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200609/1
...
|
5 |
22.09.2006 18:26:19 |
|
|
AutoSave in Access
Not sure if the is the correct term?? What I want to do is to transfer
information from onyx to an existing access data base?...
|
9 |
22.09.2006 18:26:01 |
|
|
Syntax error
I have a text box in a report that keeps giving me an error of an ivalid
syntax. The report has the fields below.
=Sum([Expr1]) =Sum([Expr2]) =Sum([Expr3]) =Sum(
[decProductionHours])
I want to add all the Sum Expr together (=Sum([Expr1]), =Sum([Expr2]), =Sum(
[Expr3]) and then divide by =Sum([decProductionHours])
I am trying to get the average in a new field.
Exam...
|
2 |
22.09.2006 18:05:19 |
|
|
Finding properties of a macro in code
I've been building a little utility MDB that will search & find all
instances of a search word within an MDB file. This is so that I can find
all references/uses of a table name, field name, query etc.
All's well so far, but I've got stuck with searching in the Macros. I've
tried the Containers ("Scripts") collection and Document collection/objects,
and can see some properties relating...
|
3 |
22.09.2006 16:41:02 |
|
|
list of table names and fields
i got this code off of this site to give me a list of the table names and
fields in my database. When i run the code in the immediate window it starts
maybe in the middle of my tables and lists them, it doesnt give me all my
tables. Any idea why? and is there a way to make a table of this data?
Public Sub GetFieldNames()
Dim dbs As Database, tdf As TableDef, fld As Field
Set dbs = C...
|
6 |
22.09.2006 16:36:02 |
|
|
open a query from different databases
I want to know, if I can use some VBA code to open a query from a different
database. Say, for instances, I am in my main database, and I have a button
on a form. I want the button to open up the query that I created in my other
database. Is that possible? If so, can you help me with the code?...
|
8 |
22.09.2006 15:02:02 |
|
|
hide a control on a form
I have a form frmJobs with a subform fsubNotes. It can't be resized, moved or
closed. No edits, additions, or deletions. I control these with buttons for
edit, add, cancel, new, and save on both forms. The main form frmJobs has an
exit button which closes both forms.
What is the vba programming for making the exit button visible = false when
the subform state is allowedits = true or all...
|
2 |
22.09.2006 14:09:22 |
|
|
Test An EMail Ending Using Access 2000
Hi all,
I with a lot of help from others managed to create an database for checking
data accuracy. One of the checks is to check Email adddress endings to make
sure they have a valid domain e.g. .co.uk .com etc. These are stored in a
table. Just today I found out you could ping sites to see if they are valid.
i.e. Ping google.co.uk.
So, what I would like to do is have a function ...
|
3 |
22.09.2006 14:02:01 |
|
|
password protect the use of a command button
I have a report that is opened by the click of a command button on a
switchboard. Is there a way I can password protect the use of this button?
--
DMainland...
|
7 |
22.09.2006 13:39:01 |
|
|
2003 Bug? Email problem
I have an access program that uses this line to send an email.
DoCmd.SendObject acQuery, Report1, "MicrosoftExcel(*.xls)", Address, Copy,
Blind, Subj1 & "-" & txtMonthEnd.Value, Message, True, ""
It works fine on a computer where I'm running office 2000 and windows 2000.
I have a second computer with Office 2003 and Windows 2000.
When I use this program on my Office 2003 m...
|
1 |
22.09.2006 13:26:02 |
|
|
Access programming
I receive a message "MISSING: FILEMGMT 1.0 Type Library" when compiling VBA
code if I have functions such as "LEFT". This happens in Access 2003 and
Access 2002. The file filemgmt.dll is present in the system32 directory. How
can I clear this issue?...
|
2 |
22.09.2006 12:48:45 |
|
|
Pessimistic Locking of a Database.
I need to lock my database so that no 2 users can input data into the same
record. I do not want them to be prompted after the data has been entered
for their data to overwrite any other data that may be in that record of
field. How do I achieve this type of locking?
Frontend is PC based and Backend is on a server....
|
1 |
22.09.2006 08:07:01 |
|
|
Refresh subform
Hi,
I have a main form (Frm_Main) and a subform (Frm_Filenames). I click a
button on the main form and it deletes every record in a table
(Tbl_Filenames). The code then updates the Tbl_Filenames with updated file
information (I can pause the code and see the updated records) but the
subform shows '#DELETED' for each field in each record.
I can close the main form and reopen it howe...
|
3 |
22.09.2006 04:57:01 |
|
|
Pass-thru vs non-pass thru query in DAO
I'm working in Access97 & DAO, unfortunately, as there are upgrade issues
stopping me from using something more up to date. Here's the problem I'm
having:
I'm updating data in a A97.mdb (lets say "archive.mdb") with info from a
..csv file, from code in another A97.mdb (lets say "control.mdb"). Control.mdb
has some static data tables in it. To do the transfer, I'm creating a temp
datab...
|
5 |
22.09.2006 01:41:39 |
|
|
carriage return in textbox
In my VBA app I got a big textbox, and need it so that when a user hits the
return key a carriage return happens, and let the user keep typing. This is
driving me nuts! It happens fast but I can see the carriage return happen
but cursor goes back to the last position of the string.
Here is my code
Private Sub ProjectsNotes_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode =...
|
3 |
21.09.2006 23:38:21 |
|
|
can a front-end be auto closed after a period of inactivity?
I have a back-end/front end database. The back end must be periodically
refreshed against outside Oracle tables. My problem is that I cannot refresh
while another user has the linked tables in use. Usually this means that
they left the app open on their desktop. Can I set the front-end desktop app
so that it will automaticlly close after a period of inactivity?...
|
5 |
21.09.2006 23:14:01 |
|
|
Last line from external file
How can I read the last line from an external txt file and assign this to a
string veriable?
Thanks in advance....
|
2 |
21.09.2006 23:12:23 |
|
|
MsgBox
Can you change the font of the message in the box?
Thanks in advance
...
|
2 |
21.09.2006 23:09:39 |
|
|
Capturing most recent zero date
I have a table that is contains a/r balances and I want to get the most
recent date that the balance was 0. Currently there are 65 days worth of
data. I would also want to get the next date that did not have a 0 balance. ...
|
2 |
21.09.2006 22:28:34 |