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...
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...
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...
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...
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...
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...
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...
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...
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 ;-)...
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")...
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...
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...
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...
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
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
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...
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...
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("n", [Start], [End]) This returns a value that...
Greetings
I have created an application for use in a production facility, for logging job and task progress, along with elapsed times. Operators "start" tasks, and "end" tasks with a click of a command button, or a swipe of a barcode scanner. The "start" or...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.