Search results

Looking at your solution, you really just need one table with 'ClientID','ClientName','Descr'. Like Banana said: change to ClientName or something, try to normalize a little and have a main form for main table, insert all subform on this mainform and voilá.....It works fine for my database...

Designing a database requieres a good design with the tables. You need to see over your table relations and see if it is a way to more effectively relate tables. Also, having a combo to pick values like: 'Skriv inn skap/PLS nr' would automatically fill other textboxes if tables are related...

Best way would probably be to make an unbound form with unbound textboxes. Then a button, btnSaveMe and code: Dim strSaveData as String strSaveData = "INSERT INTO tblSomething(field1,field2,field3,field4) " _ & "SELECT field1,field2,field3,field4 " _ & "FROM tblUnbound " _ & "WHERE unboundID =...

Yes, these seems very suspicious! Anyway...do an INSERT INTO after the update of last field or make a button with the following code: Dim strFilter As string strFilter = "INSERT INTO tblreturns(returnnumber, datereceived,dateprocessed) " _ & "SELECT returnnumber, datereceived,dateprocessed "...

If the underlying tables are related this should be of no problem. If not, you'll need to, by the code, insert values into the subtable by a INSERT INTO query or use the query tool, make the query and set it as the countrolsource of the form.

Dim strFilter As String strFilter = "INSERT INTO TPERSONAL(NAMEPER) " _ & "SELECT name " _ & "FROM TORDER " _ & "WHERE orderID = " & Me!ORDER!orderID CurrentDb.Execute strFilter, dbFailOnError This was for access 2000. My experience is that it is best to enclose these procedures in their own...

To automate with Word you'll need to create a new .dot document. In the document insert a table to hold the different values from fields in the table of the database. Then make bookmarks in each tablecell and give them apropiate names. Then you'll need to code in vba (in the database). Here's an...

Hi! Are you opening the form from another form? With data already recorded? Then you should use the wizard to choose which form to open from a button on the first form. Then add more code to that button that will manipulate textbox on second form through: Forms!frmSecondForm!ClientType.Text =...

Hi! Are you opening the form from another form? With data already recorded? Then you should use the wizard to choose which form to open from a button on the first form. Then add more code to that button that will manipulate textbox on second form through: Forms!frmSecondForm!ClientType.Text =...

Hi! Are you opening the form from another form? With data already recorded? Then you should use the wizard to choose which form to open from a button on the first form. Then add more code to that button that will manipulate textbox on second form through: Forms!frmSecondForm!ClientType.Text =...

Where isn't the data in correct order? In the table(s)? In a listbox? If table(s): Do you have an autonumber field (e.g.:customerID)? How are your tables related?

The incrementing part could be done by: Nz(DMax("[aField"],"tblSomething"),1)+1 in code (behind a 'make copy' button). I'm not sure if you mean 'copy' the recordset or copy the document. Believing you mean 'copy the recordset', that is: copy an ordernumber into a new ordernumber and bringing...

Thank you so much for patience and guidance. That did the trick. I was so convinced that I really needed the ItemID. :-)

Hi! Yes, you're right. That's a typo. However... how is access supposed to know where to insert the ItemID if I don't tell which ItemID to insert where...? I think it should be possible to use a for..each statement here or...? Thank you for answering :-)

Hi! Here's a way to copy an existing order with all its subforms data. From a button on mainform, paste and adjust the following code: Private Sub cmdCopy_Click() On Error GoTo Err_SENDCOPY Dim MyRs As DAO.Recordset Dim sqlNew As String Dim lngNewOID As Long Dim intONr As Integer Dim My2Msg As...

Try GROUP BY to filter the result. I always use the query tool in access to create such a query before I try to write it in code

Hi! Don't forget to requery the listbox: Me!lstSomething.Requery Put the code in the AfterUpdate event of ID field or in the nextRecord button and the other buttons that may beffect a change in the ID field

Private Sub Form_Open(Cancel As Integer) DoCmd.GoToRecord := acNewRecord End Sub

Hi! Private Sub cboSomething_AfterUpdate() Me!txtSomething.Text = Me!cboSomething.Column(1) End Sub

Hi! Private Sub btnSomething_Click() Dim strSql As String Me!cboComboBox.Enabled = True End Sub Private Sub cboComboBox_AfterUpdate() strSql = "INSERT INTO tblB(myID,myItem,myPrice) " _ & "SELECT myID,myItem,myPrice " _ & "FROM tblA " _ & "WHERE myID = " & Me!cmoComboBox CurrentDB.Execute...