|
Temporary report name for Email
One of the reports produced by my Access application is a sigle page which
displays information about individual customer orders. Each page is emailed
as a "snapshot" attachment. Is there a way to temporarily name the report to
reflect information in the report, e.g. Order Reference Number or Customer
Code, so that the report can be identified from the attachment name in the
email?
...
|
3 |
17.08.2006 01:30:01 |
|
|
Function In Query Called Multiple Times
Hello All,
I've come across a curious issue I've not encountered in the past. A
function within a query appears to be called whenever the screen is
repainted.
The query runs fine and returns a set of fields for each record. One column
calls a function based on the solution described in the following Microsoft
knowledge base article:
ACC: Adding Dynamic Counter to Query to Co...
|
4 |
16.08.2006 21:42:37 |
|
|
Session variables in Access 2000
I have created a database in Access 2000 which requires log-on, with the
security table specific to the database. When the user adds or edits a
record, I want automatically to persist the user's identity with the new or
changed record.
That means I need a means of capturing and persisting the user's log-on data
so that it can be married to the record when it is saved. I HATE using
p...
|
2 |
17.08.2006 05:15:05 |
|
|
get value of =GetCurrentComputerName()
I am retrieving .value of many textbox controls on a form using a loop. I am
building an SQL textfile. When I retrive .value of textbox with default
value of =GetCurrentComputerName() it brings in "=GetCurrentComputerName()"
instead of my computer name. How do I get it to run the function and return
the value when I go to retrieve the .value field of the textbox?...
|
2 |
17.08.2006 05:11:26 |
|
|
Access/MakeItFitThePage
I have some apps where forms are set up for landscape printing because I
couldn't squish everything the users wanted into Portrait format. Excel has
this cool thing in the Print dialog that tells it to make the output fit on
one page. If Access has it, I haven't been able to find it. Don't want to
write a ton of VBA to make it happen; anybody know where it might be hiding
in Access, o...
|
2 |
16.08.2006 21:44:37 |
|
|
apending data to table from unbound form when form field blank
Does anyone know a function or method to apend data from an unbound form to a
table when the form textbox is blank?
Dealing with only text fields in my table, am using code:
""" & Me![formfield1] & """
When the form field is blank it creates code "". (two double quotes side by
side)
The access table does not like this. (the [table]field property "required"
is set to no)
I was ho...
|
3 |
16.08.2006 20:31:02 |
|
|
Error 3077 with ComboBox
I have a combo box which looks up records in a table by user name, and
returns the data to the form. There is one user whose last name has an
apostrophe in it (i.e. O'Healy), and whenever I select this name from the
combo box I receive the following error:
Run-time '3077'
Syntax error (missing operator) in expression.
I'm almost certain that this error occurs because of the apostro...
|
5 |
16.08.2006 18:52:02 |
|
|
appending table from form
I have put the following code in a button_click event on the form myform to
append mytable.
ID, FirstName, LastName, are the field names of the table AND the Form
textbox names, they are identical
======CODE========
dim sql as string
sql = "INSERT INTO [mytable] (ID, FirstName, LastName,)"
sql = sql + "values (Forms![myform]![ID], Forms![myform]![FirstName],
Forms![myform]!LastName)"
...
|
11 |
16.08.2006 18:50:01 |
|
|
Automatic time/dates and locking of table/forms on completion?
I have a simple table and form to record projects where I manually input the
time and date, followed by a title of the project and then a remark/comment.
I use the table/form within a larger work recording system.
I would like to be able to have the time and date inserted automatically
from the PC clock and the table/form locked from further amendment on
completion. Basically a simple t...
|
4 |
16.08.2006 18:28:01 |
|
|
Hiding the Access window
Jeff, (or anyone else) if you have any ideas....
XP service pack 2
Access 2003
The following code is for the custom "splash" screen with a timer on
for 5 secs.
Modal = Yes, Popup = Yes, Autoresize = Yes, BorderStyle = None
Private Sub Form_Open(Cancel As Integer)
Me.Visible = True
'Hide Access Parent Window
apiShowWindow Application.hWndAccessApp, SW_HIDE ' This function...
|
3 |
16.08.2006 17:24:39 |
|
|
How do I create a session variable in Access to hold user name?
...
|
2 |
16.08.2006 16:46:27 |
|
|
Group by Week
Hi.
I have a dataset that includes Reference Number & Date. The dates range
from 01/12/05 to 31/05/06 and this needs to be broken down by week in the
form of a count of reference numbers, by date.
Is this possible?
Cheers,
Steve....
|
4 |
16.08.2006 16:45:12 |
|
|
MS Graph Object Model II
Sorry about the second related question here. Should have included it in my
first question about the line break. I'm trying to specify the font color in
the "myX" part of my data label below. The first part of the label is black.
..Points(i).DataLabel.Text = Format(Val(Str(Sales)), "$#,##0") & vbCrLf & myX
I'm thinking something like Format(myX,[Red]) or something but I've never
had to...
|
1 |
16.08.2006 16:38:02 |
|
|
Opening different forms based on count of similar items
I want to open up one form if the count of a table record field is 1, and a
different form if the count is more than one. What would the coding be for
that?...
|
2 |
16.08.2006 16:25:00 |
|
|
MS Graph Object Model
..Points(i).DataLabel.Text = Format(Val(Str(Sales)), "$#,##0") & vbCrLf & myX
The code above populates the data labels in my line graph. It works fine.
However, when I use vbCrLf to insert a line break between
"Format(Val(Str(Sales)), "$#,##0")" and "myX", it appears as though an extra
line is added.
It looks like:
$1,567
myX data
I would prefer it to look like:
$1,567
myX...
|
2 |
16.08.2006 16:19:36 |
|
|
Need basics of migration Access to SQL
Anyone know how and where I can find the basics of what I need to be infomred
about onhow to migrate Access 2002 to SQL?...
|
3 |
16.08.2006 15:59:39 |
|
|
Using a macro stored in excel's personal workbook
Cannot open a macro I am using in my personal workbook in excel. Error states
the macro cannot be found.
Code:
Dim xlApp As Object
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
xlApp.UserControl = True
Set xlBook = xlApp.Workbooks.Open("C:\Documents and
Settings\cb\Desktop\MASTR.xls")
xlApp.Run "personal.xls!removealphas"
xlBook.Sa...
|
1 |
16.08.2006 15:53:15 |
|
|
Messed up with Class Modules
I'm praying for an Angel to bless me with a sample db engineered to the max
with Class Modules so that I can play around, just like what I did with
Northwind.mdb when I started out with VBA.
Thank You.
--
Sreedhar...
|
10 |
16.08.2006 15:11:02 |
|
|
Cancel Print Job
Is there any code that can be used to cancel a print job after a report has
been sent to the printer? I want to cancel the print job and clear the
printer's cache. Any help would be greatly appreciated.
...
|
1 |
16.08.2006 13:25:11 |
|
|
Excel Automation creates a hidden instance of Excel using the Append Method
Hello All!
I've run into an annoying problem automating Excel from Access. My
program creates an instance of Excel where users can insert specified
data. Once there finished they can push a button on the Excel worksheet
that imports the data back into Access into the appropriate tables. The
importing process consists of first creating a linked table to the
Excel worksheet and then appendin...
|
5 |
16.08.2006 13:16:28 |
|
|
Knowing when Access application changes windows size mode
How do I know when the Access application itself goes from Maximize,
Minimioze, or Restore. The only way I could figure something out is to have a
form open that uses the timer event to check and see.
What I am trying to do:
My application is designed on 1024 x 768 resoulition. I have code to resize
the forms and controls if the resolution is different than the design
resoluton. I woul...
|
1 |
16.08.2006 12:45:02 |
|
|
Error in Export: "Microsoft Office Excel is waiting for another ......."
I have this routine which I developped a couple of years ago to export query
results to Excel.
I use a custom routine so I can add titles etc, format the data as required
and create pivot tables in Excel on the fly.
The routine has run fine until recently.
However, what I get now for large data exports is mid-way through the export
a dialog appears in Excel with the message:
"M...
|
1 |
16.08.2006 12:26:00 |
|
|
How do I set up an alert or notification system in Access?
I am trying to create a database that alerts users when their reports are
due. The due dates will be typed in manually, however, somebody has
something due every day......
|
2 |
16.08.2006 12:19:58 |
|
|
Get External Data
I would like to write some code that will import some data but I want the
user to select the file to import. I would like the first import box to
point to a specific location and not the last location used. Is there a way
to get the first import box to look in a folder I chose?
Here is the first part of the code that just brings up the import window:
DoCmd.DoMenuItem acFormBar, acFil...
|
2 |
16.08.2006 12:11:39 |
|
|
Problems with Database for Multiple Users
I created a database that when a user inputs information in a form and then
clicks a button on the form to merge to word, the vb runs a program to pull
information from our AS400, merges that information with standard names and
phone numbers, then merges the data into a word document. Each time I input
a different claim number on the form, a make-table query runs to dump the
AS400 infor...
|
2 |
16.08.2006 10:40:02 |