I think I know the answer to this, but thought I'd see if anyone had any ideas... I was asked if there was any way to know when a record was created in the database. When the table for these records was created, a field for "Enter Date" (i.e. the date the record was enterd into / created in the database) was not a part of the structure. I know that for going forward, we can create this field in the table and have it populate with Date() behind the scenes so we can track the actual enter date. But, for the records that are already there, is there anything that Access keeps somewhere as to when the record was created in the table?
I think my question is fairly simple - fingers crossed.
I want to create a field that, whenever a record is added, it auto-adds the date & time the record was created. I'd call it Book_Date_Added, or something like that. I tried snooping around the Default Value options but couldn't figure it out.
The table exists and it already has some records, so I'd need to know how to add this field rather than how to create it when I create a table (although that would be helpful too, if it's somehow different).
I am trying to create a form to enter data in a table. I would like to make it pull in info from a switchboard. If the record already exists I would like it to find it and allow me to edit the info. If the record doesn't exist I would like to be able to add a new record with the data input. What is the best way to accomplish this?
This has got to be a really easy one for you guys...!
I need to record the date/time a record was created - I've tried to use now() but obviously that updates and there appears to be no function for create date...
I created a module to generate the correct date to begin manufacturing. There are two sets of criteria. If the job's prefinish is a certain code then manufacturing takes 7 days. If the job's door style is a certain code then manufacturing takes 5 to 6 days. Otherwise the date range is 4. Prefinish takes precedence over door style. I have units that have the special prefinish and one of the door styles listed then it gets the door style days instead of 7 days. Any ideas?
Function CreateWOSDDate(ByVal PreFin As String, ByVal DrStyle As String, ByVal DelDate As Date) As Date
Dim intNumDays As Integer
Select Case PreFin
Case "BR17", "BR28", "WH06", "BR06", "BR11", "WH17", "BR00", "BR22" intNumDays = 7 Case Else intNumDays = 4 End Select
I am new to the forums, so if i posted this in the wrong section...please accept my apologies...
I am creating a database for recording some information about various customers. There is a date field involved, and if a certain number of days pass from that date, i want to create a button that when it is pressed it will check all the dates to see if this condition is true.
EX
Current Date is 10/21/2006, when i press the button, the database will check to see if 10 days have passed from the date recorded.
User 1 - 10/05/2006 - True User 2 - 10/10/2006 - True User 3 - 10/15/2006 - False
Then it would just display the records which are listed as true only. I was thinking of using a query, but i am not sure how to quite do so...please give your recommendations as to what i can do.
i think this must be easy but im new and despite reading lots just cant figure it out. i have 2 tables
job details:
autonumber customer location time
picking list:
autonumber, equipment1 equipment2 equipment3
both the autonumber are primary and linked in a relationship. when i create a new record in the job details table i need it to automatically create the coresponding blank line in the picking list table with the same number. If I enter something in the picking list table then it creates the matching number and everything is ok but if i dont then it throws my numbers out.
I have a program that you can search all or a specific record. Once you find the record, you can double click on it and another form will open up with only that record's information.
What I need is to have a button that will copy this record's name, address, phone number, contact info, and etc --> and create a new record with a new Record Number using the current record. This will allow the user to avoid entering in the same information again. For confirmation purposes, I would like to have a SAVE button to verify and save to the DB.
Does anyone have any inputs on how I can do this? If you would like to see the program, please let me know.
Thanks in advance for all your help and suggestions!
How do I create a new record (in the table to which the form is bound) automatically if, when the form opens, there is no record in the table that meets the criteria in the form filter?
I am new to using MS Access and I am having a difficult time trying to do one particular thing. What I am trying to do is represented in the Contacts database template in Access 2007. When that database is opened, there is a link labeled as New displayed on the table that opens a form to enter a new record. I cannot figure out how to do that, can anyone help?
Also, is there a way to automatically open a particular form when the database is opened?
I am unable to create a new record due the the following error "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. " I have looked everything over and can't find how the duplication is occurring. I am pretty sure it is the primary key of a table called Squad, but it's set to autonumber. I have uploaded the database hoping an experienced or fresh set of eyes could spot the problem. The goal of the database is to track squad inventory along with officers assigned to the squads. The main form is generically called "unit_Numbers" which uses "Squad Subform". Everything else seems to work correctly except for creating another squad.
I would like to create a button with a macro that will bring up a blank form to create a new record (as opposed to going directly to the datasheet table). There are options to Save a Record, Refresh a Record, Search for A Record, Delete a Record and Show All Records, but I don't see a macro to create a new record.
I am editing data in a table that was designed by someone else. For some reason, they divided the date into three columns (YR, MON, DAY). I would like to join these three fields together and create a legal DATE field. I have tried the following:
SELECT YR AND MON AND DAY AS TheDate FROM MyTable;
However, it returns an odd result. I think this might be because ACCESS does not know I want a date format.
My question is: is the above QUERY correct and how do I tell ACCESS to put the concatenated data in a date format.
This works but how do I use "datecreated" to get the creation date of the table and format it. I tried to use DateCreated in place of Date but get errors such as variable not defined or .datecreated without a with block.The result I'm going for is something like "tblMstr20140603".
I'm reworking a db to make it web compatible. Right now I'm working on my Price and Sales tables.There are about 900 Sales records, 450 Price records (for about 45 Items).
I have re-done my Price table with an Autonumber Key field. (It had a multi-key which I understand web db does not support.) Each autonumber key represents a Date with new Price for a Company/Item. The Price change Dates are random.
I have put a Foreign Field in my Sales table for the Price key field.
My dilemma is matching the Sales with the Prices.
When the Price Date and Sales Date do not match (at least half of them don't match), I need to look back in the Price table to the max Date BEFORE the Sales Date in the Sales table for that Company/Item in order to select the correct Price key.
I need to make Access automatically create new records in a table for me.
Just for example:-
Table #1 has 2 fields
PersonID (autonumber) PersonData (text)
Table #2 has 3 fields
ID (autonumber) PersonID (number) MoreData (text)
The database user creates a new record in Table #1 using a form.
I need the database to automatically create a field in Table #2 and fill in PersonID, taking the value from the autonumber field of the same name in Table #1.
The MoreData field can be left blank. I don't need that filled in automatically. I just need a new record to be created automatically in table2 with the PersonID field filled in with the most recently created autonumber.
I have a main form called FrmCalls with a button on, which when pressed brings up a pop up form called FrmSurround, within which is a subform in datasheet format called FrmContacts. This has 3 fields within it. I want the system to tak a value from Frmcalls (numeric value) when the button is pressed and place it as a new record in one of the fields on the datasheet (FrmContacts).
I have the following code on a combo box in a form that creates a new record in the table Products if it doesn't already exist:
Code:Private Sub comProduct_NotInList(NewData As String, Response As Integer) Dim strSQL As String 'Exit this sub if the combo box is cleared If NewData = "" Then Exit Sub strSQL = "Insert Into Products ([Product]) " & _"values ('" & NewData & "');" CurrentDb.Execute strSQL, dbFailOnError Response = acDataErrAdded End Sub
It creates a new record and inputs the appropriate value into the Product field, however then it goes to the next record and when I try to edit other fields, it does so on a new record.
So, for example, I wanted to set the Product field to ProductA and the Brand field to BrandB and the Size field to 200, it produces two separate records like this (code box used for formatting):
I have two controls on my form that I want to reference in an append query to create a new record. The first is a text box, the second is a combobox that is populated with all of the dates associated with the text box. The selection of a date updates a subform based off of a hidden column (chart ID, an autonumber field based on combinations of record numbers and visit dates) in the same combobox. I would like the user to be able to enter a new date and create a new record that would contain the next autonumber in association with the new date and the record number from the text box control. I have tried using an append query with the following SQL, but I consistently get errors referring to "type mismatch." Any help would be greatly appreciated; thanks in advance.
Code:Private Sub cboDOVSearchChart_NotInList(NewData As String, Response AsInteger)Dim ans As Variantans = MsgBox("The date you entered was not found. Do you want to add a newdate?", _vbYesNo, "Add New Date?")If ans = vbNo ThenResponse = acDataErrContinueMe.cboDOVSearchChart = NullDoCmd.GoToControl "cboDOVSearchChart"GoTo exit_itEnd If' add dateIf ans = vbYes Then Dim strSQL As String strSQL = "INSERT INTO Patient_Visits ([Medical Record Number], " _ & "[Date of Visit]) " _ & "Values (" & Me.[txtChartMR] & ", " _ & "#" & CDate(NewData) & "#)" 'this line has the arrow on debug CurrentDb.Execute strSQL Me.cboDOVSearchChart.Requery Me.cboDOVSearchChart = NewData Call cboDOVSearchChart_AfterUpdateEnd Ifexit_it:End Sub
I have a database where on the bottom I have kept the record navigation buttons. When I move to the next record is fine, but when it reaches the end and I press once more, it will create a new one. How can I avoid this?
I made a button special for that purpose to creat new record). I guess the best option will be not to show the record navigation and create buttons to go back and forward and avoid that the next press of the button will create new record.
