|
Table Field saying "Unknown function 'Date' for default funtion?
Setting up a Field in a table for a value (date) that will be filled in
automatically in a Form. Using the Access 2000's default value for this date
function: ' date() ', I receive an error message when trying to save this
change: "Unknown function 'Date' in validation expression or default value on
'tblTracking 2007Q1.Request Date'. Is there something else I can do or is
there a defec...
|
3 |
26.09.2006 19:37:03 |
|
|
Multiple Entries for One Record on Forms
I have a data entry form that consists of a main form with three subforms
attached. When entering data into the subforms, I need the user to be able
to enter multiple entries into each subform for each record (one to many
relationship). For one subform, I can enter in multiple entries, but can only
see the last one. How do get each entry to show on the form at the same time?
For the o...
|
6 |
26.09.2006 19:58:11 |
|
|
Office XP Professional Activation
I was running Windows XP Home Edition and installed Windows Media Center.
When I installed Media Center it completely wiped out all my Office XP
Professional.
I reinstalled my Office XP Professional 2002 and when I attempted to
activate it,it
would not allow me to, telling me it was already installed on another
computer. It is installled on my desktop and I am trying to reinstall on t...
|
3 |
26.09.2006 19:55:02 |
|
|
combo box to text fields of a table
hi all,
iam doing a project and i want to send the data of a unbounded textbox
to different fields of a table based on the value selected from the
combo box. is it possible, please claryfy my doubt
Bobby
...
|
2 |
26.09.2006 19:30:55 |
|
|
Limit characters in a numeric field
Is there a way (in the table design or in a text box on a form) to limit the
number of characters that can be entered? I know how to do this for a text
field, but I want to do it in a numeric field where users may enter only
digits 1 thru 9.
Any suggestions on the best way to accomplish this?
Thanks....
|
3 |
26.09.2006 19:28:36 |
|
|
Output to Excel
I have a button on my form that outputs the current data of the form into
Excel sheet,my problem is that the data is displayed horizontally,while i
need to display it vertically and i'd like to leave an empty row between some
records.
Could any on help me ?...
|
1 |
26.09.2006 19:15:02 |
|
|
Error When Changing Index in Table - Help Please
I attempted to change ControlNum from Yes (Allow Duplicates) to Yes (No
Duplicates) and got the following error message.
The message says to change the data in the field or fields that contain
duplicate data. What is the best way to find the duplicates? And what
would my next step be?
I originally allowed this field to contain duplicates, but now realize that
this w...
|
4 |
26.09.2006 19:09:34 |
|
|
Append Table - Auto Number Problem
I have a query/append table process that takes historical data, ascending by
date and adds new unique records as they appear (the data eventually gets
removed from the original database source I query in approx. six months due
to an IT archive process). The problem is the append table auto numbering
tries to renumber the existing records before it assigns a number to the new
unique recor...
|
4 |
26.09.2006 18:58:01 |
|
|
What is apa format?
Is there any website I can go to without paying for APA or MLA formatting?
How do you do it on word?...
|
5 |
26.09.2006 18:53:17 |
|
|
Calculation in text box
Hello to all-- I was told that you can calculate data in a text box in
Access? Is there some where I can get mathematical calculation to use in
Access? Example
If I wanted to get an average of three samples entered in three separate
boxes in my form setup and I have built a text box to display the average.
What and how do I need to enter that calculation? I have tried the Event
Builder...
|
3 |
26.09.2006 18:51:02 |
|
|
Verify Phone
Is there a method for verifying first if the data entered is a valid number,
then if it's a valid phone number? By Valid phone number I mean is it 10
digits without any formatting EXAMPLE ##########?
I think I can use IsNumeric for the first part, but can I pass a format to
IsNumeric, if so how?
Thank You
...
|
4 |
26.09.2006 18:32:12 |
|
|
auto BackUp being generated
Have Access2002 designed running on an Access2003 machine. DB is split and
on the desktop is only the FE.
The FE is failing; generating a MS error that the application must close -
with the choice to Send or not Send a report to Microsoft. When this occurs
a 'BackUp' of the FE then exists on desktop.
Have duplicated the failure point and the backup is created each time.
I am presu...
|
1 |
26.09.2006 18:12:02 |
|
|
SQL Server
The database that I created was recently upsized to a SQL Server. I am now
running into the problem of not being able to add new records. How can I set
my form up to add new records to the table. Can someone please help?...
|
4 |
26.09.2006 17:52:02 |
|
|
Database visualization
Hello,
We have recovered an old access database (.mdb) and we would like to
see in a schema the relations between tables. Do you know how I can
automatically visualize this ?
Thank you
Nic.
...
|
5 |
26.09.2006 17:46:03 |
|
|
Refresh Data for shared environment
We have users sharing the same database. If someone updates the information,
how do the others on the network receive the data? Is there a way to refresh
the interface?
Any suggestions are appreciated...
|
2 |
26.09.2006 17:46:02 |
|
|
report
hi !
i am generating a report with a lot of fields.
if the value in a field is null , that field cannot be not included in
the fields on the report.
how do i do this ... with a query or some other way ???
thanks
brino
...
|
2 |
26.09.2006 17:41:02 |
|
|
LDB.exe for 2003 Access
Is there an LDB.exe for 2003 in order for me to see what individuals are on
the database? I had one for Office97, but there appears not to be one.... Is
there another way to see who is on the frontend and backend some other way?
...
|
5 |
26.09.2006 17:36:02 |
|
|
copying Access CD using XP
This is not really an Access question, but now that I have
the Access CD I want to make some copies of it.
Do I need software other than xp to make a copy of
a CD. Of course you need copies of the CD in case
something happens to the original.
...
|
7 |
26.09.2006 17:32:21 |
|
|
I enter field in 1 form record and it goes into all records
Why? I enter data into a field in the form and it repeats in all the records.
--
Rich D
Armstrong Custom Homes
Redmond...
|
2 |
26.09.2006 17:16:13 |
|
|
Time Calculations
Hi
I have a table with a “down time†and an “up time†field. I would like to
get the total number of minutes between the two. The time difference may be
as long as 16 hours but I want it to display just in total minutes.
Thanks in advance for any help with this.
Chuck
...
|
5 |
26.09.2006 17:15:01 |
|
|
Outlook and password
Can someone tell me why Outlook will display a dialog on its own from time to
time asking for a password?
...
|
2 |
26.09.2006 17:08:29 |
|
|
Application.ExportXML problem (sorting)
Hi,
The statement above, generates an XML file.
But there are two problems.
First, it does not work on queries. On queries, it does not error, but
produce zero lines of XML.
Second, when I use a table with a primary key (that should be in effect
automatically) the XML-output, is not ordered. That is, it is mostly not
ordered, but sometimes it is.
1) How can that be fixed that ...
|
4 |
26.09.2006 16:54:02 |
|
|
Parameters - enter once
I have a number of queries that use the same paramater to pull data. The
queries report on or update different items in the database. How can I set
up up so they can enter the parameter once and all queries will use that
parameter when run? I launch all the queries via a macro so right now the
user must enter it (ie: Aug-06) many times while the macro runs everything....
|
3 |
26.09.2006 16:34:02 |
|
|
Utilizing ADOX to add fields to existing table
I need to add some fields to an existing table in the database. I have tried
implememting the following code in a module. But when I run the code I can
step through with no errors but my existing table is not updated with the new
field. What am I missing? Thanks in advance.
Dim cat As ADOX.Catalog
Dim POTotals As ADOX.Table
Set POTotals = New ADOX.Table
Set cat = New ADOX.C...
|
2 |
26.09.2006 16:29:46 |
|
|
Microsoft Access 2000 - File Attachements in records
Hi,
I'm knew to Access and I want to create a simple contact database and I want
to know if it is possible to store files such as word and excel for
individuals on the database, e.g. as a file repository
I hope that makes sense.
Djuro Rnic...
|
1 |
26.09.2006 15:57:01 |