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!

Register Log in
  • Congratulations derfloh 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: *

  1. dr1256dr

    Dual Boot and System Drives

    Nelviticus That makes perfect sense. In my case, I already had Vista installed.
  2. dr1256dr

    Dual Boot and System Drives

    linney Thanks for the suggestions. I always wondered if such a thing existed as a hardware switch to activate, deactivate drives. Now I know. Drive caddies were also suggested to me. As far as the Virtual PC solution goes, I heard some horror stories about hardware support and performance. I'm...
  3. dr1256dr

    Dual Boot and System Drives

    Greetings. I have searched all over the web for an answer to my question, with no luck. Maybe I am using the wrong search terms, there are a bazillion articles, posts, storys, etc about dual booting. I need to dual boot Windows Vista and XP Pro. I got there no problem, with each OS on their...
  4. dr1256dr

    Keeping 2 servers synchronized

    But still, I don't see how the DIFF backup can be the same size as the FULL backup, as you mentioned before.?" Well, my assumption was that after a differential backup,"backup.bak" would grow by the amount of data entered since the last backup. As to the sequence, I didn't think of that. As I...
  5. dr1256dr

    Keeping 2 servers synchronized

    k108, I guess I can check into that, (replication). It just seemed a little bit extravagant as a starting point. I was hoping there would be a way to just create a small bak file with ONLY new data, then restore that bak using the append setting. In effect, I am looking at it like this...
  6. dr1256dr

    Keeping 2 servers synchronized

    Catadmin: Maybe I have not explained myself very well. (happens frequently!). I want to avoid having to download the large full backup bak file, as it takes a long time. Even if I do an incremental backup/restore, the file size remains the same. What I am trying to accomplish is a means of...
  7. dr1256dr

    Keeping 2 servers synchronized

    Thanks for the quick response, Dr.Sql I am still a little confused, however. I am already doing a full backup from production, then restoring to development. The problem is that the resultant full backup bak file takes an incredibly long time to download to my home office. It looks as if the...
  8. dr1256dr

    Keeping 2 servers synchronized

    I am a developer working from home 2 or 3 days a week. I need to keep my home SQL server in synch with my server at work, give or take a few hours. I am running SQL Server 2000. Currently, I run a backup at night, zip up and download the file in the morning, then do a restore. This works fine...
  9. dr1256dr

    Editing object description properties with VBA

    I created a routine to read and edit the description properties of tables, (the one you see in the database window). It seems to work just fine. This is the basic code behind it; (I substituted all my editing/updating code with the debug.print to keep it simple.) Function...
  10. dr1256dr

    Sequential line numbers to table

    It works! Bob, Roy-Vidar...you were both right. I needed the explicit declarations. But that wasn't all of it. I also needed to lose the ! in the syntax. Thanks for all the help, I can now lose 5 queries, 5 tables, and a bunch of messy code! Stars for both. Even if Bob spent the most time ;-)...
  11. dr1256dr

    Sequential line numbers to table

    Same type declaration error, same place. I must be overlooking the obvious, sorry! My complete code: Private Function AssignLineNos() Dim db As Database Dim rs As Recordset Dim lngLoop As Long, txtJob As String Set db = DBEngine(0)(0) Set rs = db.OpenRecordset("tblMySource")...
  12. dr1256dr

    Sequential line numbers to table

    Bob After further reading of your post, I should ley you know that this table will not be update by any forms. I pull the data from elsewhere, and use it to print work orders, and in some labor collection procedures, (barcoding). I also print barcode labels, which is where I use the line...
  13. dr1256dr

    Sequential line numbers to table

    Bob Thanks for the response. I am still on part 1 of your reply. I am getting an error at run-time; "Type-declaration character does not match declared data type", at this line: If rs!("Job") <> txtJobNumber Then My field name in the table is Job, not Job Number or JobNumber. I know my Job...
  14. dr1256dr

    Sequential line numbers to table

    Greetings Seems like this should be easy, but I am stuck! I import data in a table from another program. I link to the table using ODBC, and use an Append Query with 6 of the fields. The primary key in my new table is multi-field; fieldA, fieldB, fieldC. fieldA is a "Job Number", in text...
  15. dr1256dr

    Elapsed time: division?

    BobJacksonWcom; Thanks a bunch. This is exactly the kind of tip I was looking for. I will adapt this to fit my needs, and post how I used it when I get there. Dennis
  16. dr1256dr

    Elapsed time: division?

    MichaelRed; You are absolutely correct! I frequently reach beyond my experience..... By doing so, and browsing great forums such as this, I end up learning something new everytime! Thanks for your help, and a star for trying to help. Dennis
  17. dr1256dr

    Elapsed time: division?

    MichaelRed; I can't seem to do what I need with your example. I modified it, so this is probably where I went wrong. To recap what I am trying to do: tblLog has 4 fields: fldJobNo, fldPieceCount, fldStart, and fldEnd. My form and queries append the fldJobNo with a 7 character text value, the...
  18. dr1256dr

    Elapsed time: division?

    Thanks, I will try this later. Dumb question: I added a timer event to my simple form, that fires every second. This appends a 1 to simple temp table. Seems too simple to be true, I now have a number of seconds per operation with which I can do anything I want. What is wrong with that picture...
  19. dr1256dr

    Elapsed time: division?

    Thanks for the quick response. Please humor me here, as I am learning VBA as I go. Can you give me a specific example how I would go about this? Would I use the DataDiff function in a query? (I looked in help.) I tried: Elapsed: DateDiff(&quot;n&quot;, [Start], [End]) This returns a value that...
  20. dr1256dr

    Elapsed time: division?

    Greetings I have created an application for use in a production facility, for logging job and task progress, along with elapsed times. Operators &quot;start&quot; tasks, and &quot;end&quot; tasks with a click of a command button, or a swipe of a barcode scanner. The &quot;start&quot; or...

Part and Inventory Search

Back
Top