I would like to create an Expire Indicator field. This field would automatically check against today's date and if the Expiration_Date equals to TODAY, the indicator would automatically be set to YES.
Does anyone know how to create this field in the table?
Thanks in advance!
Is there a way that a DB expire after 30 days? :confused:
I have found some sample DB (see attachment) but it is limited only in a single machine, cause I'm going to distribute my DB on a Network. Can anyone help me how to incorporate this to my DB. Just re-post the the updated DB thanks.
Hi
I am creating a database where i store information on all computer and printers we have. The printers have warranties usually lasting 2/3 years
Is there a way i can set a function where when a printer warranty is expiring within 30 days a reminder is displayed on the main menu
Many thanks in advance
Kabir
I have a "date" field and a "Expire dare" field, what I need is automatically obtain a expire date wich will be the last day on the month of the date field plus 1 year.
example
date = 15/02/2006
expire data 28/02/2007
How can I obtain the result?
I am trying to create some sort of warning to show that a date in one of my forms will expire in say 30 days. I need the warning to be a pop up (or similar) rather than be sent via email (only because I don't have Outlook set up and probably will not be able to). Effectively, I have a list of names and a column in my table to show an expiry date. To avoid missing the expiry date, I would like to be advised of this at least 30 days before hand.
View 3 Replies View RelatedAny way to make the query expired after a defined period but it must remain with that query only not for other queries. Also the query expires should have an option to be alive again or redated for next period after updation means expiry means stop working but not corruption or anything else.
View 5 Replies View RelatedI really need some help with this! I have a table with a field called [days.out]. It contains values from 1 to about 350, non sequencial with duplicates. I would like to run a query that would create a new field called [days.grouped]. This field would contain the word "1-15" if the value was between 1 and 15 in field [days.out] and "15-30" if value was between 15 and 30 in field [days.out], etc....
Hope someone can help me!!
All,
I have trawled boards and sites, but cannot find the answer!
I have a make-table query, and I wish to create an AutoNumber field.
Now I know that if you put fieldname: "" , a Text field will be created and if enter fieldname: [] then a Binary field will be created.
Is there a code I can use to create an AutoNumber field?
Help appreciated!
Regards,
Jempie
I have an extremely large database which is in a continuous form format, and what I would like to happen is, instead of using the find button that would just find a word, I would like to have a pop-up search box that would yield actual texts throughout the DB (something like the search feature in Adobe Acrobat). In addition, I would like to use the "and" or "plus" together to search for additional data if needed. Please, unless there is a sample I could download and use in my db, please be specific in your instructions since I am new to all this.
Thanks!!
I have a table in an Access 2000 database: [SAP_Survey_Answers] that contains FieldNames: CO_ID, ES_ID,
PKey, QFieldName, QAnswer. The *_ID are ID#, QFieldName lists the questions in a survey, & QAnswer corresponds to the QFieldName and gives the answer given by the customer. Here's the dilema: I need to create a new table with CO_ID, ES_ID as Field Names BUT I also need each question as a new field name. How can this be done? Query? SQL statement? I've been racking my brain on this one. Any help would be greatly appreciated!
I need to show two decimal places on a form based on a recordset of a table that has a field - type = double, format = fixed, and decimal number = 2
I need to show 101.00 and 102.00 so if user insert a record, record would have a sequence id of 101.05.
How do I create that field by code? The table is part of a system loop that it changes everytime thats why I have to recreate the table again and again.
I can do the double, I cant do the fixed and decimal number.
Please please help.
Thanks.
NEVER MIND, I FIGURED IT OUT.
Instead of including it with the code, I tweaked how the form displays it.
Thanks.
I have a database that I took over for a small group (it has about 400 records), and they want to add a field for "Member ID", to use for member badges and whatnot.
A friend tried to help me by suggesting the "Change the starting value of an incrementing AutoNumber field" from the Access Help File, but I don't necessarily want incremental numbers, I just want a string of perhaps 8 numbers in no particular order, and obviously, unique to each record. I also don't understand how I can get that to work in pre-existing records...
So, what I'm wanting, in a snapshot, is:
83928475 John Smith 123 Any St
93827221 Mary Jones 678 Market St
19182734 Elvis Presley Graceland
etc...
I was thinking that perhaps a formula could be created in a query? Heck I don't know!
I only know enough about Access to be dangerous, so I appreciate anyone's help!
THANKS!
Matt
Hi,
I'm new to this forum and have a question:
I want to create a table with an Autonumber field using a SQL statement,
in Microsoft Access Database, something like this:
Cnn.execute "CREATE TABLE newtable (id Long, Name Char(100)) "
is there something to put in place of "long" to make the field autonumber?
I tried the word "autonumber", but did not work.
Many Thanx.
Hadi.
I am trying to , create a field using the IIf function that will display a $250 bonus for agents every time they sell a car for at least $20,000. Otherwise, the function will return a 0. Name the field Bonus. I put in Bonus: IIf(SalePrice >= "20,000" Then + "250",True, 0) and it is saying that I have an improper syntax.
View 2 Replies View RelatedI have a table as followed;
EmployeeID: PK
FirstName
MInitial
LastName
Company:FK
Department:FK
What I want to do is create a new field that automatically populates based on what is entered into the above fields.
Essentially creating a single field with unique data generated by multiple fields.
For Example if I entered the following informaiton:
EmployeeID: 1 (AutoNumber)
FirstName: John
MInitial: P
LastName: Doe
Company: FederalGov
Department:Test
The new field can be generated as followed: JohnPDoeFederalgovTest
What i plan on doing with this is making this "generated" field an index so no new duplicated records can be added.
I created a database of "My Cars", "Television", and "Wines" and a Trouble Reports(TR) for each. I have a field TR on each and for now a user can fill it up with number i.e first TR is 1, second Tr is 2 etc etc. I want it automatically filled automatically not manually. However, I want it to do the same for "Television" and "Wines" when I write Trs on them. I am a rookie and I dont know how to do it I attached a copy of the db I created.
View 2 Replies View RelatedI have the following vba script and I can not get the yes/no field to work, also with adding field properties of required = yes and the text field to be 50, just examples are fine and I will update what I want.
Code:
Sub test()
Set Db = Application.CurrentDb
Set tdf = Db.TableDefs("1Testing") ' 1Testing is your table name
' First create a field with data type = Text
Set fld1 = tdf.CreateField("FieldT1", dbText) ' Field1 is your Field Name and formatted as text
[Code] ....
i am trying to have a continuous form where i have a combo filter to filter the records. i would like to be able to add records on this form but i keep getting an error
Field cannot be updated
runtime error 3348 cannot add record(s); join key of table 'tblOrdersItems' not in record set.
the table system for the relevant tables is a one to many.(parent / Child).it seems to work beautifully. i have the unique id fields of both tables in the form. i have the foreign key of the parent that is bound to the child form.
when i create a new record the error message appears. when i click end. i can see that the id fields have been populated and they look as they should. i cant seem to grasp what join key is not present. open frmDiaryNoneItems. there is a combo box in the header that you will need to toggle to show some records. try and create a new record and you will grasp what i mean.
I'm trying to use DDL to add a DATE field as above with NOW() as the default value..
I am using the same syntax pretty much (Altering instead of Creating a table), but its not working..
The error I get is:
err.number = 3293
err.description = Syntax error in ALTER TABLE statement.
Code:
CurrentDb.Execute "ALTER TABLE MyTable ADD COLUMN RecordCreatedDate DATE DEFAULT NOW()"
I have a very unusual situation where I need the name of a field in an Access table to end with a blank (i.e. space). I tried doing it trivially while in Design View but no dice. I tried it through some SQL along the lines of the following pseudo code
Select [old table].[Address] as [Address2 ], [old table].*
Into [new table]
From [old table]
but the new field's name "Address2 " lost the final space.A third try was through some syntax for an Alter Table statement to add or modify a field. It didn't pan out.
I need to creat a field named Q.
Q is the quarterly growth from the YYZ field.
I have another field, Date, which is obviously the date of the record YYZ.
There is one record per date.
So, how do i compute
Q=Y(t+3)-Y(t)
?
I'm very lost doing this operation.
How can I use different fields values to compose a paragraph? I want to make a shipment notification letter using different fields. For Example,
Hi [ShipToName],
Your order of book [BookName] has been shipped via [Shipping_Service]. The tracking No. is [TrackingNumber].
Your order has been shipped to following address,
[ShipToName]
[Street1]
[Street2]
[City], [State] [ZIP],
[Country]
Then I also want to email it using outlook 2010 but that might be a different thread.
I have an Access 2013 database file with many fields. One of them, I'll call it Field 3, is a box which I would like to either leave blank or put a check mark in it. I would like to be able to create an Iif field for Field 3 where a check mark is automatically inserted in Field 3 IF Field 1 - Field 2 <or= 0, otherwise I'd like Field 3 to remain empty.
View 9 Replies View RelatedHi All,
I have a database with two memo fields. Both have exactly the same properties in table design view.
One field is called 'notes' and when I want a new line I just have to hit ENTER. Result is as wanted.
The other field is called 'responses' and when I hit ENTER, the cursor jumps to the next field (as if these were a text rather than a memo field). it does not start a fresh line. However, this field has not length restriction; I can copy and paste any number of lines into it. But I must not hit ENTER, and I cannot produce a line break.
As I said above, both fields appear to have exactly the same properties in Design View. Why then do they behave differently?
What's wrong? What have I overlooked?
Thanks for your help.
Adrian
Hi All,
I am trying to create a make-table query, with a new AutoNumber field.
I know that if you are creating a new Text field you type FieldName: "" in Field and for a Number field you would type FieldName: [], but what do you type for an AutoNumber field?
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.
Thanks in advance for any help you can provide...