Search results

Age you dont need in table. Lets query do calculation (on one field put this Age: Now()-[Day of Birth]). If you still need Age in Table create update query with this formula

If I got you right. Create two tables: first: ID, Part Number, Quantity, Description - Revision and Drawnum second: DrawerNum, DrawerDesc, and CofC create relationship "one to many" from second to first table (Drawnum is primary key) After that you can create cbox and choose:

Did you try a Union Query? I'm guessing; create two querys, first from table pipe , second from Intrusive Manhole Survey, and join this query with Union query with Pipe_ID as key

I want to help, but don't understand what you want. please post what you have and what you want (excel like)

How to delete all forms or reports from code in database?

Thanks Leslie This is what I'm looking for. Thnaks a lot :)

whats the size of form, maybe you form is too big? If form isnt big try this: when form is open go to Windows on Menu bar and choose "Size to Fit", save form and put this code on OpenEvent of form. "DoCmd.Restore"

tblDelivery have only one value for row. I mean Customer in some date have only one value for some products. crosstab didn't do any summarize, only present data in excel like form thanks in advance...

I send you a copy of db. on Main form click on "Pregled isporuke" to open form on which I working. form is based on tblTemp, tblTemp is created by "c-t" make table query. I want to update tblIsporuka_details with changed data from tblTemp. I hope you come upon in the mess in db.

Thanx Le Many thanx this is what I need. Thanx a loot.

thanks Leslie... -------------------------------------------------------------------------- Run an append query calling your c-t and append it all into a table m8... __________________ I have done this. I have form based on that tblTemp but problem is... how to transfer data back to source...

I dont now how to get data from temp table to original table. With update query surely. But how to "rotate" data, because my "productId" become column headings in temp table.

thanks BLeslie88 ! lets say I'm on 15th row (costumer called Denis). after I change data in another form and requery data I wont to retain focus to that 15th row (costumer called Denis). thanks in advance

I create a tblTemp table based on crosstab (from tblDelivery) . When I change some data on this tmpTable, how to move data from this tblTemp to original table tblDelivery.

I have a form based on crosstab query. when I want to change data that's not possible beacuse qrosstab isn't editable. I create another form to open when I double click on record where I want to change data. When I go back to main form how to move focus to the record where I was.

I have form called frmMain with subform based on a crosstab query. Because crosstab query isn't editable I create a command button to open another form to change data, but when I go back to frmMain I call frmMain.subform.requery to refresh data. Everything is working, but how to go (setfocus) to...

thanks Yes this is what I'm looking for. How do I forget trying this? Thanks a lot!

Is it possible to open access database window at specific size (example at 800x600)? I dont mean on forms. I want to creating application which wont resize on full screen if resolution is higher then 800x600. I try with hiding access database window but I dont like this solutions.

thanks a lot

I have a problem with combo boxes. I can create a combo box to move form to the record which I selected in combo box. Also I can create another combo box to add new records with notinlist event. But is it possible to do this with one combo box. I want to use combo box to move forms to selected...