I have a form with 4 subforms on it and I am trying to find a way to capture the last modified date for the record regardless of what form or subform they touched
Is this possible?
Right now I have a macro on before update of Now() on the form and all of the subforms but that is only showing when that form was last modified which is not exactly what I am trying to achieve.
I have a split database with a frontend that I semi-regularly update (when one of my users finds a bug I never would have thought for looking for). On my menu screen i have a text box that says: "Last Updated: ##/##/####".
At the moment I manually update the date every time I update the frontend.
Is there a way I can use the DateModifed property of the .mdb file for the frontend as the date in my textbox using VBA?
I have a subform that is filtered by a textbox on the main form. Is there any way I can add a timestamp to a record on the subform when a user changes anything on that record?
I've tried the Macro that is listed on Microsoft's website regarding timestamps, but I had serious issues implementing that to a subform.
How do I set up a field so that when the record has been modified, the field is automatically filled in (or replaced) with a date? In other words if I open up my member's detail form, and go to Sally Smith and edit her information on 11 July 15, that date is saved into a field called last modified and then updated every time I go into her file and edit & save it.
I have a table in my Access 2010 Database with few date/time fields. I have set different formats like Short Time, Medium Time etc. But when I link this table to Sharepoint list, all the date/time fields have been modified to their default format (General Date).
Is there a way we can keep the formats as such even after linked to Sharepoint list? If not, is there a workaround?
I have an unbound form on that form I want to put three sub forms one on a products table the other on a course start dates table and the link table that joins the other two together. all three are related to each other with Pk/FK links.
When I try to link them it says you cannot link items on an unbound form.
I am trying to open a form in design mode and add controls, this i have done. I am doing this all in a class, and am having trouble saving the modified form.
I have tried using the following, both produce errors
I'm a novice Access user and I've been put in charge of changing this. The database is on a shared device. I copied a working frontend (access file) to another machine and used the link table manager tool to find the new database. Now when I open the table view mode I can see the table data, but when I open the form, it doesn't show the data at all and it only lists 1 record. I know this sounds like a really stupid question, but is there one more step or am I in insert mode?
I used a macro to record the date and time the current record was modified and show that information on a form - the information on how I did that is here: http://office.microsoft.com/en-us/a...0345351033.aspx
That works wonderfully, however I would like to add to this the user that modified the record.
Is there a macro code for this??
I tried setting the Item to read [UserModified] and the Expression to be User() however that did not work.
I need to able to quickly find which the last records that have been modified. I have an invisible field "txtModified" on the main form and selecting when changes where made to the record on the main form is easy using a qry on that field. The problem I face is that the form with all details of a particular item contains 2 subforms. Changes to data on each of these subforms doesn't effect the time/date on the main form. However, each of the subforms is also time stamped upon change.The qry to select the last records changed therefore needs to look at 3 fields and select records with the latest date in any of the 3 "Modified" fields. How do I do that? I suppose I'll have to put an expression in the qry?Thanks for your advice.Walter
I have this code in a Query... [Type in your product, such as mtt20]
Once you type in the product it will go and find it and display it.
My question is : Is there a way to modify this so it will allow me to enter more than one product and then go and get the results. Preferrably the easiest way possible as I am a new user of access and no program training...
My problem is that somehow the PK of my [Orders] table got turned off allowing records with duplicate IDs. To get rid of the duplicates, I did the following: 1. create a new, test database. 2. copy the [Orders] table to it. 3. create a new field, [Delete] in the [Orders] table 4. write a query to find duplicate orders and make a new table[$Dup_Orders] with just the [IDOrder] field in it. 5. write a query , linking the [$Dup-Orders] table to the [Orders] table via [IDOrder]. Here’s the SQL of that query:
SELECT DISTINCTROW [$Dup_Orders].[IdOrder Field], Orders.DeleteDup FROM [$Dup_Orders] INNER JOIN Orders ON [$Dup_Orders].[IdOrder Field] = Orders.IdOrder;
With that query, I would like to go through the table, flag the records to delete, and then write a query deleting those records.
The problem is that Access does not allow the [Orders] table to be modified.
The database is completely independent with only an imported [Orders] table and a temp table created from a query.
I created a "BeforeUpdate" property on my form, which is meant to insert the date into the field DateModified when the record is modified. The code says:
Private Sub Form_BeforeUpdate(Cancel As Integer) Me!DateModified = Now()
End Sub
When I am running the form and modify a record then go to find a different record through an unbound text box which I use to locate records , it comes up with "run-time error '3020: Update or CancelUpdate without AddNew or Edit."
Hi all, I have a form wich contains 2 subforms, these subforms are runned by a query wich selects data between a range of dates, the problem is when i open the form it will ask me the range of dates twice, once for one subform and then again for the other, as the range of dates are the same for both subforms is there a way to open the form typing only once the range of dates? Thanks Marco
I'm looking for a way to update forms, reports, queries etc... by exporting them to another database with the same objects. Essentially, I'd like to export only those forms etc... that have been modified according to the mofified date.
I'm really new at VB. But I'm learning. I'm also learning to work around access too. What I'm trying to do is have a Form with a TreeViewCtl that acts as a menu for other forms. I'd like to have the TreeViewCtl open those forms in a subform so there is always just one form open at all times. This way my "clients" don't get lost in the forms. Believe me, they get lost easily...
I already posted a question like this here: http://www.access-programmers.co.uk/forums/showthread.php?t=80756 But I'm not sure if this is a VB question (TreeViewCtl) or a Forums question... A sample of what I'm trying to do is available at the link. My TreeViewCtl works fine, but the forms open in seperate forms. Sorry for the dbl-post.
Does anyone have any ideas? I've been searching google for 2 weeks without any answers.
i have a stock control db. when new stock is ordered it updates 'units on orders' field, then when goods are recieved the subform field is updated and this automatically updates the 'units on hand field'.
i then have another subform for stock going in and out, i would like to be able to have the units on hand field as above (which is the main form) automatically updated like is when using the the goods recieved sub form??
not sure if i explained it properly but i can send the structure if that helps?
My main form has four command buttons that when clicked will make visible one of four subforms.
I can switch freely about the subforms by clicking on each of the buttons. However, when I place the cursor in a subform(and thus give it Focus), and then attempt to select another button to open another subform, I get the dreaded "can't hide a control that has the focus" error message.
What type of code should I use and where exactly should I be putting it?
I've tried setting focus to another subform in the OnClick event of my buttons, but that doesn't seem to be working.
I have a problem with main form and two subforms in it. Both subforms are in "continuos" mode, and each of them has field in footer, where it calculates total sum for all field that are in it.
Then there is main sum below both subforms (all this is in detail section of form) and it calculates total for both sums of each subform.
Whenever i fill values in first subform and in second subform, i have results everywhere, but if i fill values in first subform but leave second subform empty, the "main sum" below both subforms is empty also....
The control source for main sum field is "=Forms!frmMainForm!frmSubform1!Text1 + Forms!frmMainForm!frmSubform2!Text2" where Text1 is "total sum" in first subform and Text2 is "total sum" in second subform...
I set default value = 0 for all fields in both subforms, but it won't help....still shows empty fields in that subform, which isn't filled....Actually when i open form for the first time, it shows "0" values in all empty fields and then immediately clears them and shows empty fields...
I need a form with 2 subforms. the main form is for an indidual. the first subform is a list of characteristics. the second subform is sort of a calendar function, produced for date scheduled, results, next meeting date.
I have tried the form wizard, but it produces a jumble of the mixed fields. Can I create a subform or 2 before I create the main form, and then link them somehow?