So Im Making A Simple Database....

Nov 14, 2006

Ive just started creating the table..and Ive put fields like name/address etc as text but there are a few fields that need you to select an option...so i want to use the "lookup wizard" to create a listbox or combo box dont know which is best.. BUT the problem is when I select lookup wizard it says "unable to start lookup wizard. The lookup wizard doesnt apply to fields of this data type".

Why does it say that?

View Replies


ADVERTISEMENT

Need Help On Making An Expression (Simple)

Dec 28, 2006

OK, I have 3 fields in my table: First Name (FNAME), Middle Name (MNAME), and Last Name (LNAME). The table is named EMPLOYEES and I need to make an expression that will give me an employees full name (LNAME, FNAME MNAME) in that structure.

Now I created a new Query which included the three names, but I cannot figure out how to do the expression for the full name, it keeps giving me errors.

I tried using the builder and doing basically:
[LNAME] & ", " & [FNAME] & " " & [MNAME]

That gave me an error saying it contained incorrect expressions or something. I also substituted + for &, and "AND" for &, and still got those errors.

I only have one report where the name format needs to be like this, and thought I could use a simple query to collect the data and format the name. If anyone can help me it would be greatly appreciated.

Thank You!

View 3 Replies View Related

Making A Form So Its Not A Whole Page. Must Be So Simple

May 5, 2005

i have created a form based on a query and basically the form comes up as a whole page spread and i would like it to just come up as a small form instead of a whole page. i think i go into properties and then choose the actual form but i just need to know how to make it so its small.

Hope this explanation is adequate

Thanks

Nicholas

View 2 Replies View Related

Making Stock Database HELP!

Nov 2, 2005

I am looking to design a simple stock database for work. This is just an idea at the moment, unless I can get my head round this problem.

I have throught that I can have 3 tables

NEW STOCK(this is where you enter all new and existing stock is)

USED STOCK(this is where all the stock that has been sold used for whatever reason is entered)

ACTUAL STOCK(this is where the items in NEW STOCK have the items sold in USED STOCK deducted from them to give you the ACTUAL STOCK)


PLEASE HELP ME, am I completely on the wrong line or can I do this?
Would be good if I didnt have to use SQL, VBA etc...

View 2 Replies View Related

Making A Front And Back End To My Database...

Jun 5, 2006

I need help making a front and back end to my database. How should I do it!?!? All I know is what I should put in the front end and what goes in the back end. The rest needs to be explained to me somehow...

View 3 Replies View Related

Making A Enduser Version Of The Database?

Mar 23, 2008

How do I make my database so only the creator (myself) can edit the tables, forms etc and other users see an interface starting with the switchboard, which they can't use any database tools except what the forms allow them to do?

Basically some kind of user permissions.

Thanks.

View 7 Replies View Related

My Audit Trail Is Making My Database Too Big

Aug 9, 2007

Hi,

I have discovered a problem with my database and wonder if anyone here can point me to the best solution...

The problem is this... when I took our company database over about 3 years ago it was around 45MB... now it is almost 350MB and growing steadily.

I have today discovered the main cause of this... the audit trails on a couple of the tables. If I remove these 2 fields only from the database it cuts it down to under 100MB. The Audit trail is quite important for us and so I'd like to keep it if I can. It is stored in a memo data type (the data is well over the 255 char limit of a text box). Is there any other better way to store this data or is there anything I can do to reduce the size of the memo data type?

Any advice would be greatly appreciated!

View 2 Replies View Related

General :: Making Database Executable For Others

Mar 15, 2015

If you make your database into a executable file to package it, does the other person you are sending it to have to have or own Access to use it. I was under the impression that I could create a database, package it as its own program and give it to someone that does not have access and it would still work? If not, how would I do such a thing.

View 4 Replies View Related

Making A Template Out Of Existing Database?

Apr 28, 2012

We have a shared personnel access database for our department. Another department is wanting to use the same database. Is there a way to go about deleting all the info and making a template to give the other dept to use?

View 5 Replies View Related

Making Daily Backup Of Database?

Oct 29, 2013

As my database is growing and hold more and more data i want to make a daily backup to the local hard disk (it works on a network now) automatically.The way i want it to work is as follows :

