Annoying Popup Messages

Jun 6, 2007

I have no idea wheather this is supposed to go in Queries or Forms, so feel free to move this to either.

Here's my problem:

I made a query that looks at three text boxes on a form. I'm not sure how to set up the buttons correctly so I just bluffed it (like always :) ). Every time I run the query it keeps wanting me to re-enter the data that it was supposed to look at anyway! If you need more info, just ask. Thanks.

Anonymous_354

P.S.: I'm really new at this. I just learned about Access a week ago.

P.P.S.: I use Access 2000

View Replies


ADVERTISEMENT

How To Disable Action Query Popup Messages

Aug 18, 2006

I'm told (via the non-helpful help system packaged with MsAccess) that the way to 'turn off' the helpful confirmation message related to an action query is under tools>Options>Edit/Find tab, and then uncheck the appropriate boxes.

I've done this. In fact, right now I have all three boxes unchecked which relate to confirmation messages (record changes, document changes, and action queries) - and I'm still having that same popup message every time I run the query, or have a report pull the query for me.

this wouldn't be more than just a hassle, except that one of the end users for this system isn't the most computer-savvy person in the whole world. In fact, I desperately need to "steve-proof" this system! I have this nightmare of being woken up at midnight because of this little glitch. any ideas how to disable that popup confirmation message for good??

View 8 Replies View Related

Forms :: Change Access Default Error Messages With Custom Messages?

Apr 29, 2015

how to change Access default error messages with custom messages? Like, if I enter some data in a sub form where the parent form is empty new record, default error message says that 'You must enter a value in the 'column name' field'.

I want to disable this default message and display my own error message. Now I know MessageBox and MsgBox fuctions to display custom messages, but how to disable the default message.

View 6 Replies View Related

Annoying Problem.

Oct 7, 2005

Basically i have a form which logs error corrections. The users enter a 'date received'. My user has now asked to have a date due to automatically be calculated by adding six days. I have done this with no problem:

=DateAdd("y", +6, [date received])

My form is not unbound, this date due field is the only unbound field i have. This date does not need to be saved in the table, just to appear when the user opens the form, which it does.

The problem which i am having is that i have a report which runs of a query, printing out the error correction, when the user types in the auto number required. The records added after i put the date due field, will not print out and when i run the query and type in the auto number of these records they do not appear...yet they are stored in the table. Obviously this is due to the 'date due' field, but im not sure how.

I really don't understand what is wrong. Could someone please give me an insight into what maybe wrong or tell me what to search for in the forum, because the searches i have tried have not come up with anything.

Thank you

View 1 Replies View Related

Annoying Parameter

Apr 6, 2005

I have a SQL query in which I have created a parameter to be entered by the user.

This works ok, however... everytime the user is asked to enter the parameter twice...

How can I stop access from asking users the second time?

Cause... the way I see it, one time should be enough and the query itself doesn't state the line in which the parameter is twice either...

Thx!

View 5 Replies View Related

Annoying Combos

May 27, 2006

Hi There,
I know this subject has been beaten to death, but I have searched the forum and cannot find a post relating to my particular problem.
I have three cascading combos on a subform that work fine and dandy when I open the subform on it's own, but when I open the main form that the subform is embedded into, I get the following message [IMG]cascade[/IMG]
I know I am missing something simple.
Any advice would be most welcome.

View 2 Replies View Related

Annoying Query, Yet Simple? - Please Help.

Jul 29, 2005

Hi guys,

A friend of mine has recently created a simple database which holds details of childrens story books. It logs the name of the Author, the storyline, its character etc in various tables...

He's currently creating some simple queries for his database. However, there is one query which neither he nor I can figure out, I'll try to explain to the best of my ability.

Basically, the 'story line' field in his database explains the basic plot of the book, some of the plots have the words "son", "dad", "father" and "boy" in them.

Now, he wants to create a simple query, which looks up and displays data which contains the keywords "dad", "father", "son" etc in them. So far he's tried...

Like "*Son*" Or Like "*Father*" etc...

This worked, briefly. The query was bringing up storylines with both contained the words "son" and "father" , which is correct. However, the query was also bringing up story lines with the word "song" in them, or any word which remotely related to one of the keywords, but didn't contain the exact criteria in the query (son, father etc).

