I have a database that logs complaints. I've added a field to calculate the age of a complaint based on the date received and the date resloved. To update this field I have an update query that runs after someone closes an update form. My problem is that I recieve two dialog boxes one that confirms that I'm will be updating the table and another that tells me how many rows were updated. I would not like those boxes to appear so the update would look transparent.
When i try to insert data into a backend Oracle table (with ODBC) using a form, (i use docmd.runsql "insert....") Access gives me a message like"You are trying to append 1 row to the table are you sure you want to append?"
i want to suppress this message as i have to insert into 2 tables and delete from 3 tables when the user enters some data in the form, so it asks the user five times (say 2 times for insert and 3 times for delete..) when it inserts or deletes each table. the user doesnt want this to click every time when they do that... how do i suppress these messages, is it Access-specific or oracle specific? I am not able to do this..! is this any kind of exception that i have to put in??
I am designing a transactions database for some of my clerical staff. I've inserted a data entry subform into the main transactions form (which also has a subform that summarizes all the selected company's past transactions). This data entry subform actually has as it's record source a table that simply stores that one record temporarily.
So when the user is finished entering their current transaction, I have a Save button that actually just opens a popup form which displays the data they entered into the data entry subform, giving them a chance to verify their entry is accurate. This form has a Save button which runs an append query and a delete query, adding the record to the permanent Transacations table and also clearing the temp table.
The problem I have, I think, is that when the popup form opens, the main form data entry subform still has that record locked as exclusive. I believe this is the case because while I am indeed able to make changes to the fields on the popup form, none of these changes appear in the temp table. In other words, the user is not actually able to use the confirmation pop up form to make any necessary edits to their entry. This makes the form sort of useless!
Is there any way to customize append query confirmation message? Unclicking Confirm Tools-->Options-->Edit/Find-->Confirm-Action Queries disables all warning messages.
My query takes some records from one table and append them to another table. When I run the query, first warning message says "Warning you r about to run an append query that will modify data in your table" (this is the message I do not want to see) and then if OK is clicked, the message says "you are about to append XXX rows...(this is the message I would like to customize)
I have my form where each records image displays as you scroll through the records. I want to add a control similar to the file dialog control, where users can browse to an image file on their machine, and then preview it and Update it.
Hi I've been having this same problem for a while and I've had a bit of help here but none of the suggestions have so far worked.
Basically I need a way to stop people tabing through a sub form without entering data. The sub form has a check box that has to be checked (it can't be set as True as default) the required field doesn't work and for some reason the Enforce Referential Integrity on the join between the main table (tblCustInfo) and this one doesn't work either.
tblCustInfo = the main form tblAgentData = subform
I have a split database, using Access 2010, Sharepoint is 2007 I believe. I have a form where I can enter requests onto a log and I've set it up to allow attachments. However, I get an error of "Cannot update. Database or object is read-only." if I try to add/remove attachments on a record. I have no issues adding and updating the data other than the attachments.
I've also found that if I bypass the start-up options (using shift) then the attachments work fine. Unfortunately, through trial and error, I haven't been able to find a database option which I can enable and fix the problem.
How to have this functionality enabled without bypassing startup (I've only intended to do basic things like hide the nav pane).
Is there anyway to put common dialog box in MS Access Form. There is an option from ActiveX controls icon, but gives an error message, saying I do not have licence to use it ?
I have a Access 2010 DB. The mainform have a subform with one table alone.
I have a button who close Access when the user are finish on the mainform. Still I have the upper right corner X-button who also closing the app.
My problem is that when the user use the X-button then a dialog box appear and ask for saving the changes for the table in the subform on the main form. The user must then do the choise 'yes' , 'no' , 'Cancel'.
There is no need for this dialog box, (I take care if it's necessary earlier) but I can't get rid of it.
I have the following code which successfully opens the dialog box with filters however when I add a function with an Excel import, the filters do not work at all (no files are shown even though they exist in the directory that's opened within the dialog box). If I manually type in the filter (i.e. *.x) it still shows the files.The function at the bottom was provided by cheekybuddha from another form, I'd be lost on getting the Excel file imported into Access.Here's the VBA code (the Function is also included at bottom):
Code: Private Sub Command0_Click() On Error GoTo PROC_ERR Dim strpathtofile As String Dim strTable As String, strBrowseMsg As String Dim strFilter As String, strInitialDirectory As String Dim blnHasFieldNames As Boolean
I want to retrieve some parameters from file, So for that i want to implement File Open Dialog in One of the form. File Open Dialong is available in Micrososft Common Dialog controls.
When i choose Microsoft Common dialog control from extra toolbars, it gives me error saying that "You don't have licence for using Common Control ActiveX.
I've written a function which opens the Outlook GAL dialog, allows users to select recipients and passes back a 2-D array (recipients and type i.e. To, CC or BCC).Here is the code :
Code: Public Function GetContactsFromOutlookGAL() As Variant Dim appOutlook As Object ' Outlook Application Dim objNameSpace As Object ' Outlook NameSpace Dim objSelectNamesDialog As Object ' Outlook Select Names Dialog
[code]...
The only problem I have is that when I 'display' the SelectNamesDialog, it doesn't make it the active window and bring it to the front - it just opens the dialog in Outlook and you have to navigate to the main Outlook window to find it.I'd like for the dialog to 'popup' - ideally, without the main Outlook window dragging along behind
I believe it's possible (judging from this article) to achieve this using API's - specifically, a combination of FindWindow (to retrieve the window handle) and ShowWindowLong (to set it to a topmost window in front of all other windows).
I am trying to remove random characters from a field. The field [assycode] contains a string similar to say, FGEJBF1 or ABFGYRUKC I want to remove any occurrence of "F1" normally at the end of the string but not always at the end. I used: Like "*f1*" to find the correct records, that worked fine, I then used [Assycode]-" f1" in the update to box, It wants to update 146 records I click ok then it says It couldn't due to a type conversion error. Just messing around I tried adding "F1" to these records using [Assycode]+" f1" and it worked fine. Can anyone point me in the right direction?
is there any way to get rid of deletion confirmation when you run a make-table query. though I unchecked all boxes under Confirm on Edit/Find tab, still popping up.
I'm wondering if its possible to have a "would you like to save changes, yes/no" thing pop up after data has been added or changed to a form, or have the option to save when closing a form and if no is chosen then any data changed is not saved.
Just as the title describes, I can't seem to find a solution to be able to link the front-end to the back-end tables through the common file dialog when the backend is an accdb file that is password encrypted.
See the example attached. Here it should work just fine per the Article at :
http://support.microsoft.com/kb/181076
I've found it works fine without a password encrypted back-end but not with a password encrypted back-end.
Anyone have any ideas? It would be nice to use this feature in Access as well as automating the relinking.
I have a question that I have a Microsoft Access database (.accdb) front-end/backend split and I want to give the database to my company client. As we have the different path for the backend/frontend linked. I want some code that will popup if the database location is not found and popup with the dialog so the user then select the backend and it would be ready and there is no need to popup each time the database open, it would run once it did not find the last linked path.
Also I have tried the code of Dev Ashish URL.... but unfortunately it would ask everytime to refresh the table links and I only want to run the process of linking tables when the database start and the linked path not found.
I am trying to create a button to delete record, I have used the wizard and it works fine but now I want to have a confiirmation message to confirm that they really want to delete this record.
below is my code. The prompt works but the record never deletes.
Any Idea's
Private Sub cmdDeleteRec_Click() On Error GoTo Err_cmdDeleteRec_Click
DoCmd.SetWarnings False If MsgBox("Are you sure you want to delete this record?", vbYesNo, "Warning.........") = vbYes Then Me!frm_Entry.SetFocus DoCmd.RunCommand acCmdDeleteRecord DoCmd.SetWarnings True Else DoCmd.SetWarnings True End If
My training table consist of 3 fields and using unbound form
1st field custid (text field)
This can't be NIL or Can't duplicate
What I am looking for learning point of view (duel check at same field with different behaviour).If record is duplicate "Popup message" and curser move back to same field.If field is empty "popup message" Do you want to continue, If yes, move back to field if NO, close form..Therefore, on Before Update event I wrote the following.
Private sub txtcid_beforeupdate (cancel as Integer) If Dcount("[custid]", "[customerdetails]", "[custid]='" & me.txtcid & "'") > 0 Then MsgBox "Customer ID already Exists !!!!" Cancel = True Me.Txtcid.Undo
[code]....
Just a quick update "I tried to used YES or NO option in Exit event too, but no success.
I have a form and I have created an event procedure on the "before update" property of the form. My procedure is:
Private Sub Form_BeforeUpdate(Cancel As Integer) Dim pwd As String pwd = InputBox("Is the information you entered correct?") If pwd <> "yes" Then MsgBox "Record Not Saved" Me.Undo Else MsgBox "Record Saved" End If End Sub
the record is not saving under any situation. What do I have wrong?
Attached I have a database that I've been working on which has a form called "frmCriteriaSearch". It is based off of the qryCriteriaListBoxUpdate query. I am trying to get the listbox in the second tab of the results section to work. It queries fine for the checkboxes, but I cannot get the comboboxes to affect the query (unless a checkbox has already been selected)
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!!
i have a form that i want to stamp with a date when it was last updated. if a change to the form is made it will be stamped with today's date. i used the BeforeUpdate event so that you could choose to save the edits or not so if you didn't mean to edit a record then the date would not change. the code is: Dim myVar As Byte myVar = MsgBox("Changes to this issue have been made. Would you like to save the changes?", vbYesNo + vbQuestion, "Save Changes?") If myVar = vbYes Then [LastUpdate].Value = Date Else Me.Undo End If
my problem is that when i change the combo box values it will run this event and ask to save. i think the reason this is happening is because the comboboxes save when you change them. how do i accomplish the same task as above but allow the combo boxes to act like txt boxes?
also is there a way that when i ask if the user wants to save or not, to have a cancel button that will take no action, leaving the record open the way it was (new typing and everything) before the user tried to close the form without saving that info?
Hi all, I have 2 tables, “DATA-CUSTOMER” and “DATA-MAIN”“DATA-CUSTOMER” has the following fields:Rep_code, Area_code, Name, Update (yes/no)“DATA-MAIN” has the following fields:Rep_code, Area_code, NameI have a form which has 3 combo boxes, looking at the following fields: rep code, area code, name,. These combo boxes are picking the data up from querys which look at the table: “DATA-CUSTOMER”I am trying to enable the user to select from the 3 combo boxes these 3 fields and it should update the table “DATA_MAIN” with these details. It appears to update the "DATA-MAIN" with one record but keeps overwritting the first record, and the combo fields in the form already have fields selected, i would like them to start of blank when entering the form.Any help would be appreciated, attached is test database that I cant get to work properly.cheers, Kevin
