Search results

Hi, Not sure if this is right forum, but here goes. I am looking for advice on sending data to some electronic equipment via a data cable using a port on the computer. The access form is complete and just needs to be able to output the data to the port. The electronics are waiting for data...

Hi, I use the following code in the "On Format" within the detail section of a report. I have to copy and paste the code when the field name changes. So I have multiple copies which display differences for the Passdate and Case Select sections. Is it possible to use the following code once but...

Thanks for the feedback, I will try and implement your suggestions Thanks Darrell...

Thanks for the reply, but its a bit more in depth. I need to create 2 tables one showing last months data and one this months data. Give the records a sequential position in both tables and then create a report that shows the movement of the people in the report ie: move up, down or stayed in...

Hi, I have created a query that creates a table. The table displays people in a league based on a points system. The points system works fine, however I need to add a position for each of the people in the table. (something like autonumber down through the table) Thanks in advance Darrell..

Ideas For How to Create Report Hi, I am looking for Idea's of how to create a report. Basically the report is a league table showing Month and YTD, this is the easy bit. The part I need suggestions and guidance on: The report also needs to show peoples movements in the league table i.e...

Thanks, I will have a look at the suggestions you made. Daz....

Hi, Is this possible? I have a number of reports that get published onto the intranet monthly. The same reports now need to be published hourly if possible. The reports database sits on a NT server which also runs as the Intranet server. So I am looking to see if NT can automatically...

Thanks, Will try it. Daz..

Hi, I am looking for guidance on how to get a query field to display a numeric period from an existing field that contains a date. ie: 01/01/2005 = 1 (1st Month) 01/05/2005 = 5 (5th Month) Etc. Thanks Darrell...

Hi, Long story but here goes. I have created graphs from within Access. Graphs run from a crosstab query and data is grouped by month (Jan - Dec) Graphs then display results by month - this all works fine. We now need to show target line on the graph. Target data is kept in a table and is...

Hi, I need to create 12 new records in an existing table (one record for each month of the year) Once I have created the new records, I then need to: 1. Add the dates for each month into a date field for each of the 12 records (ie: 01/01/2005, 01/02,2005, etc) 2. Populate the new record...

Hi, I have been trying to solve a problem for some time, but unsuccessfully. I am trying to output a graph with two lines one for "Results by Month" and one line for "Target Per Month". The idea is you could see how someone is performing against target by month throughout the year. ie...

John, That works fine. Thanks Daz...

Hi, I will see if I can explain this a little easier. I have two tables: Departments (List of departments) Reported Data (Records created when a department reports info) I can run a query on the "Reported Data" table that shows which departments reported information, because a record was...

Hi, I am trying to create a query that shows departments that have and have not reported any data. Table 1: Departments (Contains 40 Records\Departments In Total) Field 1 = fID Field 2 = fName Table 2: Reported Data (Contains 5000 Records From 40 Departments) Field 1 = fID (Relates to Above...

Hi, I have a Access db that uses Access Graphs in the reports. The reports work fine and creates the graphs with no problem from within access. I have now had a request to display another line in the graphs. Line 1: Performance (Line already showing) Line 2: Target (I need to add a new line...

Hi, I am using the following code quite a few times and across three forms. Dim ScorePoint As Byte Dim Score As Integer Can I use a Global or Constant to specify the type instead of having the same code numerous times throughout the db? Thanks Daz....

Hi Uncle Gizmo, Thanks for the demo, that works great. Daz....

Hi, I need some advice for the best way to proceed with some code. I use the following to update a form and then it opens a new form which asks for the following information: GameID (on main form) Batsman No (on main form) Batsman Score (on main form) Overs (on main form) Wkt (on main form)...