In basic terms, how do you create a query which only brings up words that match the EXACT query criteria? In this case, 'Son' or 'Father' or 'Dad' etc? Rather than words which only briefly relate to the criteria, such as 'Song' or 'Fat' etc?

Thanks for your cooperation, feedback and examples would be highly appreciated.

Thanks all,

Jonathan.

View 4 Replies View Related

Yes My Sql Newby Nuss Is Annoying =(

Nov 14, 2006

Heya, I know this is probably something simple as I know I have done sql problems like this before. However, I am wanting to show cars which have the same name but are of different colours (without duplicates), I figured I could just use a SELECT DISTINCT? However, when I do this it just brings up one car name and one colour when there are multiple colours.

SELECT DISTINCT car.carname ,car.colour
FROM cars;

I am guessing its because the SELECT DISTINCT statement is applied to both the name and colour.

If somebody could just tell me what I am doing wrong because I am guessing its something simple yet I am too frustrated to see what it is now!

Thanks =)

View 1 Replies View Related

One Annoying Duplicate Record Problem!!!

Aug 4, 2005

I have a search form passing text from unbound controls to a query. These two fields (AuthorName & Title) of the query are from two different tables (Authors & Papers) set up in a many to many join. The 3 dummy records I am using are as follows:

Record 1
AuthorName: Smith (Author 1)
Title: SmithTitle

Record 2
AuthorName: Smith (Author 1)
AuthorName: Jones (Author 2)
Title:SmithJonesTitle
(i.e. two authors for this record)

Record 3
Author: Jones (Author 2)
Title: JonesTitle

If I stick in 'Jones' into the Author field and 'JonesTitle' in the Title field I correctly get 1 result from the query (record 3). However, oddly, if I put in Smith and SmithTitle I get two records (2 x record 1)!!!!! There aren't two records!!! Similarly if I leave both blank I get all the records and again there is a duplicate of the Smith record (and only this one is duplicated!)

The query criteria are:

[AuthorName] Like [Forms].[Search]![Author] & "*"
[Title] Like [Forms].[Search]![Title] & "*"

Any ideas???

Thanks

View 5 Replies View Related

Currency Field Formatting - Simple But Annoying Issue!

Jan 10, 2007

Hi All,

This is my first post so can I just say how great and useful this forum has been for me since I joined! I have found pretty much everything I have wanted without having to ask, so thank you everyone!

I am only beginning with Access at the moment, as I try to implement some improvements to the way my company works!

I have one really simple, but annoying issue at the moment and I cannot find the answer anywhere!

I have a currency filed in my table. I want to format it in USD, but USD is not available in the format options, just £ and €. I cannot see where the hell I get the USD $ format from?

I know this is probably well simple and I am being a plum!

View 3 Replies View Related

POP UP Messages.....

Oct 17, 2005

Does anyone know if it is possible to add a pop-up message to an individual record in a database? and if so how do you do it???

I have a database which holds infomration about suppliers, some suppliers give us fixed prices for some products to general customers but they also offer another price for certain customers of ours. What i want to do is have a pop up message displayed to users that pull up these products with varying prices..

Anyone got any ideas???????????????????

View 1 Replies View Related

Weird Messages

Sep 11, 2006

I modified a form in an existing split database, by simply adding several fields. Now, I get various messages such as " not Access database "
or if it opens, the following message when I try to close it:
"Your last change may not have been changed because an internal buffer was locked by another user... "

Plus, when I do get out, I cannot delete the .ldb file which it says is open by Administrator. The thing is I ma only one to try this new database and I set no permisasions or... ?

Please, any ideas?

Russ

View 1 Replies View Related

Has Anyone Got Code For SMS Messages?

Mar 20, 2008

Hi All

Been asked to build a module to enable the user to send SMS text messages to mobile phones. I know Access can do this and some sample code I have seen was in VB and it uses MSXML2 but if anyone has any different approaches I would be interested.

Cheers
CodeMaster::cool:

View 2 Replies View Related

Update Messages

Nov 15, 2005

I have a form that has a bunch of text boxes and a few drop down boxes (that reference lookup tables) that allow the user to add to a lookup table.

I have this working and the tables are beign updated. My question is that when I go to save I get a message box saying ("YOU ARE ABOUT TO APPEND 1 ROW (Yes/No)") for every look up table.

