Hi there,
I apologise if this has been answered, I couldn't find anywhere else on the forum.
On the data access page it gives an annoying warning that says 'This website is using your identity to access a data source. If you trust this website, click OK to continue, otherwise click cancel'.
Is there a way I can suppress this message? It looked cool at the start, but now it's just annoying....
Thanks!
I do have a DB that takes some data from Stripes and imports them into access. Since this will be a multi user DB I want to make a warning form.
Basically a user will do the download, I want a form or a pop up message that will show to the next user that will open the DB while the download process is ongoing, to see that the download data process is still ongoing, That he needs to wait until the data download has finished.
I have an Access 2010 db on a shared network drive. All users accessing the db are running Windows 7 OS and have a licensed corporate version of Access 2010. The advanced options "Shared", "Edited record" and "Open dabases by using record-level locking" are turned on. Additionally, the locking time limits are set to their default levels. If a user selects the save icon after making additions or updates, the following waring message appears:
Costar Job Database can't save design changes or save to a new database object because another user has the file open. To save you design changes or to save to a new object, you must have exclusive access to the file.Since I developed the db, I am the only one that makes design or object changes. I know that users don't need to select the save icon to update the db, but I don't want them to "freak out" if they select save and see the message.
Is there any way to prevent the message from being displayed?
Anyone know how to suppress the folowing warning:
(I don't have admin rights so my solution will have to be done within Access :rolleyes: )
ok, i'm probably gonna confuse a few ppl here, lol :rolleyes:
i keep getting a warning message when i try to open winamp from within access, is there any way i can stop this warning message from appearing?
any help would be most appreciated
can someone please modify the following code to add a warning message to an add button.................this add button allows to add details filled in a form...
Private Sub addrec_Click()
Dim strSQL As String
DoCmd.SetWarnings False
strSQL = "INSERT INTO tab_main ([username], [cost_centre], [number], [phone_model], [imei], [puk_code], [sim_no], [date_issued], [notes], [tariff], [call_int], [roam]) VALUES ('" & Me.username & "','" & Me.cost_centre & "','" & Me.number & "','" & Me.phone_model & "','" & Me.imei & "','" & Me.puk_code & "','" & Me.sim_no & "',#" & Me.date_issued & "#,'" & Me.notes & "','" & Me.tariff & "'," & Me.call_int & "," & Me.roam & ")"
DoCmd.RunSQL strSQL
DoCmd.SetWarnings True
End Sub
warning message such as Are you sure you would like to add USERNAME(whateva is inserted in the USERNAME FIELD)
thanks
Hi All,
I have a data access page needs a filter by a dropdownlist, the dropdownlist used is a html control and I use javascript to filter the data programmaticlly in the onchanged event of the control.
MSODSC.DataPages(0).Recordset.Filter="AppID = 3";
My problem is, when this statement runs, the page refreshes. But I don't need the page refreshes, it set the dropdownlist text to the default text, not the value user select. The browser is IE7.
How can I stop the page refresh itself?
Thanks and Happy New Year!!
I use a close button to close a form. There is list box in this Form. If the list box is empty, then simly close the form. However, if there are projects in the list box, I want to give a warning. If the user say YES, then everything in the listbox will be deleted and the form will be closed. If user say NO, tehn the form will not be closed. They then can use anotehr button to save teh projects.
I wrote the follwing code. The delete portion itself works. But it seesm comfused with msgbox. Could you pelase help me correct this code? Thank you very much for your help.
lbDestination -- list box name
Private Sub Close_Click()
On Error GoTo Err_Close_Click
If IsNull(Me.lbDestination) Then
DoCmd.Close
Exit Sub
End If
If MsgBox("You have unsaved initiatives. Are you sure you want to close?", vbQuestion + vbYesNo + vbDefaultButton2, _
"Delete?") = vbYes Then
Dim rsDestination As DAO.Recordset
Set rsDestination = CurrentDb.OpenRecordset("tbInit", dbOpenDynaset)
rsDestination.MoveFirst
Do While Not rsDestination.EOF
rsDestination.Edit
rsDestination.Delete
rsDestination.MoveNext
Loop
Me.lbDestination.Requery
End If
Exit_Close_Click:
Exit Sub
Err_Close_Click:
Resume Exit_Close_Click
End Sub
I have struggled with this for so long now I hope someone can help.
I have a form called frm_Collections which is run from the query (qry_Collections). When I type into the Reg field in the Form I would
like the user to know if the Reg details have already been used in a
previous record. The database can have duplicates in this field, however a
"Warning Message" would promt some investigation.
I have tried loads of DLookup on Before Update, but really need setting of
in the right direction.
Thanks
Hi all,
I am building a simple db from scratch using the limited knowledge i have, and a lot of the information gained from searching these forums as a guest. I've now reached a point where I can't seem to find what I'm looking for, so any help would be gratefully received!!
I have a single table, single form and single report (told you it was simple;)). The table has nearly 2000 records and 2000 pictures (linked). On the form I can print every record with a single click of a command button. This is great, but I would like a message box to popup and confirm the print action, as this is gonna be expensive if its clicked on every record!!
If anybody can help, I would be chuffed!! I searched the forums and can't seem to find anything on this!!
j
I have a temporary table within my access database. I have a macro button that makes the table (thus deleting the old one in the process) and then appends information from three other queries to it.I want to stop the standard warning message from coming up. The message I get is below. I have already cleared the action queries check box so the warnings for the making table (if no previous table exists) query and appending data query have disappeared. However the below message still pops up when the make table query begins to try and delete the old table. How I can make it go away?
"The query you are about to run is a make-table query. Unlike most queries that displays data in Datasheet view, a make-table query creates a table and copies specific records from one or more tables and queries. If the table already exists, the query will replace the structure and contents of the table.If your intention is to create or replace a table, click Yes. To avoid being prompted when you run such queries, click the File tab, then click Options. In the Access Options dialog box, click Client Settings. Under Editing, clear the Action queries check box.
I would like to show a Message box to an operator when a certain number of records have been reached in a subform e.g when 36 records have been entered I want a message to appear telling the operator that a certain report can then be raised. Whether this is possible
View 5 Replies View RelatedI have a questions database. When user is filling out the form, the following fields are required: Questions, Author, Type of Question and Answer selected. Answer is selected by clicking on the button next to the Answers. If these fields are not filled out, a user gets a prompt saying that so and so field is blank. If have a problem, it works for all required fields except for Answer. Below is my code. I have attached a screenshot with Author and Answers blank. I only get a warning about the Author and not the Answers.
Code:
Private Sub Form_BeforeUpdate(Cancel As Integer)
nullerr = 0
strnull = ""
If IsNull(Me.txtQuestion) Then
nullerr = 1
[code]..
In an MS Access 2000 - SQL Server 2005 project I use a "Microsoft Office PivotTable 9.0" control on a form. The control is populated by a stored procedure. This works fine but when the pivottable opens a messagebox with the title "Microsoft Data Access Components" and a message "This page accesses data on another domain. Do you want to allow this ?" appears.
After clicking "OK", a message box with title "Microsoft Office" and message "This website is using your identity to access a data source. If you trust this website, click OK to continue, otherwise click Cancel".
After clicking "OK", the pivottable opens.
How can I get rid of these messages ?
On the internet I found some suggestion to add a website in the Internet Explorer settings "Trusted sites". What's the meaning of that ? The data for the pivottable is in a local SQL Server database, so which website do I have to add to the "trusted sites" ?
Any solutions for this problem ?
One other question: is there an alternative for the "Microsoft Office PivotTable 9.0" control ?
I have a combobox with several options for a device's parts. When one part is selected, it gets added to a device table.
ComponentCmb
Generator A
Generator B
Gearbox A
Gearbox B
Blades A
Blades B
Blades C
Tower A
Tower B
I want to display an error message if an option is being selected more than once.
For example, if a gearbox has been chosen, then another gearbox cant be chosen too.
How do i display this warning message.
I have a table (ComponentT) of different device components a user can select from ( generators, gearboxes, etc.)
The table has 3 fields - ComponentName, ComponentType, ComponenentDetails
I have a query returning all the ComponentDetails values.
I then have a combobox that uses this query as a row source.
The user can select different components they want from the combobox. Once something is selected, it is added to a new table - UserSelectedComponentsT
As a device can have only one gearbox or one generator etc. I want a warning messagebox to be displayed if the user tries to select a generator from the combobox when one has been previously selected.
Is it good to use (to make) Data Access Page to access the database (and put it on the web ) ?? :confused:
View 1 Replies View RelatedI have a photo (jpg format) which store OLE field in a table. But, I would like to display it in a Data Access Page. But, I have being prompt the following error: "You tried to drop an OLE or long binary column onto your data access page. There is no HTML control which binds correctly to this column type."
Do anyone know how to overcome this problem?
Hi,
Can anyone tell me how I can get my data input web page to load with a new fresh input page. At present, each time a user opens the form, it displays the last record that was input previously.
When using a form, the record properties can be changed so that when the form is opened, it displays a new blank record to fill in. I cannot find any properties in the web page design view that allow it to be set to startup with a new blank page rather than the last record that was entered.
Any suggestion?
Thanks
Hi,
So i have made a Data Access page using the wizard from a table called Employees
I want the Access page to have some sort of search button so that they can quickly find an employee, rather than scrolling through all 100 records.
How can i do this?
Thanks Brian
Hey guys,
I'm somewhat new to MS Access. I'm trying to allow a user to update, add/delete records through a data access page. I am able to view the query, navigate through the results, but I am not able to make any changes. I get a pop up message saying the record set I am using is read-only. As far as I know, my table is fully editable. Anyone have input on this issue?
Hi All,
I have created a Data Access(DAP) Page to append the sales order received on phone. The Data Access Page is linked to query which has autonumber field to store the Sales Order. I have a textbox on DAP for Sales Order No. The autonumber generated in Table is different from autonumber generated on DAP. I want same the autonumber on page and in table.
Thanks for time.
S Acharya
Hello Everyone,
Can you allow the users to update and edit the data access page and actually change the data in the database? Or is it just a view only? If possible I need the user to be able to update the database through the data access page.
Is this possible?
Any ideas would be helpful.....
Thanks
I have a database for my staff to enter data into via a data access page. It works on all windows xp os computers. We do have staff working on Windows 2000 os computers and it is not working appropriately.
The database was created in Access 2003. When the user pulls up the page, none of the drop down menu's populate. I try to trouble shoot it and access states that it can't make a connection to the database. This is only on Windows 2000 os. Windows XP computers work fine.
Any suggestions?
Thanks in advance,
jason
I have built a BD with several date fields (on a form) that were set up with a simple command button for "today's date" to be entered.
I'm attempting to set up a Data Access Page that is very similar and easy to use. I need help setting up command buttons that auto-populate text boxes.....if this isn't the best route, I'm open for ideas.
I have just started putting the Access Data Pages together and don’t have a real good grasp yet.
Any help would be great…..
I have a database that I'm trying to create a data access page for. The database allows people to put in their information and register for a conference. This part works fine.
I tried using the data access page wizard to create the page. I can't seem to get the connection string to point to the database so that when I upload both to my FTP, they will work together.
I have successfully uploaded the access pages to the FTP, but it will only update the database if it remains on my computer.
How can I set the location to be relative to the data access page? (eg - DB1.mdb is on ftp in /_private, data access page in same directory on ftp and looks in its own directory).
Or, maybe the problem isn't this straight forward?
Thanks,
--Jim