Search results for query: *

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

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...

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...

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

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...

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

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

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

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...

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...

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 '*' &...

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...

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

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...

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...

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

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

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

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.