Tables question
I am very very new to access and I am trying to create a DB from an Address
Book. My question is:
Is it better to create one Address Book table with several address types
(customer, v | | 4 | 46 | 11/11/2009 5:58:28 AM |
Query Question
Hi,
I need someone to set me in right direction in my attempt to make this Query
By Form work. This is what I have now. I have a Query that works fine. Except
I want to use the Query | | 5 | 39 | 11/11/2009 3:31:15 AM |
Forms
Hello,
I have created a switchboard (not using the built-in tool). Works like a
charm. But recently I have been banging my head against a wall trying to
figure out the following. | | 2 | 49 | 11/11/2009 2:39:26 AM |
Trying to average a parameter for each month of each year
I have a set of chemical parameters (pH, EC, Ca, Mg etc...) which I am trying
to get averages of over each month and year they have been sampled for (data
is from 1995 to now with multiple | | 4 | 41 | 11/10/2009 4:46:49 PM |
Multiple selections from forms
I have searched through many responses to what appears to be my query, but
still cannot find a suitable solution.
I am trying to create a database to consolidate standard risk assessm | | 5 | 40 | 11/10/2009 4:33:01 PM |
export query result from Access 2003 to specific cells in excel 2007
Hi ,
I'm trying to create a dashboard using Access 2003. Being a newbie I
would request your help.
I found some codes in the net but not fulfilled my needs (I might not
have | | 0 | 47 | 11/10/2009 1:43:18 PM |
Populating
Hello,
I'd like some help figuring out how to get the following scenario to work as
my efforts are not successful so far.
I have 2 subforms based on tables. One for schedul | | 0 | 51 | 11/10/2009 10:12:56 AM |
How do I resize a JPG so that it fits in a MSFlexGrid cell?
I just don't know the Methods to use.
| | 0 | 51 | 11/9/2009 11:07:02 PM |
Problem Loading and sizing images
I want to load a series of images, resize them, and display them in a
MSFlexGrid.
I've got MSFlexGrid displaying images as follows:
With Me.flxGalleries 'the MSFlexGrid
| | 3 | 42 | 11/9/2009 9:28:09 PM |
Linking 3 tables with common data
I have three tables Project, O&M and Submittals. The common item is Project
Number. I want to link the three tables to the same project number.
I am having a hard time getting this to w | | 8 | 42 | 11/9/2009 9:21:02 PM |
How to add calculated field to forms
I wold like to add a calculated field to a master/sub form.
--
Thank you, Jack
| | 5 | 54 | 11/9/2009 9:09:02 PM |
Simulate holding the Enter key down
I have a form that generates random numbers. If I press the command button
once I get a random number, and that works great. But I have noticed that if
I hold the Enter key down the random | | 6 | 40 | 11/9/2009 6:25:04 PM |
is access capable of building a cost calculator?
i currently have a rather complex series of tables in excel and of course a
really rough looking form due to excels limited capabilites, i am interested
to know if i could successfully bui | | 4 | 42 | 11/9/2009 5:50:29 PM |
Query By Form Null Value
Hi,
I have a Query By Form with several User Input Boxes. One is for a number,
that I enter into the box. What I would like to do is, when I leave the input
box blank for that column, I | | 3 | 50 | 11/9/2009 5:31:39 PM |
Moving Label only and not box associated with it
I have an attachment on my form and the 'Picture label' needs to be above,
and not next to, the attachment box. How do I seperate them and or keep them
from moving simutaneously. I kknow i | | 6 | 49 | 11/9/2009 5:09:12 PM |
is access capable of building a cost calculator?
i currently have a rather complex series of tables in excel and of course a
really rough looking form due to excels limited capabilites, i am interested
to know if i could successfully bui | | 2 | 44 | 11/9/2009 1:15:01 PM |
Use a combo box to find an Employee
Hi,
I’m trying to identify a route driver based on the route number the location
& the time the route was at the location.
I have many routes with the same number (i.e. 100, 200, | | 1 | 39 | 11/9/2009 4:53:41 AM |
Research project: one database or several
I'm a bit of an Access novice and, although I've had a wee root around these
posts, I apologise if the answer to my question is already there somewhere.
I'm working on a database to h | | 1 | 47 | 11/9/2009 3:53:01 AM |
RunCommand acCmdImport
When I use RunCommand acCmdImport in 2003 is very well, but in 2007 is not
good.
How do I change it .
thank you very much.
| | 0 | 41 | 11/9/2009 3:40:01 AM |
Membership Roster with Picture
I am a rank beginning and I need to create a roster of our volunteers,
including their picture.
I have the table set up and the form, but I'm having a great deal of
difficulty inser | | 4 | 41 | 11/8/2009 10:18:04 PM |
Security warning
Hi Group,
This is probably a windows question but here goes anyway.
Win xp access 2007.
I have several computers that do not have Access installed.
They do have Microsoft Access R | | 12 | 42 | 11/8/2009 9:07:37 PM |
How do I change the properties of a field
A form called "Home Base" is linked to a "Patient extended" table, the
default view is single form. I made 2 subforms : one linked to "Patient
extened" and one | | 12 | 41 | 11/8/2009 12:36:46 AM |
Tables
Is there a function in Access which would allow field names in a table to be
created based on user input?
| | 6 | 61 | 11/6/2009 7:36:43 PM |
I'm trying to delete 1 note so printer will work
My tech person added 1 note to my computer with-out me knowing it. Because of
it I can't get my printer to work anymore. How do I delete 1 note?
answer to "thewalrusclub@gmail.com&q | | 2 | 39 | 11/6/2009 3:44:01 PM |
Word 2003
When I push ALT J, I want my cursor to automatically move to the next *
symbol in my paragraph, so I don't have to keep inserting text with my mouse.
Can anyone tell someone who is not very | | 1 | 55 | 11/6/2009 3:41:58 AM |
Help with count function
Hi there, thanks in advance for any help, and apologies if this is a question
from the dumb kid at the back of the class.
I'm trying to get to grips with Access and so am designing a | | 8 | 56 | 11/5/2009 6:56:48 PM |
change delimiter in access functions
I want to change the delimiter when writing functions in Access. I now have
to use a semicolon instead of a comma. I think it is because Access "knows" I
work at a Swedish computer | | 1 | 48 | 11/5/2009 4:57:19 PM |
Displaying zeros (0) in contact information
Hi,
In Ireland phone nuymbers usually start with 0857103245 or 0909627457 i.e.
prefix is a 0.
I'm trying to design a form which requests contact information to be entered
into a data | | 2 | 44 | 11/5/2009 3:29:47 PM |
Combine queries
I have the following three queries - qry 1 & 2 are called by qry 3 and
joined. If I combine them into one query it takes forever. Can
someone please suggest a simple way of combining the | | 13 | 50 | 11/5/2009 3:47:18 AM |
Calendar & Access 2002
I have a form with a [Date] field. I have a Calendar Calendar on that form.
When the user clicks a date on the Calendar, I want the [Date] field on the
form to update. Right now, they m | | 3 | 56 | 11/4/2009 7:20:24 PM |
29 Hosting Web www.ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Host | | 0 | 101 | 11/4/2009 11:50:18 AM |
how do I apply a footer in access
I'm using access and would like to add a footer containing my name
| | 3 | 60 | 11/4/2009 5:51:38 AM |
DLookup or similar function
I need to return multiple values into a single field on a form based on
criteria that identifies the correct values to be returned. For example: I
have suppliers which ship to mulitple st | | 3 | 65 | 11/3/2009 8:42:01 PM |
How would I remove all data from northwinds template.
How would I remove all data from northwinds template.
| | 9 | 50 | 11/3/2009 8:00:20 PM |
New database
I am completely new to Access and databases in general. I am creating a new
table, the first field of which needs to be an AutoNumber, but it needs to
start at 10001; eg first AutoNumber gen | | 5 | 43 | 11/3/2009 4:50:39 PM |
Pivot Table
I'm very new to Access and I am starting to use Access 2007. I have a Pivot
Table I need help with. I have 450 employees, some active some non-active at
several locations. My Pivot table | | 2 | 43 | 11/2/2009 5:31:02 PM |
I need a message to pop up
Hello,
There is a text field in a form in which numbers are entered. If the user
enters over 8 digits I want a message to pop up saying "OVER 8 DIGITS" if
the user ent | | 4 | 47 | 11/2/2009 2:03:43 PM |
Fill fields automatically on Form
I have a table with fields - Financialcompany and companydescription, which i
use in a form to update another table with the same field names. I have used
the following code on the exit even | | 4 | 44 | 11/2/2009 4:52:01 AM |
Can't edit templates
I downloaded the "issues" template. Nothing works like the tutorials say. I
can't add columns. I can't add fields-gives an error message saying someone
else is using the file. T | | 2 | 52 | 11/1/2009 6:37:13 PM |
Just beginning !
I am Very very new to Access. Where I would like to start would be with a
tutorial, but I have no idea of even that. I can say I am very good with
excel (even teh math functions, etc), wor | | 2 | 177 | 11/1/2009 2:25:01 AM |
Export Query Question
Hi all,
If I open a database window and select "Queries” then scroll down to a query
called qContacts. Then right click on the query and select export, I change
the Save as typ | | 1 | 49 | 10/31/2009 9:12:04 PM |
Access developer and run time
Currently my dbase is a access 2003 that provides a data access page to other
user on my site to view only info. We are moving to access 2007 [that does
not support data access pages unless | | 0 | 50 | 10/31/2009 4:07:01 PM |
?find rows where penultimate digit in a 9 number code in a column
As part of a research project I am looking at a database of approximately 33
000 people in microsoft access 2003. One of the columns is a 9 digit code
(all numbers). I need to select all peo | | 6 | 41 | 10/31/2009 12:41:16 AM |
Query for record count - all tables
Can someone help me with a query that would give me the name and number of
records for all tables in a database?
THANKS!!!!!!!!
--
GD
| | 4 | 48 | 10/30/2009 7:26:02 PM |
Default values in Report
I have a report that I will like the default values in some of the fields to
be 0. Please help
| | 2 | 55 | 10/30/2009 3:44:07 PM |
IF STATEMENT
I am trying to set up a field in access that is dependent on another
field.
current field in my table are "Amt" and "D/C"
I will like to add a field that say | | 6 | 48 | 10/29/2009 6:37:01 PM |
how do I add cost of item, resale price, etc in access template?
I downloaded an Access Database for Inventory. I want to add the cost of
each item, total $ we have in item on stock, total resale value. Help.
| | 1 | 38 | 10/29/2009 5:45:14 PM |
Contacts already in use by another person?
I am new to Access and have done a few "tests" with my database. I deleted
the files and when I went back in to create a new Contact file, I get a
message that says: You can't mod | | 1 | 52 | 10/29/2009 4:24:01 PM |
conditions in where; the order
Hi,
I'd like to know which condition in where part of sql will be considered
first. I'd like to optimize sqls.
For example: select * from table t where condition1 and condition2 and
| | 5 | 48 | 10/29/2009 3:27:08 PM |
Updating information
I have a table of names and addresses that I send out yearly for apartment
inspections. I update it according to when they pay,when its sent out, when
its inspected, if it passes inspection | | 2 | 45 | 10/29/2009 2:30:26 PM |
open webpage
I work on a site on daily basis. I want to create a button on the desk top to
open the website. I know by shortcut I can go to the site but I need one
Button
Khusro
| | 1 | 50 | 10/29/2009 11:12:44 AM |
Closing a Bound Form without Saving to the underlying table?
Is it possible to close a form with fields bound to a table, without saving
any data that is in the fields on the Form?
I've tried using acSaveNo but the data still gets saved.
| | 3 | 52 | 10/27/2009 6:59:15 PM |
Exporting a pivot table using a macro
How can I set a macro to export a pivot table from Access to Excel? I have
tried exporting the table (not pivot) and doing the pivot in Excel, but I
can't get the format the same as it is w | | 0 | 46 | 10/27/2009 6:21:01 PM |
Code for check dupes not working
Hello!
I put this into the AfterUpdate event of the EmployeeIDfk combobox on
the continuous subform.
(I have Date and Event on the mainform, and then select Employees on
the | | 12 | 42 | 10/27/2009 12:11:54 AM |
how do I add cost of item, resale price, etc in access template?
I downloaded an Access Database for Inventory. I want to add the cost of
each item, total $ we have in item on stock, total resale value. Help.
http://office.microsoft.com/en-us/template | | 1 | 36 | 10/26/2009 10:31:02 PM |
Sorting
Hi,
I need to resend letters according to the date they were originally sent
out. They are all in a database under "date mailed" How do I sort them so I
get only October? | | 3 | 53 | 10/26/2009 6:19:32 PM |
Setting Field Focus after Function Call
I have a Color picker to lookup color numbers to be kept in
fields - I give access to the Color Picker via a button, whn
the user has selected a button I would like to be able to
place | | 2 | 44 | 10/26/2009 5:23:02 PM |
Error when opening control
I have designed a Data Base, which opens to the MAIN MENU. When any of the
controls are clicked from the main menu, the following message appears:
"The expression On Click you entered a | | 1 | 47 | 10/26/2009 3:59:23 AM |
networking and office 2007
Can I access Office 2007 through my home network.
My preference would have been to reinstall it on my new and now main
computer rather than accessing it on my old one, but, I do not have | | 5 | 51 | 10/26/2009 12:59:21 AM |
Adding days to a date.
I'm trying to learn Access on my own...
I'm wanting to make a simple database to control a calibration schedual.
I have a table called Device with a tab called Freq.
I have another table c | | 2 | 54 | 10/25/2009 10:41:12 PM |
Can I filter a subform combo from a textbox value on form
Is it possible to filter a subform combo from a textbox value on the main
form. I have looked through the Access forum but have not found any help. If
this can be done can the answer be as s | | 2 | 53 | 10/25/2009 3:24:01 PM |
Can I run code automatically between each Field being selected ?
I have some code that displays various shapes in various sizes
depending on field contents on a form - where would I put this
code to fire automatically as each field is changed/updated ? | | 4 | 51 | 10/25/2009 3:22:30 AM |
Form Event Property - Insert New Record
Is there a Form Event Property that can be used to detect if the user clicks
on the Insert New Record Navigation Button?
| | 5 | 52 | 10/24/2009 11:14:06 AM |
Tables
I am attempting to build a equipment maintenance database for a construction
company. I need to be able to pull a report that shows every part for a
piece of equipment. I would like to be | | 1 | 54 | 10/24/2009 2:09:03 AM |
Which Field is Selected ?
Using VB I am allowing the selection of a color from some
color picker code. I want to use a single button to allow
access to the color picker so I need to able to tell which
Field I ne | | 2 | 43 | 10/23/2009 11:19:54 PM |
Convert HTML Color code to Access Color Code
I have HTML color codes stored in a DB - like '0000FF' (I
don't store the '#').
I want to set the Box.BackColor fill color of a rectangle to
the HTML color in an access database (re | | 3 | 44 | 10/23/2009 11:17:22 PM |
howdoiregisteronlineforwindows7
| | 1 | 50 | 10/23/2009 9:09:43 PM |
Isolating Info
Newbie working on Access 2000 here. I am working with a mortgage broker,
trying to establish a database. I created fields to indicate if the contact
is a borrower or a co borrower. When I | | 5 | 51 | 10/22/2009 10:44:36 PM |
access 2003 to 2007 self made menubar conversion
recently switched over to access 2007. I have made a program in access 2003
with a general homemade menubar. When I loaded the program in 2007 my 'old'
menu bar was visible undr the tab 'inv | | 1 | 42 | 10/21/2009 8:08:07 PM |
transferring files from old pc to new and replace harddrive?
I have a Dell Dimension 8100 with a Vista Home Premium 32 bit Oerating system
and some additional software programs.
-I would like to transfer some files to my new Dell PC with a 64 bit Win | | 2 | 45 | 10/21/2009 7:28:15 PM |
Automatically set screen resolution when opening MDB file
Hi,
What can i do to set the users screen resolution automatically when opening
a MDB file to ensure that the forms does not cutt of. I know the procedure to
set the screen properti | | 2 | 43 | 10/21/2009 6:52:11 PM |
New to Access and need a little help getting started
I'm playing around with Access 2007 and I'm starting it off with creating a
password database. I created two tables. One table is a client table that
has only two fields. The first field | | 6 | 38 | 10/21/2009 7:30:01 AM |
Create database and form for patient records
I need some help, i am a beginner when it comes to Access but have worked a
lot with Excel.
I want to create a database and forms/reports to use in a small scale
veterinary recepti | | 9 | 45 | 10/21/2009 12:29:16 AM |
Oops! Didn't check "Save password" when linking tables. What now?
I'm a newbie, using Access 2003 to pull data from an ODBC data source. When I
initially linked the tables using the Link Table wizard, I didn't notice the
"Save password" checkbox | | 3 | 42 | 10/20/2009 8:55:12 PM |
Query 2 Return Negative/Positive Values
I am quite new to access and have yet designed the following query:
SELECT DISTINCTROW Accounts.[Account No], Accounts.Account,
Sum(Transactions.Amount) AS Balance
FROM Transactions | | 1 | 44 | 10/20/2009 12:34:29 PM |
percentage calculated shows in form, but not in report
Hello,
Being new to Access, we are trying to make a field in the Report show a
calculation (defects/rejects).
This was usually calculated by the user, then typed into the database.
We | | 2 | 47 | 10/20/2009 12:51:52 AM |
HELP: update access from excel userform
Hi all,
Is is possible to update access table from an excel userfrom even if the
user inputing the data in userform doesnt have access installed on their
machine?
For eg, t | | 2 | 48 | 10/19/2009 8:38:02 PM |
Access forms as a window
Hi All,
New to Access .. so please bear with me.
I am trying to make a form .. so far so good ..its got all the data I
need. I just cannot see to make the form a window. In other | | 3 | 54 | 10/19/2009 7:41:23 PM |
Calculation between records
Hi,
A few months ago I asked a question on this forum and some very nice people
responded (Thank you). Unfortunately I now can't find the thread on the forum
and have to ask the question | | 2 | 53 | 10/19/2009 5:18:02 PM |
multiple records on the same form
I Have created a form f_hours that has multiple records of different types, i
am a paramedic for a large metropolitan city, the data i enter is shift code,
shift start date, vehicle used, pa | | 3 | 37 | 10/19/2009 11:59:21 AM |
IIF Function
I have the following in a text box ia Report which is returning an Error:
=Trim("Dear" & " " & IIf([pref]>0,[pref],IIf(InStr([firstname],"
")>0,Lef | | 2 | 54 | 10/19/2009 5:31:01 AM |
how do i turn on my cookies on a imac so i can get my gmail.
how do i turn on my cookies on a imac so i can get my gmail.
| | 1 | 43 | 10/18/2009 11:37:57 PM |
Not a new user
Not a new user, I get the boxes to post, however when I do post it, I don't
see it listed nor do I get replies. I don't get it. I have been successful
before and I have tried multiple comp | | 3 | 51 | 10/18/2009 3:43:01 AM |
Problem(s) with DLookUp
I am having problems getting DLookUp to work when variables are
involved. The following expression works fine; until I try to
substitute the variable SVID in place of the number 332?
| | 7 | 39 | 10/17/2009 9:40:47 PM |
First Names
I have a text box on a report as follows:
=Trim([Titles] & " " & [Firstname] & " " & [Lastname])
The problem is that sometimes the Firstname field contains | | 3 | 56 | 10/17/2009 4:10:56 PM |
how do you get rid of hp recovery icon comming up
| | 1 | 37 | 10/17/2009 12:13:52 AM |
How we create Telephone Directory in Access 2007 with sorting ?
Hi , iam a new user access 2007 any body tell me how we create telephone
directory in access 2007 using user picture and sorting form .
| | 3 | 48 | 10/16/2009 11:40:43 PM |
If then code for empty combo box column
I have an order form with a combo box which contains a list of customers.
The combo's source is a query which provides an alphabetized list of
customers joined to the orders table.
| | 4 | 42 | 10/16/2009 7:46:17 PM |
Importing large numbers as text
I'm trying to import a text file containing an invoice # field into a table.
This Inv# field needs to be formatted as text, because some of the invoice #s
contain letters & numbers.
| | 1 | 43 | 10/16/2009 7:24:01 PM |
Unable to enter data in Access 2007 database on a network
I have an Access 2007 database on one PC on a network.
If I open the database from a second PC on the network, it is made Read-Only
and I cannot enter or update data.
If I create a datab | | 2 | 44 | 10/16/2009 2:57:01 PM |
fit to screen
Hi, I am a new user trying to make my report fit to the screen. I have a
multi report that i have dragged four different reports to make one report.
My problem is i know that i have alot | | 3 | 55 | 10/16/2009 2:26:07 PM |
Library references
Please, will somebody help me with this. I have been struggling with this
for over 2 weeks. I posted it under Macros but with no success.
I have recently updated from Microsoft 2003 | | 1 | 58 | 10/16/2009 2:25:09 PM |
can access do this?
I'm a beginner with access, but i'm setting up a database at a real estate
agency, to make things paperless. -not an easy task, especially since i am
only starting with access.
my p | | 1 | 54 | 10/16/2009 1:34:50 PM |
How do I find the ID of the Last Record of a Table?
I have a table in which the ID is NOT 'autonumbered'(no repetitions) and
I want to find out what the last ID used was so I can increment it in
order to add other records. By 'last record', | | 5 | 41 | 10/16/2009 1:14:25 AM |
Automate Access table actions based on Filesystem resources?
Hi again everyone. I really appreciate the help i've received in this forum.
As I've mentioned, I'm new to Microsoft development, but I am interested in
using Access (an the other MS Offic | | 10 | 37 | 10/15/2009 9:41:01 PM |
unable to enter data in Access 2007 database on network
I have an Access 2007 database on one PC on a network.
If I open the database from a second PC on the network, it is made Read-Only
and I cannot enter or update data.
If I create a datab | | 2 | 51 | 10/15/2009 8:46:20 PM |
Date Range Prompt
Hello,
I have a query in which I have a prompt on last day. For some odd reason
when I enter in any range containing the date 10/1/09. I don't get the full
range of data however, wh | | 4 | 42 | 10/15/2009 4:35:18 PM |
Appending data to linked tables
I needed to create a routine to append 4 linked tables with 4-30
records ... Using 2007.
I have written some VB code and am looking for some basic starting code.
The program already exis | | 7 | 46 | 10/15/2009 12:20:35 PM |
The best way to search for a specific record ID?
I want to search an existing (access 2007) table (SiteTBL) for a record
that contains specific text (such as "SD-125") in one of the text
fields. When I locate the specific record | | 4 | 39 | 10/15/2009 3:50:22 AM |
Product Key registration. Did not receive
I downloaded and installed free trial but did not receive product number to
register. Please help
| | 1 | 45 | 10/14/2009 1:04:22 PM |