Not Linked to BE database at startup
I just finished splitting my database and now I am having a different issue.
The front end will be used to connect to several different BE (depending on
the project being worked) I have the code to make the connection as needed.
My issue is that the BE will all have different names and maybe locations.
When I try to load the form on the FE, Access will not even run any code in
load event before it errors if it cannot find the BE it was connected to.
What I want to happen is have the form load and post a msg saying that it is
not connected, then allow the connection to be m
|
3/11/2010 4:47:01 AM
|
8
|
=?Utf-8?B?c2s=?= <...@discussions.microsoft.com>
|
|
application.followhyperlink hangs Access application
When I use the following code Access 2007, running on Vista, hangs (not
responding).
Private Sub Tax_ID_Click()
Dim varX As Variant
Dim homePath As String
On Err GoTo errorHandler
varX = DLookup("[LC_Tax_ID2]", "[q_Homes w Tax]", "HomeID=
[Forms]![Members]![HomeID]")
homePath = "http://www.lakecopropappr.com/property-details.aspx?AltKey=" &
varX
Application.FollowHyperlink homePath
errorHandler:
MsgBox "Error trying to launch " & homePath & " webpage. Please ensure that
the URL you are trying to reach is correct", vbCritical, Error
End Sub
This code runs OK o
|
3/11/2010 3:47:01 AM
|
0
|
=?Utf-8?B?Q2hhcmxpZSBPJ05laWxs?= <CharlieONe...@discussions.microsoft.com>
|
??how to?? 10 random records per user in large file
Hello,
I am just starting to learn Access and know some basics. I've tried
using SELECT TOP * to try to get what I need, but obviously Access is
not reading my mind correctly wko
I'm working with database tables that have around 200,000 rows of data
pertaining to work-units completed by 70 employees in a week (column
label = ENTR). The SELECT TOP * brought me back records for only one
user...it was the right number of records though - 10 for emp# 45678 ;)
I need to randomly select 10 records for *EACH *user-id (unique to the
employee) so that I can review productivity and qu
|
3/11/2010 3:17:40 AM
|
1
|
Trixie <Trixie.47n...@thecodecage.com>
|
Change the colour of the active TabControl
Hi there
I currently have a database which consists of a tab control.
I would like to change the colour of the current tab I have clicked on so
that the tab and the tab control is a different colour (e.g. yellow).
Is this possible to do?
Thank you in advance for your help.
|
3/11/2010 3:11:01 AM
|
0
|
=?Utf-8?B?Zm9yZXN0OA==?= <fore...@discussions.microsoft.com>
|
Hyperlink to a specific page in Excel
Hi there
Is it possible to set up a hyperlink to a specific page in Excel?
Currently, the hyperlink is to the first page of the Excel file but I want
it to link to the second page of the file.
Thank you in advance for your help.
|
3/11/2010 12:41:01 AM
|
0
|
=?Utf-8?B?Zm9yZXN0OA==?= <fore...@discussions.microsoft.com>
|
inventory level adjustment
How would I make it so the level of my inventory would automaticly adjust the
amount.? If I enter a date in the orders table as the order is completed the
inventory level for the item would subtract one.
--
Todd
|
3/11/2010 12:30:02 AM
|
11
|
=?Utf-8?B?VG9kZCBSb2NoZQ==?= <ToddRo...@discussions.microsoft.com>
|
DLookUp
An AC2003 table contains journal entries. Each entry contains a date
(DJ_Date), a time they woke up (DJ_Wake_Time) and a Time they went to sleep
(DJ_Sleep_Time). The DJ_Date is formatted as a general date. The two times
are formatted as short time in the table definitions. The table name is
DailyJournal.
In order to compute the total time slept I need to compute the difference
between the time they went to sleep the night before and the time they woke
up today. I'm using the Diff2Dates routine (I use it everywhere, it's
great). The problem I'm having is with the DLookup.
|
3/11/2010 12:14:01 AM
|
6
|
=?Utf-8?B?UGV0ZXJN?= <Pet...@discussions.microsoft.com>
|
Problem with Access 2003 to Access 2007
Hi, thanks for reading! I'm updating a database created in Access 2000 that
was then upgraded to 2003 and now I'm trying to open it in 2007. Here's what
happens:
1. Open old database file (MailingList.mdb)
2. Get login screen and see main switchboard
3. Fill in login information
4. Database opens but the Office Button shoes only one option -- Close
Database
5. Ribbon is disabled except for certain functions on the "Home" and
"Acrobat" tabs (can't even see the other tabs).
After reading this forum and trying to find similar problems among users, I
ended up doing several
|
3/10/2010 11:51:48 PM
|
0
|
=?Utf-8?B?TE1O?= <...@discussions.microsoft.com>
|
car sale
I am wondering if you still have the car. If you do could you pleasesend me
your number or address. Thank you. You can call me at 206 366 2810.
Fedor Galenko.
|
3/10/2010 11:00:42 PM
|
1
|
"fedor" <korshu...@yahoo.com>
|
annuncio
magazziniere 33 enne con esperienza e ottima capacit� magazzino,ordini
ecc.,e aiuto banco cerca qualsiasi orario in localit� latina o zone
limitrofe. per contattarmi tel 3394101320
|
3/10/2010 10:16:41 PM
|
0
|
"Di giacomo Massimo" <massimo.digiac...@live.it>
|
How do I create a report with headers in a row?
I want a report which has a lot of information given per each day of the week.
I want to far left column to print only once with the corresponding
information for each day beside it.
Example report: cleaning tasks to do
3/1 3/2 3/3 3/4 3/5 3/6
clean bathrooms 1 1
mop floors 2 1
vacuum bedrooms 3
vacuum living 1
wash laundry
My current column report shows this:
3/1
|
3/10/2010 10:07:01 PM
|
2
|
=?Utf-8?B?TWljaGVsZSBF?= <Miche...@discussions.microsoft.com>
|
data entry using 2k7 not viewable in 2k7 but is viewable in 2k3
I have a user with a database that was created in Access 2k3. When we
updated the users Office suite to 2k7 everything was functioning properly
except certain Access databases. The database in question is stored on a
network share and is !100MB in size. When the user opens that database all
of the forms open and data can be entered. Once entered and saved the new
data is no longer viewable in Access 2k7. If you go to another machine and
pull up the database using Access 2k3 the data that was entered in Access 2k7
is viewable.
again the issue is data entered in Access 2k7
|
3/10/2010 8:53:02 PM
|
1
|
=?Utf-8?B?cHJpbWV0aW1l?= <primet...@discussions.microsoft.com>
|
Button on form to print report for current record
I want to put a button in my input form so it can print a report looking at
only the current record I am in using2007.
See names below:
Input Form: CC Form Entry
Unique Field: CC Number
Report: Customer Complaint Form
Can anyone help? thanks so much
|
3/10/2010 8:37:01 PM
|
2
|
=?Utf-8?B?QW5pdGE=?= <An...@discussions.microsoft.com>
|
copying database for backup
I have a database with 3 years of data - I would like to save it - make a
copy and delete out all of the data to save the old and start fresh with 2010
data- the database is Split into a backend and front end( that is confusing
enough in itself)
Just wondering for the best steps to make a copy to store for prior 3 year
database. - new database for 2010 - some of the tables will retain their
records - ex. customers etc. others with transcations will/should only have
2010 data.
Not sure if make a copy of front end and backend for Prior to 2010
and then a New front end and b
|
3/10/2010 8:25:03 PM
|
4
|
=?Utf-8?B?YmFicw==?= <b...@discussions.microsoft.com>
|
Switchboard passwords
I have two switchboard pages. One with options for a user and one with
options for an admin. On the main switchboard I have two selections: user and
admin. I want to be able to attach a password to the admin selection so that
when someone clicks it they will be prompted for a password and then directed
to the admin switchboard.
|
3/10/2010 8:19:01 PM
|
2
|
=?Utf-8?B?TGlzYQ==?= <L...@discussions.microsoft.com>
|
order data by a rank
i need to create a form order by the militaty rank.This form is based in a
query "qrystaff" with three fields: MemberID FullName and Rank.I´d like that
the data were ordered firstly by MilitaryRank and secondly by FullName in
alphabetical order.There is an easy way to do this?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access/201003/1
|
3/10/2010 7:41:57 PM
|
4
|
"JOSELUIS via AccessMonster.com" <u58...@uwe>
|
Form - Relating two tables
Hello,
I am trying to create a project progress form. The is completed twice a
month.
I have created a table that has the periods as follows:
Report Num Period Start Period End
------------------------------------------------------
1 01 Jan 10 15 Jan 10
2 16 Jan 10 31 Jan 10
etc....
The second table has the work items in the project:
Item # Work Desc. % Total % this Period % Cumulative
--------------------------------------------------------------------------------
1
|
3/10/2010 7:31:02 PM
|
2
|
=?Utf-8?B?QnJpYW4gVA==?= <Bri...@discussions.microsoft.com>
|
Report - Eliminating Duplicates & Reducing Space
First let me state that I am fairly new to Access (2003), although I am very
familiar with Excel. That being said, I am running into difficulty with
duplicates and extra spaces/rows appearing on my report. Here is what I have:
* Four tables: Address, Family, Email & Phone
* I created a query, Address Query, that pulls most of the fields from all
four of these tables. The relationships are:
Address & Family: one-to-one;
Address & Email: one-to-many;
Address & Phone: one-to-many
The links between these tables are Last Name & First Name (which are in all
four t
|
3/10/2010 7:03:02 PM
|
0
|
=?Utf-8?B?c2xycA==?= <s...@discussions.microsoft.com>
|
Opening hyperlinks
I have a hyperlink to a wiki that opens in my database window. I have to
click the back button to return to the database. Can the wiki be opened in a
seperate window?
|
3/10/2010 6:04:01 PM
|
1
|
=?Utf-8?B?VGFtbXkgUy4=?= <Tam...@discussions.microsoft.com>
|
Win 7 and Too Many Users
Most of our boxes are XP, but a couple of them are Win 7.
Also, the XP boxes have Access xp (2002) installed, but the Win 7 boxes have
Access 2003.
Problem: when a user on Win 7 opens an access program, all of the xp users
then get a "Too many users" error when they attempt to open the same access
program. It only takes one Win 7 user to kill all attempts by xp users to
open a file.
Does anyone know of a solution to this problem, or perhaps have more
information about what may be causing it?
Thanks in advance for any help.
Fred
|
3/10/2010 5:47:01 PM
|
4
|
=?Utf-8?B?RnJlZHJhdGVk?= <Fredra...@discussions.microsoft.com>
|
Query Criteria IIf statement
I'm using MSAccess 2003 and this seems like a simple process, especially
compared to some of the things I'm trying to do in my database. In the
criteria of a query field, I am using the following IIf statement:
IIf([FYAGR]>3000000,3,<4)
[FYAGR] is a different field in the same query. When [FYAGR] is greater
than 3,000,000, I get 3 as expected, but no matter how I word the range of
numbers I'm looking for in the false part of the statement, my query returns
no records. If I remove the IIf statement and place '<4' I get the correct
range, but no matter the combination I can'
|
3/10/2010 5:35:01 PM
|
4
|
=?Utf-8?B?aWFu?= <...@discussions.microsoft.com>
|
Query expression...
I am currently using 'Weekday: DatePart("w",[Wdate])'. Can the actual day
Mon, Tues, etc. be displayed?
|
3/10/2010 5:17:02 PM
|
2
|
=?Utf-8?B?MTE2?= <dweek...@stdgear.com>
|
Filtering a form with a combo box using left function
Hi
I have a table named "TblData" containing 5 field
One field is named "IDProcedure" (text field)
This field contains information like "M-41-25" or "P-1000" or simply
"41-50"
I have a form with "TblData" as records source
As I want to filter the form, I create a combo box with 3 choices
"Manuals"; "Procedures" and "Process"
Now I have to put some code on the after update of the combo box
"ChoixCat" to filter the form
The only way I can manege it is using the first left character of the
field "IDProcedure"
So if the user select "Manuals", I want the filter to be app
|
3/10/2010 3:56:55 PM
|
3
|
jean <jeanulric...@gmail.com>
|
Changing existing code to add "IF Statement"
I am currently using a database that is working well. However, I have
discovered that I need to make a slight change so that one of the fields
calculates differently based on the data used in another field. This is the
existing code:
=DSum("[WeeksService]","Service Record Query","[EmployeeID] = " &
[EmployeeID] & " And [DepartmentName] = Current_Department_Name")
I would like to have the code add ALL of the weeks service IF the Current
Department Name is equal to "Reserves". Can anyone provide help? Thanks in
advance.
--
Judy
|
3/10/2010 12:21:01 PM
|
4
|
=?Utf-8?B?anVkeWI=?= <ju...@discussions.microsoft.com>
|
Adding "IF Statement" to existing code
I am currently working with a database that is working well. However, I have
discovered that I need to add an "IF Statement" to change the expression so
that it adds all of the weeks service if the DepartmentName field is equal to
"Reserves". This is the existing code:
=DSum("[WeeksService]","Service Record Query","[EmployeeID] = " &
[EmployeeID] & " And [DepartmentName] = Current_Department_Name")
How do I need to change the code so that all of the weeks service will be
added together if the DepartmentName is equal to "Reserves"? Thanks in
advance for your help.
Judy
|
3/10/2010 12:17:01 PM
|
3
|
=?Utf-8?B?anVkeWI=?= <ju...@discussions.microsoft.com>
|
Crosstabs with between..
Hi
trying to make a crosstab with data who tells me how many cars goes where
to, (which city), in which period (Time of day)
Something like this:
TO 00:00-07:59 08:00-15:59 16:00-23:59
Oslo 2 3 6
London 3 6 12
Paris 1 0 0
Can you help me?
|
3/10/2010 12:09:01 PM
|
3
|
=?Utf-8?B?TW9yZ2FuSg==?= <Morg...@discussions.microsoft.com>
|
Integrate data in real time
Hello,
We have been looking for a real time data integration program.
We have not found the right software yet.
Basically we'll be using the tool for the migration of contacts and data in
real time.
Thanks for your help!
|
3/10/2010 11:26:01 AM
|
2
|
=?Utf-8?B?R3VlcnRhcw==?= <Guer...@discussions.microsoft.com>
|
Design and layout for Order Analysis?
I want to analyse our inquiries/orders conversions, by country, for a
selected period.
From my Inquiries table I have taken the fields Ref, InquiryDate, Country,
Status.
I created several queries as follows:
1. Uses those 4 fields with a FromDate - ToDate parameter on InquiryDate,
and a country specified in the criteria row for the Country column.
2. Takes the Ref field from the above, and Groups by Count. This gives me
the total number of inquiries for the period entered, for the specified
country.
3. As per (1) but using "Booked" in the criteria of Status.
4. Takes the Ref fi
|
3/10/2010 11:19:01 AM
|
2
|
=?Utf-8?B?Q1c=?= <...@discussions.microsoft.com>
|
Explorer 8
Does anyone know how to remove IE 8, if theres no remove button.
|
3/10/2010 9:31:01 AM
|
1
|
=?Utf-8?B?bW9tYWdhaW45?= <momaga...@discussions.microsoft.com>
|
fggfdfs
htyygft
|
3/10/2010 8:25:52 AM
|
0
|
"carole bureau" <carole.bur...@orange.fr>
|
a
发件人: "John W. Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com>
主题: Re: PaintBall 2
日期: 2010年3月10日 9:35
On Tue, 9 Mar 2010 20:10:48 -0500, "Ben" <bgagne@live.ca> wrote:
>Paintball 2 Is AWESOME!!!!!!!!!!!!!!!!!!!!!!!
>
>^_^
It's also completely offtopic for this Microsoft Access technical support
forum. Please find a more appropriate venue.
--
John W. Vinson [MVP]
|
3/10/2010 8:25:03 AM
|
0
|
=?utf-8?B?6ZmI6bmP6aOe?= <cheng6712...@163.com>
|
Add Calculation Field In Query
I hv this sql
SELECT Qtskssubcat2.BRNCD, Qtskssubcat2.BRANCH, Qtskssubcat2.SUBCATDESC2,
Sum(Qtskssubcat2.Netbal1MIA) AS SumOfNetbal1MIA, Sum(Qtskssubcat2.Netbal2MIA)
AS SumOfNetbal2MIA, Sum(Qtskssubcat2.Netbal3MIA) AS SumOfNetbal3MIA,
Sum(Qtskssubcat2.Netbal4MIA) AS SumOfNetbal4MIA, Sum(Qtskssubcat2.Netbal5MIA)
AS SumOfNetbal5MIA, Sum(Qprevmthsubcat2.Netbal1MIA) AS SumOfNetbal1MIA1,
Sum(Qprevmthsubcat2.Netbal2MIA) AS SumOfNetbal2MIA1,
Sum(Qprevmthsubcat2.Netbal3MIA) AS SumOfNetbal3MIA1,
Sum(Qprevmthsubcat2.Netbal4MIA) AS SumOfNetbal4MIA1,
Sum(Qprevmthsubcat2.Netbal5MIA) AS S
|
3/10/2010 7:49:02 AM
|
1
|
=?Utf-8?B?enl1cw==?= <z...@discussions.microsoft.com>
|
Calculated field in a table
I've got a table with 10 of 15 fields calculated. I enter data into the
table via a form, which does the calculations. The form works fine, but for
some reason the last 4 calculated fields don't get entered into the table.
Should I even have calculated fields in a table, or should they primarily be
used in queries and on reports?
If ok to put in tables, any idea why the last few calculated fields aren't
being recorded? Then 1 out of maybe 15 records the calculated fields do get
filled! The same data is input for every record. TIA
--
Logo
|
3/10/2010 6:16:04 AM
|
3
|
=?Utf-8?B?TG9nbw==?= <L...@discussions.microsoft.com>
|
How Best to Disable <ESC> Key on Form
My problem surrounds the <ESC> key function by design within Access. In my
office we have a major departmental database being accessed by 20-30 users at
any given time.
1. This is NOT an issue of the number of simultaneous users.
2. It IS a problem of users ACCIDENTALLY hitting <ESC> ocassionally
while they are entering data into this database.
+ The users are using this database and another commercial database
(non-Access, which has different functional use for the <ESC> key
than in Access) toggling back and forth between these da
|
3/10/2010 5:52:01 AM
|
4
|
=?Utf-8?B?TUo=?= <...@discussions.microsoft.com>
|
How can I create stock emails to reply to clients?
Can anyone tell me how to do this please?
|
3/10/2010 3:09:01 AM
|
2
|
=?Utf-8?B?SmFuZXQgVG9kZA==?= <Janet T...@discussions.microsoft.com>
|
Date conversions
I have to import data from an ASCII text file and
use INSERT INTO ... to create records in an existing
table.
There are a couple of fields with dates in the form
Mar 05,10
I know that I can set the 9 characters into a string and
manipulate the string using format(... to massage the data
into a form suitable for the SQL string using #s.
I was just wondering if that technique is the most efficient
or is there a better approach?
--
Len
______________________________________________________
remove nothing for valid email address.
|
3/10/2010 1:18:19 AM
|
5
|
".Len B" <goneh...@internode0.on0.net>
|
PaintBall 2
Paintball 2 Is AWESOME!!!!!!!!!!!!!!!!!!!!!!!
^_^
|
3/10/2010 1:10:48 AM
|
1
|
"Ben" <bga...@live.ca>
|
Combo Box
Hi,
I want to put a combo box on a form the lists values (PK) of records on
another form. I want to know how when I select a value from the combo box it
can open that other form on the specific record i selected its PK??
|
3/10/2010 12:09:01 AM
|
1
|
=?Utf-8?B?SGVzaGFtIFNha3I=?= <HeshamS...@discussions.microsoft.com>
|
Query Criteria is not working
I am having an issue with the criteria of a query.
I am limiting the data by a date range, an account code, and the number of
loads.
The date uses BETWEEN @FromDate AND @ToDate
The account code uses NOT = 4125 OR NOT = 4121
The loads is > 0
With the above scenerio, I get no loads which are 0, but I still get account
codes 4125 and 4121.
If I put the account criteria in seperate columns, then I remove those
account codes, but then I get loads that have 0.
Any ideas?
Cahd
|
3/9/2010 11:41:50 PM
|
4
|
"Chad Cameron" <chadNOT...@hotmail.com remove NOT>
|
painting holidays in red in a frmcalendar
in my aplication I´m using a frmCalendar and I need that holydays be
displayed in red and also saturdays & sundays. I create a tblHolidays to
store holidays but I don´t Know how can show these days in red in the
calendar.
Private Sub SetDays()
Dim intI As Integer, intJ As Integer, strNum As String, strTipoNL As String,
ctl As control
' Move the focus so we can dink with the calendar
Me.cmbMonth.SetFocus
' First, clear all the boxes
For intI = 1 To 42
' Controls are named "tglnn"
' Where nn = 01 to 42
' Using Format to get 2 digits
|
3/9/2010 10:58:36 PM
|
0
|
"JOSELUIS via AccessMonster.com" <u58...@uwe>
|
General Table/Input Data Question
have a bit of a problem for a small little project i wish to finish and i am
stuck on a minor detail.
Basically this little project has to keep track of receipts
Company Name
Vat Number
Date of Receipt
Amount of Transaction
the easy way of doing it of course is just straight input it into the table
(either directly or via the use of a form to mask the entry into the table in
a pretty way)
I have gone the form route and well i have discovered that i have several
receipts from the same company which means i have to enter the company name
and Vat number over and over ag
|
3/9/2010 10:52:04 PM
|
2
|
=?Utf-8?B?U2lk?= <...@discussions.microsoft.com>
|
Update Query!
Can I have an UpDate query to delete all content of all fields in
tblHorses
tblOwners
tblInvoices
--
Thanks in advance for any help with this......Bob
MS Access 2007 accdb
Windows XP Home Edition Ver 5.1 Service Pack 3
|
3/9/2010 10:44:17 PM
|
5
|
"Bob Vance" <rjva...@ihug.co.nz>
|
Renumbering or inserting
Hi,
I need help renumbering my records. I'm new to Access so I'll explain what
I'm doing and if there is a better way please let me know.
From a form the user can either choose to create a full set of tasks or a
reduced set of tasks. These tasks show up on another form called "traveler".
I made two tables. One table has the full tasks (80 records) and the other
has the reduced tasks (30 records) But they aren't really records per se
they're more like 5 word instructions that tell someone what to do. Anyway,
when they click the full button I run an append query that append
|
3/9/2010 10:14:02 PM
|
6
|
=?Utf-8?B?SndpbA==?= <J...@discussions.microsoft.com>
|
No In List Event
I am having trouble adding a record to the list. The list source is a is
query called "qryCountries" on a ComboBox control. The coding is:
Private Sub Country_NotInList(NewData As String, Response As Integer)
Dim ctl As Control
' Return Control object that points to combo box.
Set ctl = Me!Country
' Prompt user to verify they wish to add new value.
If MsgBox("Value is not in list. Add it?", _
vbYesNo) = vbYes Then
' Set Response argument to indicate that data
' is being added.
Response = acDataErrAdded
' Add string
|
3/9/2010 9:22:01 PM
|
2
|
=?Utf-8?B?aWhvbGRlcg==?= <ihol...@discussions.microsoft.com>
|
Changing Form background color conditional format
I am trying to fingue out how to get the conditional format for a Form. There
is a field called [Reason For Test] and I am trying to write the code so that
when someone chooses "Applicant" the form page (not continuous) background
color is Green, and when they choose "Allied Agency" the form page background
color is blue.
I would really appreciate help with this.
|
3/9/2010 9:06:01 PM
|
1
|
=?Utf-8?B?U3RlcGhhbmll?= <Stepha...@discussions.microsoft.com>
|
DCount within a Group
I have a report that groups students by grade. Within each grade is the
student's name. If the student's parents are divorced, the report will show
the student twice, once for the dad and once for the mom. I need a unique
count(w/o dupes) of the students within each group. I am currently using
DCount but I'm getting the count of the entire school. The DCount is now in
the group on the report, but it doesn't matter where I put it, the count is
the same.
|
3/9/2010 9:02:01 PM
|
1
|
=?Utf-8?B?U2NvdHQgQWxicmlnaHQ=?= <ScottAlbri...@discussions.microsoft.com>
|
Auto-Increment Issue (couldn't find this one)
Windows XP Service Pack 3
Access 2007 (from Office 2007)
Visual Basic 6.0
I have a table with an auto-increment column. This time of year, there is a
lot of deleting and inserting going on in that table. Inserts are done
through a Visual Basic program that does not touch the auto-increment field.
Now and then, more so this time of year, I get a duplicate in the field and
of course if fails. I found that, to fix it, I have too compact and repair
the data base. Needless to say, that gets tiresome doing it multiple times
in one day.
Any solutions?
thanx,
nick
|
3/9/2010 7:43:01 PM
|
2
|
=?Utf-8?B?bmlja2Y=?= <ni...@discussions.microsoft.com>
|
mde 2 mdb
Hi,
can enyone help me to reverse eng. one mde file to mbd.
thanks
|
3/9/2010 7:01:04 PM
|
2
|
"NeNe" <nenad.ruz...@ri.t-com.hr>
|
Using and "IF" statement
I am working with a database that uses the following code to sum the weeks
service that an employee works in a given department:
=DSum("[WeeksService]","Service Record
Query","[EmployeeID]="&[EmployeeID]&"And[DepartmentName]=Current_Department_Name")
The code is working fine. However, I have discovered that I need to add
some type of "IF" statement so that if the Current Department Name is equal
to "Reserves", that it will sum all Departments (not just the Current
Department Name). Thanks in advance for your help.
--
Judy
|
3/9/2010 6:09:01 PM
|
2
|
=?Utf-8?B?anVkeWI=?= <ju...@discussions.microsoft.com>
|
test
|
3/9/2010 5:35:26 PM
|
0
|
"jordens st hilaire" <bigjo...@sympatico.ca>
|
how do i get a macro/code to open a specific switchboard page
hi
i have four switchboards (patient, staff, lists, accounts) with patient
being default
but i need to open the staff switchboard using either a macro or VBA
thanks
|
3/9/2010 5:26:01 PM
|
2
|
=?Utf-8?B?Qm9va3NiaW8xNQ==?= <Booksbi...@discussions.microsoft.com>
|
NAS Drive
I have a split 2003 mdb on a NAS and for some reason when a second user, or
more, connect there is a drastic performance hit. The db becomes very slow
to respond to any user actions...
Anyone have any ideas as to why?
QB
|
3/9/2010 5:12:02 PM
|
8
|
=?Utf-8?B?UUI=?= <...@discussions.microsoft.com>
|
Alternative for MS Excel VLOOKUP function in MS Access2003
I am converting several MS Excel spreadsheets into a single MS Access 2003
database for a User.
The User’s original MS Excel VLOOKUP query is coded as follows:
=IF(VLOOKUP(EG2,EH:EI,2,FALSE)=B2,"Good",VLOOKUP(EG2,EH:EI,2,FALSE))
New MS Access Table Name:
0301_ElectricitySupply_FeatureLine-up
Field names for MS Excel and MS Access are as follows:
MS Excel Cell: MS Access Field:
A2 Verify Config
“A2” is VLOOKUP function listed above.
MS Excel Cell: MS Access Field:
B2 Config No
Example: B2 / Config No:
MTU0301-0010
Note: This number is a
|
3/9/2010 4:56:06 PM
|
2
|
=?Utf-8?B?Q0JlbmRlcg==?= <CBen...@discussions.microsoft.com>
|
enterabel form (data going into multiple tables)
Hello
I am currently designing a database for my company, and I keep on running into problems when I want to create an enterable form using multiple tables. This means that when i create the form, I will be using fields from different tables, and when it is entered into the form is should go to the tables. However, when I create this, there seems to be problems, It works if I input information into every field. However, if this is not done than the record is not remembered. I would like to know how to fix this problem.
Regards
Graeme
|
3/9/2010 4:49:32 PM
|
9
|
Graeme <u...@msgroups.net/>
|
ghostscript question
I've been using GS 8.14 for several years now in a couple of MS Access apps
and it's run great. I'm converting word docs to PDF's. But one of my clients
ran into a small problem so I'm trying to switch to GS 8.64. But the modules
that I was using in my mdb for GS 8.14 don't seem to work wiht 8.64. I
changed all the code to show the right version and a copule of other little
path issues have been taken care of and it runs without errors but the
resultant PDF is coming out blank now. So I'm guessing that the GS code
modules I got somewhere for version 8.14 won't work exactly right
|
3/9/2010 3:12:42 PM
|
1
|
"Keith G Hicks" <...@comcast.net>
|
Export Access Query to a pipe delimited .csv file
Fairly new to Access VBA.
How can I export an Access Query to a pipe delimited .csv file???
I believe the VBA Syntax is...
DoCmd.TransferText acExportDelim, _
"Specification Name", "qry_name", "C:\PathName\FileName.csv"
How do I specify and indicate to make it pipe delimited, "|"???
Thanks for your review and hopeful for a replay.
PSULionRP
|
3/9/2010 2:27:01 PM
|
3
|
=?Utf-8?B?UFNVTGlvblJQ?= <PSULio...@discussions.microsoft.com>
|
Format question
I need to use the Format function in a calculated field in a non-saved
query. The table field in the calculation [intSomeVal], is an integer.
I'm having trouble figuring out how to get the zeroes and nulls to
display as non-zero ("").
Ordinarily, this format property would work
#;-#;"";""
But in a Format function I can't seem to figure out how to
get a zeroes and nulls to display as blank.
Val(Format(intSomeVal,"#;-#;?;?"))
Thanks for any suggestions.
|
3/9/2010 1:51:31 PM
|
2
|
"John M" <newsgro...@microsoft.com>
|
cannot send or receive emails
My Windows mail account (Vista)has suddenly stopped working. It wil not permit me to send or recieve emails. It asks me for my username and password, but when I type these in it just doesn't recognise them and asks me to enter them again. The error message is
Account: 'pop.ntlworld.com', Server: 'pop.ntlworld.com', Protocol: POP3, Server Response: '-ERR invalid user name or password.', Port: 110, Secure(SSL): No, Server Error: 0x800CCC90, Error Number: 0x800CCC92
This happened around 6 months ago but that time when I went to Tools - Accounts - Properties - Servers the username and passwor
|
3/9/2010 1:18:38 PM
|
1
|
doffaj <u...@msgroups.net/>
|
How can i tag up a record 6 months before it expires
HI. Using Access 2000.
I need a formula or qurey to flag up records whith Training Certificates
that are about to Expire. I would like to know 6 months before thay expire
so that i can organise new training before the expriry date. Is this
possible?
--
Thank you for reading my post. Hopefully you can answer my querie
|
3/9/2010 11:36:01 AM
|
2
|
=?Utf-8?B?U2hhenph?= <Sha...@discussions.microsoft.com>
|
Display of the database
Hello
I hope this makes sense.
Currently, when any form in my database is displayed, there are scroll bars
along the sides (right and bottom).
I want to change the display (without altering the computer display) so that
any form takes up more space. In other words, if my form is 10 inches wide
and 10 inches tall, I want to see it reduced so that I can view the whole
thing.
Thank you in advance for your help.
|
3/9/2010 5:12:01 AM
|
1
|
=?Utf-8?B?Zm9yZXN0OA==?= <fore...@discussions.microsoft.com>
|
Bvbnikjmjkb
Htfgljk .lt6gyhjtybhnj
|
3/9/2010 5:06:57 AM
|
0
|
ILT Classroom in the City <phil...@salford.school.nz>
|
Use of check boxes in a database
Hi
I'm hoping for some help in this.
I have included the use of checkboxes in my database. So basically, if it's
checked, it means yes. If not, it means no.
The people who are using this database would like me to include the word yes
or no adjacent to the checkboxes. I believe this is redundant but they're
insistent on the inclusion.
What do you think is the best way to deal with this question?
Thank you in advance for your help.
|
3/9/2010 5:03:01 AM
|
11
|
=?Utf-8?B?Zm9yZXN0OA==?= <fore...@discussions.microsoft.com>
|
How can invoices be generated from multiple queries in Access?
I am an office manager for my local synogogue. I have created an Access
database to track our membership and their pledges and payments. I would
like to be able to generate quartetly statements that indicates a previous
balance, each pledge and payment (i.e., transaction) for the quarter and the
current balance. In the past I have used Mail Merge for things like this,
but this time I am having trouble embedding in a document information from
multiple tables/queries. Any assistance with this task would be greatly
appreciated.
Thanks!
|
3/9/2010 4:44:01 AM
|
5
|
=?Utf-8?B?TmV3IE9mZmljZSBNZ3I=?= <New Office ...@discussions.microsoft.com>
|
Suppress "Do you want to save changes you made to ..." message.
Everytime I try to close an opened excel sheet, I get the message
"Do you want to save the cahnges you made to ........."
How can I suppress the "warning" dialog?
set oOXL = createObject("Excel.Application")
oXL.Visible = False
oXL.workbooks.Open (Filename)
oXL.sheets("Inventory_1").select
....... processing, only reading no modification to sheet ......
oXL.workbooks.Close <<<<< this triggers the message.
Set oXL = Nothing
Thanks.
|
3/9/2010 3:43:01 AM
|
6
|
=?Utf-8?B?UGVycnk=?= <Pe...@discussions.microsoft.com>
|
Function for UserName Group
Function for UserName Group
Hello,
Using Access =9203 on XP system=85
I know there are a few functions out there that will pull the windows
username=85
I=92m looking for one that will also return the group (set by the sys
administrator) to which the username is assigned=97should the username
be assigned to a group.
One of the functions that returns the username, utilizes (I believe)
the mpr.dll=85maybe there=92s one for the group name (just a thought)?
Thanks for any help,
alex
|
3/9/2010 1:39:41 AM
|
4
|
alex <sql_...@yahoo.com>
|
Inconsistent State
Hopefully someone can shed some light on this problem...
I have a Access 2007 db that I developed and have been using for a couple of
years now. Just recently it has crashed twice and when it crashes, the FE
will not link to the BE. If I try to open the BE it says database is in an
inconsistent state... what exactly does this mean? The db is being used in a
server environment with approx. 10 users, what would be some of the possible
situations that might cause this problem?
|
3/9/2010 1:25:01 AM
|
1
|
=?Utf-8?B?S2V2aW4=?= <Ke...@discussions.microsoft.com>
|
Rounding Problems with Euros
Hi, I noticed that every time I dive, add or multiply a number in euro the
answer doesn' t Maatch the euro number. Does anyone know how to eliminate
this ongoing issue i'm having?
Here is an example to better explain my problem:
let's say I have a bottle of rum that cost 4.50€ and let's says there are 12
bottles in tha case. If I want to find out what the case cost is if I do 4.50
x 12 I would get the case cost, but when dealing with euros the final case
cost once I multiply doesn't reflect the bottle cost once I divide my answer
again. I would get something like 4.53 or sim
|
3/8/2010 11:53:01 PM
|
1
|
=?Utf-8?B?U2FudGk=?= <Sa...@discussions.microsoft.com>
|
Combo Boxes
Is there a way to change a combo box that has 3 columns of information (last
name, first name and address) so that all of the information appears on the
record?
I created a form, that in the Name Field, when you click on the arrow, a
combo box lets you select the name, showing the last name, first name and
address. However, I did not realise that on the record, only the last name
appears.
This is a student database and I am trying to track payments for certain
items. I think I have to create another form.
Any help would be greatly appreciated.
|
3/8/2010 11:52:01 PM
|
9
|
=?Utf-8?B?QWxlZGE=?= <Al...@discussions.microsoft.com>
|
Autonumber trying to create duplicates
I use an autonumber as my primary key in my table contracts. From the form
contracts users select create new record, enter the contract number and state
and county and then refresh. Sometimes the error message comes up with
trying to create duplicates. When I investigate the contract number which is
a unique field itself there is no duplicate. If I reset the autonumber
everything is fine and the user can add records with no problems. This error
seems to occur randomly and I need help as it is killing productivity.
Thanks
|
3/8/2010 11:36:59 PM
|
1
|
=?Utf-8?B?R2FyeQ==?= <G...@discussions.microsoft.com>
|
Rounding Issues
Hi, I noticed that every time I dive, add or multiply a number in euro the
answer doesn' t Maatch the euro number. Does anyone know how to eliminate
this ongoing issue i'm having?
Here is an example to better explain my problem:
let's say I have a bottle of rum that cost 4.50€ and let's says there are 12
bottles in tha case. If I want to find out what the case cost is if I do 4.50
x 12 I would get the case cost, but when dealing with euros the final case
cost once I multiply doesn't reflect the bottle cost once I divide my answer
again. I would get something like 4.53 or sim
|
3/8/2010 11:30:01 PM
|
1
|
=?Utf-8?B?U2FudGk=?= <Sa...@discussions.microsoft.com>
|
Mixing Access 2007 with 2003 and Replication
I am presently using Access 2003 and contemplating upgrading to 2007 and have
a couple of questions.
1-If I keep my MDB as "2002-2003 format" can it take advantage of all the
changes, in particuler "Export to PDF", I want to be able to Email directly
(no more PrimoPDF)?
2-If I change my MDB to 2007 can I still replicate to the others MDB's
("2002-2003 format")?
Thanks for any help.
|
3/8/2010 11:24:01 PM
|
5
|
=?Utf-8?B?V2luZDU0U3VyZmVy?= <Wind54Sur...@discussions.microsoft.com>
|
text conversion to number on select query
Hi,
In a Select Query I'm joining 2 tables by Item ID (unique value, similar to
Social Security Number) but 1 table created by IT has Item ID as a "number"
value and the other table has it as a "text" value.
How can I in a Select Query, create a formula that can either have the text
as a number value and vice versa so i can link the 2 without getting "type
mismatch in expression."
I think I can use Cdbl Value or something like that in the formula but not
sure.
Thanks!
|
3/8/2010 10:01:01 PM
|
3
|
=?Utf-8?B?aW5zcGlyeg==?= <insp...@discussions.microsoft.com>
|
How to access data in Access 2007 through Sharepoint
I have an Access 2007 database created and ready to use.
I would like to use the Shareport as an interface and though it to access
the forms (input the data) and view the reports in the Access 2007 database.
Is that possible? And if yes, what is the way to do so?
|
3/8/2010 10:01:01 PM
|
6
|
=?Utf-8?B?QS4gSi4=?= <...@discussions.microsoft.com>
|
How to loop through closed Forms?
How do I loop through all CLOSED forms in my Access 2007 accdb?
This only works for OPEN forms:
Dim frms as Forms
Dim frm as Form
For Each frm in frms
Debug.Print frm.Name
Next frm
Thanks
|
3/8/2010 9:35:30 PM
|
3
|
deko <deko...@gmail.com>
|
'asctrls.ocx' error
I have a database created under Microsoft Office 2003 and Windows XP. Works
with no problem with Office 2003 and XP.
I have tried to load it on another PC with Microsoft Office 2007 and Windows
7. It will not load and locks the PC.
The error message is 'Your Microsoft Office Access database or project
contains a missing or broken reference to the file 'asctrls.ocx' version
1.0'
As I can't load this database on the new PC, I have no idea what to do.
Other databases I have transferred across work fine. Any suggestions
please?
thanks
|
3/8/2010 9:08:27 PM
|
1
|
"Peter" <To reply please post another news message>
|
Workgroups Link
I'm trying to secure my database that is located on a network drive. I've
created my secure .mdw file and now I want to create short cut to make the
users automaticly sign in under that workgroup. My problem is some of the
people do not have Access installed in the same folder I do. Is there a way
to create the shortcut in such a way that it simply opens Access via whatever
user default method selected?
I've already tried programming the shortcut with out the link to access and
it will not trigger the workgroup, it only opens the database as normal.
Thanks in advance! (Using
|
3/8/2010 9:07:01 PM
|
1
|
=?Utf-8?B?Sm9obg==?= <J...@discussions.microsoft.com>
|
vista - vba - appactivate trouble
Hi all,
I have an application running on several xp, vista and 7 computers. (access
versions >= a2k, db format = access 2000).
This application communicates with other applications using keybd_events and
appactivate
On some computers running vista (not all, why why why?), AppActivate often
hangs in these cases:
* when you put a windows in background, and try to activate it,
* when you minimize then maximize some times (1, 2, 3 times) then try to
activate it.
The problem can be reproduced at will on any of these computers (and the
problem doesn't occur on other c
|
3/8/2010 9:06:23 PM
|
4
|
"Alain Bourgeois" <brolspa...@skynet.be>
|
upgrading from office 2007
i heard of the deal were, if u have office 2007 u can upgrade to office 2010,
does this deal apply to enterprise, cause one of my parents company is
parterned with MS and got enterprise for $20 for me, is it possible to
upgrade from office 2007 enterprise to office 2010 (whatever it could move up
to)
|
3/8/2010 9:05:01 PM
|
4
|
=?Utf-8?B?eGVyb3gxMTEx?= <xerox1...@discussions.microsoft.com>
|
asctrls.ocx error
I have a database created under Microsoft Office 2003 and Windows XP. Works
with no problem with Office 2003 and XP.
I have tried to load it on another PC with Microsoft Office 2007 and Windows
7. It will not load and locks the PC.
The error message is 'Your Microsoft Office Access database or project
contains a missing or broken reference to the file 'asctrls.ocx' version
1.0'
As I can't load this database on the new PC, I have no idea what to do.
Other databases I have transferred across work fine. Any suggestions
please?
thanks
|
3/8/2010 8:41:09 PM
|
2
|
"Peter" <To reply please post another news message>
|
Access 2000 vs 2007
I am working in a small office configuration (5 employess), and we are all
using one of the Microsoft Server configurations (our IT folks out of LA set
it up, and as you will find from this question, I am not a tech guy).
We have been using an ACCESS program I wrote several years ago on the 2000
version of Access. At one point our office was upgraded to 2003 without
Access, and we kept the 2000 version on our computers and the program rocked
on just fine.
I recently had a computer crash and my new computer was delivered with
Office Professional 2007 - which included Access 2
|
3/8/2010 8:33:01 PM
|
2
|
=?Utf-8?B?S2V2aW4=?= <Ke...@discussions.microsoft.com>
|
te llega ?
te llega ?
__________ Informaci�n de ESET NOD32 Antivirus, versi�n de la base de firmas de virus 4786 (20100119) __________
ESET NOD32 Antivirus ha comprobado este mensaje.
http://www.eset.com
|
3/8/2010 7:31:39 PM
|
1
|
"alejandro" <er_ale...@hotmail.com>
|
emailing multiple reports
I have an access 2003 form with entries that are used to make 2 separate
reports. I want to place a command button on the form to have both reports
attached to one email.
thanks for your help
--
rjpohl
|
3/8/2010 6:40:01 PM
|
1
|
=?Utf-8?B?cmpwb2hs?= <rjp...@discussions.microsoft.com>
|
Unable to open subforms in Access
I am working with a access database that is located on a network drive. This
database is a patient history list and when i double click on the patient's
name it is supposed to show me the patient history but it doesnt. I have
gone to the access options and changed the trust center settings to allow all
macros to run but still can not get the database to work. Any Idea's?
|
3/8/2010 5:54:02 PM
|
2
|
=?Utf-8?B?YnBhbG1lcmk=?= <bpalm...@discussions.microsoft.com>
|
Conditional Formatting if the field contains a specific number
I am working in Access 2003 and have created a database of chefs who
volunteer for our annual event. Over the years, several are repeat
volunteers. I am attempting to create a report wherein the "year" field will
turn yellow if the information contains the year "2010".
Can this be done (and by someone of my limited grasp of Access)?
Thank you for any help you can give.
|
3/8/2010 4:36:01 PM
|
2
|
=?Utf-8?B?bmJzbGFyc29u?= <nbslar...@discussions.microsoft.com>
|
Importing Excel file without server access
I'm automating the process of emailing query results as an Excel file
attachment to one recipeint. The recipient will complete data in the Excel
file. My problem is that our company will not give this person access to our
server, therefore he cannot upload his updated Excel file to one of our
drives where I can then access it, import and update my table. There is
nobody that he can email the file to either. I believe, however, that he'll
have access to unpload a file to our company's SIFT site. Is there a way,
through automation, that I can then import the file from the SIFT sit
|
3/8/2010 4:26:01 PM
|
1
|
=?Utf-8?B?QWxleA==?= <A...@discussions.microsoft.com>
|
Office for 3 computers
I have Office 2007 on 3 computers but one of them will not go back on line so
I have a laptop I want to put Office on and I'm wondering if I should
activate it, if it will work or how it works. Does the 3 copies go on 3
computers and that's it just as if all 3 of my computers got trash I have to
go and buy another Office for 3 computers or can I just take off of one and
put on another?
|
3/8/2010 4:21:02 PM
|
1
|
=?Utf-8?B?bG9zdHNvdWw2Mg==?= <lostsou...@discussions.microsoft.com>
|
subform option group not working
Access2003
I have a main form called fClosure (PK ProjectID)
There is a subform called fClosureApproval (PK ClosureApprovalID, SK
ProjectID)
On fClosureApproval, I have an option group with 2 toggle buttons. see code
below
Select Case optApproval.Value
Case 1 'Approve Closure by adding PM and date
Me.ApprovedByMgr = DLookup("[ContactPMgrID]", "[t040Project]",
"[ProjectID] =" & [Forms]![fClosure]![ProjectID])
Me.DateMgr = Now()
Case 2 'Request Clarification by displaying pop up form
Dim stDocName As String
Dim stLinkCriteria As S
|
3/8/2010 2:24:01 PM
|
3
|
=?Utf-8?B?ZGVi?= <...@discussions.microsoft.com>
|
How can I change the program used when following a hyperlink
I have a database which uses hyperlinks to take me to a set of image files,
gif & jpeg. I have recently moved to Firefox. If I click on a link to a gif
file it opens in Firefox, but if I do the same for a jpg it persists in using
IE. The file association for jpg files on the computer are to Photoshop. But
I prefer opening the links in the browser as I am only viewing, not editing,
the files
Anyone got any ideas
JimR
|
3/8/2010 2:19:01 PM
|
3
|
=?Utf-8?B?SmltUg==?= <J...@discussions.microsoft.com>
|
Iff statement to show pictures
Is it possible to use Iff statement to show pictures
Actually I am trying to use tow different pictures on the form if the value
is less than 0 or higher than 0
example
=IIf([Text135]<0,"","Pictue B")
=IIf([Text135]>0,"Pictue A","")
How can I Do This
so far i am unable to fix this issue
Regards
Aamer
|
3/8/2010 1:37:01 PM
|
2
|
=?Utf-8?B?QWFtZXI=?= <Aa...@discussions.microsoft.com>
|
Converting MP3
What is the simplest way of converting MP3 to WMA?
|
3/8/2010 1:20:04 PM
|
2
|
"Robert Armstrong" <Robertarmstr...@xln.co.uk>
|
How to install Provider on server
Dear Sir/Madam.
I am getting this error
Provider error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB
status value, if available. No work was done.
Actually In our page I am reading XML using ASP,
Error at this line
adoRS.ActiveConnection = "Provider=MSDAOSP; Data
Source=MSXML2.DSOControl.2.6;"
It was working fine in past but when we changed our server then this
problem creates. One person saying this problem occurs due to
unavailablity of provider.
So please tell me what is the main reason.
Please help me what to do a
|
3/8/2010 12:40:52 PM
|
2
|
Deep <vinod...@gmail.com>
|
access 97 web browser
hello,
When including the Microsoft Web Browser into a form I receve an error
message : 'No object in this control'
Do you have a soulution ?
I have also develop an Ax project with VB6 including the web browser control
ans it works correctly, but when I put the Ax i a access97 form, the browser
control of the ax is absent ??
Thanks for help
eric baar
|
3/8/2010 11:24:53 AM
|
1
|
"eb" <e....@skynet.be>
|
MSDAOSP (MSXML2.DSOControl.2.6) in the server
Dear Sir/Madam.
I am getting this error
Provider error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB
status value, if available. No work was done.
Actually In our page I am reading XML using ASP, like
adoRS.ActiveConnection = "Provider=MSDAOSP; Data
Source=MSXML2.DSOControl.2.6;"
It was working fine in past but when we changed our server then this
problem creates. One person saying this problem occurs due to
unavailablity of provider.
So please tell me what is the main reason.
Please help me what to do and how to do to rectify thi
|
3/8/2010 11:07:14 AM
|
1
|
Deep <vinod...@gmail.com>
|
Same Variable But In Different Sub's
Hi,
Please see code below.....
Sub X1()
V1 = "GI-ACE"
Sheets(V1).Select
Call S
End Sub
Sub S()
ActiveSheet.UnProtect ("util")
Range("B43:BW200").Select
Selection.ClearContents
Sheets("Data").Select
Selection.AutoFilter Field:=1, Criteria1:=V1 '!!!!THIS IS WHERE IT
FAILS!!!!'
Selection.AutoFilter Field:=145, Criteria1:="CHECK"
Range("E3:G800").Select
Selection.Copy
Sheets(V1).Select '!!!!THIS IS WHERE IT FAILS!!!!'
Range(B42).Select
Selection.PasteSpecial Paste:=xlPasteValues
End Sub
Basically, I need to use a defined variable (V1) in other subs, how can I do
|
3/8/2010 10:07:01 AM
|
1
|
=?Utf-8?B?TSBDaGFoYWw=?= <MCha...@discussions.microsoft.com>
|
Invoicing using Access
Hi
I am fairly new to Access - but totally sold on the possibilities and am
well on the way up the learning curve.
What I need to do pretty quickly is work out how to raise an invoice - one
was built for us but it doesn't seem to work :-( Rather than get the person
back to re-do it, I thought it would be better to learn the process so that
we can create our own in future.
We are using Acess 2007 with Windows XP Pro
Most of the information is in one table called Billing.
We need to include:
Hire of Centre (optional) +
Number of people * cost per person
Less deposit paid
|
3/8/2010 9:04:02 AM
|
10
|
=?Utf-8?B?S2F0aHJ5bg==?= <Kath...@discussions.microsoft.com>
|
Incorrect Total on Main Report
In one of my reports The Main Report presents the accounts while the
sub-report consists the positive and negative transactions pertaining to such
an account. On the main report I have three text boxes. Two of them
representing the SUMs of the Positive and the Negative amounts separately,
while the third presenting the result. However, unfortunately the third box
instead of presenting the difference correctly, is presenting a type of
running balance. With every new account the result from the last account is
simply adjusted.
In other words, it is only the first account that is
|
3/8/2010 5:55:01 AM
|
1
|
=?Utf-8?B?RmFyYXogQWhtZWQgUXVyZXNoaQ==?= <FarazAhmedQure...@discussions.microsoft.com>
|
form
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=1abfd859-2cd0-4d4e-8724-df2e535eeefb&dg=microsoft.public.access
|
3/8/2010 4:47:01 AM
|
0
|
=?Utf-8?B?U3VwYWNoYWkgQ2hvY2hhaXBhbmljaGFub24u?= <SupachaiChochaipanicha...@discussions.microsoft.co
|
querydef locking up a database
Has anyone heard of opening a shared database, but changing a querydef
(with vba) setting it to exclusive? Access 2003 run-time?
|
3/8/2010 3:35:48 AM
|
0
|
SmartbizAustralia <...@smartbiz.com.au>
|
Merge PDF from Access
Hi
I need to generate a letter in PDF with a couple of fields such as name dob
etc from access. How can I achieve this? I am thinking to maybe have a word
document and then fill the fields from access via automation and see if
there is a way to convert this letter to PDF. Is there a better way?
Many Thanks
Regards
|
3/8/2010 12:29:44 AM
|
3
|
"John" <i...@nospam.infovis.co.uk>
|
Switchboard items table won't delete
After long deliberation I finally decided to follow the frequent advice to
split my database. (Using a copy intially, of course). The wizard failed,
with 2 error msges that I have seen many other posts about - subscript out of
range, and something else. So i decided to do the split manually. Worked OK
and the links are up and everything working. One problem though - when
deleting all the original tables from the new _fe after setting the links to
the new _be, Switchboard Items could not be deleted as it was in use. Well
yes, of course it was, I have to have my switchboard open to
|
3/7/2010 11:08:01 PM
|
2
|
=?Utf-8?B?Q1c=?= <...@discussions.microsoft.com>
|