Posts by Sin_Thetic

Re: Creating a form to search a database

bump

i have a database that is a knowledge base of requests and solutions

what i want is to have a form that has capabilities of searching the database, how is this done?

i also need to have a form for entering new data

thank you

Re: Assistance required for IF and AVERAGE functions

thanks alot for the quick reply

much apreciated

i have several things i need some help with here, i used to know how to perform these functions but now ive long since forgotten

any and all help will be greatly appreciated

first thing:

the scenario is a spreadsheet for adding call centre operators evaluations (1 being worst and 5 being best) from the clients

in the spreadsheet, i need to create a function to add a quick evaluation based on the operators score from the client

so if the score is 4 or higher it would read "good - improving"

and if it is less than 4 "poor - improving"

i think this is just a simple IF question...but i have forgotten how to do it

thanks

Re: Word VBA Assistance

Quote from norie

Ger

I don't know if I'm right but I think the OP wants to display the Save As dialog box to prompt for a filename.:)

correct

i also must designate a directory which should show up in the prompt

Re: Word VBA Assistance

what i tryed (the easy way) is the record the macro with the assigned keystroke and just click save as...but i cant stop the recording without closing the dialog box or saving the file....

basically, all i need is to be able to hit a keystroke and the save as dialog box appears and after saving closes the document

Re: Word VBA Assistance

thanks for the reply Ger, i had tryed something like what you posted before and it didnt work the way i need it to

what i need is a Keystroke to prompt for the filename and directory (the save as dialog box)

thanks again

I have a quick question for VBA buffs

i have to create a macro to prompt for save as, then save, then close the document all using the same keystroke (Alt-E)

it is simple im sure, im just missing an important line of code here or there

any help at all is much appreciated!!