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
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.
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.
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"
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?
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
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.
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?
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.
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.
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.
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?
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.
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.
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)...
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?
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?
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.
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.
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])
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.
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
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:
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.
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.