Showing A Message

Dec 13, 2005

Hello

I've got the folowing sitation:
Mainform "KlantvolgsysteemB"
It's based on a field "projectnummers".
On this main form there's an unbound text box "Bericht" (not visible)
Also on this main form there is a subform named "Subformulier ContactactiviteitenBM"

It's possible to fill in a date on the subform "Subformulier ContactactiviteitenBM". This date is named AttentieDatum (Date/time). There is also a field "Attentie" (Yes/No)

My issue:
When the field "AttentieDatum" is equal to the systemdate and "Attentie" is True the unbound text box "Bericht" should become visible.

I've got the following code:
On the action After Update from "AttentieDatum" from the subform "Subformulier ContactactiviteitenBM"

Private Sub Attentiedatum_AfterUpdate()
Dim JaarNu, JaarToen, MaandNu, MaandToen, DagNu, DagToen, Attentie, Bericht AS Integer
JaarToen = YEAR(Forms!ContactactviteitenBM!AttentieDatum)
MaandToen = MONTH (Forms!ContactactviteitenBM!AttentieDatum)
DagToen = DAY(Forms!ContactactviteitenBM!AttentieDatum)
JaarNu = YEAR(date())
MaandNu = MONTH(date())
DagNu = DAY(date())
Forms!KlantvolgsysteemB!Bericht = Bericht
End Sub

And on the action On Current from the mainform "KlantvolgsysteemB"

Private Sub Form_Current()
Dim JaarNu, JaarToen, MaandNu, MaandToen, DagNu, DagToen, Attentie, Bericht AS Integer
Forms!KlantvolgsysteemB!Bericht.Visible = False
If IsNull (Forms!ContactactviteitenBM!AttentieDatum) Then
Forms!KlantvolgsysteemB!Bericht = Null
Else
JaarToen = YEAR(Forms!ContactactviteitenBM!AttentieDatum)
MaandToen = MONTH (Forms!ContactactviteitenBM!AttentieDatum)
DagToen = DAY(Forms!ContactactviteitenBM!AttentieDatum)
JaarNu = YEAR(date())
MaandNu = MONTH(date())
DagNu = DAY(date())
Forms!KlantvolgsysteemB!Bericht = Bericht
IF Attentie = True AND JaarNu = JaarToen AND MaandNu = MaandToen AND DagNu = DagToen
Then Forms!KlantvolgsysteemB!Bericht.Visible = True
End If
End Sub


Can anybody help me?
Sorry for my English. I'm from holland :o

View Replies


ADVERTISEMENT

Showing Message

Aug 26, 2005

Hello guys,
I have form with a button called process ,when I hit the button it select the column from oracle database tables and then it inserts the values in other oracle database table,so during this process ,I used docmd.hourglass true,but now I want to change to a message stating "Processing..." and after finishing the insertion it hides this message,is anyway to achieve this.
Please let me know asap.

Thanks
vsap

View 5 Replies View Related

Modules & VBA :: Set Warnings False But Still Showing Not In List Message

Dec 19, 2013

I am working in Access 2010. A bound combo box, Not In List event. I have the following code. It opens up a form to add the new name in. The form opens and then the "Not in List" message pops up. I have tried adding the SetWarnings to both forms, created a SetWarning macro, to no available. The message keeps popping up. My code is below. I know I need to set the warnings back to true - but for now, I just want to get rid of the message before sticking it back into the code.

Dim intAnswer As Integer
Dim strSQL As String
intAnswer = MsgBox("The acquirer/buyer " & Chr(34) & NewData & _
Chr(34) & " is not currently listed." & vbCrLf & _
"Would you like to add it to the list now?" _
, vbQuestion + vbYesNo, "Healthcare REIT")

[Code] ....

View 14 Replies View Related

Field Value Is There But Not Showing...

Apr 19, 2006

I have an unbound field that counts the number of records (=count(emplnumber)). When I open the form the value in the field is not there, if I click on the field the value appears.
It's almost like the field is being highlighted by the cursor and covering up the contents, but the cursor has it's focus set to another field.
Oh, the field is on the form footer if that matters.

Anyone know what I am talking about?

Thank you

View 6 Replies View Related

Menu BAr Not Showing

Jan 3, 2006

:confused: hi ,,,
i have this Microsoft Application and i have unchecked the check box (Allow full menus ) in the starup ... So when ever i run the application i only get
the menu bars : File, Window, Help, AdobePDF

how can i get the other menu bars ?


any suggestions

thankx:o

View 6 Replies View Related

Showing Variances

May 5, 2006

Hi All,

I have 2 sets of fields, 1 for this week and 1 for last week.
I would like to change the background colour of this weeks fields to show either an increase (green) or a decrease (red) from last weeks figures.

Can anyone help me?

Thanks

Twin

View 2 Replies View Related

