|
Access 2003 mismatch type 13 error already loaded DAO library
HI all,
I am using a loop to populate the last field of a table and am getting
the mismatch erorr. When I made the code origionally It worked, now I
copyed all necessary tables and module to another database and it
errors?
Sub usbNormal()
Dim db As DAO.Database
Dim rstOld As DAO.Recordset
Dim rstNew As DAO.Recordset
Dim iFields As Integer
Set db = CurrentDb()
...
|
3 |
19.09.2006 12:17:18 |
|
|
Moving an inserted picture
How do I move a picture I have inserted into a doc in MS Word...
|
3 |
19.09.2006 10:05:55 |
|
|
if one field is null
Hello
I am trying to make a function work which would enable me to do a
mailing.
My fields are
Table: Clients
RefClient
Titre
NomFamille
Prénom
Societé/Entreprise
ContactPersonne
Adresse
Code
Ville
Pays
all text except the first one Auto Entier long
My function is
Function Adresses(pvarNoAdr As Variant, Optional pfSansNom As Boolean)
As Variant
Dim RefClien...
|
3 |
19.09.2006 09:40:14 |
|
|
tbl
lotteryID lotteryPackNumber lotteryName lotteryUPC lotteryRetail lotteryAddedDate lotteryModifiedDate lotteryStartSerial lotteryCurrentSerial lotteryEndSerial lotteryActive lotteryMultiplier Sold ActualTicketNumber
These are my fields in my table. I need to be able to subtract sold from my
lotterymultiplier how do i need to do this.
...
|
3 |
18.09.2006 23:07:24 |
|
|
Close from and open a new form on exit event?
I have a form where the operator enters some text in a box. After they have
entered the text - a security code - on tabbing out I want to
i) close the current form.
ii) open another form.
conditional on the operator having entered the correct security code. If I
use the on exit event for my text box I get the error message 2585 "This
action cannot be carried out while processing a fo...
|
3 |
18.09.2006 22:06:03 |
|
|
DO ALL TABLES/FORMS DATA NEED TO BE ENTERED TO CREATE SUBFORMS
I want to create three databases and link them all by one control number. I
work for a government agency and we deal in assessments for businesses for
tax purposes. Not only do I have to create a database for new business but
need to expand information on exisitng businesses. This project and grown
over the last 3 years and is becoming cumbersome to keep up with records
since 2003. C...
|
20 |
18.09.2006 18:56:02 |
|
|
Help! Lost ability to EDIT
I have suddenly lost the ability to edit the data in my database. I'm not
sure when it happened, but recent changes include:
* Split the database into a front-end and back-end
* Changed format to 2002/2003 from 2000
* Created an .mde version of the front-end (but I have the same problem
whether using the .mde or the .mdb front-end).
All of my forms have the "Allow Edits" property set to t...
|
9 |
18.09.2006 16:06:07 |
|
|
making labels for dvd or video using access or excel
I have a list of films on dvd and cd in a table in excel and I want to
print out labels size 70mm x 38mm on A4 label sheets. How do I do it?
Would be glad of any assistance as I know nothing of either excel or
access. I would really need a step by step assistance.
...
|
2 |
18.09.2006 13:09:16 |
|
|
making labels for dvd or video using access or excel
I have a list of films on dvd and cd in a table in excel and I want to
print out labels size 70mm x 38mm on A4 label sheets. How do I do it?
Would be glad of any assistance as I know nothing of either excel or
access. I would really need a step by step assistance.
...
|
1 |
18.09.2006 12:54:25 |
|
|
Control Selection
I am trying to place text boxes on a form in the following oderer
Location 1 = textbox1
location 2 = textbox2
etc
The locations will be kept the same except for the number of locations used
The textboxes will vary because each textbox will have a priority associated
with it. i.e. The address textboxes will have the top 5 priorities however
if no address is present then the other textbo...
|
1 |
18.09.2006 11:47:36 |
|
|
How to return information from a form?
I have a little form that is opened by a couple of other forms, which allows
the user to mark the students in a class present or absent and the data is
saved in the database. This info is then used by the main form to retrieve
students. So in the main forms I have this sort of code.
DoCmd.OpenForm "frmStudentsPresent", acNormal, , , , acDialog,
is_classcode
ls_sql = "Select * fr...
|
4 |
18.09.2006 00:47:31 |
|
|
Set default web pages opening full-size (maximized)?
When web pages l;oad, they open 1/3d size. Rather than clicking on the
"maximize" button, is there a setting for opening them full-sized?...
|
2 |
18.09.2006 00:16:03 |
|
|
Can't use function in a report
I have a simple report that prints a date and a value (columnname 'bonus')
in its detail section. It seems to work fine. My problem is that if I try to
put the Bonus into a function, I get an error. I've tried the simplest
Access functions, such as =abs(Bonus) and =format([bonus],"##.#"). In those
cases, the report prints
#Error instead of the value of Bonus. If I try to use a function...
|
6 |
17.09.2006 17:59:23 |
|
|
2 Related field or Auto fill up 2nd field after 1st field entered
I have 2 related field in a transaction table
Example "Taxi Number" (1st Field) "Taxi Driver" (2nd Field)
Let say i have a table having latest or default Driver driving which taxi
record as per below
TaxiNumber TaxiDriver
New York 1111 Micheal
New York 2222 Jodan
.....
Now if i entred New York 1111 into "Taxi Number" (1st Field) in the
transac...
|
2 |
17.09.2006 10:40:15 |
|
|
filter vs. query on a lan
Hello,
I was hoping to get some expert advice, on deciding whether a query or a
filter is better in general, when populating a form, in a multiuser
environment. I usually have my users query via a form by whatever
parameters are approrpriate, which then opens another form and populates
it with the resutl(s). If the query returns more than a certain amount
of records, the application i...
|
7 |
16.09.2006 23:22:00 |
|
|
formula to calculate a percentage of a cell
It's 01:50 and it driving me nuts. I need to know what formula I use to
calculate a percentage of a figure.
item price in G7 is 91,000.00 I need to find 10% of this figure and put the
result in G8.
Don't laugh but I have not done formulas before and it's as clear as mud.
Thanks
Sharon...
|
4 |
16.09.2006 10:44:30 |
|
|
i did not recieve an email to except my email user name?
to except my email adress name to get on my web cam because it is telling me
that it was not varified. but i never recieved an email to except it like it
is telling me too. how do i except it for my email address to be valid?...
|
1 |
16.09.2006 00:12:02 |
|
|
just received windows xp.How do I write a standard letter?
I cannot access a blank screen on which to type a standard letter.Help please...
|
3 |
15.09.2006 22:26:38 |
|
|
Table question
New user here! That's my disclaimer for any potentially dumb questions that
follow! Are several tables necessary? Can I just use one table that is
called Master Data, into which all my information is located? This isn't my
'full-time' job, I'm just trying to create a personnel data base to make our
lives simpler here in the office. Most of what I've created thus far is
different forms th...
|
6 |
15.09.2006 21:17:02 |
|
|
Insert Object
In our Air National Guard Unit we use a program called ICS viewer to open
most of
fill in forms we use. I am trying to insert some of these forms into my
database.
When I use the Insert Object option it lists Internet Forms Documents but
when I am done installing the form and double click the Icon I created it
either saids reinstall the OLE sever or it doesn't do anything.
Any help...
|
2 |
15.09.2006 19:01:14 |
|
|
Execute code from other MS Office Products
I've used the following to execute a procedure in the module of one form from
a different form:
Forms!frmName.ProcedureName
How would I execute the same procedure (in Access) from Word or Excel or
PowerPoint?
Thanks,
sjw...
|
3 |
15.09.2006 16:36:02 |
|
|
creating a query for rental of pary items
i would like to create a database for party rentals,this willl show how much
items are out,in,and pending. it also must also be ale to show the
description of all the items one customer ordered with its unit cost ,number
of items rented,and total amount. these should be able to hold on one form.
customers information should be able to find by either name or company and a
form should be a...
|
4 |
15.09.2006 15:53:40 |
|
|
searchable keywords in Access
I wish to set up an Access database that will allow users to enter words or
phrases and have the database return the list of records that match the word
or pharase. I then want the user to be able to select one of the records and
then link to another document (the document could be a word document, an
excel document, a PDF file, a JPEG file etc.). How can I set this up?...
|
5 |
15.09.2006 15:21:02 |
|
|
Query Development Resources
I am new to Access devlopment and am trying to track down some good resources
on Query Development. Can someone point me in the direction of some good
resources either on-line of in the old fashioned book format.
Any help would be greatly appreciated.
Z...
|
5 |
15.09.2006 14:09:02 |
|
|
eliminate duplicate records in a data base
I have a data base with lists of names and addresses, many duplicates. How
do I eliminate the duplicates and keep just one entry of each name and address...
|
3 |
15.09.2006 11:55:02 |