i've got a field in a form where u need to pick gender(in dutch)
Now there's an Attention further on and i need the proper attention:(in english= Male=Sir,Female=Madame) Which is in dutch: Male= M = De heer
Female = V = Mevrouw, Unknown = O or B = De heer/mevrouw, So my code became:
=IIf([Geslacht];"M";"De heer";(IIf([Geslacht];"V";"Mevrouw";"De heer/mevrouw")))
Can some1 please tell me what i did wrong?
Kind Regards
SilverBlood
Erm, can someone tell me how to add a new record to a table pls?
I cant find how to do it in the heklp section
Many Thanks
Andy
hey guys
I want to creat something like
1. list of all countries, with one Bogus "All" representing all countries
2. When i select a Country from drop down list, i should get list of States in that Country. Again with one Bogus "All" representing all States in that Country
3. When i select a State from drop down list, i should get list of Cities in that State. Again with one Bogus "All" representing all Cities in that State
Can anyone suggest to find solution
Thank you
Hi fellas,
thanks for all ur help in my previous posts.......
ive got this problem, ive got a form that provides mobile details.
on the same form theres an add button and clear button.
all the validations work....... if the forms incomplete then validations do occur.
but the problem is......... if i clear the form (clickin on the clear button) and click 'x' to exit, it brings up one validation, which is the date_issued field validation????? and then exits
why does this validation occur??? how do i get rid of it.............
i want it to exit without any problem....... becoz i have cleared the form
Hi there,
I have been using Excel for many years and have just got to the stage where I need to build a database. I have managed to work out how to import the data ok but within the single table that I will be using I need to have a column which will add up the contents of four other columns.
EG.
Cells in Column T to be the total of cells in the same row from columns C, E, F and G.
Please would someone be kind enough to let me know if this can be done and if so how I can go about achieving this.
I am a newbie so please be gentle with me!!
Many thanks.
Paul
I have read as much as I can about using access and have decided it's time to have a play - so please forgive me if this is a silly question. Here goes.
I have a single table - it lists staff by name and staff number and shows 3 qualifications that they may or may not need (yes/no columns).
I have managed to produce queries/reports that show, for each of the 3 qualifications whcih personnel that require that qualification have not achieved it.
I now want to produce a query/report that lists any personnel that are outstanding any of their required qualifications and if so which qualification they are outstanding.
Any hints or tips would be very much appreciated.
I'm probably doing something daft but can anyone suggest why this query is giving no results?
The Item_Type field in the TBL_All_Items is a drop down menu
The query Q_Printers is supposed to be giving the results of only those item types beginning PRN but its showing no results.
ok guys i know this is really stupid and silly but i cant see for the life of me what i am doing wrong i have a query where i want to only show records between to dates (including first and last)
when i do both or less than one date nothing shows using the code below
SELECT Sum(HTRXTBL.HTRX_QTY_1) AS QTY1,
Sum(HTRXTBL.HTRX_VALUE) AS VALUE1,
DateDiff("d",[Forms]![frmCOMPARISON]![txtDATEFROM1],[HTRXTBL]![HTRX_TRX_DATE]) AS [DAY]
FROM ITEMTBL INNER JOIN HTRXTBL ON ITEMTBL.ITEM_NUMBER = HTRXTBL.HTRX_ITEM_NUMBER
WHERE (((HTRXTBL.HTRX_REC_TYPE)="ITMSALE")
AND ((HTRXTBL.HTRX_TRX_DATE)>=[Forms]![frmCOMPARISON]![txtDATEFROM1]
And (HTRXTBL.HTRX_TRX_DATE)<=[Forms]![frmCOMPARISON]![txtDATETO1]))
GROUP BY DateDiff("d",[Forms]![frmCOMPARISON]![txtDATEFROM1],[HTRXTBL]![HTRX_TRX_DATE]);
when i do greater than the from date it this code below works
SELECT Sum(HTRXTBL.HTRX_QTY_1) AS QTY,
Sum(HTRXTBL.HTRX_VALUE) AS [VALUE],
DateDiff("d",[Forms]![frmCOMPARISON]![txtDATEFROM1],[HTRXTBL]![HTRX_TRX_DATE]) AS [DAY]
FROM ITEMTBL
INNER JOIN HTRXTBL ON ITEMTBL.ITEM_NUMBER = HTRXTBL.HTRX_ITEM_NUMBER
WHERE (((HTRXTBL.HTRX_TRX_DATE)>=[Forms]![frmCOMPARISON]![txtDATEFROM1])
AND ((HTRXTBL.HTRX_REC_TYPE)="ITMSALE"))
GROUP BY DateDiff("d",[Forms]![frmCOMPARISON]![txtDATEFROM1],[HTRXTBL]![HTRX_TRX_DATE]);
:( i cant see what is different or missing help please
I feel like a goober for even asking this, since I've been using Access for three years now for work-related databases, but this is actually the first time this has come up and I can't, for the life of me, figure it out.
I need to find out if there is a way to copy something (a year, for example) and paste that one thing onto multiple rows within one column of the datasheet (Year Attended, for example.)
I don't want to have to type in the year 1,296 times; I'd like to see if I can highlight the portions of that column I want (all of the people who attended in 2005) and paste "2005" into all of the highlighted cells at once. In Excel, for example, you can copy something, highlight an entire section, and it will paste into each cell.
Any help would be appreciated!
Hey all,
I have this code on a number of difference forms:
[Forms]![Care Packs].Customer.SetFocus
This is executed by an event in another form that loads the new form and starts dumping in values. For some reason I'm suddenly getting "Object doesn't support this property or method. 'Object' is simply a textbox that is enabled, but is also locked altho to my knowledge this isn't a problem. It's late and I've been working for hours so this may be something simple I've overlooked...need to step away for a while.
Any thoughts?
I have the following fields in a query: "Employee_number", "shiftname", and "shiftdate"
And I have the following code on the criteria of "shiftdate": >= dateadd("d",-7,Date()) so that only records from the past 7 days are displayed which is fine, however when I run the query it displays the following
Employee_numbershiftnameshiftdate
1A16/09/2005
2A16/09/2005
3B15/09/2005
4B15/09/2005
which is not quite what i want.....Is it possible to make it only show the same shiftname with the same shiftdate just the once instead of showing it several times for each employee?