Search results for query: *

That sounds bad, doesn't it? I have a database with a table named Transactions. This table contains records containing transaction information. For example, some records might be: ID type amount 3456 A 25 1864 A 35 3456 B 10 3456 C 20...

I am writing a datalog program that tracks counts on a test stand. At each shift or model change, the program should append the counts file to a historical file, then zero the counts and overwrite the existing current file. I can detect when the model changes, or when the shift number changes...

Got a dumb question. I have a spreadsheet filled with data, and I have a column I need to fill down with three values. 120 215 40 I want to be able to fill down so that these three values repeat. However, when I fill down, I get: 120 215 40 45 5 -35 -75 ... There are so many cells to fill...

I am having a stupid problem, and I don't quite know why. I am tryin to write data to a file, and read it back later. The problem is that when I write the formatted date, it prints extra characters to the front of the string, that screw up reading the lines back in. The characters are...

I am not good with SQL, so I am pretty well stuck. This is what I have: tblDrawings: drawingID - serves as unique identifier (Replication ID) partNumber - actual part number misc fields that aren't important relDrawingComponents: partNumber componentPartNumber componentCount I...

I have been stuck with a program that needs to read in (line by line, so as to match strings) a binary file created using the Put Statement. The person who began the program did not write to the log files using record numbers. They simply did the following: ***CODE*** Dim cr As String Dim...

I have an application that runs in cycles, and when running will generally run for hours at a time. I need a way for the user to stop the application, but keep the form loaded. I need it to end, not pause. I found the thread below, and was thinking I could use something similar to this...

Here's what I need. I have a target cell A2, a compare cell B2, and a macro call cell C2. To start, A2 = B2. Eventually, B2 will be changed. I want to set up C2 to call a macro I already wrote (&quot;test_macro&quot;) when A2<>B2. I tried the following formula in C2...

Don't know if this is possible, but we'll give it a try. I need to output a cycling digital signal across a RS-232 line. That is, when the program starts, the line will be 0(V). After 285 minutes, the line will go to +5(V). Then after 30 minutes, the line will go to 0(V), then after 68...

Got a beginner question. I have in a previous page collected the user's name and their 'group' membership from Active Directory. What I need to know is how to define who can see which components. For example, I have three groups. Group A has a full menu bar, group B has a 3/4 menu bar, and...

I think that what I want is a Pivot Chart, but I am not sure. I have a query that supplies the data that I want, but I am not sure how to make an Access Report or Form that graphs the proper data. This is what I am looking for: y-axis measures hours x-axis consists of a program number each...

I think that what I want is a Pivot Chart, but I am not sure. I have a query that supplies the data that I want, but I am not sure how to make an Access Report or Form that graphs the proper data. This is what I am looking for: y-axis measures hours x-axis consists of a program number each...

I have created a query that does what I want it to do, except for one thing. I want it to prompt the user for a start date, and an end date, and then only accept those records with a date in the field WeekEnding between those values. How do I do this? Thanks in advance! Jon Saliers

I have an access database, and a query that makes a table for the user based on a date range. I would like to have something in the database that will put the access table into excel and create a specific Pivot Chart. Is there any way to do this? I thought about possibly exporting the table...

Okay, one last crack at this problem I am having... I have two tables, with the following relevant fields: Hours: ProgramNumber, ProgramName, Project, ProjectName, Engineer, Hours Ref_Employee: Name, Job Engineer in table Hours and Name in table Ref_Employee are the same, and relate a job...

I have a database that stores part numbers in relation to a parent part type. What I am trying to create is a form that allows a user to view all parts by selecting the parent part from a combo box. How do I go about getting all of the different parts to show up on the form in the correct text...

I am trying to create a query that will sort a table by program number, then project number, and then by discipline. I have accomplished the the sorting by program and project number, but that is where the problem occurs. In this table, EngWo, each record tracks project and program, the...

I have four databases that are all interlinked. What I am trying to do is merge two tables from different databases by using a query. I listed the needed fields and how they should merge below: Hours Table, HourTrack Database Field 1 - ProgramNumber Field 2 - ProgramName Field 3 - Project...

Sorry, this is probably a pretty lame question, but I can't figure it out. I have a form where techs report their hours. There are only two techs per job, so there are two fields where they record these values, Hours1 and Hours2. In order to do some reports, I would like to use the sum of...

I have done this before in a different database, and it works fine. However, when I set it up in a second database, I am getting errors. Here is the code in the On Load event for the form: '**Begin Code** Private Sub Form_Load() 'find out if the user has access Dim chkUser As Recordset Dim...