Search results for query: *

I forgot to pop back in and thank you for all of your help. I've used your waitfor "x" FOREVER method to initiate the capture, and I included another waitfor "y" FOREVER to close the capture file and give a clear command. then it goes back through the while 1 loop to waitfor "x"... pretty much...

Also, (sorry) I tried to use the when command since the help file states on the bottom of waitfor, that when commands stay active during waitfors but I haven't been able to figure that out enough to make any progress.

Great, well, the extra lines are a bit of a problem, but it works. I used the advice and came up with something else that should work, it's been working for me all day... With the screen resolution back to normal, I reduced the number of rows for the terminal to 36, that seems to get enough...

Thanks a whole lot... That's exactly what I was going to post about this morning. I created a new script, keeping the initializing settings, and using a while 1 loop and waitfor FOREVER loop and it worked great, I set it up to keep the capture file open for 1 minute with a waitquiet 60 forever...

To add, during the summer months, there's one more report that prints at 2200... That changes at the same time every year.

Thanks so much for such a quick and helpful reply, kodr: Yes, it's always at the same time each day. I saw an example with waitfor in it, and it seemed like something I'd want to explore for similar reasons to what you gave. Thanks for the tip, I'll be trying it out. As for my alarm logger...

I'm looking for advice on how to fix a script that I have inherited. I have no experience with ASPECT but I have some programming experience, none of this looks very foriegn, it just takes me a little time. Here's my scenario: I have an ABB Taylor Mod 300 DCS that used to have 2 printers...

I jumped the gun....OfficeSpace has the right answer..http://www.microsoft.com/technet/scriptcenter/resources/officetips/oct05/tips1020.mspx Sub ImportNutrition() Set objAccess = CreateObject("Access.Application") objAccess.OpenCurrentDatabase "C:\Documents and Settings\Me\My...

Ive been trying to set up code to automatically import an XML document but the simple examples just aren't working. I've used the examples in http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_accessxml.asp and...

I updated Mealsource.mdb click the link above. I removed the external references, replacing them with imported files. I got it to work. If you select, in the query's properties, Unique Entries - Yes, it removes the duplicates. My final version will be more clear, clean, and concise hopefully...

http://www.geocities.com/c_a_rile/MyFiles/Cal_transposer.xls You'll have to rename it replacing the _ with a space.

I put the .mdb file up, I am going to start again from scratch, being that I didn't spend too much time putting it together initially. The linked file is just a consecutive 1.)list of dates & 2.)a number 0,1,2,3 that indicates whether I work days or nights. That information changes as my boss...

no I get a number of records per MealID I got before, only they all look the same now.

ok, in the qryIngred, where the records are separate, I currently have 21 records. The concatnate function works, It combined into one feild what I wanted, but Did so repeatedly. with now 21 records in the query. What causes that, or is that an affect I have to counteract.

dhookom, that was simple (the second part) I probably would have thought to expand the view if I didn't see so many repeat entries in the query. That's some other problem I'm sure, thanks for your time and effort.

I'm getting errors (prompts asking for values) that lead me to believe The FROM section cant be a query, in this case. So I used the originating tables, with their relationships, and added the concatnate function at the end of the SELECT section, I replaced aquery with a the query that has all...

could someone tell me how to create a new field that 1.) combines several fields concatnated together within the same record and then 2.) combines several of the new fields from records where other related fields are the same, until yet another field is different. (Each ingredient is a record)...