Possible To Recreate Excel Spreadsheet In Datasheet View?

Mar 4, 2014

We have a spreadsheet in Excel that I need to recreate in Access rather than link to it (not an option). I would like to create it column by column but can't even get past column 1! We have two age fields; 1) current age and 2) "show till" age. I need the datasheet to autofill column 1 beginning with the current age through the "show till" age then stop.

Column 2 begins with the current year and autofills through the "show till" age then stop.In Excel it's just a matter of adding 1 to the previous cell to create the next age or year.

View Replies


ADVERTISEMENT

Linked Excel Files - Blank Leading Rows In Query Datasheet View And Reports

Dec 12, 2013

I decided to link Excel files and all is running fine except when I run a query on the file I get about 1,041 blank rows before my data is displayed in the query's datasheet view or any report based upon this query... the data seems good but why the leading blank rows? The data in the linked Excel sheet does not look like this and another Excel file's query looks fine and they seem set up identically!

View 2 Replies View Related

Trying To Import Or Recreate A Multiplier Formula From Excel To Access

Aug 9, 2005

Really need help on this one, here is an excel expression:

X Multipliers
$ ValueMultiplier

is less than5then *3.8
is less than50*3.2
is less than100*2.8
is less than200*2.4
is less than500*2
is greater than500*1.8

so if price is less then 5 then multiply by 3.8 and so on. In excel it's in a separate worksheet, and other worksheets linked to it and adjust their Sale Price from the Cost column. Someone else created this spreadsheet, and i couldn't find a multiple discount help in access. I tried creating a query
=([PriceBook_OLD].[Cost]<=5)*3.8 Or ([PriceBook_OLD].[Cost]<=50)*3.2 Or ([PriceBook_OLD].[Cost]<=100)*2.8 Or ([PriceBook_OLD].[Cost]<=200)*2.4 Or ([PriceBook_OLD].[Cost]<=500)*2 Or ([PriceBook_OLD].[Cost]>500)*1.8
but it doesn't work. Please help!!!!
Thank you very much

V.

View 14 Replies View Related

How Do I Show The Subform As Form View Instead Of Datasheet View :confused:

Jul 19, 2007

See title :)

I have seen that in some sample db's rightclicking the mouse showed the menu with an option to check or uncheck the dataview option, unchecked the formview was applied, but when i 'just' import the subform, i cannot find somewhere the possibility to change from dataview to formview.

Maybe someone can help me with this, probably very simple(?), question?

View 4 Replies View Related

Forms :: From Pivot View To Filtered Datasheet View

Nov 14, 2013

I want to "zoom" to the underliyng data from pivot view. When in excel someone doubleclicks a field in a pivot table, it automatically creates a table containing all the lines that field were made up from. I want to achieve the same behaviour in Access.I started to think towards a VBA coda, that could be initiated from the form's double click event. It should go to datasheet view with the prpoer filter criterias.

View 1 Replies View Related

I Want Datasheet View... Why Does It Keep Showing Form View?

Apr 6, 2006

I have a form which is opened with a filter from another form. For some reason it views the form in form view, although it was set up as datasheet view. I even went to the form properties and the default was datasheet and i made it not to allow other views. This still didnt solve it. I want it to be in datasheet view because i want to show multiple records at the same time.

If u kno how i could resolve this please offer ur help

thanks

View 6 Replies View Related

View Spreadsheet Via Form

Jan 31, 2006

Hello all,

Thanks for your kind responses.

I have another question and hope you can help with.

On my form which gets informaiton from a query, I have among other fields an Account field. I have a query, Details, that provides details on the account field, the fields of the query include Account, invoices #s, invoice amounts e.t.c.

I would like to create a button on the form that would
1) take the account # showing on the current form and run the details query based on that account #
2) display the results of the query in a spreadsheet.

Thanks again for your kind help.

View 14 Replies View Related

Split Form With Spreadsheet View On Top

Oct 14, 2015

Is it possible to create a split form with spreadsheet view on top and when you click on any field in that line it shows a regular form with field information below?

View 3 Replies View Related

General :: Complex Spreadsheet With Unique User View?

Dec 19, 2014

