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...

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...

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...

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...

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...

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...

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...

Hi Experts, Is it possible to use a progress bar to represent a block of time? for example I would like to have a prpgress bar that represents 24 hours in a day and I feed it a min and max like 12 and 24 respectively and it only shows the second half of the progress bar or 6 and 18 and it only...

Hi Experts, I am just looking for some different strategies for this one. I have about 10 reports listing various kinds of information, my manager has asked me to create a "dashboard" - basically a report that has summary info from 10 - 12 other reports. For example one report shows all...

I have searched the forums and have not been able to find a solution to this one (if one exists) Has anyone been able to find a way to list all queries and which tables are used as data sources. Any help would be greatly appreciated. Tx, Boomer

Hello, I actually had to see this one to beleive it but it is true. After a database is run, Excel files will not open properly. If you navigate to the folder where the .xls file is you can double click on it and the Excel appication will open but the file will not, the screen just freezes...

I have 2 columns, one with a number and the other with a string, I need to be able to take the number from one column and insert it in the string located in the other column. Any help would be greately appreciated. following is an example. column1 Column2 365 there [variable]...

Is it possible to get the full name of the user logged into a database. I am able to get the username but I would like to be able to get the users full name We have XP workstations with a Novell file and print server with a Win 2K active directory domain replicator.?

Hello all, I have a form (frmEmployee) that lists info about each employee - including his or her manager. I would like to be able to click a button and cycle through each employee in the form for a given manager and print out the form. ADDITIONAL INFO: I am not sure if this is of any...

I hvae the following statement in a modual: "SELECT Count(InputID) AS TotDays FROM tblInput WHERE tblInput.InputDate > #" & Format("02/01/" & Str(Year(Date) - 1), "mm/dd/yy") & "# AND ((tblInput.UserID)=" & glngUserID & ")"for some reason, the...

I have a command button that I want the user to be able to click only once and then be invisible, or until a checkbox is clicked that will reset the button to be visible. The problem that I am having is that once I close the form the button automatically becomes visible when opened again. Any...

Good day experts, I am trying to find a way to move a record to a new table using recordsets and code. If the value of field x is greater than y, I need to remove the entire record from it's current table and add it to a new table. Any help would be greatly appreciated Boomer

good day experts, I'm working on a project that I have not been able to complete and I could really use some help. I have an access query that has two fields, date and incident code. In excel I have a grid, 12 rows and 31 columns, one row for each month and one column for each day of the...