microsoft.public.access.formscoding | Forum profile

  8l2255 wrote: >I have form 'AddMultipleItems' with fields as follows > >CategoryID Number >ProductID Number >Date_Acquired Date/Time >StatusID Number >txtN unbound number > >When you click the Create button it adds txtN amount of records to 'Itemtbl' >with (~)fields filled in > >Itemtbl has information > >~ItemID...

  To make the new data show in the main form, do a requery on the main form. If the DoCmd.RunSQL code is on the subform, then you can go Me.Parent.Requery Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "Alam via AccessMonster.com" <u56406@uwe> wrote in message news:9f9ea960c6b92@uwe... >I have 2 table both are exactly same > PatientRecordTransTb And PatientRecordTb...

  Hmm. That doesn't make sense to me. Perhaps you'll have to add some calculated fields to the SQL and sort on them: SELECT FixtureTypesNoProject.Type, IIf(InStr([Type],"-")=0,Len([type]),InStr([type],"-")-1) AS Sort1, IIf(InStr(type,"EM")=0,[Type],Replace([Type],"EM","0")) AS Sort2 FROM FixtureTypesNoProject UNION Select...

  Its weird because when I take out the specs and just leave a comma like this: DoCmd.TransferText acExportDelim, , "SCMHeader", strFile then the Export works fine, but every field in the .txt file has quotes around it. Only way to get rid of the quotes is to use specs no? So when I remove the specs the Export doesn't complain about a file not exisitng, but now I have no specs and need to get rid of the quotes....

  "Goldar" <Goldar@discussions.microsoft.com> wrote in message news:7AE0EF50-E734-4578-B993-5807ED99C6AF@microsoft.com... >I want to give the user to look up (in a combo box) a product by either > product number -or- description. If I display direction, how can I force > the > combo box to return the product ID for the selected description? I have an > option box that...

  Hi I have a form containing two subforms (sub1 & sub2) on sub 1 I have a combobox and a textbox and a unbound botton that saves the information from the combobox and the text box. On sub2 I have a form showing the informations that where input in sub1. My question is: 1. How do you requery sub2 after the sub1 button has been pressed? 2. How do I "blank out" the fields on sub1 so that the user has an...

  I have created table to keep a track of attached file info. Fields are : CustID, FileName,FileLocation In my main form I have created “Attached File” button – (to attach file – should attach more than one) and “View Attachment” - (to view all attached file) button. I have created two list box – one to view the list of attached file (Current attachment). And other to view the list which is already there (previously...

  Thank you very much Jeanette, i will deep dive into the world of foreign keys and append queries..there is much to learn here. My foreign key is based on a autonumber formatted field..that this have any effect on this...? Once again, Thanks! "Jeanette Cunningham" wrote: > You will need a foreign key in the Notes table that tells you, for every row > in the notes table, which is the row in the main...

  Any idea why I am getting a "Data Type mismatch on criteria expression" error on the second line? MaxCAR = DMax("[CARNumber]", "tblCARs") LastAuditNumber = DLookup("[AuditNumber]", "tblCARs", "[CARNumber] = '" & MaxCAR & "'") Both Fields are dimensioned as Integers CARNumber is and...

  mls wrote: >Access forms/subforms and data entry.. > >I created lab id and test_no as composite primary key because each patient >can be tested upto 3 times so labid & test_no should be unique for each >patient in testing_table. > >I have created a form with lab id as drop down list which should be updated >dynamically when LAB tables gets updated every day. Instead of...