Search results

That works great! Thanks

Bob - thanks for the reply. I was afraid of that. Can you help me ... where do I put this code. I can launch the VBA Editor, but I don't know what to do next. Thanks again

I am using Excel 2003. I would like to include a cell value in my Header. For example, cell A1 says "John Smith," so I want "John Smith" in the Header. Is this possible. P.S. I searched online and found VBA solutions. I am not comfortable with VBA. But it seems this is simple, it should...

where are u pat

in theory it should be easy if [condition] = true, then me.picture = file1, else file 2

if you create a new macro, TransferDatabase is an option. You can specify the destination folder and export filetype, but i don't see ".dat" as an option good luck.

If I understand your question ... If your form is based on a query which contains Score1, Score2 and TOTAL, then create a textbox on the form, and use TOTAL as your Control Source. It should appear as an option in the drop down box. If you want this data to appear in Form B, then create a...

can u post a screen-shot of your Relationships screen

can u send a screen-shot of relationships screen

Arvdot – Help. I am trying to do the exact same thing. But I am light years behind you Can you help me understand your code - How are you pulling the email etc from the table - And how do you get the system to advance to the next record, to send the next email I believe it is somewhere...

can u explain the timestamp .... are you trying to capture the date/time of download?

i dont know about access - but you can export to outlook

Hello. I use Access at work, and I would like to use it at home for a personal project, but it costs about $400. I am thinking about buying Microsoft Works, because it comes with a Database, and it is only $40. However, I am not sure it has the features I want - basic tables, forms and...

Dear g- Typically, a mail merge would work, but in this case the letter is too complicated for that - too many different tables and subreports involved. How do you get "a Rich Text Format control." I don't see your first question/point. thank you

Hello. I want to format particular fields in a textbox. The textbox contains a paragraph, which includes a person's name. For example: "Dear [NAME], you may have won a million dollars!" I want the name to be in a different font. Is there a way to do this. Note that I can't break it up...

Hello. I am looking for a way to make a field value automatically default to the value of the immediate prior field. For example, I am in record 11, and in Field "City" I type "New York." When I create record 12, I want City to automatically default to "New York." Is there a way to do this...

I'm even thicker. I don't understand. Is this the code you would put in the make-table query: Expr1: CDate([TextDate]) When I try to run the query I get a compile error Help?

Is there an answer to the original question: Is it possible to program a make-table query to define the datatypes for the fields in the new table? If not, is it possible to write code to change field types and sizes? Thanks for any help

Oy Vey - you said: "The obvious solution is to change the query to a make table or append query with predefined fieldsizes" Are you saying that it a maketable query can set the field type/size for each field of the new table? How do you do that?

Great, thanks!