11-27-2001, 03:59 AM #9 Rich Guest Posts: n/a You are storing duplicate date, Using DoCmd.RunCommand acCmdPrint pops up the printer dialog first- exactly what I needed. I have attached the codes below.

Debugger says Me.Bathroom = 1, Forms!frmBathrooms!ID = 38. I mostly use the .Value property and Me.ControlName.Value and Me.ControlName both will use the .Value property. I created a primary key in the SQL Server table, updated the table in Access through Linked Table Manager, and now it works without any trouble. Access 2010 Vba Export To Excel Site Message (Message will auto close in 2 seconds)Welcome to UtterAccess!

Posts: 3,069 Thanks: 0 Thanked 10 Times in 10 Posts Your subform is not updateable. Access 2010 Vba Case Statement Specifically, what control did you pass it? have a good day. Here is additional explanation about my error: I get error when I try to assign values into text fields "Me.txtAddRunnerEventid.Text" and "txtAddRunnerRaceid".

This is the code which should carry the ids: Private Sub cmdAddRaceRunner_Click() DoCmd.OpenForm "Input Runner for race", , , , acFormAdd, , OpenArgs:=cmbErEventid & "|" & cmbErRaceid end sub this is Access 2010 Vba Dlookup You may have to register before you can post: click the register link above to proceed. I used the following code: Me.Parent.[LastContactDate] = Me.[MeetingDate] with the After_Insert event. What I am trying to do is assign the value that I extract from a prior form and insert into the event-race-runner associative table - thus inserting eventid and raceid.

Access 2010 Vba Case Statement

Many thanks F Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Apr 15th, 2010,11:26 AM #2 revans Board Regular Join Date Apr 2010 Location California Posts 576 learn this here now I could designate another field as the primary key because there is an autonumber field in the table. Access 2010 Vba Error Handling If not, please let me know. Access 2010 Vba Open Form Is your back-end Microsoft Access, or another database?

Be as you wish to seem Reply With Quote 12-22-2011,05:29 AM #11 wedd View Profile View Forum Posts View Blog Entries View Articles VBAX Mentor Joined Aug 2010 Posts 457 Location see here Sorry, but I a newbie to ms access and vba. Search Forums Show Threads Show Posts Advanced Search Find All Thanked Posts Go to Page... Any ideas? Access 2010 Vba Close Form

Compute the Mertens function Does Antimagic Field supress all divine magic? Thanks for sharing the solution with the rest of us!- Daryl« Next Oldest· Access Forms· Next Newest »Display Mode: Standard · Switch to: · Switch to: OutlineTrack this topic ·Email this Changing primary keys is another matter. this page Are there any constraints on the table?

Daryl SView Member Profile Sep 23 2010, 12:50 PM Post#4UtterAccess VIPPosts: 2,270Joined: 1-June 10From: Colorful ColoradoBotonist -That is the record source for your form ForestSpeciesList_subform? Access 2010 Vba Create Table In it, you'll get: The week's top questions and answers Important community announcements Questions that need answers see an example newsletter By subscribing, you agree to the privacy policy and terms Multiple-Key Sorting How could banks with multiple branches work in a world without quick communication?

Just a quirk of Access' date ' handling!

Be as you wish to seem Reply With Quote 12-21-2011,06:53 AM #3 wedd View Profile View Forum Posts View Blog Entries View Articles VBAX Mentor Joined Aug 2010 Posts 457 Location How to indicate you are going straight? Be as you wish to seem Reply With Quote 12-22-2011,04:09 AM #7 wedd View Profile View Forum Posts View Blog Entries View Articles VBAX Mentor Joined Aug 2010 Posts 457 Location Access 2010 Vba Loop Through Recordset I've had this issue when closing one form and opening another.

You would not want to delete or change a primary key if there are child records for that parent in other tables.Is your database split into a front-end and back-end? The form is comprised of a main form "ForestSpeciesList_Main" and a subform "ForestSpeciesList_subform". How do I directly display a man page? http://axisnice.com/access-2010/access-2010-runtime-error-490.php When a new meeting is added, I want to update the LastContactDte field on the Contacts form with that of the new meeting on the Meetings sub form.

You should be able to delete the child records (those with a foreign key to another table that has the matching primary key). Related 0Microsoft office can't find the object “A_Z Schaltfläche”0I can't update values in a column with their trimmed version. CurrentDb.Execute "INSERT INTO event-race-runner (eventid, raceid, runnerid) VALUES (txtAddRunnerEventid, txtAddRunnerRaceid, txtAddRunnerRaceid)" Apr 4 '10 #14 reply Expert 100+ P: 375 RuralGuy What is the RecordSource of your 2nd Form? Thanks Reply With Quote Page 1 of 2 1 2 Last Jump to page: Quick Navigation Access Help Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home

What springs to mind is creating it in a new database, but I would like to keep the same format...in other words could I change the field and control names if just wanted to show the answer as an answer.. Any suggestions or alternate solutions? Somewhere in your code you must have a call to PopupCalendar that also passes a control to that function.

The control that needs to be updated is in the first Subform(Contacts)and the Meeting Date field is in the second nested subform. I'm having trouble with one of the controls (cboGenus, or Combo29 in the code below) on one of my forms ForestSpeciesList. I would have expected it to work, but drop the .Value out of the statement so it is just: txtPageTo = numpages. Thanks for the tip CodeMed.

The time now is 09:01 PM. It's not helpful to criticize me for how the database developer used the default names for controls. Apr 4 '10 #10 reply Expert 100+ P: 375 RuralGuy Is event-race-runner a TABLE or a QUERY?