Thanks, but I don't want to go through the Recordset.Edit routine, as there are alot of fields I would have to scroll through to find what changed.
I also tried the DoCmd.RunCommand acCmdSaveRecord, but this command produces an error as well.
Any more ideas out there?
Does anyone know how I can save a record on the click of a button? The
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
command produces an error and does not save. I'm looking for alternatives. Please help.
Matt,
I'm not sure what event you want to place this code into (maybe Form_Current), but try to set the filter on the other forms based on the ID of your main form (assuming the two forms are based on the same ID). Something like:
Forms![OtherForm].Form.Filter = "ID = " &...
I have a form with a list box, that when a specific record is selected in the list box, I'd like the main form to goto the selected record.
The bound column in the list box is the ID field that is in the main form. Something in the ListBox_Click event that says goto Record where Mainform.ID =...
Hi Gord, thanks for the interest.
I guess the real question is what is the best link. The key in this example is that the link between the two subforms is based on the ContactID (when a record on the top form is selected, the bottom form will requery/filter based on the ContactID value)...
I have one form that contains two somewhat related subforms (not directly related with Master and Child links). The top subform displays names of contacts in a continuous form format. The bottom subform contains ONE name and address for the selected record in the top subform.
What I want to...
You're definitely not ignorant, I am. I did more research on this. MS suggests that you create a separate utility to that compacts and synchronizes databases. This give you more control. By doing this in VB, instead of VBA, you can compact the DB before synchronization, thus no need of...
Actually, I have a replicated DB. I read on Microsoft's site that described when replicating using VBA, that you should close then re-open the DB to see design changes. Am I mistaken?
I must be missing something because when I type ctl.cont... the shortcut menu appears but the ControlType property is not listed. Is there another reference?
I am using 97, not 2000, too.
Still did not work. I have the reference at the top. Part of my code:
dim ctl as Control
for each ctl in Me.Controls
ctl.ControlType
ctl.OldValue
...
next
What is strange is when I compile I receive no errors. But I receive errors in the Error Handler.
I added a procedure that loops through all controls on a form to see if the Value changed (from the OldValue property). I was using a Control variable(dim ctl as Control) to represent each control on the form. When I tried to use the Control Type property, I receive an error. The help in...
I created a database that is replicated. I'm working in the Design Master and I'm trying to create a new Toolbar. When I right click on the toolbar area or goto View, Toolbars, nothing appears. Can I create Custom Toolbars with a replicated DB???
Hi all, this is probably simple, but what I want to do is save the current record on a form before the user leaves the current record. Somthing like a Save button. I realize that the record is saved once a new record is opened, but I want to save prior to that. Any ideas???
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.