General :: How To Create Itinerary DB

Jun 19, 2012

The Db I need to create should give the people at my office a good search functionality for looking up when a boat starts a cruise, how long that cruise is (varying from 4 - 16 days), which sites it will visit (multiple sites per day), what the capacity of the boat is (max passengers), if it can be usd for diving or not, if it is in maintenance or not.

what I have so far:

Table 1: Boats
BoatName - PK (102 boats in total)
CapacityID - FK
ClassID - FK
TypeID - FK
MaintenanceID - Yes/No - FK
DivingID - Yes/no FK

Table 2: Diving
DivingID - PK
Diving - Yes/No

Table 3: Maintenance
MaintenanceId - PK
Mainentance - Yes/no

[code]....

How to connect everything together. How can I make this all work together so that I can have my colleagues search for a boat that sails on a certain day of the week (i.e. Friday), a certain date, for a certain amount of time abd/or with certain sites to visit? To make it more complicated, all boats have various routes they travel and of various lengths, leaving on various days of the week.

View Replies


ADVERTISEMENT

General :: Create A Button That Will Create A New Empty Backend

Oct 31, 2013

I created a database and I manage to split it into front end and backend. now I'm going to make an EXE of the front end.My question is when I open the front end, I need the database to be empty, and them create a button that will make the user select which project he wants to open (backend).I also need to create a button that will create a new empty backend and save it as a new project.

View 7 Replies View Related

General :: Cannot Create New Database

Jul 2, 2015

I have Access 2013, part of office pro, and for some reason it now cannot create a new database, ie nothing is created where i told it to It then comes up with "cannot open a database created with a previous version etc".This is NOT a previous version, it physically does not exist.This did work, well last week.Tried doing an office repair, no differance, tried delting system.mdw.If i click OK on previous message, i do get "Close ole server and restart it outside of access"

View 3 Replies View Related

General :: Unable To Create MDE From MDB

Jan 7, 2013

When I click the Create MDE button I get the error message You cannot add or change a record because a related record is required in table 'MySysAccessStorage'.

I am a user who has been making some improvements to our database. Now that I want to test the improvements I need to create an mde, but can't.

The database was created in Access 2003 and I am now using Access 2007 on windows 2010. The original developer advised that we continue to use mde format - something to do with the runtime version everyone else who uses the database have.what I need to do to convert my mdb to an mde?

View 4 Replies View Related

General :: How To Read / Create ID3 Tags For Mp3(s)

Aug 15, 2012

how to read / create ID3 tags for mp3's? I have found various snippets but they are mainly vb.

View 8 Replies View Related

General :: Need To Create Query From A Table

Apr 14, 2014

I have an old ERP system. The upload function is one line per value. So if I want to upload 7 models I need 7 lines, not one line with Qty of 7
however my source system sends the data as one line with Qty of 7

DLM2245/17DLM2245/17X1
DLP2204/17DLP2204/17X7
DLP2249/17DLP2249/17X7
DLV1004/17DLV1004/17X147
DLV1005/17DLV1005/17X158
DLV1009/17DLV1009/17X187

so in this example line 1 is fine. But line two needs 7 lines, and line 3 needs 7 lines and line 4 147 lines etc etc etc.so this is how the first three lines would look in the query.

DLM2245/17DLM2245/17X
DLP2204/17DLP2204/17X
DLP2204/17DLP2204/17X
DLP2204/17DLP2204/17X
DLP2204/17DLP2204/17X
DLP2204/17DLP2204/17X
DLP2204/17DLP2204/17X
DLP2204/17DLP2204/17X

[code]....

View 3 Replies View Related

General :: Way To Create A Audit Log In Access?

Dec 14, 2012

Is their a way to create a audit log in access?I have a log-in screen on my db and every time a user logs in i want it to be recorded. is their away to do it?

View 14 Replies View Related

General :: Create A Web Search Emulation

Oct 10, 2014

I have been tasked to create a Web Search Emulation of some sort. I'm wondering if I could do it with Access. I'm thinking if I create a start page with a search field where the user can enter any word they would like (specifically a job search) and then link that field to a query that would look/search for that word in a table that has loads of entries to see if anything is found and if there is list the titles of the results in a clickable ListBox. Then, if they click something in the list, it would open another form with the details linked to that list item.

