dcsimg

Search:

Type: Posts; User: ASoufan

Page 1 of 4 1 2 3 4

Search: Search took 0.03 seconds.

  1. Thread: Question

    by ASoufan
    Replies
    1
    Views
    342

    Question

    Hello Guys

    I have a kinda hard question, but I think it is doable.

    Lets say there is a character that is ran by another application, it keep changing it is place on my desktop, how can I make a...
  2. Replies
    13
    Views
    414

    Re: x=x+1

    thank you so much for your help
  3. Replies
    10
    Views
    465

    Re: Counter Issue

    Yes
    exactly what I needed, thank you so so so much for your time and nice help
  4. Replies
    13
    Views
    414

    Re: x=x+1

    http://www.sqlteam.com/article/returning-a-row-number-in-a-query

    this is exactly what I need to do with my query

    but I don't understand well to compare and do it :(

    any support please ?
  5. Replies
    10
    Views
    465

    Re: Counter Issue

    I am sorry but I didin't understand it well

    I have found a link the helps but seems sophisticated for me since I am a beginner

    http://www.sqlteam.com/article/returning-a-row-number-in-a-query
    ...
  6. Replies
    13
    Views
    414

    Re: x=x+1

    I don't want to sort them bro

    what I want is

    I need it in a datareport

    I want to add a number for each result the report show

    the number should be the record number that the query return
  7. Replies
    13
    Views
    414

    Re: x=x+1

    It is an Access DB

    can u help me ?
  8. Replies
    13
    Views
    414

    Re: x=x+1

    Becase I need it in a datareport

    I want to add a number for each result the report show
  9. Replies
    10
    Views
    465

    Re: Counter Issue

    The idea is
    I have a query that I used for a DataReport
    I want to add a sequence number for each row the report show

    let say the query return CustomerNumber, Name and it returned 3 records
    ...
  10. Replies
    13
    Views
    414

    [RESOLVED] x=x+1

    "select * from mytable"

    if this returns 3 records

    how can I add something to it to return a new field like when I use "AS" but it should have the row number

    I mean: if the query returned 3...
  11. Replies
    10
    Views
    465

    Re: Counter Issue

    Any body there ?
  12. Replies
    10
    Views
    465

    Re: Counter Issue

    It is MS Access DB
    yes in my VB application (small clinic system)
    I want each field have a number x=x+1
    a counter
    thanks
  13. Replies
    10
    Views
    465

    [RESOLVED] Counter Issue

    I have this query again


    SELECT tblBreakDown.Customer_Number, tblBreakDown.Visit_ID, tblBreakDown.Admition, tblBreakDown.Lap, tblBreakDown.Minor, tblBreakDown.Altra, tblBreakDown.Dressing,...
  14. Thread: Query Problem

    by ASoufan
    Replies
    2
    Views
    269

    Re: Query Problem

    I did like your suggestion and opened another query
    it works fine and this is exactly what I want
    sorry for wrong post place
    There was a site database error and I thought the post didn't go since...
  15. Thread: Query Problem

    by ASoufan
    Replies
    2
    Views
    269

    Query Problem

    I have this query


    SELECT tblBreakDown.Customer_Number, tblBreakDown.Visit_ID, tblBreakDown.Admition, tblBreakDown.Lap, tblBreakDown.Minor, tblBreakDown.Altra, tblBreakDown.Dressing,...
  16. Replies
    10
    Views
    1,073

    Re: DataReport INNER JOIN

    Thank so Bruce
    it fixed it
    :D
  17. Replies
    10
    Views
    1,073

    Re: DataReport INNER JOIN

    SELECT tblBreakDown.Customer_Number, tblBreakDown.Visit_ID, tblBreakDown.Admition, tblBreakDown.Lap, tblBreakDown.Minor, tblBreakDown.Altra, tblBreakDown.Dressing, tblBreakDown.Discount,...
  18. Replies
    10
    Views
    1,073

    Re: DataReport INNER JOIN

    thanks so much the above fixed the error but I have another question

    I have a label in the report called label10 i want it to be the value of total - paid

    i did

    .Item("Label10").Caption =...
  19. Replies
    10
    Views
    1,073

    Re: Data not found error

    they are call correct
    the query works fine if i run it from access program
    all fields are filled up nothing is null
    if i use 1 table it works
    i just need another 2 fields from table 2 for the...
  20. Replies
    10
    Views
    1,073

    Data not found error

    I am making a data report
    it works fine for 1 table query
    but if my query has inner join to get data from 2 tables
    I tried it on ms access and it get records find
    in the data report it generates...
  21. Replies
    10
    Views
    1,073

    DataReport INNER JOIN

    I am doing a data report if I use 1 table it works
    if i want the query to get info from 2 tables it says:

    DataField 'customer_number' not found

    although that the query is correct

    this is...
  22. Thread: report

    by ASoufan
    Replies
    2
    Views
    301

    report

    is there a way guys to read a report from an access database reports in a good looking window ?
  23. Thread: Question

    by ASoufan
    Replies
    6
    Views
    452

    Re: Question

    I am working since 8 days on this project and it is 5:05 AM bro
    i am not sleeping well
    you think I am not putting efforts ?
    thanks anyway
  24. Thread: Question

    by ASoufan
    Replies
    6
    Views
    452

    Re: Question

    it works, but
    it is just open the access database for me
    and i need to click on my report
    is there a way to open the report on full screen directly ?
  25. Thread: Question

    by ASoufan
    Replies
    6
    Views
    452

    Re: Question

    What if the database need password ?
    how to do this ?
  26. Thread: Question

    by ASoufan
    Replies
    6
    Views
    452

    Question

    Is there a component or a way to make me click a button to call and show a report located on access database reports from my vb application ?????

    thanks
  27. Replies
    2
    Views
    585

    DataReport Problem

    I have 2 table in my access database

    Table 1 = tblCustomer
    have these fields:
    Customer_Number
    Visit_ID
    Admition
    Lap
    Minor
    Altra
  28. Thread: Last Record

    by ASoufan
    Replies
    5
    Views
    287

    Re: Last Record

    thank you
  29. Thread: Last Record

    by ASoufan
    Replies
    5
    Views
    287

    Re: Last Record

    SQLStr = "Select * from tblCustomers"
    recSet.Open SQLStr, dbConn, 1, 3
    recSet.MoveLast
    txtLast.Text = recSet("Customer_Number")


    I tried this but it gives the customer number for the...
  30. Thread: Last Record

    by ASoufan
    Replies
    5
    Views
    287

    Last Record

    If i have 4 entries in a table inside ms access db

    how can I get a record value for the last record in the table

    I mean record 4

    notice that I don't know how many record can be
    maybe 4 or...
  31. Replies
    7
    Views
    396

    Re: problem in query

    I didin't understand them thats why I posted the fields names to replace them with a and b because I don't understand how can I take the name and family name to put in text box1 and textbox 2
  32. Replies
    7
    Views
    396

    Re: problem in query

    Sorry but I didin't understand well

    first table called tblCustomers have the following fields
    Customer_Number
    First_Name
    Family_Name
    Tel
    Remarks

    Second table called tblVisits have the...
  33. Replies
    7
    Views
    396

    problem in query

    I have 2 access db tables

    Tabel1=tblCustomers
    Tabel2=tblVisits

    Customer_Number field in tblVisits is the same as Customer_Number in tblCustomers, but all customer information like names and...
  34. Replies
    4
    Views
    400

    Re: problem in query

    Yes I tried both cases but didin't work
    Now I tried it like this
    "Select * from tblCustomers Where Customer_Number = " & sData
    It worked fine
    thank you so much
  35. Replies
    4
    Views
    400

    Re: problem in query

    I tried
    same :(
  36. Replies
    4
    Views
    400

    [RESOLVED] problem in query

    I have a field in an access database table called Customer_Number

    its data type is Number

    when i try to open record set to search by the customer_number

    "Select * from tblCustomers Where...
  37. Replies
    1
    Views
    305

    Flat Combo Question

    Is there a real good flat combo box ocx activex file ?
    because FM20.DLL is not good looking combo boxes
    and not really flat
    any idea ?
  38. Thread: play .flv

    by ASoufan
    Replies
    18
    Views
    1,291

    Re: play .flv

    Macromedia flash component can't play flv format guys
    although that flv regarding to flash files but this ocx can't run it
    good luck!
  39. Thread: email body

    by ASoufan
    Replies
    1
    Views
    367

    email body

    ShellExecute 0, "Open", "mailto:me@domain.com?subject=Hello"

    this will open outlook with e-mail me@domain.com
    and subject Hello

    how can I also set the body in outlook to a string i choose ?
    ...
  40. Thread: Time + Time

    by ASoufan
    Replies
    10
    Views
    594

    Re: Time + Time

    is there any function to read time this format
    00:00:00:00:00:00
    Years:Months:Days:Hours:Minutes:Seconds
    Like this example: 01:07:12:06:55:24
    1 year and 7 months and 12 days bla bla bla
    and I...
Results 1 to 40 of 141
Page 1 of 4 1 2 3 4



Featured


Click Here to Expand Forum to Full Width