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!

  • Congratulations bkrike 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: *

  • Users: athos07
  • Content: Threads
  • Order by date
  1. 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...
  2. athos07

    how 2 print ms access report using VB

    how can i print ms access report (my back end database) using visual basic.?? thanks
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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
  8. 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...
  9. 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...
  10. 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
  11. 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