View 2 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

General :: How To Create Fields Dependent On Each Other

Jun 19, 2012

I am very new to Access and I am not familiar with SQL. How I can create fields that are similar to each other?

Let's say I have 3 fields in my table: Name, State, Area Code.

I want it so that each time I select "Name" the appropriate State and Area Code populate. Anyway I can do this?

View 3 Replies View Related

General :: How To Create Auto-population

Aug 23, 2012

I have a table where names are associated with information. However, we are now not allowed to have any identifying information with the information, so I need to move the names to another table with some kind of indentifier to associate which patient goes with which information. I was thinking about having the auto assigned ID numbers act as the ID numbers for each set of information.

So I need find a way that when someone enters information in the main table, they then enter the name into the "ID table" with the same autoassigned number. The problem now is there is already information in the table, and since data has been deleted, the ID autoassign field has gaps. I also don't know if I can set up an autopopulate field. How to make this easier or how to create the auto-population.

View 3 Replies View Related

General :: Create Multiple Records From One

Jun 19, 2012

I have three tables:

tblClient (for basic client information),
tblDischarge (for client discharge information), and
tblAppointments (for appointments that are added to an outlook calender).

All three tables are linked using the IDNumber from the Client table. I have a form where a user inputs a discharge date for the client.

Once that date has been added I need to add 5 records to the Appointments table for different followup times based on that discharge date (such as one month, two months, three months, etc.).

I have the code working to add an individual appointment to outlook but not 5 different ones at one time. So the question I have is how to add the 5 records based on the one discharge date?

View 1 Replies View Related

General :: Create A New Outlook Email

Dec 12, 2013

I want to be able to click on a button on one of my forms and it create a new outlook email.I also want this email to have an attachment that is a report that I already have made.

View 1 Replies View Related

General :: Cannot Create A New Record In A Field

Feb 9, 2013

i am trying to have a continuous form where i have a combo filter to filter the records. i would like to be able to add records on this form but i keep getting an error

Field cannot be updated

runtime error 3348 cannot add record(s); join key of table 'tblOrdersItems' not in record set.

the table system for the relevant tables is a one to many.(parent / Child).it seems to work beautifully. i have the unique id fields of both tables in the form. i have the foreign key of the parent that is bound to the child form.

when i create a new record the error message appears. when i click end. i can see that the id fields have been populated and they look as they should. i cant seem to grasp what join key is not present. open frmDiaryNoneItems. there is a combo box in the header that you will need to toggle to show some records. try and create a new record and you will grasp what i mean.

View 5 Replies View Related

General :: How To Create A Graph From Query Results

Feb 23, 2013

I have a query that pulls up the sum of records that holkd a date value between two dates, and groups them by the person that created them.

How can I show these results in a graph? that will update every time a user clicks a buttons (as they may wish to change the two dates to search between)...

View 1 Replies View Related

General :: Create Time Billing Form

Aug 2, 2014

What I am trying to do, is create a time billing form to track time spent on different tasks, with the following items in a neat form, in this format:

1) Client
2) Employee
3) Rate/hour
4) Date
5) StartTime
6) EndTime
7) BillableHours (*)

I am able to make a form that correctly works lets the user enter records for 1-6, with the user pressing crtl+shft+; to give the correct starttime, and then at the end of the task, the user can press the same and register the end of the task.

My problem is that I can't work out how to calculate 7) as one needs to input some VBA code that converts date/time to numeric values, allowing you to calculate time difference. However, I simply don't know; a) the proper 'code' that will calculate the time different between 5) and 6). I saw that it was perhaps the dateDiff command? And b) where I would even put that code into, i.e. the exact location where one goes to and types the code into... Is it a query? Do you set it to a Calculated value in the table editor?

View 7 Replies View Related

General :: Create Time Clock Button?

Aug 20, 2012

I want to create a toggle button (On/Off), that can show time clock on button. Click to start time, click again to stop time.

View 4 Replies View Related

