Can I Still Go Back And Fix This In Table Design?
Jun 21, 2006
Hello. I have created a database to keep track of clients and their training requests. I have already created the tables and have some data entered. It is just now that when attempting to create a query with the two tables that I realized I have problems as I am getting a Type Mismatch error.
The first table keeps track of clients. Each client has a unique client number field which is an AutoNumber. The second table is a Training Request table that keeps track of the training requests for each client. Each client may have many training requests. I entered a Client Number field in this table too and that is how the two are linked by relationship. I set the Client Number field in the Training Requests table to be a Text field. I realize they are different data types but I didn't think I could set it to be an AutoNumber in the Training Requests table.
How can I fix this table design? Would I just be able to change a data type? I am very unsure of what route to follow.
Thank you in advance for any help that can be provided.
View Replies
ADVERTISEMENT
Mar 1, 2013
My forms and reports jump to the back, behind anything that is open when ever I open them into design.
View 6 Replies
View Related
Sep 30, 2013
I split my db to front-end and back-end. 20 users are using the database. But now I have the problem: In my admin front-end db I created a new table and some reports to the table, but this new table I have only in my front-end db and it doesnot appeares in back-end db - so that other users has no data in hte report for the new table. How I can create new table to be in back-and table too?
View 5 Replies
View Related
Aug 2, 2006
I am fiddling with a DB right now just to try to work out some table relationships. I have a PK, Name, it is accompanied by a year in school. I then want to relate the year in school in a different table with the requirements for that year.
such as
Year Requirement1 requirement2 requirement 3
these would be check boxes (yes/no), and I could accomplish it in this format, but I am trying to have a normalized DB so
I realize it should be like this
1st year requirement
1st year requirement
1st year requirement
but I do not know how to link this back to the PK name when switching it to this format, so that I can pull up a form that shows if the person has completed the requirements for the year they are in. I am I going about this wrong? I have been looking at normalizing DBs and relationships but can't figure out the logic for my DB thought.
Thanks for any help
Riley
View 1 Replies
View Related
Sep 22, 2005
I have a database that acts as a front end for two different back-end databases. What I want to do is be able to copy a table from back-end #1 into back-end #2.
My first stab was to try to do a TransferDatabase on the linked table from b-e #1, but that just put a link in b-e #2, and not the actual data.
Can this be done?
Thanks,
David
View 4 Replies
View Related
Jul 25, 2013
I created my database a few months ago and split the database into a front and back end. I recently added a new table on the front end. How can I move this table to the back end and re-link it?
View 3 Replies
View Related
Sep 30, 2012
my problem is that when i make a booking on my booking page it all saves, but when i go to the table where the bookings should all be kept, they all dissappear and only the recent booking i have made shows.
View 10 Replies
View Related
Jul 2, 2007
I have a Front End Database and a Back End Database.
Certain tables in the BE are linked to the FE.
Once or twice a day I need to run Make Table Queries in the FE, but I am unable to do so if someone else has the BE open.
Best solution would be greatly appreciated
Many thanks
John
View 8 Replies
View Related
Jul 1, 2004
I am sure that in earlier versions it was easy to write the result of a calculated field on a form, back to a table, but I can't find the method in the help file for the current version of Access.
Would appreciate any help.
View 3 Replies
View Related
Feb 27, 2015
Can I create a table in the back end of my database using VBA in the front end? My client is using this system and I can't easily go to their location. I need to create a table on the back end and have it available in the front end applications. My thought is to create a front end only for the purpose of updating the backend with this new table. My idea is now to have it open with a button for the user to click - this will add the table to the backend with the required fields, confirm the update was completed and then close. This app then would be trashed so it would not be run again. (Though I would put a check in the VBA that if the table existed, the user would get a message box and the coding stopped to avoid overwriting the existing file.)
And once the table is created, is there a way to programmatically link it to the front end. I will be providing a new front end with this update so I could add something in the new version.
View 10 Replies
View Related
Jan 12, 2015
I have the usual setup with a front and back end.
I want to copy three of my tables from the back end to another database (backup) at regular intervals. When using docmd.CopyObject and docmd.TransferDatabase it is the link that get copied (naturally) and not the table itself.
View 1 Replies
View Related
Feb 8, 2012
I was trying to do this in a SQL Q but thought it would be easier to do multiple calculations in my form if I used Calculated Controls instead.
I have a table Lookup_Tbl_Fiscal_Year with Start_Date, End_Date and FSA_FY.
In my form I want to take the date entered in Last_Signature_Date and look up the FSA_FY.
The Last_Signature_Date would fall somewhere between the Start & End dates.
Here is what I got but no matter what date I enter I get 0 back.
=Nz(DLookUp "[FSA_FY]","[Lookup_Tbl_Fiscal_Year]","[Last_Signature_Date]">="[Start_Date]" And "[Last_Signature_Date]"<="[End_Date]"),0)
I read that this might slow down the system. Is it better to use SQL?
View 14 Replies
View Related
Mar 23, 2012
I am designing a database for my organisation. I have done most of it but am stuck on this. Ideally I would like to have a check box (in a table) that when checked a load of data is carried across from that record to a record in another table.
Given that I can't and don;t want to use VB is there anyway that this can be done easily?
View 8 Replies
View Related
Jun 22, 2012
I did a search in here as well as Google to figure out why when I relinked the front end to the back end after adding 2 tables to the back end that the tables did NOT show up on the front end. Only the original tables that I began with.From what I have read there are different ways to do it. One suggestion on here was to create the table on the front end and export it to the back end. I guess I will have to do this going forward.
But my question is, after searching pages upon pages with no luck, since I already have the tables in the back end how do I tell the front end to find them and link them?
View 2 Replies
View Related
Jun 29, 2013
I've got a query that uses a key from one table to pull back records from another.
My question is...
On the table with the key there is another field that I want to use to pull back data from the same table from above.
A bit more info...
Table one holds colleagues details
Table two holds records
Within table one there are 2 different fields that hold different ID's for the same colleague, currently I run two different queries to pull all data - I want to know if I can simply run one query that will return every thing?
Schedule an import or export operation
View 11 Replies
View Related
Dec 27, 2013
I am trying to run some diagnostics on my database. I thought a good place to start would be to look at all of the tables, the number of records each table holds, and each table's size. I have been able to find plenty of code on the web that loops through each table and provides the aforementioned data points, but the code only looks at local tables. SInce the database is split, I have a ton of tables linked to the back end that I am unable to get stats on. Any query or any code that can pull back end table stats?
View 5 Replies
View Related
Nov 10, 2014
I am in the process of building a new database in SQL to replace my MS Access database. However, I will continue to use the Access forms, queries, and reports. The new tables will house much of the same data. In multiple tables I have hyperlinks that were created and added in the original Access tables. To import these hyperlinks into the new SQL tables I have converted them to 'Long Text' before exporting, thus changing them into strings.
For example:
Hyperlink - Email - Add Additional Mailbox to Outlook (2010) has been changed to:
Email - Add Additional Mailbox to Outlook (2010)#ServernameServerfolderDocumentationRea dy to GoOutlook TemplatesEmail - Add Additional Mailbox to Outlook (2010).oft#
The obvious issue that I am running into is that after the SQL database table has been linked to the Access database it still displays the entire string when I open the table. The form has a textbox and search button that is used as a search function. This runs a query that returns all "search results" for the desired information. Is there a way that the query can convert the string back into a hyperlink so that the query displays just Email - Add Additional Mailbox to Outlook (2010) as a hyperlink and not the entire string?
View 1 Replies
View Related
Sep 22, 2013
I have split the data base
Added a new table to the back end .But do not know how to update it to the front end
View 4 Replies
View Related
Nov 28, 2005
I am having problems coming up with a Table design and need help.
I am trying to design a table that will have 8 categories, 47 subcategories, and then choices within those categories.
Much like the following (this is only one category example, there will be many):
(Main category) Floors -> (Sub categories) Joist, Carpet, Vinyl Flooring, Wood Laminate -> (Choices for Joist Sub Category) Structure Wood 2X8 Joist, Plywood 2X8 Joist, Structure Wood 2X10 Joist, Plywood 2X10 Joist
This only shows the flow if the main category is "Floors", sub category "Joist", and then the choices under subcategory "Joist". There will be others for the other categories, subcategories, and choices.
Can someone help me or steer me in the right direction in setting up the database table/tables to accomplish this. Oh and BTW, there will be prices attached to each "Choice" under the subcategories.
I hope that this makes sense... any help would be much appreciated.
View 1 Replies
View Related
Aug 30, 2006
I have 5 tables with the same data (row and columns). How do I make it into a relational table?
View 3 Replies
View Related
Jan 29, 2008
if i had a table with products and i want to keep a record of what has been chaged or added to this product, whilst keeping the old records how could i set it up in a databse?
the excel spread sheet looks like this
product commments
1 chnged this and that 20/08
1 modifyed component 21/08
2 newest model 3/08
View 1 Replies
View Related
Oct 23, 2004
Hi all, i wonder if anyone can help?
It's a simple question really. I'm currently learning databases and am doing a project, just to show that i understand everthing i've learnt so far. I have to produce a small database.
There's nothing difficult about the project, and its a very basic database, but i was just hoping to ask a small question.
I'm producing a DVD database, to hold details on a collection. My main table holds the majority of the fields, as follows;
lngDVD_ID
strDVDTitle
strYearReleased
lngDiscAmount
dtmFeatureLength
lngCertificationID
ysnBoxset
ysnExtraFeatures
strDirector
lngMovieStudioID
lngCategoryID
curPurchasePrice
The problem came with boxsets. Originally i was just going to have boxsets as one entry, but some contain a few dvd's, each with different certification, etc, and i wouldn't be able to record running length, director, etc.
So i added a ysnBoxset field (just to record whether a dvd was part of a boxset or not) and then made a new table with
lngDVD_ID
strBoxsetName
So now i can record which are part of a boxset, and the name of the boxset they belong to. But.. then i got to the problem of Purchase Price. Obviously i cannot record an individual purchase price for those which belong to a boxset, and i want to be able to record the price of the boxset.
So my question is... is it acceptable to add a curBoxsetPrice field to tblBoxsets, which would allow me to store the price... and then just leave curPurchasePrice as £0.00 for those dvd's in a boxset??? Or is there a better way of doing it? (I know there is, but i'm a novice :( )
Thanks for any help you can give, sorry for the lengthy explanation! :rolleyes:
View 3 Replies
View Related
Mar 14, 2005
Within my db I have a table, tblProjects which currently has 36 fields. Each project will have a fixed set of 12 tasks, each having a begin and end date as well as a yes/no "completed" field. This would add another 36 fields to tblProjects.
Instead, I have created a new table tblTasks which has these 36 fields along with a PK(TaskID) and FK(ProjectID) and is related to tblProjects. I believe tblProjects is already normalized properly with relationships to tblCompanies and tblContacts as well.
I'm not sure if this was neccessary, or should I have just added the task fields to tblProjects. What, if anything, are the advantages of one way over the other? I'll be upsizing to SQL Server, does that make a difference?
I appreciate any advice,
Sup
View 7 Replies
View Related
Jun 2, 2005
Hi,
Bit of a long one but I require some advise if people can supply it.
I've started creating a DB that is now getting out of hand due to me being inexperienced. The things I want to do now are getting way to complicated. From reading various posts I know that this is all being caused by my database design and while the DB is still young I'm go back to square one. I want your advice on this if you can to ensure 3 weeks from know I'm again not chasing up weird bits of VB code to make it all work.
I basically have a lot of information to hold that interconnects with each other. I'm making up a role profile DB (so we can assign define access rights to a computer system) I have lots of info to collate but the basic stuff is.
Staff Records (Name, business area & ID)
Applications (What computer applications do staff require)
Shared Drives (What access to shared drives and folders do they need)
Shared Mailboxes (what access to shared mailboxes)
Roles (users will be assigned roles to suit their requirements)
Basically what I have at the moment is below.
Roles
Role ID
Role Name
and about 15 other fields that dont really matter for this
Applications
Application ID
Application
Shared Drives
Shared Drive ID
Shared Drive
Shared Mailbox
Mailbox ID
Mailbox
Each role will only have a select number of applications, mailboxes and drives from the overall list. so role 1 may give access to 2 of the 10 applications, 1 out of 5 shared drives and 3 out of 4 mailboxes. Role 2 on the other hand may need 9 out of the 10 applications, 1 out of the 5 shared drives and 1 out of 4 of the shared mailboxes.
I just don't understand how I can create a form from these tables that would display all the different roles with their respective apps, mailboxes and drives they would need.
any advice you can give to help whould be appreciated.
Again sorry for the long post.
View 1 Replies
View Related
Jun 5, 2005
I am designing a db for our Law office. I want to have tables for different types of Civil Cases-ie Divorces, Deeds, Contracts, Personal Injury, Auto Accident, Slip and Fall, Product Liability, etc. The divorce, Deeds, tables are easy but I am having difficulty deciding on the personal injury tables. Heres my dilemna. Can I get away with one or two Personal Injury tables even though there will be blank data fields. For example, I will need a field for the name of the product in a Producrs Liability field. This field will be blank in all other Personal Injury Cases. I know the rule is you don't do that but my alternative is 15-20 tables for every concievable Personal Injury Case- Auto Accidents, Slip and Falls, Fraud, Prouduct Liability, Accounting, Attorney, Dental and Medical Malpractice, etc. This is in addition to other civil case tables, criminal case tables and federal case tables. Anyone have a suggestion?
View 6 Replies
View Related
Aug 30, 2005
I am not sure if which I should be using as the main entity for my tables. I am creating a database for hourly information on individual employees. Each employee will have the same types of hours to keep track of (weekly, bi-weekly, monthly etc) I naturally thought to treat each employee as the databases own entity and created fields for each type of hours but hit some trouble when trying to pull queries to compare each employees hourly information against each other to see who is being efficient or not. Each employee has the same exact fields but with just different numbers. We track each type of hour by week (Field One: Week 36, Field Two: Aug 28-Sep 03)This is the first time I am creating a database from scratch. All advice greatly appreciated and TIA :confused:
View 10 Replies
View Related
