Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. athos07

    Begginer

    Thank you very much and sorry it took mo forever to reply. Been busy driving busses :), hope I can get back on track doing IT duties. thanks angain
  2. athos07

    Begginer

    Good day, I don't have any Idea of what I am doing. I have asp.net and sql server installed in my computer. Now I have installed apache because I want to learn the basic on how to make PHP codes. I have alread download the file. Installed in my computer but this error came out: (OS 10048)Only...
  3. athos07

    how 2 print ms access report using VB

    i have already done it but anyway, thank you to for your code at least i will have an alternative code for this. my code is this: :) thank you very much Dim objAccess As Object Private Sub Command1_Click() Dim dbName As String Dim rptName As String Dim Preview As Long Const acNormal = 0...
  4. athos07

    how 2 print ms access report using VB

    how can i print ms access report (my back end database) using visual basic.?? thanks
  5. athos07

    sql wildcard in VB

    hi gud am, im creating a report using VB, I have a parameter. sample: parameter = inputbox ("ENTER LASTNAME.") SQLparam = "SELECT lastname, firstname FROM table1 WHERE lastname LIKE '*"" & parameter & "*'" ive tried this but there's an error ples help...
  6. athos07

    Want to get date as dd-mm-yyyy format

    select your table. in the design mode. put the format dd-mm-yyyy you can find this in the general tab
  7. athos07

    creating a report

    try using the data report of VB much easier to learn, thou crystal report is much better. if your already familiar with data report or VB and report or access. you can easily learn CR
  8. athos07

    Combo box

    try this code.... Option Explicit Private Sub Form_Load() With Combo1 .AddItem "ABCD" .AddItem "ACDE" .AddItem "ADEF" .AddItem "AEFG" .AddItem "ACFG" .AddItem "AFGH&quot...
  9. athos07

    HELP! VB with data report SQL parameter as input?

    Im making a program, the program suppose to produce a monthly report using data report in VB, but its not producing any thing. ive added data environment and command1 as instructed by my boss. and put an sql statement in the command1 -> general tab. I have a criteria MONTH and YEAR for input...
  10. athos07

    monthly-yearly report using CR-VB

    what will i do if i want to have an input in vb using combo-box. And report generate thru CR. i have already code but it does not work. year always appear 1905. startdate, enddate declared as STRING startdate = combo1(0).Text enddate = combo1(1).Text startdate = Format(startdate...
  11. athos07

    SQL question

    select a_lastname, a_firstname, subject from master where subject like & "'*" & keyword & "*'" just receive your reply, thank you very much but i have already solve it. my code is this: select a_lastname, a_firstname, subject from master where subject like '*' &...
  12. athos07

    SQL question

    select a_lastname, a_firstname, subject from master where subject = & "'*" & keyword & "*'" this code in sql view in access still dosent work. what do you think is wrong with this code/statement. it produce an error msg: syntax error (operand missing) in query expression...
  13. athos07

    how to sum a distictcount(fld)

    is it possible to insert a formula that get the sum of a distictcount in the detail or group footer? how? thanks
  14. athos07

    monthly and yearly report?

    i have a very simple problem, but since im new to this i dont know what to put in my sql code.. i have a table called [masterlist] biddate itbnumber ac 02/02/2001 ITB2-011-04 ov-10 08/28/2001 ITB2-011-04 uh-1h 12/10/2001 ITB2-039-06 f-27 01/10/2002 ITB2-039-06 uh-1h...
  15. athos07

    two query problem

    i have 2 queries from asscess. the [ac/bid count] query that have the following feild - aircraft type - amount of bid price - count of itb number - percentage of bid price with this query, everything works fine but every time i add the table [summary date] query - start date - end date...
  16. athos07

    SQL PROBLEM?

    ey thanks :) hope i can retrun the favor some day athos
  17. athos07

    SQL PROBLEM?

    i have this sql code select a_lastname, a_firstname, subject from master where subject = %keyword% it dosent work, i think the problem is in the WHERE clause. what is the correct way to right the WHERE clause to search for any word in any field of the SUBJECT field.. thanks
  18. athos07

    selecting start date-end date in database

    BlackKnight thank you very much :) it worked both solution worked :) i hope i can return the favor if your going to have ur problem :) thank you again athos
  19. athos07

    selecting start date-end date in database

    I have this database, where i have a field called BIDdate that has format "mm/dd/yyyy". i have a record of 100 of dates. How can i get the first date record and the last date record, using SQL and with out any input of date range.

Part and Inventory Search

Back
Top