|
Automate login to webserver
Hi,
I have an access db form. I want to create a button that can
automatically send the username and password to server...
let's say server is login.yahoo.com.. so i would send username and
password and it would log me in.
any hints.
ty
hj
...
|
1 |
28.09.2006 18:20:28 |
|
|
AutoNumber data type
The following code works with all data types except AutoNumber. I get a
"Syntax error in field definition" error message. Can anyone help me make
AutoNumber work?
DoCmd.RunSQL "CREATE TABLE tblTest(XYZ Datetime);"
--
Thank you,
Del...
|
6 |
28.09.2006 17:59:13 |
|
|
Send message over LAN
If we want to send a message to a computer in a LAN, we type the following
command in the "Start --> Run" in Windows.
net send ComputerName 'MessageText'
How can I do that from an Access form ?
Any help is greatly appreciated. Thanks in advance.
--
Sreedhar...
|
2 |
28.09.2006 17:57:31 |
|
|
question
i wanna create a software using access. my backend will be visual basic and
front end will be ms access. i wanna feed entire datas from excel to access.
so guide me...
|
3 |
28.09.2006 17:05:02 |
|
|
Set Default Pivot value from MsAccess module...
I can open my Excel template, refresh all my sheets and save the file to a
specified location all via an MsAccess module that runs after I refresh some
tables that act as the sorce for the spreadsheet. Now I want to add a line
of code to default a value in the pivot table, I want to default FiscalYear
to 2005 as part of the process. I recorded some Excel code to do this:
(xcelapp.ActiveShee...
|
1 |
28.09.2006 17:01:33 |
|
|
Calculations based on time
I have a vStartTime and an vEndTime. I want to subtract one from the other,
and then subtract 30 minutes unpaid time for lunch to see how many total
hours a person worked in a day.
I have tried unsuccessfully to use many variations of the =DateDiff function....
|
12 |
28.09.2006 17:00:01 |
|
|
If-Then Help! Seems Easy..
This question is hard to explain but basically im getting a runtime error#13
at the bottom where it says: "if strng then". Idk if thats proper syntax or
not but im trying to make it so that i can have a search and a search
criteria withuot doing ALL the different IF combonations. This is the best
way i could think of and it doesnt seem to like the whole string being the
criteria. Could a...
|
2 |
28.09.2006 16:39:47 |
|
|
synchronize replicas using RunCommand
I am trying to initiate synchronizing a replica using "RunCommand
(acCmdSynchronizeNow)" in the close event of a form. however, it gets a run
time error 7718 when it runs "cannot synchronise because one or more objects
are open" any ideas? what event?...
|
1 |
28.09.2006 16:22:01 |
|
|
Reading beginning and ending dates...
I am trying to create a form that will take Start Date and End Date from the
main form and give me a text box for each year between the two dates.
Example:
Start Date is 05/31/2000; End Date is 1/12/2006... when I go to the second
form, I want text boxes for 2000-2006 to appear....
|
2 |
28.09.2006 15:59:02 |
|
|
How do I get the user's full name
How can I get the user's full name that is signed into the computer. For
example, I'm looking to retrieve Bob Jones, not a LAN ID of axcbj. Any help
would be great.
--
Thanks,
Chris ...
|
4 |
28.09.2006 15:15:03 |
|
|
Connect Oracle Tables via ODBC and VBA
Hi,
i wrote a script to connect automatically Oracle-Tables via ODBC to my
Access-Frontend.
it works!
but: every time i start my frontend, i have to type in login and pwd of the
oracle server, that stores my tables. I cannot understand, because in my
script, that connects the tables, i have included login and pwd in the
connection-string (see script below). i fount out, that my linked ...
|
6 |
28.09.2006 13:30:41 |
|
|
More Threads.
I was trying to increase the number of threads that a program uses.
I thought this would do it.
application.setoption "Threads", 10
This give me an error. What is the correctly way to increase the number of
threads. via VBA.
Scott Burke...
|
3 |
28.09.2006 13:25:01 |
|
|
Function that reads fisloaded() and value
Good morning,
I'm working with the fisloaded() function (thanks to the MVPs for their
fantastic site!) to determine a query's criteria. I need to see if the form
is open (obviously). If it is NOT, then I don't want criteria in the query
field. If it is open, I want to check to see what the combobox (cmbdept)
value is. If it's NULL (one of the choices has not been made), I want to
ag...
|
5 |
28.09.2006 13:09:01 |
|
|
Opening an access email by double clicking on a text area
Hi guys!
I have a problem: basically, I have a text area on a form that allows
an email address to be entered. When the user double clicks on this, I
want an Outlook email box to appear, with that email address in the
"to" box at the top.
I have some code which I found that does work, most of the time, but on
some computers, it opens Outlook Express, which is not desired. I want
it to...
|
3 |
28.09.2006 12:51:55 |
|
|
Startup Options/Database Password
Hello,
I have a database with certain startup options for the end user. What I
would like is for the database to prompt for a password ONLY IF the shift key
is used to try and bypass the startup options, so that only an authorized
person with the password can see the background of the database. If I simply
set a database password from the Tools menu, it asks for that password with
the...
|
10 |
28.09.2006 12:13:02 |
|
|
link report
Hello.
I'm doing a DB that needs to populate some information on a Word document.
The document is on the company intranet.
Is it possible to link to this file and use it as a report ?
Thanks
Luis...
|
2 |
28.09.2006 11:21:28 |
|
|
DoCmd.OpenReport, Print to Adobe Timing Problem
Hi. I have some code that loops through some items and prints out a pdf for
each item. My printer is defaulted to Adobe. This usually works just fine.
However, I now have a pretty big report that's composed of about 20
subreports. When I try to print the report using the code excerpt below, it
seems as if the code is executing before the report actually prints using the
Acrobat distille...
|
2 |
28.09.2006 08:51:01 |
|
|
Trim statement with an array
Hello,
I have the following code which will look at the values typed into a text
box, determine whether or not there is more then one name, then create an
array if there is more than one name and put the results into a select
statement. It seemed to be working fine until I added the "Trim" line. Am I
not allowed to trim an array? The user may enter one name like "Harold Bloom"
or he m...
|
4 |
28.09.2006 08:46:52 |
|
|
Change the HAVING Clause on the fly for a report
Hello expert,
I have tried and tried but I couldn't make it work.
The report can be called by the form with the where clause criteria. But it
seems not working for the HAVING clause.
Now I have a query that I need to pass in the parameter values for some of
the fields on the fly. What is the best approach to modify the parameters on
the query? I'm using Access 2003.
Also how t...
|
2 |
28.09.2006 05:56:55 |
|
|
Need help writing a function
Hi, I know very little about ACCESS VBA, therefore you are my only
possibility to get this done... I have posted also in the query groups
trying to find out a solution without coding but not having received
any answer I must conclude that coding is necessary.
Let's begin from the end.
I need to build a query (Query1) containing 2 fileds.
First field Query1.RequestedDate must be the cop...
|
4 |
28.09.2006 05:37:18 |
|
|
Bad API Call (SendInput) from ACCESS module
I want to use SendInput to send keystrokes and mouseclicks from ACCESS to
another application. I am trying first to send some text to a text box that
already has the focus in the current form. However when the API call is
executed I get a "bad API call" error. As far as I can tell the declarations
and datatypes are correct, but obviously I've missed something. Can anyone
advise what coul...
|
1 |
28.09.2006 05:06:02 |
|
|
Auto Populate Based on Date
Is it possible to select a start date and then an end date from a command
button. and then have access fill a table records. For example: If I select
Jan 1 2006 as the start and then select Jan 6 2006 as the end. I would end up
with the following records If I had a field named AppointmentDate in the
table.
Jan1 2006
Jan 2 2006
Jan 3 2006
Jan 4 2006
Jan 5 2006
Jan 6 2006
I know the...
|
2 |
28.09.2006 04:08:02 |
|
|
Tree View Problem
Hi folks,
I built a tree view control in form and report. In the form, it works
great. In the report, it works but it cannot display all the data of nodes.
For instance, the node has 100 characters but it only display up to the wide
of list box. The rest of the characters were chopped off.
Could anyone show me the way to move those chopped off characters to the
next line of the...
|
1 |
28.09.2006 03:01:01 |
|
|
Formatting after text is entered
Good Afternoon,
I am looking for a way to have formatting applied to a phone number after the
number is updated. Data entry wants to be able to just type in the format of
5555555555 so they can go through it faster, is there a way to have it
formatted after the information is typed/input?
As further example:
Data Entry Wants to Type: 5555555555 (no input mask)
I need to have it format...
|
3 |
27.09.2006 21:20:54 |
|
|
Shell Back and forth
I have the following code:
DoCmd.Minimize
Call Shell("msaccess ""N:\Databases\Football 2006.mdb""", 1)
What this does is minimize the current database and then opens and maximized
the football.mdb database leaving the current database minimized. However, I
would on docmd.quit Command buton on the football.mdb, main form. Maximize
the Current Database that was maximized.
Thanks.
...
|
1 |
27.09.2006 20:42:17 |