I was editing one of my tables in datasheet view and when I closed the table, Access asked me if I wanted to save changes. But I didn't make any changes to the design of the table or the filters I had set up. I just edited the data within datasheet view. The reason this is bothering me is that I am afraid I accidentally changed something. The only explanation I have for why it asked me if I wanted to save changes, is that I used the "undo" command to cancel a typo that I made while editing in datasheet view. When I hit "undo", it fixed the typo, and scaled back up to the first record of the datasheet. At first I thought using the "undo" command might have been the culprit, but when I re-opened the table and used the "undo" command again, it undid the change, but it didn't scale back up to the first record of the datasheet, like it did the first time I used the command. Anyway, I am staying away from the undo command from now on. It's about worthless in Access anyway, because it only undoes your last action. Have any other Access users been asked to save changes when they know they haven't made any changes to the design of the table?
This has happened to me several times in the past. I make minor changes to a report and when I go to save it or close it out, it asks, "Do you want to save changes?" Of course I say yes and it just sits there, not closing out the report tab. The only way around it that I have found is to re-write the report, from scratch.
I have noticed that when i am editing an object within my database, specifically a query and click to close it, it doesn't prompt me to save the changes and does it automatically. There have been cases where i do not want to save the changes and just wanted to know if there was a simple setting to turn off automatic saves?
Why when I set up a macro with a PrintOut action does it always prompt me to "Save As" before it prints? I have a default printer set up in the system, but it still asks to "Save As." It does print after.
So I have this relatively simple problem: I need to create a button that once clicked will open the Save As dialog box and allow the user to save a copy of the current database where he wishes. The filename should contain todays date in DDMM format along with some pre-set text e.g. DDMM PresetText.
I have a few selected reports on an Access 2007 database that users can run. Is there a way for users to view the report, save as a PDF and automatically save a copy to a shared drive by modules/vba coding as an On Click event procedure?
I recently changed the code to a case statement which recoded a value into a new field
i.e.
Case = 1 Me.Field2 = 2
and so on...
However the old data would not reflect this change as the Me.Field2 value had already been created.
Short of opening each form, changing a number closing it and then changing it back to original value, it there any way to get the database to rerun all the code in the background essentially?
I have created a button to save changes and to undo changes on a form. However if the user has not made any changes, i get a message saying that the Undo command is not available and the same with save changes.
Therefore if no changes had been made i would like to just ignore that part of the action and continue with the rest of the event procedure.
I need code for save dialog file ,and select the file from textbox and save it to the selected location.i have only this code and i dont know what else i can do with this because it just opens the save file dialog !
Does anybody know of a site where you can download/modify/use pre-made databases files? I am looking to create a basic database to store survey details about signage on site for 200 sites. Details i need to include are Site, Sign, and Components.... I think the database itself would be fairly standard, even if the fields needed tweaking I don't want to invest the time into this if there is something I could use already out there
Im fairly new to MS Access and have recently created a simple database to track the details of people in my department.
The database is on a shared drive and the idea was that when the details of the individual change, they open the database themselves and edit the appropiate field.
However, is it possible to track the changes that people make over a certain period (ie every month).
I've made my mde file from a mdb which is fine apart from the fact that I can still view all the tables and queries and more to the point able to change them. Has anyone come across this before, if so how can it be fixed?
I need to know if there is anyway to view any changes made to the security workgroup file I have with my database. I need to know when or if someone is changing it to allow someone else full access to the database, any help would be greatly appreciated.
I have two tables Tbl_Referrals and Tbl_CMSData. Both of these tables have an identifier in called ConflictID. I have created a query which selects the records from both tables where the conflict ID is the same.
I have a form running this query. Down one side of the form i have all the details from Tbl_CMSData and on the otherside of the Form i have the corresponding details from Tbl_Referrals. I need the user to be able to update field by field from Tbl_CMSData to TblReferrals. This is done by means of a simple update query for each field. This all works fine.
Problem - I need an undo button for each field. Me.Undo does not work becuase the changes have been made by a query and not on the form.
Is there a way of undoing what the query has updated? Possibly by setting the focus to a Tbl_Referrals and then undoing the changes?
I was wondering if there is a simple way to check if any changes have been made to a record when the form is closed because I would like to create a log of records that were changed. I'm sure I could create some variables to store the fields when the form is opened then check if they're still the same when the form closes, but I figured there's probably already a built-in way of doing this (since the undo button must obviously use it)
I have built an access database (Access 2002) which contains around 370 records.
It would be useful to be able to click a button on a form to review which records (forms) have been amended or what records are new.
This could be presented by either (1) sorting the records so the newest/or latest changed records came first, followed by the next most recent etc etc, or by (2) presenting a list of record names which could be followed manually.
I have tried several text books but have been unable to find a solution so any help from the experts would be very welcome.
I need a special messagebox witch returns integer value to public variable.
now I have made it the problem is how to use it.
In Sub where the messagebox form is opened the Sub should wait until it get the response from messagebox_form. That is because this sub will save it in the table.
So how to get te sub to stop and wait until the public variable is changed
(if I use some kind of loop I can't use the form at the same time)
I would really like to populate a combobox with a list of queries. This would allow the user to add a group of data into a form's subform all at once. Although I have no clue how to use the pre-made queries from VBA or even how to get access to them via a combobox.
Any ideas? If I didn't make myself clear, I can explain further. Thanks in advance!
It has really been awhile I posted in this forum I have a form purchase order details, that I used to enter quantity of items purchased. I found out that I can't delete quantities entered on the form. It appears to delete, but on checking the quantity in the inventory, it was not deleted. The vba code in my quantity section of the page is this
Quantity_AfterUpdate() Dim IT As InventoryTransaction If Me![Quantity] = 0 Then RemoveCurrentLineItem End If AddPurchase Me![Purchase Order ID], Me![Item ID], Me![Quantity], NewInventoryID End Sub
I use the code below when a form is closed to either save or undo changes. However I only want the msg box to appear if there have been any changes to the record that the form is based on, if there aren't any changes then it will just docmd.close without the msgbox. How would I check if there have been any changes to the record? I think you have to use 'Dirty' but im not really sure how to use it.
Private Sub CLoseUR_Click() Dim strMsg As String, strTitle As String strMsg = "Do you want to save changes?" strTitle = " Save Changes?"
Is there a way to prevent users from making a shortcut to a database? I have my database split and I want users to copy the front end and paste it on their desktop. However, there is a high turnover rate among the people who will be using this database. As a result, I'm concerned that the instructions to copy and paste the database may not be passed along. I would like to avoid the possibility of someone making a shortcut to this database.
I would also like to prevent users from relocating the database by inadvertently dragging and dropping it in a new folder.The only person who should be able to move the database or work directly in the master copy of the front end is the person designated at the "admin" in my Users table (that would be myself and one other person). Is any of this possible?
I have access2007 Currently i have a tabbed form on one tab i have a combo box to select names.On the following tab i have a text box which i want to display the selection made with the combo box. At first i was just getting a number on reading related issues on this forum i tried =[CMB_salesman].[column](2) unfortunately that gave no result.
Is there a way to track the changes made to a record? I have added a timestamp field to my form that indicates when the record was changed but I would also like to know which of my staff has made the change. I found this on line but I'm having no luck with it working:
CODE: Private Sub Form_BeforeUpdate(Cancel As Integer) ' Log the user details to the table Me!UpdatedBy = CurrentUser() Me!TimeStamp = Now() End Sub
What this gives me in the Updated By control is "Admin" instead of the users name.