General :: Auto Create Usernames Based On Name?

Oct 20, 2013

For a project i'm working on i'm manually entering e-mail addresses, names, and surnames. I would like a username and password automatically generated based on what the corresponding fields' first name and surname is with formatting.

Example:
First Name Surname Username Password
John Smith johnsmith01 j.smith.01

Is there any way i can do this using input masks and validation rules? Would this require a VBA script?

View 2 Replies View Related

General :: Create Addin That Adds A Tab To Ribbon?

Sep 24, 2012

I want to create an addin that adds a tab to the ribbon. I already have an add in installed that works exactly the way I want mine to, but I can't find the .mda file anywhere. I want to stick with the .mda so I have access to my forms. Here are some images of that add in I mention.

View 2 Replies View Related

General :: Create Query Or Report With Macros Or VBA?

Mar 21, 2014

I want to create either a Macro or VBA that will automatically create a report or a query.

View 4 Replies View Related

General :: Create A Form For Data Entry

Apr 22, 2014

I am trying to create a form for data entry. I would like the Total Balance in the last record to become Total Cost in the new record. However, if the total balance in the previous record is =<0 it prompts the user to enter a new total cost else use the last Total Balance. The form in question is FrmSubClients in the attached file.

View 4 Replies View Related

General :: Create X Number Of Records With A Button

Apr 8, 2015

I know this has probably been gone over, but I'm just looking for a super-simple way to put a button on my form that will create a number of records equal to the number of days in the month listed in a field. For instance, if MyField is "4/1/2015", I'd like the system to create one record for each date between 4/1/15 and 4/30/15.

I have scoured the forums, and I find many threads on creating multiple records, but none of them deal with the same type of thing I need. I have a field, called MyField, and I have a table called MyTable with a column called MyDate. I want to enter a date into MyField, then click a button, and the button will run code/macro/whatever that will create multiple rows in MyTable, one for each date in Month([MyField])

View 8 Replies View Related

General :: Proper Environment To Create Databases?

Jul 23, 2012

I would like to know in what type of working environment everyone works. i.e. an office with a closed door, a cubicle with high walls, shared cubicle, low-walled cubicle.

View 2 Replies View Related

General :: Create Duplicate Sets Of Data

Aug 1, 2013

I have the following tables in my Access database.

A < B < C < D

(The "<" represents a one to many relationship.)A given row in table A can have up to 4 children (stages) in table B (stages 1 to 4).The other one to many relationships do not have any limitations as far as the number of children are concerned.All tables have AutoNumber primary keys.When the user clicks a button in a form, I want to:

Copy all data in the current stage (current row) in table B (corresponding to a given parent row in table A), to the next stage in table B.All data in child tables must be included in the copy process.In other words, for a given row in table A, by use of buttons in the forms for each of the stages 1 3, the user shall be able to do the following:

all data for stage 1 are copied to stage 2 (for user modification), then
all data for stage 2 are copied to stage 3 (for user modification), then
all data for stage 3 are copied to stage 4

Is it possible to do this in Access 2010?

View 4 Replies View Related

General :: How To Create A Series Of Different Tables And Reports

Aug 3, 2012

I currently have 3 spreadsheets with simliar information. How can I take a database and export only select fields to make either a report or table? Here is the example with types of info i will be using:

100 communities and all their roads. Each of these communities are in a borough, which is then in a region.

Then we have a mileage for each road. Where I have difficulty is that we have another set of data that would be fine if we could just include into this which is all of those roads but additionally they have:

Classification
Surface type/condition
Traffic count

Some roads have two classifications.. each of those having a mileage. I would really like to see all of this data in a database that spits out the needed tables and totals.

View 1 Replies View Related

General :: How To Create Relationship With Duplicate Records

Mar 21, 2014

See attached picture where I am stuck at?

I have a table that holds UK Postcodes and a customer table that holds customers.

I am trying to create a relationship between the 2 so when I enter a postcode in the customer table this is then related to the postcode table.

The main problem I have is that there is a lot of duplicate postcodes in postcode table so the primary key is simply a number as you will see in the picture.

View 2 Replies View Related







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