Is there a way to not show this message box. I think I am getting one for the form and other text boxes in general and then 7 more for each Lookup table. I am cool with one, but want to get rid of all the Lookup Table message to update.

Below you will see a bit of the code that I am using to update the Lookup tables.



CODE:
SQL = "INSERT INTO tbl_CITY VALUES ( '" & CITY & "' )"
SQL2 = "INSERT INTO tbl_INSP VALUES ( '" & INSP & "' )"
SQL3 = "INSERT INTO tbl_OCCUPANCY VALUES ( '" & OCCUPANCY & "' )"
SQL4 = "INSERT INTO tbl_STATE VALUES ( '" & STATE & "' )"
SQL5 = "INSERT INTO tbl_TYPE VALUES ( '" & RENTALTYPE & "' )"
SQL6 = "INSERT INTO tbl_UNITS VALUES ( '" & UNITS & "' )"
SQL7 = "INSERT INTO tbl_ZIP VALUES ( '" & ZIP & "' )"


DoCmd.RunSQL (SQL)
DoCmd.RunSQL (SQL2)
DoCmd.RunSQL (SQL3)
DoCmd.RunSQL (SQL4)
DoCmd.RunSQL (SQL5)
DoCmd.RunSQL (SQL6)
DoCmd.RunSQL (SQL7)

CITY.Requery
INSP.Requery
OCCUPANCY.Requery
STATE.Requery
RENTALTYPE.Requery
UNITS.Requery
ZIP.Requery

View 2 Replies View Related

<HELPpls> Update And Messages

Sep 1, 2005

Please can someone give me a hand. I dont know a lot of coding but what I want to do is when I add a record with a IDnumber to a table I want the System to Check automatically if that IDnumber has been entered in 10 times in the table, if it has I would like a message to popup

Any ideas my brain hurts???

Cheers All

View 1 Replies View Related

Modifying Error Messages

Mar 14, 2006

Hi to all. I need to modify some existing error messages in my form so that I can create messages that will be more user friendly. I know that it is possible but searching for this issue was a bit confusing. How do I do this?

Thanks in advance

View 1 Replies View Related

Access Error Messages

Mar 27, 2007

Hi all,

Is there any resource that gives a definitive run down on all the errors that can exist within access; their causes and solutions. For example; the enter parameter msg box that appears when it doesn't recognise field value.

Just curious.

Thanks

View 2 Replies View Related

Aaarrrrghhhh - Error Messages Like No Other!

Aug 30, 2007

OMG - I've have spent what seems like forever doing this database and I've opened it and it has listed the following saying that they are broken references and I must fix them but I don't even know what they are!

What I have to fix is:-

actevent.ocx
activeACTx.ocx
ACTBAR.ocx
ACTSKIN4.ocx
QTOCONTROL.dll
AXCTRL32.ocx
AXAUTCTL.ocx
AXIS.ocx

I could just about put my head in my hands and cry - I just want to get this done so that I can get it invoiced before the month end.

Many many thanks to all that know what these strange alien messages are.

Donna x :eek:

View 7 Replies View Related

Delete Security Messages

Nov 28, 2007

Hi, when I want to open my new database a lot of messages appear, which are not really friendly for the user. Does somebody know how to avoid them?

The application "C:Program FilesMicrosoft OfficeOffice11msaccess.exe" is set to be launched by this pdf file. the file may contain programs, macros, or viruses that .......Then you are able to click on Open or Do Not Open

and

Opening Database.mdb
This file may not be safe if it contains code that was intended to harm your computer. Do you want to open this file or cancel the operation?
Cancel, Open or More Info

and

Security Warning: Unsafe expressions are not blocked. Do you want to block unsafe expression? Yes, No or Help

thank you for the Help. Mirj

View 1 Replies View Related

Error Messages On Forms

Feb 7, 2005

I have a form with the text box "Project Name"

I have used a command button placed next to the project name box which if clicked opens up a finance details form for the project name box.

Problem is if that project does not have any finance details it still opens up the form but just comes up as totally blank.

Is there anyway i can get an error message to come up and say
"No matching data found for this project" when they click the command button to open up the finance form, but there is no finance data?

I have tried but unsuccessfully.

I entered this code

Private Sub Label75_Click()
On Error GoTo Err_Label75_Click
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Contract Filtered"

If Combo22 = "" Then
MsgBox "No Matching Data Found", vbExclamation

End If

