|
database design - different possible data types
Hi everyone,
I'm trying to normalise my database, but am running into a problem due
to the field's data type.
Here's a simple example:
tblCables:
FLD. NAME.........FLD. TYPE
cableID .............. autonumber
size ................... string or double
unitsSystem........ boolean
If unitsSystem is "American", then I need to store the size as a
string, but if unitsSystem is "metric",...
|
6 |
21.09.2006 13:46:20 |
|
|
Append database primary key to start at 1
I unfortunately did not do a compact & repair after I deleted data from my
database. So when I started adding more data it started at the previous
data's ID last number instead of starting at 1. How do I fix this so that
the primary key ID number starts at 1. I already entered 150 records before
I realized that the ID numbers were wrong.
Thanks
Pat...
|
6 |
21.09.2006 13:26:02 |
|
|
Updating VBA event code at runtime
Hi
I'm sure this has been asked before, so my apologies in advance for dumb
questions!!!
Has anyone been able to update the VB code for events fired by, eg., command
buttons?
Any suggestions greatly appreciated
Steve
...
|
6 |
21.09.2006 13:03:54 |
|
|
How do I access an access table in delphi
I get a login to access database dialog box in delphi (using the table, data
access control) which promts me for username and password, but I can never
log into access though I try valid username and password?...
|
2 |
21.09.2006 12:01:56 |
|
|
why can't I install updates please?
When I am reminded to install updates by window eg. security update for
Publisher 2003 and Update to Outlook 2003 junk e mail filter, this always
unsuccessful....
|
2 |
21.09.2006 11:55:36 |
|
|
arrange sheets in alphatical order
arrange sheets in alphatical order...
|
2 |
21.09.2006 11:53:36 |
|
|
how do I link a pop-up form to a sub-form
I'm trying to use a pop-up form to input specific comments to a record in a
continuous form sub-form but access keep on giving me #Name? error. The
pop-up is activated by a button in the sub-form record, and I'm trying to
read the fields in the record automatically when the pop-up form display so I
don't have to type in the information again , and so the comment will be
linked to the rec...
|
3 |
21.09.2006 11:29:01 |
|
|
Error - failed to connect to db cannot aquire schema lock?
I am trying to connect to a database created in Access and I am getting an
error message reading "failed to connect to the database, cannot acquire a
schema lock because of an existing lock could not use (the path to the db);
file already in use.
Does anyone know what this means?
Thanks in advance...
|
1 |
21.09.2006 08:23:02 |
|
|
look at a date and return the following sunday
I need to show failures to meet target by week, with the last day of the week
being Sunday. So if a failure occurred on 07/08/06 I need to list it against
13/08/06.
Is there a neater way than If day = Monday add 6 days to date, if date =
Tuesday add 5 days to date?
Thanks...
|
5 |
21.09.2006 08:15:01 |
|
|
Help me Please
Prueba.
...
|
1 |
21.09.2006 07:50:25 |
|
|
Right click menu not showing
I have a shift disable option which works just fine. If I open the database
with the shift key pressed, I get the right click menu. If I don't have the
shift key pressed, I don't get the menu.
What could be going on?
cheers in advance....
|
3 |
21.09.2006 07:46:02 |
|
|
Can't change Primary Key; no relationships in diagram
Hello --
My problem occurs in a backend mdb.
Appending to a table has started to reject rows, giving the reason as
"...key violation...".
For testing I want to remove the PK.(on a single column).
In table Design View I get the message
"You can't change the primary key.
This table is the primary table in one or more relationships."
I removed all the relationships in Tools > Re...
|
3 |
21.09.2006 05:18:20 |
|
|
Who playes rune scape
Whats ur user
...
|
2 |
21.09.2006 05:16:53 |
|
|
Every time I type ACN it changes to something else, Help?
Everytime I type the letters ACN they change to CAN. Can someone tell me how
to fix it. I try to add it to the dictionary but it doesn't work. Thanks...
|
4 |
21.09.2006 05:15:00 |
|
|
Provide centre & middle alignment for controls on forms & reports
This is such a basic design function in most graphics - why can't it be done
in Access?
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsr...
|
2 |
21.09.2006 05:13:01 |
|
|
Please help changing the way this report is filtered and opened...
I am new to the filtering the report from a form concept. In my current
code the report must be open to apply the filter. I would like to
change it so that it runs the filter while the report is closed and
then opens the report. Can someone please explain how I should modify
the code?
Here is the current code:
Private Sub Apply_Filter1_Click()
Dim strRCName As String
Dim str...
|
3 |
21.09.2006 05:01:50 |
|
|
Verfication of user entered data
I have searched but am still lost. Heres the issue: My database
tracks employees by what station they are working on a given day.
Because I have upwards of 800+ employees (and no IT dept) my main table
is Personnel which contains all relevant personal data. I had to
create a UserID for each employee that consists of LASTNAMEFM (where F
and M are the first and middle initials). I figured o...
|
9 |
21.09.2006 03:22:59 |
|
|
Displaying date from a filter (via form)???
I have a form that uses a filter to filter a report via critera from a
form and a Start date and end date are 2 of the fields on the form.
How do I display the date on the report that the person entered via the
form to filter the report?
...
|
2 |
21.09.2006 02:45:44 |
|
|
Filter problem in report
Hi all
I am trying to filter the report based on the combo boxes in form,
using the following code
Me.Filter = "LocationName = " & LocationName & " AND " & "ParameterName
= " & _ ParameterName
DoCmd.OpenReport "rptResults", acViewPreview, , Me.Filter
but when I press the button and report opens it asks for the 'Enter
Parameter' both both fields.
Interesting thing is that it asks for '...
|
4 |
20.09.2006 23:48:46 |
|
|
Problem with Security
I am working on a database that has security enabled. I cleared the password
for the "admin" user, and now the security has been disabled. It no longer
askes for the username, and it won't let me import the forms and queires.
What have I done?
I can redo all of the queries, reports, forms, and switchboards, but I don't
want to have to do that....
|
2 |
20.09.2006 23:22:54 |
|
|
Problem with Mail merge
I have an access database that I want to mail merge with word, but when I try
to do it says that I don't have sufficeint permissions to do it. The database
has security enabled, and it worked before the security was enabled....
|
2 |
20.09.2006 22:58:08 |
|
|
Disable custom menu item
How do you disable a custom menu item with VBA? I have several menu items
(pull down type) like File, Edit, and Help etc… I need to disable some of the
items under these menus based upon security level.
Thanks
Mike Robinson
...
|
3 |
20.09.2006 22:56:52 |
|
|
Auto populate field
How would I code, say, Field2, such that on entry
If Field1 is not null Then
Field2 = previous record's Field2.Value
Else Exit Sub
I don't know how to refer to a previous record's field's value......
|
2 |
20.09.2006 22:55:20 |
|
|
Fill email field based on hypertext www field
I noticed a correlation between www.mycompany.com and Emails
contact@mycompany.com
I would like to pass @mycompany.com to Email field in tblContact, from Web
field in tblCompany
Users should be able to fill the blank Email field with a button before
typing just john.smith or ignore it and type the whole Email
Field Web is Hyperlink
tblCompany and tblContact are linked with a one-to-man...
|
1 |
20.09.2006 22:22:01 |
|
|
images as OLE objects
on 2 computers, in ACCESS2000, when I try to insert same images (JPEG format)
from a file on c:drive into a table (OLE object field), it works OK on one
computer, but not on the other (instead of the image, the word "PACKAGE" is
inserted). Double-click on the image displays it in Microsoft Photo Editor
(the one that is OK) and in Windows Picture and Fax Viewer (the one that is
not OK - h...
|
6 |
20.09.2006 21:54:10 |