New Access User Needing Direction

Aug 24, 2005

I am a novice user trying to set up a db for small business and am needing a little direction. Most of the company's sales come from the contracted work for remodeling homes; however a small amount of sales are over the counter sales within their showroom.
How do I set up the db to track the following: customer info, contract sales amount & date & payments & balance due, labor costs by employee and sub contractor, materials costs, and net profit from contracted amount vs deductions of costs?
Payments made are directly related to contracted sale and not labor or material costs; with the exception of the over the counter sales. My boss currently tracks the above info in an spreedsheet ... please advise. Any help will be greatly appreciated.

View Replies


ADVERTISEMENT

First Time Access User Needing Help

Jan 18, 2008

Hi
I am a teacher using Access 2007 for the first time.
I have downloaded and created a Student Info database which contains details of nationality, guardian's contact info, etc.
I also have an Attendance Excel Sheet which calculates daily / monthly attendance in its most basic form.
How do I link the cells that show the current attendance of each student to the Access db? Can I link it so that it appears on the db forms / tables / individual student page?
Please advise.
I'd appreciate the coming to me in painfully simple steps.
I teach English and Humanities and am not well versed in computer language ... although I enjoy its challenges and use a lot of it for teaching and administratie purposes.
Thanking you in advance,
Kscape.

View 1 Replies View Related

Query Needing Like And A Place For User To Input

Apr 14, 2008

Okay my access skills are low at best and I'm trying to build a database for work so hopefully this isn't to stupid of a question.

I'm trying to creat a query that will allow the user to type in a work type and have it generate the all records containing that work type. The way the data is in there to get it to generate just a specific work type without the input I have to use Like "*newacct*" for example. Is there any way to do this since there are more then one work types for some records?

Thank you

View 8 Replies View Related

Needing Help With List Boxes - Access 2000

Nov 27, 2007

Hi, I am trying to create a button that upon click it moves the slelected item in list box one to list box 2 but i am not sure how to go about it, cany anyone help?

Dominic

View 1 Replies View Related

A Little Direction.....please

Oct 19, 2005

Basic user here,, I know I have seen what i am looking for on someone elses database but for the life of me I cant figure it out...

I would like for a field to open upon the click of a check box...

ie...

check box: [attrite], if I check the box I would like the field [date] to open in order for me to put a date in it. if the box is not checked the [date] field will not be seen.

is this simple? if it is code could you really explain on how to do it? Can it be done with a form or something different?

thanks for the help

Jake

View 6 Replies View Related

Needing Advice

Aug 5, 2005

Hi Im currently building an Access aplication and Im looking for some advice.

What Id like to do is use a list box which has a list of items in it, once an item is selected and a button clicked for this information to be sent into a text box to then be stored by the database. Each new item should be added to the end of the list.

I was wondering if its actually possible and how you would go about doing it.

Thanks for your help.

View 1 Replies View Related

Newbie Needing Help

Apr 6, 2006

Ok guys, im going to be flat out honest, Im new to this whole database thing. I've been doing a lot of studying and Decided that I am going to try my hands at a real simple and straight foward database. It seemed fairly simple but i guess not so im asking for help. I think my problem lies in understanding how the keys work, and what exactly they do for the database itself. And two the relationships, im not really sure of, i understand how to set them, but again i dont know what they do for the database in the end. Ok so heres what i got:

The object of this DB was to collect, store, retrieve, edit and display data for a fictious Print center that deals with Black & White copies and Color Copies.

3 tables:

Company
Customer
Job

these tables contain:

Company Table:
CompanyID Set to AutoNumber *SET AND PRIMARY KEY*
CompanyName Set to Text
Address Set to text
City Set to text
State Set to text with 2 Character limit for input
ZipCode Set to text with 5 characrtr input
Description Set to Memo
Webaddress Set to hyperlink

Customer Table:
CustomerAccountNumber Set to autonumber *SET AND PRIMARY KEY*
CompanyName Set to Text
JobNumber Set to number
FirstName set to text
LastName Set to text
PhoneNumber Set to text with mask set
FaxNumber Set to Text with mask set
Email adddress Set to text

Job Table:
Jobnumber Set to autonumber *SET AND PRIMARY KEY*
Jobname set to text
Jobtype Set to text
JobDescription Set to memo
DueDate Set to Date and time

Ok now hers the relationships I set up:

