|
|
|
How do I do this in Access 2007?
Thu, 13 Nov 2008 12:26:03 -0800
Hi,
I have Access database has a customer table.
The customer table has a customerID field datatype is autonumber (prim. key).
I made a CustomerEntry form base on customer table.
On customerEntry form has a textBox lookupCustID field.
What should I do if I enter a value in lookupCustID, onexit event it
lookup ...
|
leading zeros in autonumber
Thu, 13 Nov 2008 09:31:02 -0800
Hi, I'm an old SQL/FoxPro type, and the help here is great for dragging me
kicking and screaming into the foibles of Access!
My question: can I force a fixed-format onto an Autonumber field? I need
the autonumber to display on a report with leading zeros, e.g. "000016." Do
I need to convert it to text fi ...
|
force uppercase in part of expresssion
Thu, 13 Nov 2008 01:06:01 -0800
I want to combine fields first name and last name, but I want Last name in
upper case. The last name field in the table is forced to upper case with
">", but that does not work in the expression (well I can't get if to work.
Probably a super simple question, but thanks.
M ...
|
Can I do this in Access? Please help
Wed, 12 Nov 2008 15:05:00 -0800
The basic idea is that I have to send letters 5 times a year at 1, 3, 6, 9,12
months from Date of death of the person.
I need to set it up as follows:
Deceased Name Date of Death Caregiver's Name Address(City-State-Zip).
The letters are slightly different from each other(based on length of time
since ...
|
How do I use count if in access?
Wed, 12 Nov 2008 11:42:01 -0800
I am trying to add a count if fuction to my report. I run this query and I
want it to ountif like Copy only. How would I show this on the last page of
the report?
SELECT [Vault Audit].[Loan Number], [Vault Audit].[Date reviewed], [Vault
Audit].[Original Signed Note?], [Vault Audit].[Scanned Note?], [Vault ...
|
Importing CSV
Wed, 12 Nov 2008 13:09:07 +0100
Hi
I get an error when trying to import csv file with the following structure:
"Data:2008-10-17 13:15","Agregacje wg no¶nika kosztów","Kryteria: Okres
pomiêdzy 1 i 9; Rok finansowy: 2008","No¶nik kosztów","Agregacja","Konto
ksiêgowe","Kwota","No¶nik kosztów: B100","304"," 490020","Zakup
us³ug-Warsztat" ...
|
Importing data
Wed, 12 Nov 2008 12:41:01 +0100
Hi
I get an error when trying to import csv file with the following structure:
"Data:2008-10-17 13:15","Agregacje wg no¶nika kosztów","Kryteria: Okres
pomiêdzy 1 i 9; Rok finansowy: 2008","No¶nik kosztów","Agregacja","Konto
ksiêgowe","Kwota","No¶nik kosztów: B100","304"," 490020","Zakup
us³ug-Warsztat" ...
|
|
|
Access Database with more than 1 user. Please, need urgent advice.
Thank You.
Tue, 11 Nov 2008 15:38:56 -0800 (PST)
Hello,
I have a Microsoft Access file in a network. Can I access the file
from multiple computers?
And can the users edit the database, using a form, at the same time?
Thanks,
Miguel ...
|
Lookups
Tue, 11 Nov 2008 15:05:01 -0800
I am super new to Access, but am seasoned in Excel... have come to a point
were I think my Excel doc should really be in Access... so I'm trying it out.
I see that Lookups in Access are not the same thing as they are in Excel, but
I want to be able to, in Access, lookup a value and its corresponding piece
o ...
|
"Id is not an index in this table"
Tue, 11 Nov 2008 14:06:03 -0800
My database was working fine until earlier today when my computer locked up
just as I was finishing entry of a new record. Since that point, I am unable
to open my database and get the above message (error 3800). Is there a way
to fix this error?- I am using Access 2007.
Thanks in advance...
Ang ...
|
|
|
