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
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
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.
I have 3 different "buttons" on my form that run individual update queries. I know these update queries are running correctly. Decided to make a macro that will allow me to run all these queries by clicking one macro button.
My question is: Is there some way to stop the pop up msg that advises I am about to run an update query and the next pop up msg that informs me of how many rows I am going to update?
These pop up boxes are starting to drive me crazy when I run the macro.
I have a button that inserts values into a table. But every time is dose this, a update message appears. How can i change this so this doesn’t appear? Is it something to do with the security settings? or is there some code which automatically clicks yes? - I want to min user involvement.
Update Message
************************************************** ******************************
Your about to update 15 row(s)
Once you have clicked yes, you can't use the undo command to reverse the changes.
Are you sure you want to update these records?
YES/NO
************************************************** ******************************
Kind Regards
Richard
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???????????????????
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
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:
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
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
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:
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
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
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
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!
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
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 RelatedI 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 RelatedI 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
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
I have a database containing various linked tables and all has been fine for years.
I now have to add some fields to the main table and change some field sizes. I know about the 255 field limit. And I know that an individual record cannot exceed 2K.
BUT, when I simply lower the size of a text field, (i.e., from 40 to 30), I get either the message Too Many Fields Defined or Record Is Too Large.
Hi All,
I've put an input mask into a table and would like to personalise the error message to give the user more information about how they should be entering the data correctly. I don't know where to start with this - can someone point me in the right direction??
Many Thanks,
Mary
Hi there,
I have an access database in which I am updating a table from a form using visual basic for access. I have got the update to work, however before the application appends the table, it asks a question "You are about to append a row" then an option for "yes or no"
I have a custom message that appears after the appending, but I do not want the message in bold above to appear at all. Does anyone know how I can suppress that message?
Thanks
I have developed a form and used code to disable the append messages Access displays the user such as: 'You are about to append data, do you want to continue'.
The form works great on my machine and I don't see the messages. When i use it on another machine the messages appear?? Please help.
Is there a way to disable the automatic error messages that occur when a user:
1. enters a letter in a number field
2. enters a date in the wrong format (should be MM/DD/YY and they enter MM//DD/YY, etc.)
3. clicks on a button that will open a hyperlink (Currently a message pops up to make sure the user wants to follow the link, by selecting "Yes" the hyperlink opens.)
I would like to add in my own error messages for the above errors but I don't know how to disable the system generated error messages.
Thanks!
Hey,
Newbie here,
my frist error message appears as soon as I create a new database. As soon as a I create the name and it opens the new database a message pops up that says "Error Loading DLL" does anyone know what this is? and will it create a problem for me?
Secondly, I have a database that will be used for employee Reviews so the fields I have are as follows: Key, Date, Time, Department, Employee, Topic, Explanation, and Supervisor. I want to be able to generate a report for each employee, however I am not sure how to use the wizard to create this. If anyone knows of some tutorials or report aids I'd love to get my hands on them!
thanks!
~Jennifer