Company Table: CompanyID ------> Customer table:CompanyName

Customertable:JobNumber ------> JobTable:JobNumber

I tried and thought this would keep things simple but for some reason when i go to create my querys, i get this thing telling me that i have other data from another tabel and cant be edited, i figured out that i had to put the job in first to get a job number and when i go to enter the customers information i have to manually enter the job number in. (Kinda Sucks) I entered some sample data, and tried to make a form, I used the autoform and created a general form but when I flip to the last record in the DataBase it wont let me enter any new information, I thought i was suppose to do that, so i went to the table properties and set the table to Data Enrty Only, and i still couldnt enter new data.

:confused: Ok so theres my problem, I made a boat with duct tape and now im wondering why im sinking to the bottom. Any help would be GREATLY APPRECIATED and if possible a broken down real world explanation on how the keys and relationships work, and what they actually do for the database. I also probably didnt set up the data in the fields correctly, I was trying to normalize everything but im not sure.

Thanks guys! Im really greatful for any help you can offer! ~[MikE]~ :)

View 5 Replies View Related

Sorry, Noob Needing Help..

Nov 19, 2006

Hope nobody minds but I don't really know Access and I have a table that needs sorting pretty desperately.I have a table with 5 columns that I need to filter out so just the remaing records are left over.http://img208.imageshack.us/img208/7328/untitled1wb8.th.jpg (http://img208.imageshack.us/my.php?image=untitled1wb8.jpg)The column 'fax' is the column with the records in it and the following columns need the record removing if the box is ticked.TimFPS, OurFPS, OnFPS, NeedsToBeFPS, however the column 'NumberWeHave' I'm not too sure about so I'll ignore it for now (I may need to take them out later)Sorry to be a complete noob and if anyone can help it will be muchos appreciated.

View 2 Replies View Related

Newbie Needing Help

Aug 19, 2004

Hi all,
I need to develop a relational database to
track new construction -builders, subdivisions and
employees and additional info about each subdivision.
I want to be able to set it up so that the end user can
click on a drop down list of builders and then have
another drop down list of subdivisions to choose from
when updating or doing data entry.
Any suggestions would be greatly appreciated.
As basic parameters I have around 80 builders with
up to 150 subdivisions. I would also like to be able to use
this in other areas besides mine.

View 5 Replies View Related

A Point In The Right Direction Plz.

Nov 14, 2006

Not sure what this covers so if someone could point me in the right direction, so I can get started.

I want to do a search of customers through a button on a form with names, and there you get a list of customer that match your criteria. When you click or double click on that customer you get sent to the main form with all the customer details on it.

thx
Damien

View 3 Replies View Related

Someone Throw Me In The Right Direction!

Jun 9, 2007

Hello there! Im currently trying to set up a database to hold customer information and how many "hours" they have left in thier account. With a form that you can sign up new customers and minus / add hours to exsisting customers accounts. To be hounst im not really sure where to begin, it will probley sound easy to most of you though :( !I have had previous access expirence whilst doing course work - thats it.Thank Yooh for reading - please help!!

View 6 Replies View Related

A Hint In The Right Direction.... Please :)

Nov 11, 2007

We have a small business selling computer products and now we have a website to sell the products on. We have 3 main suppliers each with a few thousand products and currently I am using a macro (many infact) in excel to combine the current data files we get from each supplier into one file that gets uploaded to the website for import. However we would like to move the whole thing over to access to hopefully speed up the daily process of creating the file for upload. I get similar data from each supplier although obviously the columns arn't in the same order etc and one supplier has info that the others do not but what is the best way to set something up so that it pulls all the products in from each supplier and rearranges the data to fit what is wanted.

I haven't used access before but I have time to put into this to try and get it to work well.

View 1 Replies View Related

A Nudge In The Right Direction Please

Nov 21, 2007

Hello,

I am new to this forum and Access databases in general, me and a colleague have been given the task of recreating our course brochure into an online searchable webpage. The web side of things I am ok with, its just the designing of the database that is causing us both endless problems.

Before I go into more detail about what it is that we need and showing the example Access database we have created so far, can I ask if I am posting this is the right section and secondly can I attach a database to a post?

Many thanks

View 10 Replies View Related

Need To Find A Direction

Sep 7, 2005

