Hello.

I have a client with several machines on a LAN (their office) all running
Windows XP Pro SP2. Most of the machines are running Access 2003, however
one machine is running Access 2007.

The machine that is running Access 2007 can never access the network-stored
database if anyone else is already in it. However, if the Access 2007
machine is logged into the database first, everyone else can log in without
issue.

Hope someone in here can suggest something to aid in this problem.

Thanks!
Shoregeek

I am developing a tracking database that will deliver a report which will
tell if a document is early or late. I would like to calculate the Average
time for those items that are marked "Late".

I used an IIf statement in a text box on my Report which reads:
IIf([Early or Late]="Late", Avg([Total Time Early or Late]), "Item is on
time")

[Total Time Early or Late] is a calculated field that returns the difference
in two General Dates in the following format: "XXdays XXhrs XXmins" using the
code on this web page: (http://www.accessmvp.com/djsteele/Diff2Dates.html)

Right now the answer is returned in a general number format (i.e. 2.818)

I would like the answer of my IIf statement to be formatted in the same
manner as the diff2dates function:
Average Days Late: "2 days, 4 hrs, 13 mins"

Any idea how I would accomplish this?

Thanks

I have several reports all of which now need to include records from a user
specified date range. The reports are all run from a menu selection.

Do I need to set up a different form as the front end for each report to
collect the date criteria or is there a way of selecting the report and
storing the report name so that the correct report runs after the date
criteria is input. I have a command button on the form to open the report but
can't see how to specify which report automatically. I'm not a great VB user
so all simple help much appreciated!

Sheila

You should ask this question in an email newsgroup which is more appropriate
to your problem. This newsgroup is dedicated to the Microsoft Access
database product.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Marios" acma.com.cy> wrote in message
news:C4ACEE67.7FD%%marios@acma.com.cy...

I am trying to create a query that drills down and creates a parts list.

We have a database that has their parts in one table (tblParts). There is
another table that has the parts materials (tblPartMtl).

The way it works is that we have a top level part. That part has other parts
that go into it. Those other part can be comprised of smaller parts, and so
on ...

The Parts table is just a master list of each part. The Parts Material table
is the same list of parts plus what materials it is comprised of.

Now, one of the Parts Material could have it's own BOM. I would have to look
at that part from the Parts table and find out what its materials are
composed of.

What I would have to do is make the following links:

Part - PartMtl
Then link the PartMtl back to another Part table but using the part Mtl as
the linking key.

This can go back and forth 10 times or more to get a complete parts list.

Is there a better way of doing this?

Hope this makes sense!

I'm trying to put text in an unbound text box in a form as follows:

Me!txtPriority.Text = "Rush"

This is taking place during the On Activate event procedure for a report.
Initially, I got an error message saying the control had to have the focus.
So I tried

Me!txtPriority.SetFocus

Which gave me an error saying something like the command couldn't be
executed. So I tried DoCmd.GotoControl and I got an error saying the command
wasn't available.

I'm missing something obvious - haven't written VBA in a long time.

I need to send a query string to an asp page, and although I've created a
function to replace certain characters (%%, & ,+ etc), I was wondering if
there was a built in VB function like UrlEncode to do the job properly from
within Access.

Am I being too hopeful?

Many thanks

Ian King

I posted this in the Queries section and got a good start but I need to close
the loop (as it were).

I have a table (I cannot change the layout) with the following structure
(strID is the Primary Key):
tblPers_Awards
strID : Trans : Award1 : Award1Date : NbrAward1...Award40 : Award40Date :
NbrAward40

For each strID there could be data scattered thru the various fields...data
in Award1, Award 15, Award23…etc.

I have 2 separate table with the structure (AwardCat is the Primary Key):
tblCombinedAwards
AwardCat : Precedence

The only difference is in one (original) the Precedence field was set to a 3
char text field (001…300). I made a version that changed the Precedence to a
num (1-300) in case this was easier to use for this project.

Im creating a contact database for our marketing person. Most of it I
can handle, but I have one issue. A contact can belong to one or more
organizations in the architectural world, ie, AIA, AAMA, etc...

What I want to do is have a check box for each of these orgs. Then our
marketing person can check them off for each one they belong to. I
have made a table for the list of orgs. Is this something easy to do,
or is there a better way?

Thanks!

Mark

Monsieur Bernard ROSA

4 Rue Saint Juste

11590 OUVEILLAN

Objet : Formiguères,

Votre demande de devis le 13 avril 2008

Monsieur,

Je vous prie de vouloir trouver ci-joint, un devis pour un montant T.T.C. de
92 606,69 ? (dont T.V.A. À 19,6 %% : 15 176,35?), représentant la réalisation
de votre projet ainsi que les matériaux et fournitures nécessaires aux
travaux.

En cas d'acceptation, nous vous prions de nous retourner un exemplaire de
devis signé, ainsi qu'un acompte correspondant à 30 %% du montant T.T.C.,
soit 27 782,00.

En espérant que mon offre pourra retenir favorablement votre attention,
veuillez agréer, Monsieur, mes sincères salutations.

Martinho FERNANDES