|
Read a password to a table in a Macro
I have some tables in my Db that are password protected. I am automating
multiple steps in a Macro and would like to build in a step that reads the
password. Someone had recommened the sendkeys Action in a macro, but that
doesn't work for me. I have tried to set up an Autokeys macro but it doesn't
like the syntax of the password.
I basically want to simulate entering a password for a t...
|
3 |
15.09.2006 20:51:01 |
|
|
Unable to open dB exclusively
Occasionally, I have experienced times when I am unable to open a database
exclusively. I understand that if someone has it open, its not possible to
open it exclusively. However, I have a tracking mechanism in the database
that checks to see who has the database open.
Has anyone ever experienced times when you are unable to exclusively open the
database to make some updates / modificatio...
|
5 |
15.09.2006 20:49:02 |
|
|
Can’t_remove_the_lock_file!
I have a built a database application with a front end and a back end
database. It works fine but sometimes, after closing the application, the
lock file isn’t removed. The database thinks I’m still logged on even if I’m
not.
Why isn’t the database considering me as logged on, even if I have closed
the database?
Is there any simple ways to reset the database if this occur, wit...
|
3 |
15.09.2006 20:41:02 |
|
|
Error "There isn't enough memory to perform this operation"
I have been building a complicated database for the Trucking industry... and
now when I try to modify one of the more complicated reports, I get the
message in the Subject line above. I can't even re-enter the design view or
preview my report.
Also, if I try to click on a button in a form that would bring me to the
report, I get the message: "You canceled the previous operation."
A...
|
2 |
15.09.2006 20:33:01 |
|
|
ADODB Recordsets
I use the following command to retrieve data for current project tables.
Dim rst As ADODB.Recordset
Set rst = New ADODB.Recordset
rst.CursorLocation = adUseClient
LineNote.Open "StoredProcedureName", CurrentProject.Connection,
adOpenForwardOnly, adLockReadOnly
What I need to do is read data from a table in another Access Database. I
was able to figure this out before, bu...
|
3 |
15.09.2006 19:30:33 |
|
|
How to make sure a field is formatted correctly?
I want to make sure a field is formatted correctly. When the user types in
the field called Speed, I would like for the data to be formatted as 50,35.
50 and 35 can be any random number. If the field is not formatted in this way
"00,00", I want to display an error message for them to correct it. Can
someone help me w/ some VBA code?...
|
3 |
15.09.2006 18:08:01 |
|
|
How to remove an empty record from a table
I'm new to VBA. I have a table with a couple of blank records in it amongst
other full records. I would like to know what code I can use to delete these
records. I tried ...
DoCmd.RunSQL "DELETE * FROM tblNewPImodems WHERE TRACK_NO = """";"
but it doesn't work. Any help would be appreciated....
|
3 |
15.09.2006 17:59:34 |
|
|
Disable mousewheel
It is standard In Access forms that when using the mousewheel you will scroll
to the next or previous record. I don't want that in my application. Does
anyone knows a solution?
Klaas Muurling
Leiden
Holland...
|
6 |
15.09.2006 17:55:51 |
|
|
Data Check of Multiple fields
I have a module that uses the TransferSpreadsheet acImport to bring in 4
tables into one table and that works great. The next step I am having
trouble with is on each record I have about 8 different checks for warnings
or errors in the data.
Because several of the checks require nested if's, I would like to open the
table and code the checks for each record but I can not figure out how t...
|
3 |
15.09.2006 16:39:02 |
|
|
Need help getting filepath information via File Dialog
I am wondeirng if there is a way to have the file dialog box (or something
similar) return a URL value from the selected file. Basically the issue I am
having is that I am trying to add hypertext links to files stored on a shared
network drive into an access table. Currently, using a pretty basic file
dialog approach, the hyperlink text will be based on the file path as defined
for eac...
|
5 |
15.09.2006 16:02:37 |
|
|
Report loss
I have a Database on a Shared Drive. One user just got a new computer. She
is now unable to run any reports now. I have command buttons that open up
forms and run reports. The command buttons open all the forms, but when it
comes to the reports nothing happens. She does not receive any error (such
as permissions).
Other users are still able to run all the reports as usual.
Does anyone...
|
3 |
15.09.2006 15:42:23 |
|
|
Run-time error '2427 Error Message - Help!!!!!!!!
I am relatively new to VBA, but can manage to work through some basic issues.
However, I am receiving the following error message when I click on the
command button of a form:
Run-time error '2427
You entered an expression that has no value
When I run degug, the following code appears:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim ssn As String
If Len([S...
|
5 |
15.09.2006 13:47:48 |
|
|
calculate results between previous records
Hi,
Can somebody help me with the following:
I have a table with some numbers and dates. I want to calculate the
difference between the dates and numbers and put that in a table or query.
For example:
field1 field2 field3
abcd 01-01-2004 1000
abcd 31-12-2004 2500
abcd 20-03-2005 2580
i need to know how many months in field2 between the first record and
the next, also for...
|
5 |
15.09.2006 11:42:46 |
|
|
Array output to a Table
I've got an array that collects the Grade, Division and JobTitle from a
recordset. I would like to output this to a table in the following format:
(Anyone got any ideas?)
Array Jobs()
Grade Division JobTitle
21 Credit Collections Manager
21 Sales Sales Manager
21 Credit Accts Payable Manager
21 Credit Accts Receivable Manager
21 Sales Advertising Manager
21 Finance Sr Fi...
|
4 |
15.09.2006 06:18:41 |
|
|
Display Date in TitleBar
Hi everybody,
How can I display date and time (or whatever I want to show the user
prominently as a constant reference) in the Application TitleBar through VBA ?
Any help is highly appreciated.
--
Sreedhar...
|
8 |
15.09.2006 04:17:30 |
|
|
HELP
My name is Albert and i am requested by my employer to buy databases in
the following fields:
* Pharmacy
* Poker
* Bingo
* Casino
* Sportsbook
* Backgammon
Can you please help me find a resource, or someone who can share/sell
such? We are willing to pay for this informations/DBs.I need phone,
email, product, and address.
Thank you very much in advance.
Albert Constantin
albert...
|
1 |
15.09.2006 03:30:50 |
|
|
HELP
My name is Albert and i am requested by my employer to buy databases in
the following fields:
* Pharmacy
* Poker
* Bingo
* Casino
* Sportsbook
* Backgammon
Can you please help me find a resource, or someone who can share/sell
such? We are willing to pay for this informations/DBs.I need phone,
email, product, and address.
Thank you very much in advance.
Albert Constantin
albert...
|
1 |
15.09.2006 03:11:10 |
|
|
Assigning a variable for calculating a field total on a monthly ba
I am trying to do a report that will show the number of items remaining in
inventory on a monthly basis. Fields would be like numunits, unitsold,
remaining.
I assume I would need a variable to store June’s remaining total (or
previous month) in order to calculate July’s remaining total by subtracting
the number of items sold in July from June’s remaining total and so on for
the ...
|
1 |
15.09.2006 00:06:02 |
|
|
How to secound highest value in the table?
Hi,
Is there a function in Access that can find the second the highest value in
a table?
Max can get the highest value right?
Thanks...
|
5 |
14.09.2006 23:43:02 |
|
|
OpenReport method with a Form criteria
Need help please. I am trying to open a report that is based off of a query.
I want to open the report and pass the query for that report its criteria
from 2 fields on my form. The form name is Form1, the two fields are FName
and LName. The report is called Search.
This is what I have so far when I run the report using a macro and set the
Where condition:
[dbo_vDocProperty Query]![Pri...
|
5 |
14.09.2006 23:15:55 |
|
|
acwztool (ACWZTOOL)
I've noticed that in my VB in the Project window listed before the name of my
project there is another project listed: acwztool (ACWZTOOL)
Can someone tell me what this is & if I can delete it or not? ...
|
4 |
14.09.2006 20:19:02 |
|
|
Import Excel sheet
Hi,
I am trying to import a specific sheet in a workbook that has several
sheets. I know I need to use the transferspreadsheet method, but I am not
sure how to format the range I have tried sheet(1) and also the name
"Wal-Mart Stores" with no success. Any help would be appreciated.
Thanks,
--
James Gaylord
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wo...
|
13 |
14.09.2006 20:03:02 |
|
|
Help with writing to an HTML file with VBA
OK here's the deal. I have this Access database that I use to log
server checks for some old Netware servers. With the help of some
other cool stuff I found in Groups, I made this module that writes the
results of the server checks out to html pages, one per server. Now
what I am trying to do (because my boss is never happy enough) is make
a "dynamic" page that shows the name of each serve...
|
3 |
14.09.2006 19:02:41 |
|
|
Applying Filters
Hello again .. sorry about so many questions ...
I am attempting to apply a filter to a form. The Filter that I am
attempting to apply is:
[Station] = UID_Station ( <-- which is a string)
and
movement![Date] = [DATE]= Between #" & DateAdd("d", -1, Format(Now(),
"mm/dd/yyyy")) & "# and #" & DateAdd("d", 1, Format(Now(), "mm/dd/yyyy")) &
"#)"
I was trying to put them into a singl...
|
5 |
14.09.2006 18:56:48 |
|
|
Can I rename a column name from a table using Visual Basic?
Hi.
When I import files, usually they don't have the right columns name that I
have to use with como queries.
What I would like to do is, after import any file to access, rename the
columns name.
Can you help me, either, how can I have a cicle to see the table definitions
so that I can rename the columns table.
thanks for any help.
...
|
2 |
14.09.2006 17:59:01 |