Search results for query: *

i see that if i am not in form mode i can click on the ref field and press f9 to update the field. waht i need is for that field to automatically update itself upon the insertion of text in the first field. should i use a macro for that?

I do that and then i save and protect the form. When i first insert it it is blanks since the text box it is referencing is blank. When i then go to the text box when its a form I enter text in it and nothing happens down where the reference is on the next page. So i have a text box that a...

I have a 3 page form that one of my users created. They want the information in several of the text boxes to be used throughout the form without having to be retyped. i figured i could use a bookmark or crossreference to do this. I have set the initial test box (which is in a table) with a...

Thanks for the tips: Questions: If i use a form does it have to be based on a table? Will the date info just stay in a text box field that i added? if i use the table i have the sme question. How do i make it so that just the latest entry in the date control? i don't want the table to keep...

I have a query for a report that takes totals from 8 different tables. the tables have been changed to run by a Month/Year parameter in MM/YY format. So now when i run the query its going to ask me 8 times to enter the same MM/YY (once for each total) Is there a way I can just enter the parm...

Hi Folks, I have what I hope is going to be a simple question. I have a query that uses criteria to give me a subset of data that i want to display on a report. I want to total the premium dollars on this report. Thats easy. i'd aslo like to show the TOTAL premium for all records in the...

thanks for the ie tip... we have been working for DAYS with the vendor about their addin.... they've tried a couple times to pawn it off as an outlook issue... but i just keep telling them the only time this happens is using your addin... they tried downloading somethign called OUTLOOK SPY ...

P.S. Everything , the dll and manual all worked FINE in 5.5 environment

Hello all, We have software we use for our legal team at my company. This software uses a .dll that integrates Outlook with their software. My problem is this. When a user receives and email in Outlook and they want to file it in a case in the legal software they click a button on the...

it is definitely possible! Where would i put that code? Can i run that as part of the query or a macro? do i run it by itself??

I'l not familiar with that function. Could you by any chance give me an example?

Hi Folks, I am have a functioning db that pulls in Data from a SQL database into my Access Table. Using Access 2003. Trouble is i have found I ahve a problem with one of my fields. I am currently using linked tables to the SQL data and then I have a make table query that creates the MAIN...

PERFECT Thanks so Much!!!

Hi ! I have field that I want to add to a query that calculates the number of days from todays date to Expiration date of policy. Easy enough to use DateDiff. This calc works for criteria of all policy types equal to A, S or R BUT If i have a Policy type of C then i want to substitute Cancel...

i'm using Access 2003... thanks for the help... i'll be trying your ideas in the morning when I'm back at work! Kath

I have a few forms i created with unbound excel spreadsheets. I'd like to open a form from a switchboard. My users use run time access... What i'd like is for the user to click on the button to Open a form and then be able to A) type in the form name in a dialog box and click OK and that form...

Fabulous.... THANKS for your help.... I appreciate it greatly Kathy

I have parameter queries feeding reports in my Access database. Normally a user will select a report to be run by a vendor. So they enter the vendor in the parameter box and the query runs and the report is displayed. i have a manager who would like to run that query for ALL vendors. i was...

can anyone elaborate a litte more on that? i am a novice VB person but can a little bit... i just added a combo box to my word doc and now i can't delete it... argh!

Hi, I have a WORD template that has a drop down list of 12 or so choices. When protected the user cannot enter a choice of there own (in one of the pre done choices isn't what they want) How do I make this field behave so that it shows the 12 choices but also allows for a user to type in...