Table Creation : Big Table Or A Lot Of Small Ones
May 14, 2007
I want to create a dynamic page which will be composed of quite a lot of elements and will be filled with elements from my database.
First is the headline, 10 or so attributes, separate. Then 30 lines on the same model : Title (different for each line of course), Boolean, String, Date, Another String, Another Date, Another String. These lines are independent.
There will be approximately 1000 pages.
I wonder if I should create one huge table with everything in it (like Id, Headline, Title1, Boolean1, String1, Date1, String1, Date1.2, String1.2, Title2, Boolean2, String2, Date2, String2, Date2.2, String2.2, ...) or one table for each line (on the model : IdPage, Title, Boolean, String, Date, Another String, Another Date, Another String) plus the headline in a separate table?
I think I should take the "lot of tables" solutions, am I right? will it be a problem for Access?
View Replies
ADVERTISEMENT
Jul 17, 2013
I have a table that is a list of all of my events. Each record of events should have a child table that list all of the things that happened at the event. When a new record (event) is added how can I have a new child table created and linked to that record. Also I have a blank table to serve as a template for what each child should look like. How do I make sure this occurs? The child tables can have the same name as the index. I am just using numbers 1- for the index with 1 being the first event and so on?
View 8 Replies
View Related
Apr 9, 2008
How would I archive all orders place by customer 'x' in to a new table called tblArchive?
something like:
CREATE INDEX tblArchive ON tblCustomers WHERE customername = "x" ?
View 5 Replies
View Related
Apr 15, 2005
I created a new table for my database that contains three fields. A first name, last name, and a full name field. Is there a way in the definition of the table that I can define the full name to =[TrackComposerFirstName] & " " & [TrackComposerLastName]? I'm not sure where I would define a formula in data elements of a table.
View 10 Replies
View Related
Sep 15, 2005
Hello,
This will probably generate a few good laughs but here goes!
I have been given an Excel file with 6 fields about 20 chars in each field.
This file is a whopping 250 records. I would like to be able to add, change, delete and search records.
The DB would need to be shared by 2 users on a home network. Both are using Windows XP.
What would be(heres your chance!!!) the easiest solution for this?
This is for someone who wants to keep it simple. If it was simple though, I guess I would not be posting this!!! Haha.
They best part is they have MS-Works on their machines.
Any help or better yet a completed solution would be much appreciated.
Thank you
Take Care
Tom
View 1 Replies
View Related
Dec 7, 2005
Hello,
I have created a table containing jobs that need to be done from my team (IT production). Each time someone start or finishes a job, he must fill a box that updates a specific row in the table. I want to log the time of that action.
Any ideas of how I could set this up in Access? I have tried the Now() function in the Default Value of the field End Time, but this is updated everytime I refresh the table
View 5 Replies
View Related
Aug 17, 2005
Hello all,
I need some advice for an ASP.NET web application I am working on. I am trying to automate the making of a new table within a database and then have all records from an old table migrated to the newly made table. I would like this task to run from the scheduled tasks on the server in the way of an .exe
The new table would be created on the first day of every month, taking the name of that month. I was thinking to use an empty template table which already has all the fields, and then making a copy and renaming it to the current month.
After the new table has been created I need to copy all the records from the table that represents the previous month over to the new table that represents the current month.
Any advice would be much appreciated.
Thanks
View 1 Replies
View Related
Feb 12, 2008
Is it possible (and logical) for me to create a table with a calculated field from 2 other fields in the same table? Example; I have a long time field (mm/dd/yyyy hh:mm:ss) aka StartTime, and a long time field EndTime. I would like to subtract the StartTime field from the EndTime field to get the total time elapsed, but in hh:mm:ss format. I can get it in hh:mm format, but I really need the hh:mm:ss format. Any Ideas? :cool:
View 4 Replies
View Related
Feb 18, 2014
I have two tables; Customers and contracts.
I would like access to automatically create a record in the contracts table when I change the status in one of the Customer Fields from prospective to Customer.
The two tables are linked using the Customer ID field.
Is this possible?
View 1 Replies
View Related
May 14, 2007
Hi all-
I work for a staffing firm and I'm trying to figure out a way to turn exports from our vendor-based sql gui (i.e. I can only get .xls files out of it, can't just run SQL queries) into spiffy reports using Crystal Reports. My grand plan is to use Access to process these various XLS files (one for each client) by linking them to an Access DB and coding a table to conditionally tally individual records based on different criteria.
The criteria are company name, position name, date submitted, active, and status. I was able to code an Excel template that did the trick perfectly, but required each file to be edited to reflect the new report format, and updated as more positions are added. My question is this: is there some way for me to create a DB that links to the XLS files for each client and puts each company name, position name, date submitted (pulled straight from XLS files) and then the following tallies:
submitted (just # of pos name by date)
accepted (status != "s" AND active = "y" by date)
etc.
I don't really expect someone to do all my coding for me, maybe just point me in the right direction, as the only coding outside of excel formula coding (which I feel doesn't really count despite my proficiency) that I've done has been over a decade ago. Any suggestions?
View 4 Replies
View Related
Nov 29, 2013
I searched without success for a solution to show small pictures (icons) in a table field to show up in a continous form.
Purpose is:
a communication log table has comm codes such as
- mail out
- mail in
- tel call in
- tel call out
the comm log table has the fields
CustomerID, datetime, CommCode
The CommCode table hast the fields
CommID, CommCode, Icon
The form (subfrm) should show in continous form mode to each customer..Datetime, (commCode), and to visualize the Commcode the small image (icon) presented by an envelope with an arrow right, an envelope with an arrow left, etc.
I cannot find a solution for storing those little images and retrieving them from an OLE-Field.All my other pictures I do not have stored in the tables, but only the image path, but for that I would prefer to store them directly into a table field as they do not blow up the database.
View 1 Replies
View Related
Sep 29, 2013
How can I update (some columns) in a table from the same table based on a Criteria column in the same table.
View 2 Replies
View Related
Jun 28, 2013
I need to get x and y coordinates for each device, but the data has to get looked up from 2 other tables.
I have a table (called InstReclosers) that has device names. Each device is on a Section. I can go to another table (called InstSections) and look up what Node that particular section is tied to. Then I need to go to another table (called Nodes) to get the X and Y location for that particular node.
How I can go about getting this X and Y data into the InstReclosers table?
...in summary, InstReclosers has device name and section name. InstSections has section name and node name. Nodes has node name and XY coords. Need XY coords for each device in InstReclosers.
View 3 Replies
View Related
Dec 30, 2004
I have tried the count(field name) and the sum(field name) but neither of them are giving me the grand total only the count/sum of that row. Here is my code, please look - I'm sure its something small and stupid
SELECT [qry_Refi_Yield].[LOAN NBR], [qry_Refi_Yield].[BORROWER], [qry_Refi_Yield].[PURPOSE], [qry_Refi_Yield].[FUNDED STAMP], [qry_Refi_Yield].[HSS], [qry_Refi_Yield].[UNIT TEAM], [qry_Refi_Yield].[Cycle Time], [qry_Refi_Yield].[Total Yield], IIF([Cycle Time]<=30,1) AS Yield
FROM qry_Refi_Yield
GROUP BY [qry_Refi_Yield].[LOAN NBR], [qry_Refi_Yield].[BORROWER], [qry_Refi_Yield].[PURPOSE], [qry_Refi_Yield].[FUNDED STAMP], [qry_Refi_Yield].[HSS], [qry_Refi_Yield].[UNIT TEAM], [qry_Refi_Yield].[Cycle Time], [qry_Refi_Yield].[Total Yield]
ORDER BY [unit team], [hss], [funded stamp];
past tries: count([qry_Refi_Yield].[Total Yield])
count(borrower)
View 7 Replies
View Related
Jun 20, 2005
Hi everyone,
Here is my problem:
I Have a form that shows bills in a continuous form. My problem is that I want to put a textbox or a label that will display a kind of counter for each bills. For example, If I have 3 bills to display, I want my label or textbox to display 1 for the first bill, 2 for the second, 3 for the third, and so on.
But I don't know how to do that with a continuous form.
Could someone help me, please...
Thanks in advance!
View 1 Replies
View Related
May 30, 2006
hi there,
i also need help in my form creation. as you can tell from my post, i am clueless.
anyways, here is what i want to do.
i have an input text as:
title1
name1
address1
these will grow based on how many people information one needs to enter. so say if i have 3 people i should have:
title1
name1
address1
title2
name2
address2
title3
name3
address3
and so on
the thing is i only want to show input text 2, 3, etc when i have several names to enter.
so what i want is, a button, such that when i click on that button, it creates input text 2, 3, based on the number of people i have.
i know how to do this easily with html/javascript, but i MUST do this in ms access, so i hope somebody can help.
TIA
chocho
View 1 Replies
View Related
Apr 18, 2005
I am attempting to create a report that the user can specifiy a contact type which is selected from a drop down list and the report will only show those records. The name of the report is "Contact Listing bu User Supplied Contact Type." I also have a form called "Report Contact Selection."
Right now I am getting only contact type of "recruiters" to appear when I run the report even when I select a different contact type. As you will see when you look at the "contacts" table, I do have records with different contact types.
I am including a *.zipped version of this database and if you should need any additional information, please feel free to ask.
Thank you.
View 6 Replies
View Related
May 10, 2005
Hi,
I was using access 2000 to build a small office app. It will be on a network and will generally be used by only 2 or 3 people(max). I was wondering if the default jet technology would be good enough for this. If it isn't, what should I use? I looked at other options such as msde and ado but it's a bit confusing when you're new to this stuff.
Thanks,
scratch
View 2 Replies
View Related
Aug 29, 2007
There are times when it is just necessary to have a little rant, a canniption if you will.
For the last few weeks I have been working off-and-on with a new database for a salmon hatchery. One of the forms I designed contained a subform in continuous form view that flickered inordinately when first loaded. Now, there's a lot of code going on behind controls etc to run sql updates or deletes or appends depending on what the user clicked. There was also some code to alternate the row color of the continuous form. I spent literally days trying to find what part of my code was causing the problem.
I swore a lot.
I searched.
I eventually gave up as other priorities began to arise at work. I resigned myself to my fate.
Then I discovered, quite by accident, that the problem arose by the use of some unassociated labels being present on my form. I removed them, replaced them with labels associated with a control, and presto: the form flickering/reloading magically vanishes.
Great.
But what a colossal PITA for something so bloody stupid. There's absolutely no reason why this should occur IMHO. Honestly: it's hard enough to learn VBA, SQL, and relational db design without having to deal with poorly documented glitches like this. There are days when I think I'm finally starting to get the hang of Access, then something like this comes along and I want to send a lynch mob to redmond! :mad:
Ok, end of rant :) Hope the solution to my problem comes in handy for someone else someday.
View 3 Replies
View Related
Mar 22, 2006
Hi,
What i want to do is have a field called "monthlyhourcount" in my query that totals all the hours in a field i have in a table, the field in the table is called "hours worked" were a figure is entered, i need my query to give a total of all the figures entered. so far in the expression builder i have :
monthlyhourcount: [JobListMonthly]![Hours Worked]
when i run the query with this it gives me the seperate values, i need one total value.
any ideas guys?
Thanks
Conor
View 1 Replies
View Related
Nov 21, 2006
I'm fairly new to Access (2000 is the version im using), and I'm not sure how to do several things within a form:
1) make cursor in a text box jump to the front (left) when clicked on
2) Lock (and grey out) a text box once data has been entered into another
3) assign a field to correspond with another, and to have this shown on the form (ie: having a list of names and their corresponding phone numbers assigned to each; then on the form, having a combo or list box with the names that a user can select- once a name is selected, their phone number appears automatically in another text box)
4)Locking screens or subforms when moving on to another (either by pressing a button to open another form, or by selecting a field in another subform)
thank you in advance for your help and advice
View 1 Replies
View Related
Jun 26, 2006
i have a table..
staffdayid
date
timein
timeout
notes
i want to have a feature in my database like the following..
these are basically day to day clock in times for my staff..
is there a way that everday.. a new record will be created..
eg.. on 04/06/06... i turn on my pc for the first time.. and when i view the timesheet form.. a record for today is automatically created.. then throughout the rest of the day, this form will be displayed..
when i turn on my pc on 05/06/06, the database will know its a different day, so it creates a new record for today... then i can just move back and forth throughout the days to see the details..
if i then turn my computer off for 5 days, then turn it on at 10/06/06, it still should have made records for 6,7,8, and 9th June, but they will be empty, and the record im shown is for the 10/06/06,
how can i make this?
View 3 Replies
View Related
Jul 5, 2006
In a field “NAME” I have “Adam Smith”.
From this field I want in a QBE window (not in VB) to make two new fields “FIRST NAME” “Adam” and “LAST NAME” “Smith”.
In Excel there are the functions FIND and SEARCH with which I take the number of the gap “ ” (5) between Adam and Smith and with the functions LEN, RIGHTS and LEFTS I have a result.
What could I do in Access 2003?
View 3 Replies
View Related
Aug 9, 2007
I been tasked with a project to be written in access which I am rather unfamiliar with, web design is more my area.
For part of the project I need to copy some pricing fields from a pricing table to a new record at the point that the new record is created. The new record is created when a 'new form' button is clicked.
What I would like to know is what and where I should trigger the copy query from and what function should I be using?
cheers
John
View 1 Replies
View Related
Mar 12, 2008
Hi! Im wondering why my code below Does not work!.... any suggestion???
strStatement = "SELECT SessionData.RunNumber, SessionData.SessionID, SessionData.SequenceNo, SessionData.SubjectID, SessionData.Latency, SessionData.BeamBrk1, SessionData.BeamBrk2, SessionData.BeamBrk3, SessionHeader.SessionDate, SessionHeader.ChamberNo" & _
"SessionHeader.GroupID, SessionHeader.SubjectVariables, SessionHeader.TestDefName FROM SessionData" & _
"INNER JOIN SessionHeader ON SessionData.RunNumber = SessionHeader.RunNumber;"
getQueryname = InputBox("Enter a name for New Query?", "Enter a Label or Name for Query", "Enter Query name/Label Here", 500, 700)
Set qryEmployees = curDatabase.CreateQueryDef("getQueryname", strStatement)
View 4 Replies
View Related
Jan 16, 2006
I have a continous form bound to a query which also has a group by function. Is it possible to create an editable bounded textbox because Access is giving a message saying recordset not updatable.
View 2 Replies
View Related
