Search results

Is there a way to do a simple copy and paste into Excel 2016? My clipboard data is an address in column format, 5 rows. I'm trying to start off very simple. My Excels 2016 is open. My cursor will be in the Excel location, cell, where I want my data placed. I want it placed in a role. As simple...

I'm using access 2013. I'm trying to use a template call contacts. It is asking me for a "web location". The following point I get tripped up on: IMPORTANT Before you can create an Access web app, you need to have a SharePoint site where you can host the app, either through an Office 365...

I will try. Thanks Bob

Over last year and a half I have tryied every thing to change field, char size, from 255 to 6 char. Never any luck. My error is: This error can be caused by one of the following: The maximum number of columns allowed in a table or the maximum number of locks for a single file is exceeded...

My Button has to give me a sort "SQL" and continue on to open a Find Replace command. I'm using a split window. It would be the same as selecting the top of the lower, bottom of split window, and selecting the sort order. Than going to the Find Replace icon and searching. The button would be...

I am trying to connect the following code within a button on a form: SELECT [MST-SC-Muni].[Municipality], [MST-SC-Muni].SC, [MST-SC-Muni].TypeCity, [MST-SC-Muni].County, [MST-SC-Muni].WRK FROM [MST-SC-Muni] ORDER BY [MST-SC-Muni].[Municipality]; The button should run this code and then open a...

Thanks for the help. Bob

Sorry. I had to use Design View for the forum. BOb

Is it the Tab Index hat can control my order movement on a forum? As above it don't seem to work. Bob

I got the following error: This error occurs when an event has failed to run because the location of the logic for the event cannot be evaluated. For example, if the OnOpen property of a form is set to =[Field], this error occurs because a macro or event name is expected to run when the event...

Thanks. I will give it a go. BOB

In a form is there a way to change sort order based on which field is active? I'm using a Split Form which gives me the ability to sort by clicking on the header name ans selecting sort. This slowing things done since my workload is heavy. Bob

Every time I change me Tab Index, for my work order, when I save and restart the Tab Index is in a different order. It seem it changes back to A DEFAULT ORDER. I set the labels to "0" and then set the fields in the Tab order I want. Bob

After many attempts with Microsoft Support I am not able to find the most recent version of Access. I question the integrity of my updates. My most recent version number of Access is 15.04551.1506 Microsoft has a version 15.0.4420.1017. The school I went to would mean Microsoft's version is...

There is a light border that is still there after I remove the text that was in the box. I want to remove the ghost image, for lack of a better name, that is left. Also all the images, fields, are locked together. I want to remove some individually,without moving everything. I'm in the "LayOut...

Sorry posted in wrong place. Sorry posted in wrong place.

Remove-Label box after text is removed There is a light border that is still there after I remove the text that was in the box. I want to remove the ghost image, for lack of a better name, that is left. Also all the images, fields, are locked together. I want to remove some...

Very good and informative YouTube. It helped me better understand the process. Know I need to know how to create a link to files in directory. Every file in the directory has a matching record field. Do you know of a YouTube. My search brought up nothing. Bob

I did an import of text to Access 2013. The date came out much unexpected. 010313 came out as 03/26/1928. I only list this one but the all came out wrong. I had set the data type to Date/Text. I did not change it to anything special. I just took the default. I'm sure it's probably something...

I was able to convert most data in Excel using the following: 022313 534672 13251- More notes (This field equals the file name, good to append the file to record. 022313 =MID(A2,8,6) need to find a way to convert the date to 02/223/2013 534672 =MID(A2,8,6) 13251 = MID(A2,15,5) - More notes. =...