|
Set to default printer in MDE
Hi, in my case, the the user opens the mde file, the forms does not
have a full bar toolbar expect the print preview and print button (the
one with the printer icon) nor the menu bar. If i compiled on my
machine to make the mde file, it will pick up my default printer (for
example 'hp laser 123', 123 is a unique number). If somebody is using
that mde on a different floor, it will give an erro...
|
1 |
13.09.2006 12:57:37 |
|
|
SQL trouble.
I have added the following code to the onClick event on a button on an Add
Account form. I want it to add a record to the Charges table using the
values that are in several controls on that form. I can't for the life of me
figure out what I am doing wrong. Any help would be greatly appreciated.
Dim SQLText As String
SQLText = "INSERT INTO Charges (Service Name, Charge Amount, Accoun...
|
6 |
13.09.2006 12:36:20 |
|
|
Show file dialog box
I want to open the file dialog box this VBA-code. But, I can't get the code
from help to work, se code below? A compile error occure --> "user
definedtype not defined"
What is missning in the code to open the file dialog box?
Sub Main()
'Declare a variable as a FileDialog object.
Dim fd As FileDialog
'Create a FileDialog object as a File Picker dialog box.
Set ...
|
2 |
13.09.2006 11:17:35 |
|
|
Running Sum - Tracking
Hi,
I've got trades that are sorted by ID in a query. The query keeps a running
sum of the cummulative quantity bought and sold. When this cummulative total
gets to zero, it means the position was closed at that point. What I want to
do is add the IDs of the trades that made it go to Closed to a new table...
Thus if I have:
ID TradeDate Ticker B/S Qty Cummulative
4...
|
1 |
13.09.2006 10:00:24 |
|
|
I need to find traing in VBA and programming with access
--
MG...
|
5 |
13.09.2006 09:29:02 |
|
|
public variables used in combo box
Good evening,
In a module I set up a Public variable as UID_Station (as String) and I use
this in most of my reports and forms with a problem ...
but then there is this one place ....
I am trying to use the variable in the property of field that I am setting
to a combo box. when I do --- the form asks for the variable when I open the
form. This is NOT what I want.
Amy ideas?
...
|
2 |
13.09.2006 02:08:01 |
|
|
Convert Superbase 3.0 front-end db to Access 2003 db
We have an application that is built with Superbase 3.0 front-end and Access
2000 backend. We would like to convert the Superbase 3.0 database to Access
2003. Has anyone does this? How? Any information - good or bad - would be
appreciated.
Thanx in advance....
|
2 |
13.09.2006 01:44:35 |
|
|
Question about reports, subreports, and page breaks
Folks,
I have four subreports in a report in the detail section. I suppose I
could move them to the footer of the report. Anyway, if any of them
have data, I want the main report to force a page break. I am trying
to use the "hasdata" property for the subreports, but I am getting the
generic error indicating property not available for object.
How does one tell the main report (using V...
|
3 |
12.09.2006 23:31:08 |
|
|
Trouble with getting latest file
Hi,
I have a problem getting the latest file of a series of files created. Each
week a number of files (can change each week) are created. I am unable to
change the naming convention. They are all in a path of
\\wpwss05\GrpData\XFERDATA\Reports\.
The filenames are:
SMSR_PLN_GEN_POL_XLS09092006_1_200609110531.txt
SMSR_PLN_GEN_POL_XLS09092006_2_200609110531.txt
SMSR_PLN_GEN_POL...
|
4 |
12.09.2006 23:12:09 |
|
|
Find email address in text file using vba
I need to find email address in a text file (c:\File.txt). The file is not
delimited, but all email addresses have "@" in them. How can I find the email
address (there would be only one per file, but there are other words in the
file), and then pass it to strEmail = "The found email address".
Thanks.
- Steve...
|
4 |
12.09.2006 23:10:03 |
|
|
Copy tables but only within a linked database
Thank you all for any suggestion that you can provide.
Question:
In a front end/back end database configuration how can a table be copied
from another table within the back end database and then re-linked to the
front end database?
When I issue the commands below, the table gets copied to the Front End
database instead of within the Backend database where I need it to be..
More expla...
|
3 |
12.09.2006 20:06:02 |
|
|
Error message
When I compile my database coding, I am getting a missing reference. It is
Microsoft ADO Extension 2.8 for DDL & Security. I know I had it when I
created the coding on my local computer. I think my mistake was copying the
database onto a network drive. Now I get that error and I don't find the
reference - it's missing? How do I get that extension?...
|
11 |
12.09.2006 19:48:02 |
|
|
Error on Form Open
I have a form with a subform that consists of 31 list boxes that are set up
like a calandar Month and year based on combo boxes also on subform. This
form worked fine until I put SQL (quite complex and lenghty) in the "Row
Source" of the list box. This populates the list boxes with reminders from
an events table.
It all works fine when the form is open, but If I put the form in Desi...
|
2 |
12.09.2006 19:27:02 |
|
|
Large Delays (only on some servers) for Queries of Linked SQL db's
Hi,
I have an Access 2003 .mdb/.mde that queries linked tables from a SQL db in
order to provide Access reports to the user. It also combines with the SQL
queries, data from a few very small tables within the Access db.
On most systems/servers/networks, this app works well. But there are two
systems/networks (one running Server 2003 and another running Windows 2000)
where the que...
|
1 |
12.09.2006 18:35:02 |
|
|
Basing 2 combo boxes on another
Hi there - i have a company form that allows users to enter, amongst other
things, 2 project numbers against a company so e.g. company joe bloggs might
have project numbers 35 and 40 assigned against it.
I then have an activity form where users log information such as hours
worked with a company and they must also select a project number here - i
have no problem limiting the value in t...
|
2 |
12.09.2006 17:54:30 |
|
|
date calculation
How can I could number of dates from an inputted date and omit Saturday and
Sunday while counting?
Thanks!...
|
6 |
12.09.2006 17:02:02 |
|
|
Default CurrentUser when not opening form
Hi group,
I found a peculiar situation with my database. When I first use CurrentDB
and then show Workspaces(0).UserName in a MsgBox, I get the name of the
logged in user. However, when I do not first access CurrentDB and ask for
the value of Workspaces(0).UserName right away, I get "admin"... Further
investigation reveals that "admin" really is the logged in user from then
on, at ...
|
4 |
12.09.2006 16:54:01 |
|
|
Access Performance Analyzer closes Access when I use it.
I'm trying to run Performance Analyzer, instead of brining up any additional
screens it closes the Access program altogether. This also happens when I
try to run Documenter Analyzer. The Table Analyzer is working fine.
I'm using Access 2003...
|
1 |
12.09.2006 16:47:01 |
|
|
Expresion to find a sentence in a field containing multiple sente
I have a querry in Access and I need an expresion that needs to find a group
of words in another field and return yes if it finds it and return blank if
it doen't find it. I have the following expression in which:
ADDED WORKLIFE REWARDS MEMBER: is the field name in the querry
Call_Comments is the field where it needs to search
ADDED WORKLIFE REWARDS MEMBER is the sentence that needs to s...
|
5 |
12.09.2006 16:25:03 |
|
|
limit to one user at a time
Is there a way to put an access database on a network folder and set it up to
where only one user at a time can use the database?
--
Billy Rogers
Dallas,TX
Currently Using Office 2000 and Office 2003...
|
2 |
12.09.2006 16:06:31 |
|
|
If then statement
Hello,
I need to create code in which the beginning of a field starts with the
words "No
Solution Yet". I can write the code if the entire field equals "No Solution
Yet" (see below), however I can't figure out how to do it if it just begins
with these terms.
If Me.Solution = "No Solution Yet" Then
strMsg = strMsg & "Solution needs to be documented"
MsgBox strMsg,...
|
7 |
12.09.2006 15:31:02 |
|
|
Delete part of text string using code
i have a large number of address records containing the country (United
Kingdom)
I want to delete this from each record in which it appears.
Easy to do using Find..Replace but I want to automate using a query or
preferably using VBA code. I'm sure this is easy but I can't see how to do
it.
Also the addresses are currently displayed as an address line with each part
separated by comma...
|
3 |
12.09.2006 15:04:14 |
|
|
Temp store selected values of listbox
Hi,
My scenario:
I have tblProducts 1:M with tblProductDetails
tblProducts holds the name of the products while tblProductDetails hold
different rates for a particular product that is used on different crops that
we grow.
Say, a product called Bravo can have a different rate for Cabbages and a
different rate for Lettuces.
Often more than one product is applied in an application to cr...
|
6 |
12.09.2006 13:56:02 |
|
|
replicating a record: quick query
Dept, Subdept and costcentre are combo text boxes. I need to change the
following lines so that when the button is clicked it blanks the text boxes
in the new record.
!Dept = Me.Dept
!Subdept = Me.Subdept
!Costcentre = Me.Costcentre
thanks...
|
2 |
12.09.2006 12:40:17 |
|
|
how to set up odbc over network without refreshing everytime?
I have shared a folder(with database) in one machine and have set the odbc
from the other machine to the first machine. thing is while setting the odbc
Apply button is inactive and only ok button is active. and after restarting
the machine he has to set the odbc again..is there any solution to this. I
will be very much grateful to u if you could give me a solution to this....
|
1 |
12.09.2006 10:48:01 |