Hi!
I have two Table names:
tblupdate
tblDetails
What i want to do is to update the table tblupdate from tblDetails using the button in Visual basic Interface.
Here my code:
Str = " Update tblupdate " & _
" Set tblupdate.Text1 = (Select Text1 From tblDetails where tblDetails.Text 1 = '" & Text1.Text & "') "...
Serenityquinn15
Last Activity: Nov 4 '08, 04:23 AM
Joined: Oct 22 '07
Location:
-
>>Crystal Reports is a business intelligence application used to design and generate reports from a wide range of data sources.
DataSources like: Microsoft Access(any version), SQL, and etc.
>>In Creating report in crystal you'll learn about the report design, place object on a report, and how to sort, group and total your reoport data.
>>If you are using access 2000, you can connect your database to crystal,... -
Serenityquinn15 started a topic Trouble In Truncating Number into two Decimal Placesin Visual BasicTrouble In Truncating Number into two Decimal Places
Hi!
I have a little trouble about in truncating numbers. What i want to do is to get the two decimal places.
here's the example:
when i try to get the half of 20500.39 it shows like this:10250.195
but what i want to see is 10250.19 only.
another one is 20500.42, it shows like this: 10250.2
which in real, it must be 10250.21.
what im going to do???
here's my... -
Hi!
Thank You!!! :)...Leave a comment:
-
Complete the Date in Query
Good Day!
I was trying to query this data.
here is the situation: I have a data of the Following:
DATE
January 1
January 2
January 4
January 6
if you notice, there's a missing date.
What i want to do is to add or put the missing date automatically to complete the date using the QUERY only, i mean without encoding the missing date from the table.
... -
Change xx/100 to 00/100 in crystal report
Hi!
I have a problem regarding in the crystal report. I use the function towords() to convert the number into words but I notice that the last part of the words it show xx/100. How I can change this?
It should be 00/100 instead of xx/100 .
Please Help Me.
Tnx. :) -
Append query to another table automatically
Hi!
I have a question regarding in MS Access Database specially in query. Is it possible to append query automatically?? ???
Thank You! -
Hi!
It works good!!! Thanks for the help!Leave a comment:
-
Calculating Military Time
Hi!
I used Query in Access to calculate the time in and out of the employee of course to get the total minutes, however i've been encountered a problem. when i put for timeIn=22:00 and for time Out =24:00 the total mins display like this:" -1320 ", which actually wrong. it should be "120" mins instead of "-1320". how i can fix this problem??? i already set those data into short time format.
Please help... -
Serenityquinn15 started a topic Cannot Start your Application, the workgroup information file is missing.....in Visual BasicCannot Start your Application, the workgroup information file is missing.....
Hi!
"Cannot Start your Application, the workgroup information file is missing or opened exclusively by another user"
this is the error i got when i run my system. i'm using adodc connection to run my program and the backend was the Ms Access Database. I set the password to my database to secure all the data but when i run my system this error was come up.. i dont know why???
Here is the code:
... -
Thank You for the Information. However, I created this code so far but i dont know why isn't working, here's my code:
Dim strSql As String
strSql = "INSERT INTO OpenDataSource( 'Microsoft.Jet. OLEDB.4.0','Dat a Source=" & App.Path & "\Extract.MDB;' )...[Sam_Timedata] ([EmployeeID],[Pin],[Timedata],[Count],[InOut],[strEmployeeID]) " & _
"SELECT EmployeeID, Pin, Timedata, Count,...Leave a comment:
-
Append specific Data From SQL Server To MS Access Table
Hi!
I was wondering if it is possible to get the specific data coming from SQL Server 2000 and append it to my MS Access Table through VB Code????
If it so, please advise me on how i can do this kind of importing Data.
Thank You -
I need a number with decimal places.......Leave a comment:
-
Total amount in Data grid Columns
Hi!
I have little trouble in my Program. I need to total all the amount in specific column.. comes from the data produced by the datagrid..
heres my code:
Set rs11 = New Recordset
rs11.CursorLoca tion = adUseClient
rs11.Open "Select * From Leave WHERE EmpNo= '" & Txtempno.Text & "'", con, adOpenDynamic, adLockOptimisti c
Set DataGrid1.DataS ource = rs11
... -
Count the number in Crystal Reports
Hi!
I'm using crystal reports, And I have some trouble in counting numbers..
because even Blank field are counted... and I dont know why????
Im using this code:
Count({Field})
Want I want to do is to count only true values in each field....
Actually, it is my first time to create a report in crystal.
Please help me what is the best thing to do.. to avoid this kind of error..... -
Yes, I selected those combo box but still its empty...
No errors occur.. but theres no data appeared in data grid...(which actually I have a data to display on that specific date in the datagrid.)...Leave a comment:
-
I test the code that you gave me but there's no data appear.... Please see my code if it is correct...
Private Sub Command1_Click( )
Adodc1.RecordSo urce = "Select * From [Timereport] WHERE Name = '" & CmbEmployee.Tex t & " ' and Timelogging.Dat e Between #" & DTPicker1.Value & "# AND #" & DTPicker2.Value & "# Order by Timelogging.Dat e "
Adodc1.Refresh
...Leave a comment:
-
Filter Date in The DataGrid using DTPicker1 and DTPicker2
Hi!
I have a question regarding in filtering. I want to Filter my Datagrid1 according to Name of the person and the Date ( which actually, Date from to Date of...).. I don't know How I can do this....
Example:
Name: Perla Cruz
Date From : January 01, 2007
Date To: January 15, 2007
This is the basis to filter my datagrid.
PLease advise me..
thanks!!! -
I tried it... but the same error occurs... I need to set my DataReport into legal size but how I can do this???? Please Advise me. thanks.Leave a comment:
No activity results to display
Leave a comment: