Re: Append Query Headache!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

If you are indeed talking about tables, your "combo boxes" are probably
lookup field data types. Check the tablesdbdesign newsgroup for the many
reasons NOT to use that data type. You may have just added a new reason to
the list.

Jeff Boyce
<Access MVP>

"Paul" <Paul@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:716C8ECD-7292-4CC2-A8A2-6A2334E5CA77@xxxxxxxxxxxxxxxx
> Ok, I have an apend query that basicly copys everything Ineed from one
> table
> to another in another DB. It works, except where I have combo boxes on
> both
> tables. The combo box fields are not coming over in the append query, but
> everything else is.
>
> What do I need to do to make this work?


.

Relevant Pages

  • Re: Unable to reset Combo Box Data Field Format.
    ... Regards to mixed data types and the combo boxes - ... either selecting values from the combo box row source or by typing them it ... based on other combo box selections of fields in the DB. ...
    (microsoft.public.access.forms)
  • RE: Computing time difference
    ... The problem is probably that the values from your text boxes are not actually ... date data types. ... > another text box which shows the time difference in minutes. ... > Private Sub txtEndTime_AfterUpdate ...
    (microsoft.public.access.formscoding)
  • RE: Computing time difference
    ... > The problem is probably that the values from your text boxes are not actually ... > date data types. ... >> another text box which shows the time difference in minutes. ... >> Private Sub txtEndTime_AfterUpdate ...
    (microsoft.public.access.formscoding)
  • Re: Users want Check Boxes for entry
    ... then you could interface the foreign key field with an option group. ... The group lists all the reasons, and the field stores the number of the ... > track why the rejections were rejected. ... > form with check boxes for each reason. ...
    (microsoft.public.access.forms)
  • RE: How to retrieve all or patial records
    ... They have seven combo boxes to choose from for the report, ... For text data types: ... I have a query in which uses a forms combo boxes to set the criteria of the ...
    (microsoft.public.access.queries)