stLinkCriteria = "[Project Number]=" & Me![ProjectName]
DoCmd.OpenForm stDocName, , , stLinkCriteria





Exit_Label75_Click:
Exit Sub

Err_Label75_Click:
MsgBox Err.Description
Resume Exit_Label75_Click

End Sub


But instead of not opening the blank form, it comes up with the error message and then opens the blank form.

Or if there is finance data for that project it comes up with the error box still and opens the form

Any ideas people?

Thank you please

View 11 Replies View Related

Create Error Messages

Feb 8, 2005

I have a very simple database I wrote a few years ago that provides reports on data (mainly calculating sums & percents on those sums). When run, the reports open form-dialog boxes that prompt for criteria. The dialog boxes then become invisible & the query accesses the data in the invisible form & allows the report to run.

What is the easiest way to have the program display error messages when
1. The criteria entered is not found
2. The form/dialog box has an empty field

Right now, the computer has an automatically-generated action failed message and the macro halts. These are confusing to the user.

Thanks for any suggestions!

View 5 Replies View Related

Change Error Messages

Sep 27, 2005

Hi

I have two problems.

One when a required field is set to yes - i want to change the error message to something more meaningful.

Two i would like to stop people enetering data into a sub form on the main form when there is no data in the main form? I linked them using the wizard.

So main product linked to sub form with productID?

Many Thanks

scott

View 4 Replies View Related

Personalised Error Messages

May 10, 2006

I've validated some fields that users enter info into but can anyone tell me how I can change the message that pops up on the error message so that it is relevant to my system, i.e. is there anyway of personalising it? Please give me a simple answer, I'm not very good at using Access!

View 4 Replies View Related

Customisation Of Error Messages In Access. Is It Possible?

Feb 10, 2006

I am an A-level ICT student I am creating a database system for my year 13 coursework and was wondering if there is a way to edit the error messages which appear when an input mask is not followed correctly and such. Any help would be much appreciated. Thank you.

View 2 Replies View Related

Scrolling Messages - How To Link To A Table?

Mar 16, 2007

I have got the following code off another thread which works great!

I was just wondering if there was any way I can link the scrolling messages to a table so rather than having to go into the code to alter the messages the user can change them through a form or in the table.

Option Compare Database
Option Explicit

Public txtScrollStatus As String ' Needed for Status Bar


Private Sub Form_Load()
DoCmd.Maximize
' Text for Caption of Form
Me.Caption = " CAPTION MESSAGE " & Space(25)

' Text for Label on Form
Me.lblScrollingLabel.Caption = " SCROLLING LABEL MESSAGE " & Space(100)

' Text for Status Bar
txtScrollStatus = " STATUS BAR MESSAGE " & Space(25)

End Sub

Private Sub Form_Timer()

' Produce the Scrolling Text in Caption on the Form
Me.Caption = Mid(Me.Caption, 2, _
(Len(Me.Caption) - 1)) & Left(Me.Caption, 1)

' Produce the Scrolling Text in Label on the Form
Me.lblScrollingLabel.Caption = Mid(Me.lblScrollingLabel.Caption, 2, _
(Len(Me.lblScrollingLabel.Caption) - 1)) & Left(Me.lblScrollingLabel.Caption, 1)

' Produce the Scrolling Text in Status Bar of Access
SysCmd acSysCmdSetStatus, txtScrollStatus
txtScrollStatus = Mid(txtScrollStatus, 2, (Len(txtScrollStatus) - 1)) & Left(txtScrollStatus, 1)

End Sub

View 4 Replies View Related

Changing Messages / Date Fields

Jul 9, 2007

Hi Guys me again!!

After spending the last few hours searching the forum and net for an answer I have finally conceded again that I need advice

I have a field in a table called DOB (date of birth) this is currently set as a Date / Time field

It did orignally have an input mask for short date i.e 11/11/2011 but i have removed this for now.

On my form (Patients) there is also some code in the after update properties box of DOB to calculate a persons age which is entered into another text field on the form.

What I need is a customised message box if the user enters the date incorrectly i.e 11/11/11 instead of 11/11/2011 alternativley is there a way to change what the user puts in i.e 11/11/11 to 11/11/2011 automatically after udating but keeping the code to calculate the age?

Hope this isn't to confusing...

Thanks in anticipation

Paul

View 7 Replies View Related







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