When a user quits the application i want to check if there is a copy already existing with the date of today.

If it does it skips the copy process and just quits.

If it doesn't, i want it to make a backup in a directory. if the directory doesn't exist it must be made.

The backup file name must hold the date of today off course.

I realize that i have to have a procedure to delete obsolete (outdated) backups as well, but ill worry about that later.

Off course Ive tried this a few times, otherwise i wouldnt ask it here. But i seem to fail every time..

View 5 Replies View Related

General :: Making Access Database Accessible Via Net?

Dec 6, 2012

there is a need to make access database (access 2007) accessible over net. I know Access Database is not web based application. So I want to know if there is any way of making it accessible via net.

View 1 Replies View Related

Beta-testing A Database While Making Improvements?

Jul 23, 2015

I need to start using the database I've created (desktop database). However, I don't want my current version to be the final version.

Should I create another file to work in and use the old version for data entry? When I am ready to start using my new version, is it easy enough to transfer all the data from the old?

View 3 Replies View Related

Making Daily List Of People From Database?

Feb 14, 2013

I have created a database of club members in Access 2010. Each day I need to generate a report of who comes to the club. Up to this point I have been using an Excel spread sheet of members that I copy and paste to new daily spreadsheets each day. how to do this.

View 5 Replies View Related

Database Creation And Testing Complete / Will Making It ACCDE Clear Everything Except Forms

Feb 7, 2015

I've created and tested my database. What step or steps do I take now to make it so it's a program that only shows the forms and menu's I created, not all the Tables, Queries etc and the formatting options? Is there a link that explains what to do step by step?

View 2 Replies View Related

Simple Database

Oct 7, 2006

I want to create a simple database which relates customers to all products in a category.

I want to be able to run a report that shows: Customer, what categories he buys from and the relative products from this category.

e.g If customer A uses products from category 1 & 2 I want the report to show Customer, Category and any products related to that catgeory.

I have three tables: Customer, Category & Products.

Please help?

GordyM

View 1 Replies View Related

Simple Database

Jun 8, 2007

Hello. I am trying to create a database where I can enter contributions from members of my church, in order to give them report at year's end. We are small number, about 70, but we collect offerings every Sunday. I tried on my own, but did not achieve much. I searched about many-to-many and many-to-one, but still don't get it right. Can someone help me with the simple structure and I do the rest? I use person's information (name, etc), amount given and date of offering.
Thanks in advance.:confused:

View 5 Replies View Related

Simple Timesheet DATABASE

Jul 10, 2007

Hi, Guys

I'm building a simple time sheet database for a friend of mine.

I know that im going to have trouble checking there amount against the tax table and taking there tax out to finalise the amount they would actually get.

So basically im an intermediate access user, how would i get the database to do this when i press like a calculate tax button..???

Cheers
Tristan F

View 1 Replies View Related

Simple Tracking Database

Dec 6, 2007

Hello,

I am trying to figure out how to setup my tables. The tracking system i am trying to create will have these information:
the Tables will contain these information

- Package number
- Received date
- Sent date
- How long have we had the package
- Status (Sent or Pending)

I will also need to figure out who received and sent the package
- Employee name

Please advise if I setup the tables correctly.

I will also need to query these info:
- all packages received 3 days ago
- how many packages an employee received and sent
- How many sent or pending

Thank you for your help.

View 8 Replies View Related

Queries :: Making Bird Count Database - Data Recorded On Monthly Basis Week Wise

Feb 21, 2014

I've been requested to make a bird count database.

The bird count data has been recorded on monthly papers like this:

[bird name] [week 1][week 2][week 3][week4]

The number of birds sighted for a given week is written in the [week x] columns.

What I need to do is make another column that shows whichever number is highest from columns [week 1], [week 2], [week 3], [week 4].

So for example:

Blackbird: Week1: 4, Week2: 2, Week3: 6, Week4: 2

highest: =6

View 5 Replies View Related

Simple Login Form With Database

Oct 5, 2005