I have a Department status report that each of our department uses to determine in which order to process our cabinets. Management would like to create a form based on this report, so that it is listed in the same order where the user could click a checkbox on each job that was completed. When finished this would update our history table with the checkbox date for the related department.

Report example

JobCode Run Lot SpecialColor Completed(unbound checkbox)
GHHT A 131 Y Y
HHTY Z 13 N
FRBG F 23 Y Y

I created a datasheet form that shows this information. I added an unbound checkbox but if you check one, they all check. I want to able to select lot by lot. I guessing at that point I would need to create an update query that would update tblHistory and the correct department date with date() on the ones that were selected.

Not quite sure how to proceed with this one. The special color field makes a difference on where the date goes. For example if the Mill completes these jobs and it's a special color then the date would go to tblHistory.Assembly. If it's not a special color then the date would go to tblHistory.Prefinished. The primary key between the two is DelID.

View 1 Replies View Related

Point Me In The Right Direction

Sep 1, 2006

Dont use access much but I have basic db dev. skills. That said, here's my dillema:

I have a front desk entry form fro service calls. There is a entry field for customerID. I would like to auto populate f_name, l_name etc... from just entering customerID. I know what I would do in an SQL situation, but how does that transfer over to access? Any help would be great. Thanks.

View 3 Replies View Related

Hello! Needing Help With Comboboxes And List, Please!!

Dec 12, 2006

Hi! Let me explain my little problem:confused::
I have in a form two comboxes an a listbox. On the first combobox you can introduce the TAG, on the second one a machine. I need that the listbox show the values of the first and second combobox separated by a comma.

The first combobox= TAG
The second= machine
listbox=TAG machine value together without using the table

If you can help me I will appreciate your information:D

View 2 Replies View Related

General :: Access Multi User Database - Error On Only One User

Apr 24, 2013

I have a multi user database in Access 2000 that is on a server. The individual users have shortcuts pointing towards the server instance. One user and one user only when opening the shortcut gets the error "you do not have exclusive rights to the database" .

All other users can enter the database with no error box. I have checked the advanced setting under options and they are correct. Ironically if you go to start and open access then navigate to the database shortcut. It opens with no error.

View 1 Replies View Related

TextBox Text Direction

Jun 20, 2005

Is there a way to set the text direction in the textbox to be vertical instead of horisental.

Or is it possible to rotate the text box to set it to be vertical instead of horisental.

Thanks

View 2 Replies View Related

Seeking Advice / Direction / Programmer

Dec 4, 2007

Hello,

Does anyone know of an off the shelf application I can purchase to allow users access to my Access database over the web? I have select data I want to allow my customers access to dynamically via the web.

I am familiar with ASP however I am not at a level to develop something from the ground up.

I have access to a Windows Server, an established database and a great desire to get this done.

My vision is to have a daily upload of my back-end (for the sake of current data)to the web server for access via the ASP front end or whatever the case may be.

I am sure to all who read this you understand what I am looking for.

I will definitely entertain hiring someone to work with me on this project if need be. Best case scenario is someone has already done the work and I can just buy it...

Thanks.

Fen How

View 3 Replies View Related

Problem With Needing Duplicating Record Dates

Jul 31, 2005

Help!!!
I am setting up a database with 'open' and 'close' dates of an event for each record/ID. I want to be able to sort/query my results into the next event (i.e. open or close) as it will be happening so that I can plan for each event, but I am not sure how to go about doing this. I have tried various queries but because the information is linked to one ID it does not want to duplicate the information in the record. I can set up separate queries for the 'open' and 'close' dates but I can't seem to be able to tie it together
=>I have 2 queries, but I really need it to be at least in one report in date order each record appearing twice ...once at the open date, once at the closing date.
anyone....please!!!!!!!
:) thank u

View 2 Replies View Related

College Student Needing Help With Lookup Combo Boxes

Mar 9, 2006

Hello people,

I'm not a programmer, I am infact a 17 year old College Student from the United Kingdom - Studying ICT!

For my major project I have to design, build and test a camera loans system for my photography department. Except, I am having problems with Combo box lookups. It's been over 6 months since I learnt this, and it's all a blank. Something as simple as this is simply not working...

e.g. in the Studentloans table, I wish to enter the Student ID number from the student ID card inside the combo box, and hit enter so that it brings up the relevant specific loans of that student.
I enter the id, hit enter and the student name, class etc does not change. Why? The same goes for my Camera Maintenance Table, Camera + Maintenance tables are combined to a CAMERAMAINTENANCE TABLE - Therefore I wish to enter the Camera ID number so that if i hit enter, it brings up the relevant service histories of that specific camera...

