Search results

OK I have a form that for contact names and I have a button that when clicked will bring up the corresponding business's info on a different form. This uses the attached macro coding and works great. My issue seems to be... that when they go into the businesses info using this button...

vbaInet: "If you have 3 paragraphs, try selecting 3 cells in Excel and paste. Then copy from those cells and paste into Access." This worked.

I am referring to Microsoft Outlook. I may just have to research that idea while the boss is out next week. Thanks for your help.

It works but kinda defeats the purpose of making it easier.

I select the email text in Outlook and select "COPY" . Then click into the Excel cell I'm putting the text into and click "PASTE" It looks normal in Excel with all the appropriate returns there.

I know apparently what the problem is but can't seem to figure out how to fix it. Let's see if I can explain what's going on coherently. I have a field in a table that we copy the text from an email into so they can be associated with a client. These could be many paragraphs. All is...

Knew it had to something simple! Worked like a charm! Thank you!

OK so I have a form where the user selects a company in a dropdown box and then the corresponding record is pulled up. (See the attached screen capture of the form detail.) This was accomplished with the following in the After Update Event: ="[File As] = " & "'" & [Screen].[ActiveControl]...

Finally got a chance to circle back to this database and watch the last video you sent. Unfortunately it looks as though I don't have the permissions on our SharePoint site to create an Access web app.

So I tested it again by copying my data into a new database and the SharePoint button became available. So I tested the method in the video and it only put my tables on SharePoint. Not the whole database that has the forms and queries to make life simple for my users. Kathie

Didn't really helped as that SharePoint button under Database Tools is greyed out for me. Kathie

It does not appear I have either of those. Kathie

Does it matter that it is an Office 365 SharePoint site? I've uploaded the way it told me to by simply dragging a file into the space to upload. (see the attached screen capture of our site). Thanks Kathie

I apologize if this has been asked before. I have an Access 2013 database that I have saved on our SharePoint site. (https://xxx.sharepoint.com/_layouts/15/start.aspx#/Shared%20Documents/Forms/AllItems.aspx) The db works fine but when a user clicks and opens the db, a copy is saved on...

I am trying to create a macro for a double-click event on a subform. Where when I double click a record on that subform it opens another form to a record with corresponding information. What exactly I need is: Double-click a record on the [Correspondence Subform] Open the [Client_Info]...

Took a couple of tries to get it but that worked PERFECTLY! Thanks llkhoutx!!! Kathie

OK So I'm not even sure this is possible but I thought I would start by checking with you guys. I am creating a database to keep track of client contact. Using the form Client_Info. What I'm trying to do is on the Correspondence tab. I want to be able to double click on a record and...

THANK THE LORD!!! I finally got it working. Here I had the declaration of the variable in the wrong spot. As soon as I changed it, it works like a charm. Thanks again CJ! Kathie

Great! Now to see if I can get it into the Login button correctly. Kathie

OK So I've found a login form that works. Right now if you don't have a password it just won't let you in. I'm not familiar enough with public variable and am having a difficult time with setting that up. Still trying! Kathie