Im not that expert in access programming, still have some more learning to do. anyway, my goal is to make a simple login form with a database of its users. How do I code it. The structure of my form is it has 2 unbound txtbox and 1 command button. A user will input its username and password then when the command button is clicked it will validate the user table if the data encoded is in the database. Thanks hope u can help me.

View 5 Replies View Related

General :: Create A Simple Database?

Aug 27, 2014

I want to create a simple database so that I can enter childrens names and then add dates to these that they will be attending our Breakfast Club. Out of this I want to be able to create a daily register of children.

View 2 Replies View Related

Table Design For Simple CONTACTS Database

Aug 20, 2005

Hello All,
At work we have a large and messy Contacts list so I decided to set one up using a database.
At present I have 3 tables:-
Companies (custID,companyname,address,etc)
People (nameID,firstname,middlename,lastname,custID)
Phones (phoneID,phonetype,areacode,number,?????)

My problem is this, Some of the phone nos belong to the individuals
and some belong to the company. If a person is replaced at a company I need to reasign the company phone nos to the new person whilst retaining the individuals and their personal phone nos. If a company is deleted I need to delete only the company phone nos. and if a person moves within the company I want the company nos to reasign to the new replacement but keep the personal nos of the individual. Now I see its going to be more complex than I thought.

Can anyone help me with the table layout and links. (nb this is only a simple database relating a person to a company without using departments etc.)
Its main use is to provide phone nos names and addresses quickly.
Many Thanks
Peter

View 4 Replies View Related

Tables :: Avoid Double Bookings In Simple Database?

Jun 7, 2013

I work across a number of small venues which have art cases that can be booked for displays. I am trying to build a simple data base to report what space is available and also what art is currently being displayed. The art is usually booked by month, but sometime it can be booked for a week etc.

I have set up 3 tables

Art Inventory

Art Cases by Venue

Art Case Bookings

In the art case booking form, I have set up the start and end date but I cannot figure out how to avoid double bookings of a case? Once I have that worked out I believe I know how to build the required reports for my needs.

View 4 Replies View Related

General :: Create Simple Audit Trail In Database

Sep 2, 2013

I am trying to create a simple audit trail (which I got directions online) in my Database (and have posted a copy here) but am getting an error on the second form (and this will be a subform eventually) -The Audit Trail instructions say to put four fields in my table which feeds the form - CreateBy=Text, CreateDate=Date/Time and default to =now(), ModBy=text, and ModDate=Date/Time.

Then to add code to the Current and BeforeUpdate events on the form as you will see in my forms attached. I created a test database with very little data (called AuditTrackingTest2DBLp-attached). I created the first table (tblCustomers) and then created the form (FormCustomerInput) and then I added code to this form on the Current and BeforeUpdate as I was instructed in my notes and it recorded my changes perfectly in the tblCustomers.

I then created a new table called tblCustomerOrders and then a form (FormCustomerSubOrders) based on this table and added the same code to this form and it is giving me an error message in the code Compile Error: Variable not defined.

View 4 Replies View Related

General :: Simple Store Keeping Inventory Database

Sep 9, 2013

I am trying to create a simple store keeping In and Out inventory database using Access, I thought I had made it but looks like I am missing something here.

The store works on SRV (Store Receiving Voucher) and SIV (Store Issue Voucher). Products will be added based on SRV and will be issued out based on SIV. So far I have created the tables as you can see in the figure. One thing I am not understanding is where to keep the record of the Current Quantity of each product, lets say an Item has been added or issue out, it should be added or deducted accordingly from that specific products overall quantity. Right now I have a sample field within products table as you can see with the name QtyOnHand but that doesn't seem to be logical.

View 7 Replies View Related

Making Specific Fields In A Current Record Copy Themselves When Making New Record

Mar 28, 2005

;) Hey everybody,

I am working on a database used in recording device characteristics/test information. The main table of information has dozens of columns for test/part detailed information. When inputing the data for each specific test, many of the info. details are repeated when testing say 20 devices of the same part all at once. Rather than retype every piece of detailed information in every field, everytime, is there an easier way? Does anyone know of a way to make specific fields copy/paste the previous record's information in the fields automatically when a new record is created? Please, if anyone could help or has ANY ideas, let me know...

Thanks

gunwax

View 9 Replies View Related







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