Search results for query: *

Good Afternoon Experts, I am in need of some help. I have not written any code for 8 years so I am a bit rusty to say the least:) I have an item table (70K records) that has 4 fields: Item, Cube, Weight, and Code (code not currently populated). I have a case code table with 8 records, each...

Thanks to all for replying, it's all starting to come together now, slowly but surely. Ryan

Hi all, I am just getting into shell scripting (korn) and have noticed that many scripts that include menu's have the menu at the end of the script or that the "main processing" is often at the end of the script. I am more familiar with vba and c++, neither of which typically use this...

BRILLIANT PHV !!!! it worked perfectly, thanks so much. I am still a little confused as to why it works????? could you post the english version of this command, I can look up the flags but I don't understand what the Parentheses are used for. Thanks again Ryan

I just tried it but with the same result. Thanks for the suggestion

Hello experts, I am having trouble with a simple find command. I am using the command line below to find all files in the current dir (without searching sub dir's) that do not have a name like s0998* but all find returns is a "." does anyone have any suggestions on why this is not working as...

you are absolutely correct but date1 could be 10/13/04 9:00 AM and date2 could be 12:00 AM in which case 5:00 did not hit.

Good day experts, I have a simple sub here it adds to "y" a given amt for each time each weekday occurs between two dates. I now need to do this by the hour. Everytime the clock rolls from 5:00 PM to 6:00 PM I have to add to "y" I realize I can do this by formatting and looping through every...

Thanks very much ScriptDan, that works perfectly Ryan

Hi experts, Does anyone have a small kornshell script or the appropriate command to search a dir and all sub dirs for a certain string and return the file name and the line number where a string is found? Any help would be greately appreciated Ryan

Hi Experts, I have form refresh problem that I cannot get resolved. I have a table that I use as the record source for my form. The table is created using a make table query. I want to be able to refresh the form data and to do this, the make table query has to be ran and I want the command...

please excuse my last post you answered so quickly and I posted after your answer. star for you thanks a million. I learned many new tricks today.

can this be done using the access query grid and if the source is another query?

Duane, Thanks so much for that function it is much more elegant that the one I had written, the only thing that I still do not understand is how to have my query execute your function to populate a field when I run the query. Again, thanks so much for bearing with me on this. I'm learning!!!

Maybe I should clarify what I need to do. I have a user defined field in a query "LoadingTimeInMinutes: Int(DateDiff("n",[traileropened],Now())" which give me the total time a trailer has been in the process of loading - in minutes - this process could span several days. I now need to subrtact...

I did not realize you could do that, how would you execute or call it from the query?

Hi All, I have a query that I have built a subquery off of, my problem is that I need to create a calculated field in my main query but It requires looping, if statements, etc. so I would like to create or update this new field in code. I don't think that I can just write the sql in code...

Good day experts, This one is pretty tricky.....I think. I am tracking the duration of production time (in minutes) involved in completing a task, the calc. is pretty basic "TIME TO COMPLETE TASK: Int(DateDiff("n",[TaskStarted],Now()))". This is working out pretty well with one exception, no...

Thanks Mike.....I guess I took one too many stupid pills I just could not put it together. apperciate the help

Hello Experts, I have a problem that I can't seem to solve. I have a query that projects the time of day at which approx. 100 events will occur (one record per event). basically I need to break up the day into 6 windows (4 hrs each) and assign a window number to that record/event thus allowing...