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
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 RelatedHow 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" ?
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 RelatedHello 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
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 RelatedI 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?
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?
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?
I am using a form with command buttons to allow an administrator with limited Access knowledge to update certain tables. This is usually done by opening a form that is linked to the table and allow for changes. For one particular table, I would like the Administrator to be able to make the changes directly in the table. I would like for them to access the table with a command button. Here is the code I am using to update the table through the form. How do I need to change it to open the table and not the form. I tried changing the DoCmd to OpenTable and changed the stDocName to "tblStaff" but I received a compile error.
Your help is appreciated.
Private Sub cmdPermission_Click()
On Error GoTo Err_cmdPermission_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmStaff"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_cmdPermission_Click:
Exit Sub
Err_cmdPermission_Click:
MsgBox Err.Description
Resume Exit_cmdPermission_Click
End Sub
I hope I can explain this:
I have a database with a table "Itinerary" it has two fields "Date of Visit" and "Agency Number"
I have a second table that is linked from a different database "Agent Info"
I created a form based on the "Itinerary" Table then I put in a sub form to show the "Agent Name" and "Market Rep" from the "Agent Info" table.
The relationship is on Agent number in both tables. The user then adds the agent number on the form and the Agent name and Market rep automatically come in.
The problem is the user wants to be able to occasionally modify the info in the Agent Name and Market Rep fields. But does not want the new info to be changed on the original "Agent Info" table.
Can this be done?
I hoep someone can help.
Hi Guys
I'm trying to create a database application which logs the number of times which i do a certain task.
Is it possible for me to create a button within a form that will increment the value with a particular field by one?
I have searched the net but can't find anything.
Thanks
Matt
Hello all,
I have a question, I'm building a MS ACCESS database and within it i have a table for putting in my program critical parameters. I don't want anyone to change the content of that table. That means not editing the 1 record in it and not adding a new record. Within the program is't a problem but if you make an other blanc database you can import the table, change it and export it back into the program (i know it is far looking but it happens).
How can i lock a table so it cannot change or it cannot be exported or imported???
I'm creating an application and I want the users to be able to view a table and filter it, however; they won't be able to edit it. Like I said, seems simple enough, but since I'm new to Access I'm not sure how to approach this.
View 1 Replies View RelatedI have a Form that is used for creating entries to fill a table. On the same Form there is also a list that shows everything in the table and a double click on the list will populate the Form with that data. The problem is that "Save Record" command button will not update the table because it thinks it is creating a new record.
The code to populate the form from the list is
Private Sub EmployeeEntryList_DblClick(Cancel As Integer)
Me![Number] = EmployeeEntryList.Column(0)
Me![EmployeeNumber] = EmployeeEntryList.Column(1)
Me![FirstName] = EmployeeEntryList.Column(2)
Me![MiddleInitial] = EmployeeEntryList.Column(3)
Me![LastName] = EmployeeEntryList.Column(4)
Me![Supervisor] = EmployeeEntryList.Column(5)
Me![Group] = EmployeeEntryList.Column(6)
Me![Shift] = EmployeeEntryList.Column(7)
End Sub
how I can make it populate the form if an entry is double clicked and then be able to save a modified version of that record over top the original.
I have a table which is linked to a form which has been working fine for over a year now but yesterday the table "locked" for editing. I can now only copy data from the table. The editing functions delete, cut, new etc are not working, we can still filter the data.If we enter data on the form it creates a new line on the table but we cannot edit directly from the table.
View 6 Replies View RelatedHi All
I'm trying to set up a form to log my clinical placement, and the number of time i undertake a procedure.
I want to have a list of a few procedure(fields) and then button next to each one in a form which will increment the number by one
How do i go about doing so?
Create form to search multiple fields in table
Return records that match search
Open the record that you want in Form View for editing
I have created a table for installer invoicing, and have a field for invoice amount. I have created a user input form that allows a user to fill in certain pay rates for different aspects of installation, and would like to know how to make the invoice amount a calculated control that will auto update the field InvoiceAmt in my table. I can't figure out how to do this in the property sheet.
View 3 Replies View RelatedHi 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!
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
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.
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?
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?
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
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)