Creating New Tables Based On Templates
Aug 29, 2014
I am working on a dataBase and I need to have it check if a set of tables exist based on the data of another table and if any do not exist create the table(s) based on a template. the caviat is that the data in one table are both names of tables and field in another.
Table1 has fields named 'first name' and 'last name'; the data in that field is for example Peter Adams, John Smith. I need to check on start that the tables named PAdams, JSmith.and so on exist, if not create them from a table template with fields 'vacation', 'personal', 'sick, etc. also i need to check on startup that a table named Department exist; if not, create it with fields named PAdams, JSmith and so on.... is that possible?
View Replies
ADVERTISEMENT
Jul 17, 2006
Hi
I was wondering how to create a form which is using data from three tables, the data in the tables does not have any relationship setup as they are not related to each other.
When I use the wizard and I select the three tables, Access starts complaining about the fact that no relationship has been setup...
Please help,
Thank you,
Gurkie
View 2 Replies
View Related
Jul 3, 2013
I am using data from a sales and a finance system and essentially need to understand the difference between them and account for this "balancing" row.
My data is as follows
TBL_Sales
Month, Product_Type, Factory, Quantity, Sales, Margin
January, A, F123, 100, 1000, 10
January, A, F123, 800, 8000, 80
January, B, F123, 10, 100, 1
January, A, F124, 500, 10000, 1000
February, A, F123, 100, 1000, 10
February, A, F123, 800, 8000, 80
February, B, F123, 10, 100, 1
February, A, F124, 500, 10000, 1000
TBL_Finance
Month, Factory, Quantity, Sales, Margin
January, F123, 1000, 10000, 100
January, F124, 550, 10500, 1000
February, F123, 950, 9500, 95
February, F124, 600, 10000, 1000
I would like a query which would look at the difference between TBL_Sales and TBL_Finance and will then add rows to TBL_Sales to make them balance. In the example above I would want it to add the following (I've used C as a Product_Type to show that it's a manually entered value) -
TBL_Sales
Month, Product_Type, Factory, Quantity, Sales, Margin
January, C, F123, 90, 900, 9
January, C, F124, 50, 500, 0
February, C, F123, 40, 400, 4
February, C, F124, 100, 0, 0
View 5 Replies
View Related
Oct 19, 2005
Hello everyone,
I just surfed in from google :)
I'm on a bit of an access learning curve and would like a little assistance if possible?
I created an access database for my uncle a year ago to deal with orders and delivery notes etc...
now he wants me to upgrade it a little, but i have no idea how..
What i want to do is:-
the database is quite simple in thought, really all i require is:
customer form (to add new customers)
products form (to add new products and change stock levels etc)
Create order form
Job sheet form (same data as create order but formated nicer)
delivery note (again same data as create order but formated nicer)
Currently when creating an order customers and products are entered manually which is very time consuming and prone to human error.
i would love to have a form that you can select customers & products from a dropdown list.
in the future i would like the stock levels to change as orders are raised but won't look into that till i've had a long read of some books
would anyone care to offer some advise? or link to a template?
many thanks
john
View 7 Replies
View Related
Mar 26, 2008
Hello all,
I have an assignment that needs Access 2002 but I have Access 2007. The template I need is called the Mailing List Template. Is that available for Access 2007 or do I have to get a computer that has Access 2002?
Thanks.
View 1 Replies
View Related
Jan 23, 2008
Check around and can't find anything useful, more of a case of can't see the woods for the trees really :p but here we go:
I doing a very simple form which I want to output to HTML (directly), it work fine and is ideal for what I need but I want to use a template to alter the colours and add a meta refresh tag but I cant get it working.
Help file next to useless so I wondered if anyone can point me in the right direction - Is it a css file ? or can I use a html file ? I've tried with both but still no joy :(
View 1 Replies
View Related
Mar 23, 2014
I cannot create a db from a template in 2007, either from a local one, installed with the program, or downloaded. The online ones download with no problems, but as soon as I click on "create", I get the message: [QUOTE] "Template 'xxxxxxxx.accdt' could not be instantiated." it goes further to say "The table 'xxxxxxx' could not be read from the template file. The object may be in an unrecognized format or contain invalid data." [UNQUOTE]. I have read through everything I can find on here, and searched the internet repeatedly. Some places say that certain .dll files are not registered, but after downloading these files, I am unable to get them to register. I have uninstalled and re-installed the entire Office suite, and run the Repair tool 3 times, but to no avail. The files are stored in, and downloaded to, a Trusted location. Templates from 2003 will work, but not 2007. I'm at my wits end now.
View 14 Replies
View Related
Dec 10, 2007
Hi everyone
I am just about to start a database project for the company. The last one I wrote was over 10 years ago in Borland's ObjectPAL and has served us well.
After doing quite some research I have decided (well... almost) to use Access as the basis for the new project as I need the most efficient and 'slick' solution in the speediest time-frame (don't we all!).
The downloadable Templates from MS seem actually quite good as a starting point, but we would need to 'glue' them together to prevent replication of clients, prospects, employees etc.
Has anyone had any success with doing this? For example, we would need to integrate Marketing Projects; Customer Service; Sales Pipleine plus our own custome stuff besides modifying these standard templates.
Looking forward to your replies
Regards
CD (UK)
View 3 Replies
View Related
Apr 3, 2013
I want to make a simple FrontEnd for my database for users to open reports to print them. I don't want them to mess with the linked tables or queries feeding into those reports. I want the front end to display a list of every report in the database that they can load up and use.
View 1 Replies
View Related
Sep 13, 2013
I'm trying to make a simple program to automate timesheet templates. Each of our staff members work on a 4 weekly basis (week 1, week 2, week 3 and week 4). I currently use a word document with the template in and copy and paste it into the timesheet. The timesheets run from the 23rd of one month until the 22nd of the month after. The issue is the four weekly template doesn't fit the same every month so I am after an automated process.
I'm thinking of having forms to select a staff member and change their hours on the template, if you will, and then a button to create new timesheets where admin staff would just need to add the first date (ie 23/09/2013) and the timesheet would be made for each staff member and auto filled with the four week template.
My main issue is I'm not sure how to link the dates to the weeks in a table. I have attached a word template of my own hours.
View 2 Replies
View Related
May 21, 2005
I'm using Access 97 and have merged the 'Event Managment' & 'Contact' templates. I thought that I would need to make 'Contacts' and 'Attendees' as the same table.
My knowledge is limited and attempts to change to 'AttendeeID' means I lose the ability to log 'Calls' to people.
Is there a simple way of combining the functionality of both databases given my limited ability in using access?
Any help would be greatly appreciated.
Many thanks
Adrian
View 2 Replies
View Related
Aug 16, 2007
Hello
I'd like to create a query like this:
select table.column, table.column, table.column
from table
where table.column = textboxvalue
How can I do this?
View 2 Replies
View Related
Feb 21, 2006
Hi all,
Right trying to create a database that is centered around displaying images.
I already have my forms and navigation working fine but need some help with the images. what i would like, if possible, is on the forms one image is displayed but it has navigation buttons underneath to switch between images in the form. nothing fancy just that!
if anyone has done this before or has any ideas it would be greatly appreciated!!
cheers
chris
View 2 Replies
View Related
Jun 14, 2005
I am working on a jobs database where employees enter information where the job is being handed off to. I want to create a table showing the latest job entry by date. The jobs are listed by "Job Number" and when I try to create a table and remove the duplicate "Job Number" it does not always remove the oldest entries.
Any help would be appreciated.
View 1 Replies
View Related
Dec 22, 2004
In my checkbox named Taxable I have the following in the afterupdate
Private Sub Taxable_AfterUpdate()
If Me.[Taxable] = True Then
Me.[Tax] = 0.06
Else
Me.[Tax] = 0
End If
End Sub
This will only insert whole numbers in the Tax field as I have tried several
combinations of numbers. How can I get Tax = 0.06?
View 4 Replies
View Related
Jun 19, 2007
I have a database with several clients who have a series of appointments. I want to be able to create a report of all the clients to be seen during a range of dates to be inputted by the user. All help would be greatly appreciated.
Andrew
View 1 Replies
View Related
Nov 12, 2014
- I currently have a table that is labeled WorkSchedule. I then Created a query called WorkSchedule Query.
- The column labels are as follows (listed from right to left): Project, Event (something inside of the project), Employee1, Employee2, StartDate, EndDate
- I created a split form that shows each record.
- On each record I made the employee1, and employee2 as a drop down box that allows you to pick from all employees.
*MY QUESTION*
How do I make a pop up form appear when there is a conflicting date based on the employee I picked?
For example: If I had assigned Rebecca to an event that went on from 11/12/2014 - 11/14/2014. Then I tried to assign her to another event from 11/13/2104-11/15/2014. I want a pop up message saying that these dates conflict.
View 2 Replies
View Related
Jun 30, 2013
I have some code that creates queries based on a value in a checkbox.
So, depending on that value, the queries may or may not exist.
I need to take those queries (if the exist) and create one union query.
This code creates the first query beautifully, but it won't union the second query.
Code:
Private Sub cmdSubmit_Click()
Dim blnQueryExists As Boolean
Dim cat As New ADOX.Catalog
Dim cmd As New ADODB.Command
Dim qry As ADOX.View
blnQueryExists = False
[Code] ....
View 4 Replies
View Related
Feb 12, 2006
Hello all,
I have a scheduling database that I am only using one table "DateLog"
It contains these fields:
JobIDInt-PK
LotIDTxt-PK
TaskIDInt-PK - List from TaskList Table
TripIDInt-PK
TaskDateDate
ForemanIDInt - List from Foreman Table
TaskQtyInt
TaskMisc1Txt
TaskMisc2Txt
NotesMemo
Every time a trip is taken to a job site, a record is created. I would like to have a datasheet view of this table that will join all of the tasks for a particular JobID and LotID together on the same record for easy viewing.
The list of tasks are static and will not change from job to job. The only fields that needs to be seen are the JobID and LotID at the row header. The rest of the data is the TaskDate for each task.
What I have attempted so far is to create a separate query for each TaskID and then to join them by the JobID and LotID. I have gotten to the point that I can put values into the datasheet, but I get an error that the primary key cannot be null.
Am I approaching this the correct way? Is there a way I can point the hidden key fields to the fields they are joined to? Access does not seem to be smart enough to figure this out itsself and I am not sure how to tell it to create the new record using the fields that it is related to.
This is very difficult to explain, any help would be greatly appreciated. I will be glad to post further clarification if I did a bad job explaining what I am trying to do.
Thanks,
Rob
View 3 Replies
View Related
Jan 27, 2014
Each each record in table1 has a unique four character (alpha-numeric) code to identify it. The first two numbers of this code represent the group it is in. (Ie. 15AB and 1502 are both grouped together) The second table stores values that apply to the entire group. I need to create a relationship between these two tables based on the first two characters in the ID field.
Things I've tried:
* Making a calculated field with left$() formula - Access doesn't allow relationships on calculated fields
* Create a new field for just the first two characters and create a data macro for after update and after insert to update that field with the expression - cannot edit the field the user is on
View 4 Replies
View Related
May 8, 2013
I have a database that I will use for invoicing, but I would like it to automatically create an invoice for customers based on parameters set for that customer (e.g., monthly, biweekly, etc.). I have tables containing the customer information, the item they are being billing, the price, etc. I want to be able to have access automatically create the invoices and add them onto the invoice table each month.
Maybe there is a better way, but I thought that if I created a query for all people that are billed biweekly and all people that are billed monthly, that I could run the queries when applicable and then somehow write a macro that would go through the list of customers and add each of them to the Invoice table and add an autonumber. That way I could click run query, run macro, and then do my invoicing. I don't know if that is the way to go or not.
View 8 Replies
View Related
Apr 15, 2013
I created 2 combobox that list specific table in a data base. I want to create an unmatched query based on the selection from those two combobox.
All field in those table are the same.
View 3 Replies
View Related
Aug 2, 2013
Table name: Items
Field: ItemName
Form name: Frmpayments
when I open the above form, it should create texts boxes on "frmpayments" based on how many data available in "Items" table under "Itemname" field. It'll be even better, if it can put those item's name in each text box it creates.
View 1 Replies
View Related
Aug 3, 2014
I am designing a database for a quarry for maintenance of their machines. I have a table that has a full list of all the parts on the machines, and a multiple value lookup field that says what machines said parts are used on. I am trying to have these values translate to another table, so I can then insert a field to say how many of each part are used on the respective machine, to display on an information form for each machine.
I would also like this table to update if the relevant information is updated, for example if a new machine is input, then have the table update to reflect what parts are used on it (an After Update function?) I have made a query that gives me the read out I want (attached) but just cannot figure out how to get that into a table so I can add the extra information.
View 1 Replies
View Related
Jul 17, 2013
I have a module in my database that creates an appointment based on a table of sessions. The module works in all respects, except two:
1) When I declare optional attendees it sometimes shows them as required attendees in the actual meeting in outlook, but not always
2) The .Send method does not seem to work. It creates the appointment on my calendar as the originator of the appointment, but does not send to the other recipients.
Below is the code:
Code:
Private Sub SchedOutlook()
Dim rsEmployee As DAO.Recordset
Set rsEmployee = CurrentDb.OpenRecordset("Select * FROM Employee INNER JOIN tblSession ON Employee.EmpID = tblSession.EmpID;", dbOpenDynaset)
Dim rsMentor As DAO.Recordset
[Code] ....
View 4 Replies
View Related
Feb 3, 2015
I am trying to create a image based off a drop down result. I have had no problem with setting up a image based off a static number. e.g 0456432 in the student id field will bring up students photo in the network share.
What I am having an issue with is the control source will look for a number instead of the name that the drop box displays. this is due to a separate table for the drop box.
what is the expression i need to make in order for the name to appear from the dropbox rather than the source id number?
View 3 Replies
View Related