Recent content by BukHix

I think you accomplish the same thing with much less code with something like this. Public Class Form1 Dim ds As DataSet Private Sub GetRecords() Dim da As SqlDataAdapter da = New SqlDataAdapter("Select " & _ "LastName, " & _ "FirstName, " & _...

VB.Net 2005 for Dummies did more for me in learning Visual Basic then any other book I have purchased. And I have purchased many books over the years.

The Answer I got it: Hours: IIf([EorDCode]=" 1",IIf([Dept]="10",55,[Regular]/60),IIf([Dept]=10,0,[OT]/60))

I have a nested IIF that I cannot get figured out. This is what I have so far: Hours: IIf([Dept]="10",55,Format(IIf([EorDCode]=" 1",[Regular]/60,[OT]/60),"Fixed")) The problem is that I need another IIF to differentiate between Regular and Overtime. It needs to do this. If Dept = 10 Then 55...

That worked great. Thank you very much for the help!

I am creating an export for a third party Payroll Company who needs regular and overtime on separate lines with a notation of which is which. The notation should be pretty easy using an ImmediateIf Checking for a greater the 0 in either column but I am not sure how to get the data in the...

I have a table with data structured like this: Emp# ST OT -------------------- 30174 1421 540 30180 1882 518 30200 2400 0 30223 2271 66 I want to create a query that takes that data and does this: Emp# ST OT -------------------- 30174 1421 0 30174 0 540 30180 1882 0 30180 0 518 30200 2400 0...

I am not sure I understand your question exactly but if you want the button to show up on top of the panel just lay the panel down first and then drop the button on top of it. I think you can also just cut and paste the item on top of the panel and it will do the same thing. For the most part...

Does anybody have some sample code or a turorial for exporting a datagrid into an Access database table?

Do you have any programming experience in VB, ASP or ASP.Net? For the forum part you can download and install Snitz Forum Software, which has an option to use Access as a datastore and does it pretty well. Another option would be Das Blog, which is a blogging application that does not require...

Can you program in VB.Net? Somewhere I have some code (instructions) that will run DTS packages on a client workstation from a VB application. Let me know if that will work you and I will look around for it.

I am trying to evaluate two IIfs in a report but have something wrong with the syntax. Here is what I have =IIf([InvUM]="EA" And [InvRoLevel]<=6,6,12, =IIF ([InvUM="Qt" and [InvRoLevel] <= 220,220,440) Basically the I want it to do the first evaluation if the InvUM field = EA and do the other...

I think this is a matter of registering a Crystal Reports DLL. I ran into this problem a long while back so I don't remember everything I had to do to overcome it but this may help you get started. Err Msg: "Cannot find keycodev2.dll or invalid keycode" appears in VS .NET

Now I have it. I stole this function from this thread: Function NextBirthday(aDOB As Date) As Date NextBirthday = DateSerial(Year(Date), Month(aDOB), Day(aDOB)) If NextBirthday < Date Then NextBirthday = DateSerial(Year(Date) + 1, Month(aDOB), Day(aDOB)) End Function And then I wrote...

I spoke too soon. The one flaw with that solution is that the BirCheck: DateSerial(Year(Date()),Month([Birthday]),Day([Birthday])) Will only consider dates in the current year so if we have anyone with anniversary dates in the first couple of weeks of January they will get skipped. Once the...