Showing Available Appointments

Jun 1, 2005

Hello all,

I have a problem that is really giving me great headaches. I have had no success what so ever. My gratitude goes to anyone that can provide some insight.

I have two tables. One table for appointments and one table of all available time slots (ie 0930 is record 1, 1000 is record 2, 1030 is record 3 and so on).

If lets say there are records in the appointments table for eg today 01/06/2005 where there are two appointments (eg 0930 and 1000) I want to build a query that shows all the appointments that have not been used (so 0900, 1030, 1100,and son on). Adding to this, I need it to show these available timeslots for multiple dats (as the appointments table will have some appointments booked for the 01/06/05 and some for the 02/06/05 and some for eg 10/06/05).

I am aiming to implement this on a Active server page where the user selects the data and then the available appointments are displayed for that given date. However, I know that the query as descibed above is essential for this to be developed!

I have spent many hours trying to solve this with absolutely no success, so many thanks in advance to anyone that can help. Apologies for descibing the problem thoroughly.

Thanks

Ricky.

View 1 Replies View Related

Not All Results Showing

Mar 27, 2007

I have two database tables, one of information of members and one of staff. I want to do a query to show all members and staff that have the title of 'Mr' in the database.

There are only 5 staff details in my staff database at the moment, all with the title 'Mr'. There are 20 members details, 13 with the title 'Mr'. When i run the query i get only 8 names, 4 from the staff and 4 from the members.

The 4 staff ones i get are the 2nd, 3rd, 4th and 4th records.
The first record of the members field does not have the title 'Mr' and so it appears that this is blocking the first staff one to appear. And the members stop appearing after the 5th record too, so it appears they are stopped as there are no more staff records.

I hope this makes some sense to you, and if anyone could tell me how to get all the records to appear that would be great. Thanks.

View 5 Replies View Related

Showing 0 If No Results

Jul 29, 2007

Hi

I have a query which is made up of several other queries that total different fields (these are a base for a report) sometimes one of the queries will be empty and then the whole query is blank, how can I return 0 when there are no records to count in 1 query so that the results from the others still show?

Thanks

View 5 Replies View Related

Help With Showing Data That Is Not There

Mar 7, 2008

Hello..

This I think is easy, but I can't put my finger on it. I have a table of processes 12 of them. In the query I have them by date. What I want to do is to be able to show all 12 processes even if there is no info in them. I have a completed button, but if there is no info in the process the completed or not completed won't show up. The process is associated to an event. Hope this makes sense.

Any suggestions? I tried in the report to have a grouping, but if no information is present for that process it doesn't show up. I want the process to show up with or without info. So the end users can track the progress on a week by week basis.

Hopes this makes sense.

Thanks

View 2 Replies View Related

Form Not Showing

Mar 1, 2005

Hi,

I have copied a form and changed the table it is linked to. however, now it just shows a blank screen, not any fields.

I have spent hours on this, please can somebody show me what I have not changed. i have attached the database.

thanks in advance

lee

View 3 Replies View Related

Images Not Showing Up

Mar 23, 2005

Hi there,

I have a "minor" problem which most of you will probably have a laugh about :eek:


I have set up my Table / Form to have an image for each "item".

Now...when I add the image, it does not show up as the thumbnail JPG. It only appears as the image name.

So instead of seeing a picture, I see 1.jopg (example)

Can anyone help me with a correct hint?

Much appreciated

Chris

View 5 Replies View Related

Showing Forms

Jun 22, 2005

Hi

i am creating a knowledge base for IT Problems.

On my main form i have a combo box which has different options within it.

I have a second form.

I have linked the second form onto my main form using the subform function and set the second form to not visible on its properties.

Basically what i want to do is when i click the option 'Other' in my combo box i want the second form to be shown within my main form.

I have managed to do this when i click any option on the combo box but i dont know how to load it just by clicking on the 'Other' option.

Thanks

Gazza :)

View 2 Replies View Related

Showing Forms

Aug 9, 2005