The relationships are all ok, the fields for Student ID are lookup, etc.

I don't understand. It's driving me insane. I need help with this, I'm struggling so much.

Help much appreciated.

Thanks - Neil.

View 2 Replies View Related

Vertical Text Direction/Orientation In CrossTab Query

Jan 7, 2007

I am fairly new to developing with Access.

I would really value some advice on changing text direction in crosstab query column labels.

I have just created a crosstab query to function as a training matrix. It has rather long column labels (there are good practical reasons for this), which makes the query very wide and difficult to print one one page.

Is there a way to change the text direction of the column headings so they are printed running up the page?

I know how to change text direction in Word or Excel, but not Access.

At the moment I am copying the query results into Excel and manipulating the text direction in Excel, but this is rather cumbersome.

Thanks in anticipation of any help. :cool:

View 3 Replies View Related

Forms :: Custom Bar Chart Using Rectangles - Control Height Change Direction

Feb 10, 2014

I am trying to make something like custom bar chart on a form using rectangles. I made 4 rectangles (BarBZ, BarBA, BarKI and BarMA) and have the following code:

Code:

Dim PctBZ As Double
Dim PctBA As Double
Dim PctKI As Double
Dim PctMA As Double
PctBZ = Me.BZ / (Me.BZ + Me.BA + Me.KI + Me.MA)

[Code] ....

It works perfectly except... the rectangles grow/shrink downwards and not upwards. As a result the bars are aligned to top, while I would like to have them aligned to bottom.

View 3 Replies View Related

Using Access's User And Group Accounts Or Using A Login Form To Access Database?

Sep 9, 2005

Using Access's User and Group Accounts or Using a Login Form to access database?

I've been researching on how to make a database secure. How to create User and Group Accounts on access, I see the step by step instructions and tried it out myself.

I also saw some sites where they give an example of a Login Form and how to create one.

My question is do you need to create both. First create the users and groups to permit or deny access to certain forms and then have a login form?

But would that mean that they'd have to login twice? Once when the database opens because it activates the db security that was created and then login again in the login form that was created?

Also when the user logins in and clicks on the cmd button on the form which opens up another from, frmWorkLog, I have an Employee field. This field I want it to have the user's name entered automatically and "locked". So that info, employee name, is extracted from the user's login. So then the user can only see his or her records only and no one elses.

How would I go about creating that. Hope I made my explanation clear.

Thanks in advance.

View 3 Replies View Related

Locking User Access To Database Objects (MS Access 2000 And 2003)

Apr 15, 2007

I have two database applications and they are:
- the (A) application is for administration use.
- the (B) application is for normal users use.

the idea is that: I made the (A) application for administrators who have full control over the database objects (tables, forms, queries, and so on ...).

the (B) application I have created for normal users who will have only to use forms to insert some data and display data only.

but the two applications has a respective table called "vacation request" table. where I linked them, so the both administrators and users can share the data.

The real question is that: How can I prevent the users from seeing the database objects in their application. I used the database options which have helped me in hidding the database objectives when the users open the application, but unfortunately they managed to access to the database objects by pressing the special keys.

I would like to have an access to the (B) application when I want to make some modifications to the forms and then lock it from users where they only have to use the forms for requesting vacations and view the vacations.

View 1 Replies View Related

User Access Denied In Access 2000 Runtime

Mar 11, 2006

We have two computers in a work group. On computer1 I have the back-end and front-end database files in the shared folder and 2 users out of 4 can access the database no problem. When the other users try to access the database they receive the error message "Microsoft Access can't Find The Database 'C:Documents and SettingsAll UsersDocumentsdb.mdb' Make sure you entered the correct path and filename" On computer2 I have the front-end database files in the shared folder and pointing to the same back-end database on computer1. Again 2 users out of 4 can access the database no problem. When the other users try to access the database they receive the same error described above.

I expect that this is some sort of windows permissions issue?
There are some clues to this fact ..
The two users that can't access the database are limited accounts, but I tried making them administrators and this had no affect.
Their shared documents folder does not have a hand underneath it?

Any help on this appreciated as it's really starting to annoy me now!

Thanks.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved