Search results

Hi, I have the following forms setup: frm_Main (Switchboard) frm_Customers (Form) frm_SalesDetailsSub (SubForm on frmCustomers showing basic details of items they have bought) On frm_Main I can search for Customers by Surname using the following code behind a search button on the form: On...

Hi, I have seen VB app's that use a script or text file such as "variables.ini" to hold variables info. ie: Path="c:\test" IP="192.123.34.134" Does anyone have any simple examples of how VB refers to and uses this type of script file. I will be writing the app in VB6. Thanks in advance...

Hi, I have been trying for the last couple of week or so to get a query working. Basically the query is used to show Hours worked by Post Code. Everything works fine and the query returns 'Hours Worked By Postcode' and Number of Records that the data was created from. (See Report in Attached...

Hi, I am creating a time keeping db. Before I jump in and start creating a way to record times worked I thought it best to ask for advice. The db is created and the last part is to capture by member: Basically I have the following fields: MemberID Job Type Date of Job Time Started Time...

Hi, I have been asked to run a query on an existing db and output certain fields as type Double. The fields in question are currently type Currency. How do I change the format from Currency to Double or do I need to? Thanks in advance Daz....

Hi, I have been reading through the boards and managed to get this far but I have been stuck on the same problem for hours, so I am now asking for help. I need to create a YTD running total: Fields: Period, Units 01/01/2006, 10 01/02/2006, 20 UnitsYTD...

Hi, I have set-up a report suite that uses Access Graphs to display the data on a month by month basis, these works fine. However the powers that be, now want a YTD version of the same report. Example: Month Report: (Already up and running and works fine) Jan 10 Units Feb 16 Units Mar 10...

Hi, I have some data that I need to export to Delimited CSV. When I look at the data in the table or query its in the correct format that I have created, however when I export using specification file it loses the formatting. For example the following numerical data goes from the correct...

Hi, I have a number of graphs that look at fields within Excel ie: =Adj2005!$C$154:$L$154 Each month I have to update the last 3 digits to reference the latest data ie: =Adj2005!$C$154:$L$155 This is time consuming, so I thought I could create a field add a name and and the 3 digits and...

Hi, I am working on sending data via a comm port using mscomm32 to some electronic display equipment. The electronic equipment will mimic the data on the users form via electronic digits. The form will have at least 4 fields showing numeric data only. i.e: 1st Field displays numeric data from...

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

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

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

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

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