The spreadsheet I've attached contains a ton of calculated cells and linked data. The people who created and utilize it aren't necessarily interested in changing the way they use it or populate it each quarter. That being said, my task is to somehow create a way that it can be sent to/seen by each person differently. First I'll point out that the 3 columns that are blank normally contain names, I deleted them for obvious reasons. The first of those columns, B, contains unique names for each agent in the firm, these people need to ONLY see their own data. The second column of names are basically managers, they need to see the records for each agent that falls under them. The 3rd column of names is irrelevant for these purposes.

Now if all this data were in access, and everyone had access to it I could easily just make records visible or invisible based on user name and I wouldn't be here right now. But they can't and that's not an option. I honestly don't know if this should be done solely in Excel, in Access or a bit of both. Currently this spreadsheet gets emailed to each manager and they have to review the data with each agent.

The first tab, worksheet, is basically instructions. It would be nice if those were images on the page and then all of the data were below that so that the agents could see them together and understand it better. As I'm sure you'll see it's a pretty complicated system so they have a hard time understanding it.

Note: There are actually about 3,000 records, I've deleted most of them for size purposes.

View 4 Replies View Related

Datasheet View

Nov 3, 2006

when you select the Data sheet View you display error messages in the Accounts Sub reports fields.

The database has been included as a reference:
Forms- Double click Accounts Form By Discipline -data sheet view

Under Current balance,Spent, and Encumbered Columns you get error message instead of the actuall totals.

Please tell me how to correct this prolsdms

View 1 Replies View Related

Datasheet View

Aug 20, 2004

Is it possible to switch the view of a subform to datasheet when a command button on the mainform is selected?

I know it is something involving acFormDS...but I cant figure out the rest of the code! I appreciate your help in advance!

(P.S. I know you can right click the form and select datasheet. Unfortunately there are not many people here that are familiar with MS Access and I dont trust that they will know this)

View 1 Replies View Related

Datasheet View

Jun 18, 2007

I am reviewing a program that in datasheet view has '+' signs in the left-hand column -- it displays rows of companies. When I select a '+' another 'sub-datasheet view' of employees of that company appears, partially covering the original datasheet view of companies.
Is this the way sub-forms look in datasheet view or is something else involved?
Thanks

View 4 Replies View Related

Datasheet View In Subform

Jul 17, 2006

Hi. I am trying to create subform in datasheet view with one column (total 3)as drop down list. Is this doable? Thanks.

View 3 Replies View Related

Querying A Datasheet View

Apr 25, 2007

Is it possible to do a query of the datasheet view of a subform? If so, how does one go about it.

Thanks.
eileen

View 6 Replies View Related

OnLoad View As Datasheet

Mar 9, 2005

hi

i have created subforms and set the Default View to Datasheet
Now i have a form where i am adding command buttons on it to load those subforms but They are not Loading it as DATASHEET VIEW.
Any Clue?

Thanks

View 5 Replies View Related

Subform Datasheet View

Jan 5, 2006

I have a subform that is in databsheet view. When the user logs in to the db it sets the global variable with the group level they have.

I would like a column to be hidden for a certain group of users and have tried the following.

On the subform opening event i have

if vlevel = "engineer" then

me.Hours.columnhidden = True

Else

me.Hours.columnhidden = False

End If

And i have done the same on the Main Form open event identifying the subform by Form!Subform![Hours].columnhidden = True

But neither worked.

Can any suggest something.

View 4 Replies View Related

Datasheet View In A Subform

Jul 25, 2006

Can anyone tell me how to manipulate a single cell in a datasheet view, or if it is even possible?

View 3 Replies View Related

Mimick Datasheet View

Mar 10, 2006

I have two Access files. One is just forms which I use as a front end app. The other is the database that I store all my tables/data/etc...

I want to run a query to display data from these tables and display it in like a datasheet view. I know how to do this if it was all the same Access file, but not how to do it with two separate files.

Thanks,

JMH

View 14 Replies View Related

Getting Rid Of The Row Header In Datasheet View?

Nov 17, 2013

I am trying to get rid of the row header (the little square next to a record) when in datasheet view.

View 1 Replies View Related

Import Excel Spreadsheet

Apr 20, 2005

Hello - just joined today. I hope to be of some help to other users, but am kind of a newbie.

I have an excel ss that I regularly receive which needs to go into my access DB. I set up a macro with transferspreadsheet and that works, except for one problem. I have one field which is designed as text but has data that looks like numbers as well as data that looks like text. When I run the macro, the number-like data doesn't import as text (23602012345 imports as 2.3602e+010). FYI the field in access is already defined as text. Each time I import a ss, I am appending to the existing data in the table

I have tried formatting the excel column as text with no luck. If I remove the data that truly is text in that column (ABC1287567) and leave just the 236* data, and then format the excel column as text, it seems to work fine. It just doesn't like the mixing of the data...at least it seems to me.

Any ideas to avoid manual manipulation of my excel ss before running the macro would be very helpful.

Thanks much in advance!

View 5 Replies View Related

Importing An Excel Spreadsheet

Nov 29, 2005

Hello Peeps,

I'm trying to import an excel spreadsheet into an access table. The excell spreadsheet was created using the access table( by using the 'analyze using excel' feature)

The problem is that I cannot import the updated excell spreadsheet. I get the error message.." An error occured while trying to import the file..the file was not imported"

Does someone have any clues as to how to fix this

View 1 Replies View Related

Import Excel Spreadsheet

Mar 13, 2008

Anyone out there have any ideas on how to Import an Excel File (SPECIFIC worksheet) to an Access Database

I am looking to do this at the click of a button or when the database opens...

What I really want to do is......
Is there a way to import this into an already existing table.
Delete the existing records and import the new records from the Excel Spreadsheet?

THanks

View 6 Replies View Related

Change The Datasheet-view Properties

Oct 24, 2005

I created some forms in datasheet view. Now I want to change the datasheet properties (background color, text color...): the problem is that the forms I create with the new properties are displayed as I want, but the old forms are displayed with the old properties.
Does it exist a command to open the old forms/subforms with the new properties or do I have to re-create all the old forms?

View 1 Replies View Related

Datasheet View Not Displaying Properly

Apr 21, 2006

I'm using access 2003 sp2 with all the current updates. I've got several tables linked to a sql server 2000 DB. We use it for an app called Altiris. Most of the queries i've written from these various tables work fine. However, a couple of them for no apparent reason, do not display the correct data in the data sheet view when the query is ran.

for example, I have a simple query with two tables linked. The first field is asking for the "name" column of one of the tables. In the criteria of that column, I put something in to limit the names of the programs i'm looking for. Lets say I use LIKE '%adobe acrobat 7.0%' When I run the query, it returns a certain number of records, but in the name column, it has all wrong info. I just ran it and it came up with 4 records: "webcast....", "abacast client", "Ibm websphere", and something else. Nothing even close to "adobe...."

So then I export the query to an excel spreadsheet and then open. Guess what? It has the correct info. Four records of adobe acrobat. The other column I have is from the other table and is just listing pc names. They displayed properly in both datasheet and excel file.

does anyone have any ideas what could cause this? I've deleted the table and linked to it several times. I've used this table for many other queries and it works most of the time. I just have no idea what is causing it to do this for only a few queries.

Thanks in advance for any help.

fisk

View 8 Replies View Related

Prior Record In Datasheet View

Mar 1, 2007

In my db I am tracking different stages for an event. I have a subform that is in datasheet view. The last field (current) is a yes/no check box that says that this entry is the current stage of the process. In one of the fields I have a afterupdate event that says me.current = true. But what I need is to change the previous entry to show that stage's current to be false.Does that make sense?Date Event Location Current02/01/07 Drying Dryer X (when next event added this =false)02/05/07 Bagged Warehouse XUp until I enter the 02/05 entry the 02/01 entry was the current stage and I want a check in the current box. But when I enter the 02/05 entry that now becomes my current stage so on the 02/01 event then current = false and on the 02/05 event current = True. I can get the 02/05 event to show current = True but how do I make the 02/01 current =False?Thanks,Rick

View 4 Replies View Related

Show Field Name In Datasheet View

Sep 6, 2005

Hello,

I am trying to find out how to view the field names for variables while in datasheet view in Access. Or, alternatively, I would like to know how to toggle between datasheet and design view for a particular variable. Basically, I have a huge database and I need to be able to find the field name for a variable that I have identified in datasheet view, but right now all I know to do is go into design view and guess which field name it is, click on it, see if the caption matches what I see in datasheet view, and keep doing this until I find the match. I did not create this database which is why I am not familiar enough to know what goes with what.

Thanks in advance!

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved