Search results for query: *

I have a table with rows that contain a Date, Id and an amount. I need to create a report or form that will show each ID with the same Date the amount and an average for the amounts. A table example would be: Date......Id..Amount 4/12/2012 123 4 4/12/2012 456 3 4/12/2012 789 2 5/12/2012 123 5...

I have a .txt file that I need to read and grab data from certain lines in the file. I may need to do this just a few times during processing or perhaps a dozen times. Is it better to open the file once and build an array of data with the information I might need.... OR Is it better to...

Hello, Is it possible to use a column name as part of a query result. for example Column names Values Product1,Product2 1235xyz, 1234ads 3422xdr, 234dnfb 4234ser, 1dae4r3 for a result looking like: Product1, 1235xyz Product1, 3422xdr Product1, 4234ser Product2, 1234ads Product2, 234dnfb...

Hello, One of our operators has a daily task that I was wondering if and how it could be automated to help them during this process. Let me explain. We receive a CD that contains PDF files. Each Pdf file needs to be opened with a password, have the security removed, saved and moved into...

I have one Front Page 2003 app where I have a search component on a couple of forms, and it works. I started another FP app and added a Search component and it does not work. I get this error: FrontPage Error. User: please report details to this site's webmaster. Webmaster: please see the...

Hello, How can I find what the Sunday date would be for the xx number of weeks represented as a numeric value: In other words: If given the numeric value of (let's say) 37, what would the Sunday date be for the 37th week into the year? I assume I would start with a beginnnig date of...

Hello, I am currently running Access 2002 Developer. A lot of our users have gone to Office 2003; so there are compatibility issue errors that pop up from time to time in my Access applications, (functions not available etc.) I'm probably due for an Access upgrade. I need a developer addition...

I put a search control component on a web page. It does work. However, it only finds the full text of a search. Let me explain: If I search for 'TM969', all documents with TM969 are found. If I search for '969' nothing is found. Why does the search feature not list the same documents? Is there...

I have a web page. I click the Format tab and choose Themes. I see a theme I like so I double click it and it throws the background of the theme on to my page. The icon of the themes, show that the headings and buttons are also subject to the theme, yet when I add text for (let's say) a heading...

Using FP 2003, how do I go about opening up a browser window within my web page? So if a user clicks a link on the site, the result of the click displays in it's own little browser window, so that the user does not leave my site? Thanks for you help!

Basic Question: (I've never done this before so I'm not sure what to do). I am creating a small business website for a friend in FP. It is a pretty basic site. My knowledge is more in VS.Net and using company web hosted servers. So once I have his site to a point where it is ready to be...

I need to move around radio buttons within an option group and also move some buttons from one option group to another. When I click on the frame, even though I moved 5 buttons from one group to another, the frame still shows those buttons belonging to the original option group. Where do I...

I am using the FP search funtion. The script looks like: webbot bot="Search" s-index="ALL"...etc. Does anyone have a link that explains the different properties of the search? And is it possible to use wildcards in the search criteria. For instance I can search the text: TM969 and find hits...

Hello, All the fields on my form come from a single query. I want to add a textbox to the form which will be invisible. The information in the textbox comes from a different table. How can I include this on the form? I tried setting the textbox's controlsource to =tblNeeded!Field, but an...

Hello, My report has an amount field on each detail line. The report is grouped by another field on the detail line. How can I (at the end of each group) sum the amounts together in the group footer and then at the end of the entire report give a grand total? Thanks

Hello, I put the spelling 'abc' icon on my custom tool bar. If I display a record from the database in a form, the Spelling icon is enabled and will check the text fields when clicked. However, if I am inserting a new record in the database via a form, the spelling icon is disabled and is...

Hello, Does anyone have an example of doing a drag and drop from a filelistbox to a dirlistbox? And what how to lightup (highlight) the folders in the dirlistbox so to show which one the file will be dropped (copied) in to? Thanks

In microsoft outlook, I was able to create a macro that I added to the tool bar. Is it possible to do the same in Windows Explorer? If so how? I want to create a button that does this: For any unknown file type (file extension), open the highlighted document in Notepad. Thanks

Hello, I have a simple report. It contains two fields for the detail. Currently the report writes on 4 pages, but the fields are so small I can probably get all four pages on one page if I could get the detail to fill down and then back to the top, down, back to the top so instead of this...

The query I have works up to a point, perhaps I need another to get the results I want, but I can't seem to get it to work. The first query: Groups by Roll Size, Plant Site and KiloPrice. SELECT rolltable.rollsize, Count(rolltable.rollnum) AS [Count], rolltable.rcvrplant...