Search results for query: *

Have I said lately how great this site is???? The combining worked like a dream. I will put in in Excel for the staff using it and will keep in Access for me. You guys are the best. Thanks so much. It has been printed and hole punched and put in the notebook for the next time I have a brain...

Good morning - I need assistance on combining of tables. Okay - here goes 1st table - City and corresponding County 2nd table - County with corresponding Division# 3rd table - Division# with corresponding Dept Code# Need it to be all in one place, be it Access or exported to Excel, for...

Hello - I have a many many page word document that has certain places info needs to be entered. In six of those places the info is exactly the same as the very first entry. I have placed fields for tabbing to the entries, but is there a way for the ones that are the same as the first, to...

Hello everybody- We are converting all oour computers to XP. The word is that all the coding we have done in 97 will be lost. True or not true? If it is - does anyone know the fix ? Thanks in advance Taylor

FoxPro- ""can't determine what action- misspelled- punctuation incorrect-procedure isn't defined"". It is spelled correctly. The others - I am clueless - just learning code. evalesthy- that is the exact code I typed in. When you say where you assigned it - varDate- you lost...

Hello everybody- My quandry is this- I need a field to update automatically when a date is entered. You guys already helped out on a big one for me so here is another. one field called - EFFECTIVE DATE one field called - REINSPECTED What needs to happen---- the REINSPECTED needs to auto...

It doesn't change until you go to the next record. I can go back a record and then go back and it is changed. But not while I am still on the original record. It isn't the last field on the form though.

Yippeeeee yooooooo - it works. Brackets - amazing what punctuation will do. Is it possible to make it change immediately instead of waiting until you go to the next record? You are the bestest ! Thanks Taylor

Okay - here I go. Taylor

Rott Paws Tried but not working. Syntax error. I tried it with the spaces in the words and without. Either comes up with that error or saying parameters don't match. Variables error. I put it in the Current Rating before update line. What am I doing or not doing?? I don't understand code enough...

Thanks so much. I will give it a go ! Taylor

The question is confusing. Okay - When a department gets inspected, the rating has to be entered in the Current Rating field. Which in turn makes the Previous Rating field be the rating that was in the Current Rating Field before the new rating was entered. Golly Pete, reading that makes me...

Hello everybody - here goes... Survey Form has these fields - Previous Rating Current Rating What I need to happen is when the Current Rating is entered in, the Previous Rating changes to what the Current Rating was. Does that make sense because it sure reads...

Have I told you today you are the best ?? You are ! Thanks so much. taylor

Hello everybody. I have a report that is generated by a query with date parameters. Is there a way to make the dates they enter for their report appear in the header of the report? I have the current date but need the date range they ask for to be visible when it is printed. Thanks in...

Thanks so much - I will give it a go. Taylor

Hello everyone. Have a database with date field showing date inspected - DATESURVEYED -. I need to fix the query so they can put in a beginning date and then an ending date. I have a query with a parameter box pop up for a single date but not a range. Need it as simple for them to enter as...

I have several users that use and share various Access databases. They range in size from 200 K to 25 mb. The problem is they open at a snails pace or not at all (leaving the app. or the whole machine locked up). My server seems to run fine in that other docs (Word,Excel, Powerpoint); seem...

Hey It's me again- Update on my question- I have changed them all in a SQL query - SELECT strconv([District Name],3) AS District FROM [Fire Department Survey List]; Is my best bet to just make table query the same way and start fresh ? If this should be in another forum - let me know. Thanks...

Hello everyone- I have inherited a database (1545 records) that everything is in capital letters. I am having a hard time getting it to capitalize just the first letter of each word in one column that has multiple words. Some of the names have a hyphen in them and some contain the number symbol...