Search results

Thanks, I will have a look this evening. Daz....

Dave, I have attached a cut down version. Search By Surname is working OK Search by Item button on the front does not work (trying to search for a sale item and display all customer who bought a particular item) Thanks Daz.....

Hi, I have already searched and found this but it not what I am after, because you are searching from a form which as a subform attached. I want to search from a main form (switchboard) When I search from the switchboard form for say ItemA: It open up the Customers form which as a subform...

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

Thanks for the link and advice. Daz....

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

Thanks I have now sorted out the problem. Daz....

Pat, Thanks for the reply. What type of command would you use in the report to lookup and count the unique UID's? DLookup etc? Thanks Daz......

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

Thanks for your help. Daz...

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

It throws up an error of 'sorry that function is not valid' and highlights 'offset'

Sorry, I explained it slightly wrong in my first posting. Amend each month for example: =Adj2005!$C$154:$M$154 to =Adj2005!$C$154:$N$154 So the letter changes and not the last 3 digits. Darrell..

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

Peter, Many thanks for the posting I will work with it and hopefully get to where I need to be. Thanks again Daz...

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