|
Hola Campeones!!
Hola Melchor y Elsa Romero: Les deseo un Feliz Año Nuevo, espero y se la
pasen muy bien y logren todas sus metas.
El motibo de este mensaje es para invitarlos al proximo OPEN que se llevara
acabo el dia Enero 6,2009 en el mismo lugar,sera un honor que puedan
asistir, Pues nos dara el honor el joven Alfredo Medina Jr. hijo del señor
Alfredo Medina, uno de nuestros lideres a seguir.
Se p...
|
1 |
1/1/2009 12:45:36 AM |
|
|
2009 Calendar
I am looking for a database to use at work as a group calendar to track
all our meetings. Has anyone seen a premade one I can download for 2009 and
on....
|
6 |
12/31/2008 11:51:01 PM |
|
|
SQL Timestamp field for Access use
I have mutliple (Office XP) Access databases linked to tables in an SQL
Server 2005 database.
I was searching the newsgroup boards for info on a write conflict message I
was getting and I came across alot of suggestions to other people to add
timestamp fields to ALL of the SQL tables being linked in Access. (It turned
out that one of my tables had a "bit" field that allowed nulls and h...
|
3 |
12/31/2008 11:47:26 PM |
|
|
QUERY FOR LASTEST OPERATION
Hi I have a database that tracks where parts are in our shop. I have a table
that we enter where a part was put and it gets taged with the date. I am
trying to make a query to find the latest [date]/[location] for a
[OrderNumber]/[LineItem].
Can anyone help me set up this query?
The plan is to make a report showing department load. I already have a
query finding the average parts ...
|
2 |
12/31/2008 11:28:54 PM |
|
|
Incrementing Invoice Number
When I create my Invoice I have 2 choices an Invoice number or Not and that
works just great, BUT if I open my Invoice again and add a charge when I
close my form it changes my Invoice Number from say 122 to 123, If my
invoice is Zero and add a charge to my Invoice its not a problem, this is
part of my code that must be wrong.........Thanks Bob
If fraSelectInvoiceNoType = 1 Then
...
|
15 |
12/31/2008 11:27:17 PM |
|
|
Complile question
hello to all
To fight bloat (my db, NOT ME), I followed advice of others in this forum
and created a new database, then imported all tables, queries, forms, etc.
All seemed to go well, but the new db would not compile at first. The
compile error I got in in several places was...
Compile Error - Named Argument not found
In each case, the offending code line involved an OpenArgs. ...
|
8 |
12/31/2008 10:36:10 PM |
|
|
Guaranteed Millionaires
http://guaranteedmillionaires.blogspot.com/...
|
1 |
12/31/2008 10:06:34 PM |
|
|
select multiple items combo box
Hi all,
I am having some trouble. I am creating a form that where for certain
categories the user needs to be able to choose multiple items. I originally
tried using a list box but after reading some of the posts here, I decided to
try using subforms as I need the data chosen to be saved in a table. I need
to use multiple sub forms as there are different categories that need to meet
...
|
4 |
12/31/2008 10:05:02 PM |
|
|
Adding records to a table
Is there a way to automatically add a record to a table for each person who
meets certain criteria?
The authorizations table I am working with has about 4,000 records. It holds
data about medical services for about 400 patients. The patient names and
other personal data are in a separate table.
For each of the patients who meet certain criteria (county, funding source,
etc.) I want...
|
9 |
12/31/2008 9:40:11 PM |
|
|
Time Calculation
Hello,
This is what I am trying to do:
There are two fields, [Time Call Received] and [Time Call Ended], what I
would like to do is calculate the amount of time it takes to process a call.
The users enter the time as such: 9:30 PM or AM depending upon when the call
is received. I tried the DateDiff function but I run into problems when a
call starts at 11:30 AM and ends at 1:30 PM. Simi...
|
2 |
12/31/2008 9:19:06 PM |
|
|
Linking Child Fields
I have a form and a subform, , both with name and Social Security Number
field. In the properties it shows that I have both linked, however only the
social security number actually shows up in the subform. The name does not.
Any suggestions.
thanks...
|
3 |
12/31/2008 9:18:01 PM |
|
|
Stumped on elspsed time calculation
I've got a table with two date/time values: [Sample Time] and [Test
Time]
In a query I'm trying to arrive at the elapsed time:
Elapsed Time: [Test Time] - [Sample Time]
The resulting column displays the correct value, ie: 2.42708.... but
when I format it using "d\d h\h" I get "1d 10h" instead of the "2d 10h"
I expected.
Obviously I'm doing something wrong -- please get me pointed...
|
3 |
12/31/2008 8:51:49 PM |
|
|
Prompt User for value
I have SQL append to a table when a button is clicked. But I can't get the
final field to prompt the user properly for a value. I'm trying to append
values from a multi select list, and have the user enter a different value
for each selection. I've tried so many different combinations for syntax
issues at the end of the SQL. The code works for the first 3 fields if I
remove the fourth.
...
|
2 |
12/31/2008 8:34:50 PM |
|
|
Expression to Require Data Entry
Hello,
Here is what I am trying to do...I would like to require data entry for a
control on a form but only if it meets the condition where:
If Reason for Call = 2, 3, 4, or 5 then Warrant Type cannot be null.
Does this make sense?
Please help. ...
|
9 |
12/31/2008 8:28:01 PM |
|
|
amine
cava cmoi
...
|
1 |
12/31/2008 8:16:13 PM |
|
|
hi
hi...
|
1 |
12/31/2008 8:09:36 PM |
|
|
SendObject method not available error
Using WinXP and Access2K2 and Outlook2K2
VBA References:
Visual Basic for Applications
Microsoft Access 10.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library.
(in that order.)
My database is using code by Arvin Meyer to send email to one or more
recipients. Great programming, in my humble opinion. I also have an event on
a form that opens Outlook with an individual’...
|
1 |
12/31/2008 7:53:00 PM |
|
|
change a decimal number to a whole number
The following was used in a query to scramble the records and reassign a new
number. The problem is, it did it in decimal format ex: 1.243565454 and I
cannot figure out how to change it to a single digit. I would like it to
start with the number 1 and then continue without skipping numbers. So if I
have a hundred records it would start at 1 and end at 100. Can I change the
format in ...
|
6 |
12/31/2008 7:37:55 PM |
|
|
Avoiding the Creation of a Blank Database
Hello!
Is there any way for us to avoid the creation of a Blank Database in Access
97? We need to do that to complete a set of security measures to avoid the
import/export and linking to our main Database Application.
Thanks in Advance.
--
Sandro...
|
20 |
12/31/2008 7:29:17 PM |
|
|
cannot find Jet in MDAC 2.5
hey I'm trying to download Jet in MDAC 2.5 and I just can't find it..
Do you guys know where it is?
thanks
-Aaron...
|
18 |
12/31/2008 7:25:16 PM |
|
|
kennenlernen
...
|
1 |
12/31/2008 6:58:12 PM |
|
|
Editing Yes/No column
I have a Yes/No column which can be edited in continuous form view. The
values display as Yes or No. However, as soon as I click in the column Yes
changes to -1 and No changes to 0. This is VERY confusing to my users; is
there any way to prevent this and get a selection list of 'Yes' and 'No' to
change the setting rather than have to type in 0 or -1 ??? Thanks.
--
"Give someone a fish a...
|
3 |
12/31/2008 6:08:01 PM |
|
|
.......
From: "mohamed atik" <amine_atik@hotmail.com>
Subject: cava bien moi cava etoi
Date: 01 Januari 2009 17:47
Clear Dayamine_atik@hotmail.com
...
|
1 |
12/31/2008 6:07:54 PM |
|
|
DSum Problem
I have a DSum in a text box's Control Source:
=DSum("[Quantity]*[UnitPrice]","tblInvoice","BillDate=#" &
DateAdd("m",-1,me!cboSelectDate) & "#")
I continue to get the #Name? error in the text box when I open the form.
The field names are correct, as is the table name and cboSelectDate has a
date when the form is loaded. Just to see what would happen I also wrote an
identical function...
|
4 |
12/31/2008 5:48:01 PM |
|
|
Simple (?) report?
I'm wondering what the simplest way to do this might be:
Two simple tables. First table is just a list of designations of "Tasks"
worked on:
ID Task
0 T1
1 T2
2 T3
(Arbitrary number of tasks)
The second table is just a series of triplets:
Date Task Hours worked
D1 ID <some number>
(Arbitrary number of triplets)
This is pretty clearly y...
|
3 |
12/31/2008 5:42:40 PM |