How would I go about doing this: I need to show two different forms one after another. For example; a menu screen (1st screen) with a command button that will pop up another screen (2nd screen) for the user to enter details about themselves. After clicking on the command button (On the 1st screen) that screen to would hide but be brought back if they click cancel. (It's a bit like having a cancel button but it goes back to the main screen instead of closing the form.) Cheers

View 2 Replies View Related

Switchboard Not Showing

Aug 19, 2005

I accidently deleted the swithboard from the "forms"-area. I know it is still there, coz when I got to Database utilities|Switchboard Manager I can still see it. How can I get it back in the "forms area"
Thank u..
Stacey

View 14 Replies View Related

Showing Last Record

Sep 6, 2004

hi all,

i have question about showing last record in a form. i have 2 table, ra and repair tables. each ra_id is consists of many repair. each repair have time and date stamped. I want to show in tabular view all of the ra records including the last update of each repair per ra_id in a form. When I select some fields in ra + time in repair table, the form showing only records that has repairs ONLY, but not all records. And also display time BUT not the last update, instead showing ALL repairs. can any one help, if i want to show all records plus time but ONLY the last update on the repair. I don't know much vba, so please tell me what to do in macro or expression builder????

View 1 Replies View Related

Switchboard Not Showing Up

Feb 8, 2006

We have a MS Access 2000 database that our Mgmt uses for reporting. We have a new manager that just started. Most of the computers we have run on Windows 2000 and some on Windows XP. So yesterday, I put the icon on his computer and double clicked and nothing came up. No switchboard. (He has Windows XP) But if I hold the shift key down and double click on the icon all the tables, reports, and queries show up and they all work. Hmmm. It runs fine on every other computer that has XP. It's just this one stupid pc. Anyone out there have any ideas?

View 1 Replies View Related

Form Min / Max Not Showing

Mar 6, 2012

i need to size a form so that it does not fill all the window, i have tried enabeling the min and max buttons but they will not display for some reason, i changed the borderstyle to sizable and the controlbox to yes the min and max buttons are enabled , but still not showing the min and max buttons, the close button shoes and thats it? i am running 2010.

View 3 Replies View Related

Showing Primary Key As Company Name

Sep 28, 2005

how do I set up supplier name in the order table like the example in the
northwind database?

what I mean is set supplier ID so that it shows combo box with names instead of numbers.

View 3 Replies View Related

VBA Code For Showing Databasewindow

Mar 5, 2006

Hi,

Within Access it is possible (under startup) to show or hide the databasewindow.

With which VBA code can I change this setting to visible = true .... or false?
:confused:

View 4 Replies View Related

Memo Field Not Showing More Than 255

Jun 23, 2006

Hi guys and Girls

I have a txt box on a report which should show comments..
In the background table the field this txt box is bound to has a data type of memo. Yet the txt box on the report stops showing any more than 255 characters! any clues? I know 255 is the field size set for my Txt fields but memo fields should be able to display 65000000000000000 trillion characters with no problems.

When I look at the table the memo field has all the txt in it, it just wont display all the txt on the report.

Thanks for any help guys.

View 1 Replies View Related

Form Showing Entry

Nov 1, 2007

I have got a db when I enter a new client in the client form it saves it in the table but when I return to the form the client I have just entered is still there so I cant enter a new client it does'nt clear the text in the text box can anyone help

Thanks

View 2 Replies View Related

Showing All Appointments Available Query!

Jun 1, 2005

Hello

I have a problem that is really giving me great headaches. I have had no success what so ever. My gratitude goes to anyone that can provide some insight.

I have two tables. One table for appointments and one table of all available time slots (ie 0900 is record 1, 0930 is record 2, 1000 is record 3 and so on).

If lets say there are records in the appointments table for eg today 01/06/2005 where there are two appointments (eg 0930 and 1000) I want to build a query that shows all the appointments that have not been used (so 0900, 1030, 1100,and son on). Adding to this, I need it to show these available timeslots for multiple dats (as the appointments table will have some appointments booked for the 01/06/05 and some for the 02/06/05 and some for eg 10/06/05).

I am aiming to implement this on a Active server page where the user selects the data and then the available appointments are displayed for that given date. However, I know that the query as descibed above is essential for this to be developed!

I have spent many hours trying to solve this with absolutely no success, so many thanks in advance to anyone that can help. Apologies for descibing the problem thoroughly.

Thanks

Ricky.

View 1 Replies View Related

Sums Showing A Negative Value

Jul 27, 2005

I have a query calculating the sum of checked boxes of field 'A' ('letters sent') and the sum of checked boxes of field 'B' (letters received). My sum field is counting the boxes that are checked but showing the values with a negative sign in front?? How do I correct this? Also - could I create an additional field in this query to calculate the percentage% (success rate) #B's checked/#A's checked?

View 4 Replies View Related

Do Not Report If All Fields Showing An N

Jul 28, 2005

:p Hello,

I am wondering if anyone can help me create a query (which is used as a basis for a report) using a criteria which is clever enough to know that if all fields are have an N (no) that a report should not be generated - but with anything else e.g. all Y's or a mixture of Y's and N's that a report will be printed. There are 6 columns where there could be a Y (yes) or an N (no) and I would really like to know if this is possible in access??

Thanks.

View 1 Replies View Related

Showing Results From A Query

Aug 2, 2005

Does anyone know how to do a query so that the user can find all the things that will expiry at the end of the current month?
The user will click on a command button and it will show the results of a product that will expiry at the end of a current month.
Have tried with parameters to which the user manually types the end date in and then it will show the results but having problems.
Cheers

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved