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...

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...

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...

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...

I have a text file with each line a new record. Each record has 3 fields on each line. They are always in the same location. Example: 022313 534672 13251- More notes. 121913 342231 40251 First value is a date field: "OrgDate" 022313 It should go into a date field called OrgDate as 02/23/2013...

I am trying to load Excel files into access 2013. I have five different files and they all will be linked. They all will have forums that will be related to the files. There are times when I will want to have the ability to move the files independently. It seems that the main file, accdb, is...

It took about a year with the help of Microsoft's best support. And also dBase Plus 8 http://www.dbase.com/support. You will not be able to load your dBase IV files into Access 2013 without the following. Actually, I should say you will be able to load access 2013 but as soon as you try to...

I have a mean database and would like to remove a couple of tables. I want to keep them, but not in this particular database. You. Want to save them into a different directory also. The tables need to be use with the same database. but not that often. I'm trying to conserve on memory use. If...

I have broken up by master database, table, into several tables. They all share the same ID values since they came from the master table. So each table that I split off has a unique, matching, identifier, ID, in both the master table and the new table. Plus a previous matching identifier listed...

I have quite a few tables in my database. I'm trying to clean up, but can't figure out how to remove tables. The exports wants to export into a number similar file, so it seems. I'm just trying to reduce the size of the database by eliminating some of the tables that I don't use all the time in...

I'm looking for a way, when entering form, to force a field to accept a value, rhs;jjc;cjs. then every record will automatically contain the accepted value time you go to a new record. That would only be for newly added record. It would stay this way tell exit forum and the next time is open. It...

I have a field that will only get numeric values, numbers. And it will always have four characters or less. I do have times when I worry my data by over eighty's certain size or I average value, or both. Is this possible when using a text field. So I'm looking for advice whether I should text...

I have several visual dBase tables converted over to Access 2013. The old tables use identification, SEQ. I have retained the old SEQ , but now have the Access ID. It seems I somewhere saw that if you delete an ID, you will be changing all the subsequent IDs that follow. In other words, if you...

I want my table to accept only certain values in a field. I tried different things with no luck. Field: OCC (except only 1 or 2) I tried Validation Rule using Expression Builder, which did not work for me. I also tried creating a default value of the same field. What I'm trying to do is have...

I have gone to layout\remove layout and for the most part it works. But now and then I have labels that stick to the field. Not always just a couple here and there that make it impossible to work with an entire column of. Bob Access 2013

I have set up a form and only want to display the date and time that will appear automatically based on when the record was created. I definitely don't know how to do this. The format that I'm looking for is: 07/24/13 11:45:44pm from what I can see I would need two separate fields to accomplish...