I have "unchecked" all the confirm options under tools, but when I run the make table query it still displays "The existing table will be deleted before you run the query, do you wish to contiue? I would like it to just run without this message, or at least give a message of my choosing. Is this possible?
Thanks!
Hi Guys,
8 posts on the subject over a number of years and the answer seems to have been no, you can't have an auto number field in a maketable query.
Is there any reasonable way to create a sequential count of the records shown in the maketable query, not the underlying records?
Background:
I have a maketable query that selects fields from 2 tables which are ordered in a specific way. The sigma button is clicked to reduce this recordset to unique entries and this is what goes into the created table.
This newly created table is a row heading for a pivot table query and I want it ordered by the method used in the query. An autonumber or some method of counting/incrementing the records would do the trick.
I am currently creating the table and then adding the Autonumber field manually, which is hardly a solution at all. :confused:
An afterthought before I post: The reason I want the autonumber field is that the pivot table shows the records in alphabetical order rather than the order the table holds the records. Is there any way of forcing the pivot table to use the records as ordered in the table. A note of caution here, I get very confused when dabbling with pivot tables. :eek:
Any thoughts/solutions welcomed. And if I'm asking the wrong question, let me know! :)
All of the types? Including Memo?
View 2 Replies View RelatedI already turned off all the checkboxes for running query confirmation (in the tool/option/Edit&find) but the users of my database still receive the pop-ups every time they run the queries. How can I fix this problem? (My database is for multiple-user environment.)
Thanks in advance,
I have a recordset with 335000+ rows. The database contains 8 different columns. I have a series of queries that validate each column element. I then use a UNION query to combine the mini queries because the validation results is the same, as well as the query structure. The validation results can either be, "PASSED, FAILED, or DROPPED".
I am trying to create a crosstab query to display the COUNT of each occurence of validation, per query. The problem is, for each query (row) in the cross tab, the total of each query is not the same, and is less than 335000 rows. One query could show 319000, another 323000... I don't know why this is doing it, because if I run each query separately, it says each one contains 335000 rows, and each row has a validation result.
Any suggestions?
I am basically making a form to streamline the processes and functionality of my database project, so basically it's just a form that runs queries.
However, whenever it runs an action query, it always brings up a yes or no prompt for whatever action it is doing. Is there any way to disable these prompts (i.e. default yes to everything) or is this just an annoyance I will have to deal with?
Thanks.
hi,
can any i tell me how to create a form or a simple messege to show the user, whe click to close the db???
for eg, show a messege like " Are you sure you want exit" Yes for Exit and No for carryon.
thanx
I have a bug in Access. Despite having turned off the confirm record changes (Tools>options>edit>Confirm) the prompt still appears in the app after it is converted to MDE and packaged for distribution.
My solution will be (if I can find it) to set the 'confirm record changes' setting to off in VBA code immediately prior to my update.
My problem is how to do it. I have looked everywhere without success.
Can anyone suggest the necessary code.
Thanks .
I am automating a mail merge with Access to Word. Does anyone know how to stop the Confirm Data Source dialog window from coming up and just except the default (orginal) data source? I have users that do not know they should just click the OK button, some are clicking NO and then I lose the connection because they dont know where the table link is. I dont know what else to do but tell them to always click the Yes button when confirming but not everone listens and then i have to do it all over again.:mad:
View 2 Replies View RelatedI would like to have an update (requery) button on my form, that when clicked opens a message box that asks "ARE YOU SURE YOU WANT TO UPDATE?", if yes, a yes button is pushed, which requeries the record and closes the message box. If a no button is pushed, the message box is closed without requerying the record.
Can someone walk me through the process?
I use the Access 2007 runtime to run my Access database on a few client machines. How do I turn off the confirmation of Action Queries? On clients that are also running MS Access, I can simply open Access, go to Access Options and uncheck the box. When I make this change in Access, the same settings apply for the Runtime on that computer. Which makes me think perhaps there is a registry entry I can modify someplace? If anyone has an idea as to how to turn this off for the runtime please let me know.
Thanks!
I have a small procedure I'd like to include in my database. I want to confirm with the user with some sort of modal popup message (I think that's the right term) when they abort data entry on a form (anywhere on that form which consists of several pages, and a linked subform on one page). I think I can use the "on undo" event, but I don't know what code to include to make this happen...
Tried searching for this to no avail, but I would think this is a common procedure to prevent users from accidental data entry abortion.
Thanks,
Brad
I have a Multi user Access Database which has been split into a Front and Back end. What I am noticing is sometimes when the user enters data into the Front end form, it is not being saved in the Backend tables....
How to confirm when the user clicks save that the data is actually being saved in the backend tables.
I'm using Access 2007..I have a table that contains transaction records from a bound form.When the user enters a certain type of transaction, I create a corresponding transaction in the after insert event.
Example
User record - tranId = 1, tranAmt = 10, tranType = DISB, tranAssocID = 0
My record - tranId = 2, tranAmt = 10, tranType = RECV, tranAssocID = 1
When the user deletes a record, I want to delete my corresponding record using the tranAssocID ( delete * from tran_tbl where tranAssocID = (the tranID of the user's record)
Problem:
1) I don't know how to save the tranID of the users record
2) I don't know how to reference the saved tranID in the delete statement.
I'm using the before delete confirm event to try to save the users tranID to no avail.I'm using the after delete confirm to delete my record in a case statement - acDeleteOK...I tried to save the value of the ID in the form (Me.tid) to a public long variable, a hidden field on the form, and a temporary variable to no avail.
Hi Guys & Gals,
I have a report that runs a number of queries via a macro in the on open property. These queries populate a table used in the report. The on close property runs a query to clear the table contents.
When a user ran this, he had a flurry of warning notices which I tracked down to the Confirm settings in the tools/options/edit find tab.
Is is possible to set these using vba?
I guess that this could be achieved using send keys, but this would probably be a bit clumsy - to say the least.
Can it be done so that the settings are changed only for the current session so that users have the original settings?
Any thoughts welcome.
Regards,
Keith.
I have a single table in my database and I have to make a form for entering contact details for clients, staff, funding bodies and everyone else into this table. There is a phone number and what code I would use the get it to check if the number already exists.
If it does, I wanted it to return a custom message telling you what entries it already exists for by displaying certain fields so that they can be identified, such as name and organisation, but then I wanted the custom message to allow you to confirm entry of the data anyway. This is because there may have been an error in entry or as some people may be contacted on the same phone number, I want it to allow the option to continue and enter the data anyway.
I have a database in which users have the ability to search by last name...nothing fancy there. However, the users continue to forget to click the Find Client button and instead just type what name they are looking for in the LASTNAME control thus changing the record that they are currently in!!!
I am looking for a way to have a msgbox pop up any time the LASTNAME control is changed. I found the code below but this works for the entire record and I don't want them to have to click Yes every time they make change.
Code:
Private Sub Form_BeforeUpdate(Cancel As Integer)
If MsgBox("Changes have been made to this record." _
& vbCrLf & vbCrLf & "Do you want to save these changes?" _
, vbYesNo, "Changes Made...") = vbYes Then
DoCmd.Save
Else
DoCmd.RunCommand acCmdUndo
End If
End Sub
looking to have the following code run only when I have a specific value present in one of my combo boxes: e.g. cbo.status = "Approved"
Code:
Private Sub Form_BeforeUpdate(Cancel As Integer)
'Provide the user with the option to save/undo
'changes made to the record in the form
If MsgBox("Changes have been made to this record." _
& vbCrLf & vbCrLf & "Do you want to save these changes?" _
, vbYesNo, "Changes Made...") = vbYes Then
DoCmd.Save
Else
DoCmd.RunCommand acCmdUndo
End If
End Sub
how I can automatically change the Client settings either with a macro or code. Specifically for the three confirm actions (Record Changes, Document deletions and Action queries). I have a database that is distributed to end users in different offices around the world. The old way lazy way, was to go to each computer and set these settings to "off" manually, but this isn't possible. I want to be able to run delete queries and action queries in the back end without the end users knowing its happening and having to select yes all the time.
View 3 Replies View RelatedI'd like a confirm dialog to appear on button click, so when the user clicks 'yes', the on click event should continue and when the user click 'no', the event should stop.
View 2 Replies View RelatedI am fairly new to Access and my "changed" position at work requires that I learn much more about the software. My first challenge is to learn how to make an existing form prompt a user to confirm or cancel changes. I don't know anything about coding but I searched online and found some coded that is supposed to make this happen. I went to "form properties'' and typed this (below) in BeforeUpdate:
'If the form data has changed a message is shown asking if
'the changes should be saved. If the answer is no then
'the changes are undone
On Error GoTo BeforeUpdate_Error
[Code] ....
BeforeUpdate_Exit:
Exit Sub
BeforeUpdate_Error:
MsgBox Err.Description
Resume BeforeUpdate_Exit
After saving changes to the design, I tested by changing the record. I received no prompt.
All I am trying to do is insert to have a form with a "Delete Record" button on it. The problem is I don't want anyone to be able to delete a record, I would like someone to have to insert a password to confirm the delete.
View 13 Replies View RelatedI have created an .asp form input script to write to an access database.
One of the fields is E-Mail__________
The next is Confirm E-mail _________
Any ideas on how to make sure that the Confirm E-Mail matches the E-Mail field input?
Thanks for you time.
I use datasheetview, when I want to delete the record I just select the row and press delete button and click "yes". However, when I click "no" (means I don't want to delete) the record is disappeared.
I create refresh button to Requery and Refresh the form but the record still not comes up. I have to close and open my form every time.
Any suggestion would be very appreciated.
What is the best way to impliment a query in a form so that the user can view the query records, and have the option to print or save the selected record using command buttons?
I tried subforms but I could not get the command buttons to work in the subform after it went into the form, it wanted to print the entire form instead of the selected record from the subform.
So in a nutshell I have 3-4 queries that are built, and I want to have them show up on my form in a format that the user can scroll through the results and select a single record of the results and then print or save that individual record from the form, if such a thing is possible.
Thanks in advance
Todd
I am trying to do the good 'ol sales report (query) to include customers with no sales.
I have a customers table, account number table, sales table & sales (line) detail table. (all linked in that order)
If I run a query to show customers (in the customer table) with account numbers, that works
An unmatched query to show customer without an account number works (but of course the unmatched account number field isn't shown).
How can I get the two two be shown together with the "unmatched" having a null or 0 for their account number?
I am guessing in principle, the resulting solution can be modified to show customers without sales alongside those with sales?