Search results for query: *

Good point Don! Anyway - I would certainly try a compact/repair of the database (after taking the mandatory backup, or course!!) If this doesn't work - try this: Make a new database file, and import all your objects into it (queries, forms, etc etc). Then import the tables, but before you...

It looks like you always round down to the nearest 1/4. If this is so, you can use the following expression to return the result (let's say you have already calculated the hours worked, and called it "hours"): RoundedHours...

This is probably a long way round, and others may have a better solution, but it will work for you... I can't think pf any way round the need for a second table (called, let's say "tblRanked") with fields matching those you want to display, and in addition an autonumber field. Let's...

You can use the following formula in the query - assuming the field containing the date of birth in your table is called "dateofbirth" (!) Current Age: Int((Now()-[dateofbirth])/365.25) There may be other ways using DatePart, but this works, so hey! Pete

You may have tried this - To make sure there are REALLY no relationships, click on "relationships" and "show all" from the menu bar in the relationships window. It is possible that you deleted a table from the relationships view without actually deleting the relationship...

Hi all - Does anyone know how to set permissions for allowing the use of the new file upload form component included in FP2002? As far as I can see the only way it will work is to create a new user with full "author" permissions - anything else and permission to upload is denied. Now...

Ah! Well, you can find cgi scripts to POST your form results to, which will both email you the results and add them to a txt file on your server. Your ISP should have this script available. If not, look on scriptsearch.com Easier still, though, is if your ISP has FrontPage estensions...

Yeah - I HATE Word's formatting! I often get updates from clients in a Word doc, and I always get the copy into FrontPage by: 1) copy/paste to notepad first (which strips out the formatting), then 2) copy/paste to FrontPage (where I have already made an empty template matching the layout of...

The only way I've found to make rounded corners is to do it by creating eight tiny graphics, and putting them round the edges of a 3x3 table. topleft, topcentre, topright, middleleft, middleright, bottomleft, bottomcentre, bottomright. * Make sure that the height and width of each corner...

Hi Kieran Two suggestions - neither really easy I'm afraid - others may have further suggestions - but here you go: 1) Set up a MySQL database and write some script (php?) to write your form results to the new database. Then you would have to take the informatino from the new database to your...

Dunno if this would be easy or not, but how about DoCmd.ApplyFilter ?? Just a suggestion, may be wide of the mark! Pete

Try this - If I have understood you correctly, you may be asking the query to display matching results from 5 tables (1 main table linked to 4 others through the id you have set up), when there may not be a single record in the main table which has a match in EACH OF THE OTHER 4. The solution...

Hi sweetleaf - Firstly, I think that if you use the nz function in a query, you MUST provide an "if null" argument; hence if you want your values to be zero, your expression should read: a: nz([field1],0) + nz([field2],0) BUT I have a feeling that the nz function would not be...

I posted the above at the same time as Dave - I didn't think of Request.Querystring - that's neater than using session vars! Cheers Dave! Pete

Hi Rob Is the variable from a form? If it is not, you can simply set a session variable to carry values from one page to another (although I believe cookies must be enabled at the client side). Use <% Session (&quot;session_variable_name&quot;) = 20 %> which will assign a value of 20 to the...

Hi tazzer I'm new to asp but I managed to accomplish this using FP2000 - I'll try to explain what I did - but you'll have to write your own code! Top of my page I have a database results region which is based on a WHERE statement looking for a variable name that matches the name of a drop-down...