Search results

The thing with this is that after the full stop, anything you type is saved somewhere, while it shows that your typing "please answer the following question:" have you tried doing it in access?

Thank you guys. You saved me hours of typing. =left(A1,4) worked great.

Hi, Everyone, I have an excel column that has building location and building name in one column, example 1245 Accounting, how can I copy the 1245 into it's own column, please help, i can do it either in access or excel. Please.

Anyone tried this!!!

after you type a comma, you should type a period and then watch what happens after you type something!!! First time doing it you have to type accept above

LOL i'm so sorry that you're misunderstanding me. This is not what i'm talking about. listen go to the website above, and type Peter,. make sure you type peter,. then see what happens. The trick here is like a magic, you have someone sits next to you, you tell him/her look at something and see...

Here is the trick. after you type Peter, "after the comma type period" then type your answer" while typing your answer, it shows that your typing something different. then when you click on show me answer, the value which didn't show will be displayed. are you confused yet?

here is the link. http://www.peteranswers.com/ guys lets see who can do it in access.

Wondering! anybody tried the above link, do you guys think we can do it in access. Thanks.

Have you guys seen peter answer website, I'm trying to do the same in ms access does anyone know how I can do it. Thanks. I want to create a text box and in the text box, i want to type the answer but I want the text box to automatically type some thing else visually!!!!!!

Guys I don't know if any of you have done this. I need to import a formatted excel file into an access table, I know that I need to write a vba code to do it, can someone please give me a tip or an example. The excel file is a formatted form, it's not based on columns & rows!!!! Please Please...

Does anyone have an example for the above, I'm asked to do the same, basically import formatted excel forms into access tables. Please Please Please help me if you can. thanks.

If the data in the spreadsheet is not in a standard row/column datasheet format how can I import it to Access, does anyone know, please help if you do. I have a formatted excel form and i need to import it to access!!!!!!

Hi Guys, Does anyone know how i can get an excel file properties from Access. Thanks.

Hi Guys, Does anyone know how i can get an excel file properties from Access. Thanks.

time format thanks, i'm doing this in excel and i'm getting this error msg. See attachment. Thanks.

I have this code for an excel file in vba, strDate = Format(Date, "mm-dd-yy") & " " & " at " & Format(Time, "h-mm-ss"). I'm trying to put colons ":" instead of the dashs "-" for the time but I get a debug error, is there any way I can make it work, or am i stuck with dashes. Thanks.

This is hard to explain but I hope that someone can help. I have over 50 maps that were created with a custom stencils template. I'm working now on a new template, can i convert the old ones to the new template? is there a way I can import them to the new template? Please help if you can :)

I have an excel file that I want to email a sheet, doesn't anybody know how? I want to create a button inside excel and then when I press it I want to attache the sheet and email it. Thanks.

Sorry All, I have a simple question, how can I tell if my laptop has a wireless network in it. Thanks.