Recent content by skeletor

Thanks very much to both respondees. I was able to use the code submitted by imex. That worked perfectly and is much appreciated.

I am having trouble with the code for an SQL Server Insert Into Query. The result gives an error message that there has been a "violation of primary key restraint". I have researched here and found that I need an If Not Exists statement within the code, but I haven't been able to get that code...

Thanks to TheAceMan and dhookom for responding to my thread. To dhookom, your solution worked great, thank you very much.

Thank you for interest in my question. The query uses the overtime table, and the fields are: Emp# - number field ShiftDate – date field, one for each day of the year Hour – number field, represents overtime hours SRC Total 1 Emp# ShiftDate Hour 514099 8/16/2010 0 514099 8/17/2010 0 514099...

I’ve searched everywhere and can’t figure out how to create a query that adds up employee overtime hours and keeps a running total. I found a Dsum example, that works great for a single employee, but adds all employee hours when multiple employees are queried. The table I use is called...

To Tony, Thanks for the response. I e-mailed Kaione support to find out if their software will let me do what I want. I have a Microsoft Access database with quite a bit of Visual Basic in it, and I want to be sure that their program will allow for the use of Visual Basic. Thanks again, Skeletor

I have a Microsoft Access database that I would like to place on a Pocket PC. Is it possible to do this without rewriting the program? Is there a conversion utility available?

I want to update a field with a sequence of numbers. For example, there are two fields in a table with 100 records. The first field is an autonumber with #'s 1 to 100. The second field is a number field named Shift. I want to start numbering the Shift field so that it starts with 1 and fills...

I've been told that Access is not a good program for a WAN. Is this based on the size of the network or the distance of phone lines? I'm working with a program that has a back end residing on a server at a remote location. The back end holds five tables with approximately 3-4 mb of data. There...