can you please tell me what are you using, table to form or query to form ??
if it's query to form I believe that there is problem in your query can you write what did you do..@!
xzorxx
Last Activity: Dec 19 '13, 07:37 PM
Joined: Dec 15 '13
Location:
-
you can make your db multiple, so more than one person can use it at same time
from tools go to option then advance option you will find something about default open change it to from private to shared
good luckLeave a comment:
-
Hi ,I didn't get what you wan't really but what I have understand
is that you trying to
when create new record in the main form sub form get a new record
and actually I can't see where is the problem is
ms access will make new record when you make one on the main
you can try to make query then create form to it ,and that's it.Leave a comment:
-
I am truly sorry mr.Rabbit the first SQL code from vb
second from ms access db..!!
good news is Just minute ago I have solve the problem I recreated the Purchase Query from 0 again ,and now it's work fine..!!
thank you very muchLeave a comment:
-
Sure replace it please...
This is the SQL
...Code:SELECT Purchase_T.Purchase_no, Purchase_T.Inv_no, Purchase_T.Pu_date, Purchase_T.P_no_pu, Projects_T.P_name, Purchaser_T.name, Purchase_T.Sup_noT, Suppliers_T.Su_name, Purchase_T.For, pu_it.pu_no, pu_it.code, Item_T.Item_details, Units_T.U_name, pu_it.qty, pu_it.price, pu_it.dic, [qty]*[price]-[dic] AS Total, Purchase_T.totDes, [Total]-[totDes] AS Grandtot FROM Units_T INNER JOIN
Leave a comment:
-
Yeah sure, sorry about that
I fixed the database query to add serial no to the sub table then try to order it but nothing happened ..!!
then i was thinking about report expression could I reverse the data from it..?
that's it and sorry again
also you can delete the hole thing if it's not okay to your site sorryLeave a comment:
-
Deleted post uselessLast edited by zmbd; Dec 18 '13, 01:28 PM. Reason: [z{none of your images are available to most of the experts}]Leave a comment:
-
Sorry rabbit I just used easy name instead of Purchase_no..
thank you zmbd you mean putting the Purchase_no in the sub Table
then order it.... I want it to be ordered to the user table order
:( is that possible...
and again don't forget I got other tables and it's just work fine
Thank you ...Leave a comment:
-
Hi...here is some codes I used it, it may help you...
Code:Dim reader As New StreamReader("C:\DB\HDW.txt") HDW.txtHDW.Text = reader.ReadToEnd reader.Close() Dim writer As New StreamWriter("C:\DB\HDW.txt") writer.WriteLine(HDW.txtHDW.Text) writer.WriteLine(TextBox1.Text + " Login " + DateTimePicker1.Value) writer.Close()Leave a comment:
-
This is for filling table as you know
And this is inside table adapterCode:Me.Pu_it_QueryTableAdapter.Fill(Me.DbDDDataSet.pu_it_Query)
...Code:SELECT Inv_no, Pu_date , P_no_pu, P_name , code, Item_details , price, qty , dic, Su_name , Sup_noT, U_name , Total, name , [For], Grandtot , totDes, Purchase_no FROM [pu_it Query] ORDER
Last edited by zmbd; Dec 17 '13, 05:15 PM. Reason: [z{Please format script and tables using the [CODE/] format button}] {Stepped the SQL for easier reading}{merged secondary post with this one}]Leave a comment:
-
thank you for your reply ...
order by sno, did nothing.
...Last edited by zmbd; Dec 17 '13, 05:07 PM. Reason: [z{third party sites are usually blocked for most of the experts; thus, mostly useless}]Leave a comment:
-
Ms Access reverse data automatically??
Hi...
I have created MS Access database for stores management and every thing is okay, there is purchase table ,receive table ,transfer table and damage table .
each one contain two table, now my problem is in the purchase table
let's take a look please
Code:first table sno inv_no date supplier
_______________ ___...Code:second table sno code details qty price discount tot
Last edited by zmbd; Dec 17 '13, 05:13 PM. Reason: [z{Please format script and tables using the [CODE/] format button}]
No activity results to display
Leave a comment: