Access To Power Point
Jul 20, 2006I need to transfer a report form access to a power point slide does any one know how or have a macro that does this. or know someone who does.
View Replies
ADVERTISEMENT
Re-enabling Power To An Access DB!!!
Jul 11, 2006Hi Guys,
I have just finished a DB in access, so I went into options and disabled all menus and shortcuts (I wanted to make it foolproof, this DB is for my mum!).
Anyway, it turns out that I wasn’t completely finished, and now I want to make a change to the DB. How can I do this?
Please view the screenshot, it shows which menus are/aren't enabled. I have explored all of the menus and I cant think of anything.
Lost Records Due To Power Cut
Apr 11, 2007Hi All,
We've just had a power cut and 2 of us were in the process of adding a record to the database. The primary field is an Autonumber and, on re-entering the information for the record, we have found that 2 numbers are missing.
Ie. instead of record numbers 1,2,3,4, we now only have 1 & 4. Is there any way of retrieving 2 & 3?
And is there something I can/should do in order to prevent this problem from reoccuring?
We have the Autonumber facility so that, when we add a new record, it automatically enters the next number. Is there a formula I can use so that the default value when adding the record is the number of the previous record + 1?
With thanks for any assistance.
Ronnie
MS Access: Logic For Point/Miles Rewards Program
Jul 9, 2007Hi Everyone:
I am new to this forum as I recently started working in MS Access. I’m hoping someone can please help me with this query I’m trying to do using MS Access 2007.
This task is somewhat similar to a typical points/miles rewards credit card program.
The problem is as follow:
For every $2,000 of accrued purchases in a credit card, an individual will get a gift card.
So, any remaining balances over $2,000 will rollover and be added to next set of transactions, until it reaches $2,000 again. For instance, if on the first week I spent $2,500, I would qualify for my first gift card. The excess $500 would rollover and be added to the next set of transactions until they reach $2,000 again. Therefore, this would qualify me for another gift card.
So far, I’ve created two tables, one that stores accrued purchases (Promo History) and another table based on an Append Query which takes all qualified transactions from the first table and appends those records to the second table (Promo History Qualified) in order to track those qualified transactions over $2,000.
However, I’m stuck on how I would accommodate the remaining balances to be carried over. Any suggestions would be greatly appreciated!!
Thank you in advance,
marel
ERROR Message Appears On Share Point Linked MS Access
Mar 12, 2014I have created a Asset database using MS Access 2010 & the same was published in SharePoint portal. Post publishing, all the "Query & Forms" are working as excepted but the "Reports" are not working.
The "Reports" is designed with "Group & Sort" option. Post grouping am able to see the "=Sum([Expression])" (i.e. Sum of the Value) value in MS Access Locally but not in SharePoint. Once i published in SharePoint, am getting "#Error" message for all the below expression wherever i have used in my reports design.
Expression Used:
Below expressions are works fine locally & getting #Error in SharePoint.
1. =Sum()
2. ="Page " & [Page] & " of " & [Pages]
3. =Now()
4. =Date()
General :: Objects Not Visible In Navigation Pane For Power Users
May 29, 2015We are encountering a problem that started with Access 2007 and continues in 2010 and 2013. We are using a network system.mdw file with mdb databases and the security seems to be working with one exception while running in Access 2007, 2010 and 2013 but runs fine in Access 2003. We have some power users who are allowed to create/modify objects. The power users and Admins have a unhide command button that displays the database window in Access 2003 and displays the Navigation pane in 2007-13. The problem is that when the Navigation pane is shown there are no objects displayed. These are not hidden or system objects and display in Access 2003 database window properly for the power users.
View 1 Replies View RelatedFix End Point
Sep 21, 2007:)Hello,
I have one Access table called plan_location where it contains the following columns: shape_id (number), seqnum (number), xcoord (number) and ycoord(number). The shape_id is a individual number for each planname, the seqnum is the number of points in the plan and the xcoord ycoord indicate the x,y location on the ground.
See example:
shape_idseqnumxcoordycoord
700609719.4294818231.424
701609745.694818251.119
702609755.9194818230.81
703609781.7674818243.946
704609822.6834818254.656
705609871.714818261.276
706609879.4324818226.623
707609814.9484818218.313
708609763.8424818198.827
709609730.0664818165.801
7010609698.2784818123.723
7011609668.3594818142.025
7012609714.9354818201.641
7013609729.6864818214.026
7014609720.4294818240.424
In the above example, although this is only one plan of thousands, the xcoord/ycoord value for seqnum=0 is not the same as the xcoord/ycoord value found in seqnum=14, thus this indicates an error.
I need to find a way to isolate those shape_id's with the beginning seqnum of 0 that is not the same as the highest seqnum of 14, in this case. The seqnum can range from 0 to any number, depending on the number of points.
If the seqnum of 0's xcoord/ ycoord values to NOT match the highest seqnum's xcoord/ycoord values, I need to find a way to insert the next highest seqnum and add the same xcoord/ycoord values found for seqnum = 0
How can this be done?
Thanks in advance..........CementCarver:confused:
Not sure how this is done..............
Starting Point For Db.
Jul 27, 2005Hi All.
This may be a bit of a strange one, but was wondering if anyone had any ideas.
I would like to create a db which is a bit like the directions bit of multimap.co.uk
As per the attached jpg, i would like a db so I can input a starting box and end box, and it would tell me the shortest distance, longest distance, route via boxes etc.
e.g
Box A as start and Box F as end. Shortest route is via Box D, longest route via boxes B and C etc.
The db would obviously not for measuring distances between boxes!!!....but thought this may explain it.
Does anyone have any ideas?
Thanks for taking the time to read this.
Frank.
A Point In The Right Direction Plz.
Nov 14, 2006Not sure what this covers so if someone could point me in the right direction, so I can get started.
I want to do a search of customers through a button on a form with names, and there you get a list of customer that match your criteria. When you click or double click on that customer you get sent to the main form with all the customer details on it.
thx
Damien
Decimal Point
Dec 14, 2005Hi
I have data numbers:
1500
60000
8900
How can I put a decimal point two from the right ie:
15.00
600.00
89.00
Thanks.........
SQL Stuck Point
Oct 17, 2006Hello all,
I am currently working on an sql query to find employees which handled more orders than average in a certain half year. For arguments sake the half year is august-dec1997. I will use two queries, one to calculate COUNT and one for the avg:
So far I have the COUNT query sorted:
SELECT Employees.EmployeeID, Count(Orders.EmployeeID) AS CountOfOrders
FROM Employees, Orders
WHERE (((Employees.EmployeeID)=[Orders].[EmployeeID]))
GROUP BY Employees.EmployeeID;
However, I am uncertain how to proceed from here and find the >AVG part of this query. Any help would be appreciated- thankyou :o
To add to this I think the next table should be like this:
SELECT qrycountOfOrders.EmployeeID, Employees.FirstName, Employees.LastName, qrycountOfOrders.CountOfOrders,
WHERE
FROM qrycountOfOrders, Employees
WHERE qrycountOfOrders.EmployeeID = Employees.EmployeeID;
But I am unsure where to put the >=AVG...
All Problems Point To This
Aug 3, 2006My Access DB is built and works great. All problems that I have seem to revolve around the 2 tables that I link to Excel spreadsheets. The spreadsheets come from downloads. The problems are:
Can't format fields in a linked table. and the download comes unformatted.
Can't make DB Multi-User because the Linked Spreadsheets restrict access to more than one user at a time.
Is it possible (Practical) to build a macro that would access the spreadsheet on a regular basis and import it (Overwriting the previous data in the table) into Access?
I would really appreciate anyone that has a solution. I am ready to pull out the last 3 hairs I have on my head.
Point Me In The Right Direction
Sep 1, 2006Dont use access much but I have basic db dev. skills. That said, here's my dillema:
I have a front desk entry form fro service calls. There is a entry field for customerID. I would like to auto populate f_name, l_name etc... from just entering customerID. I know what I would do in an SQL situation, but how does that transfer over to access? Any help would be great. Thanks.
Remove Zero Before The Decimal Point
Mar 9, 2008Hello,
I have a lot of values that look like this: 0.524, 0.673, and 0.398. I hate to look at these numbers with the zero before the decimal point and would like to find out how to remove them. I know that it's possible in Excel, but I'm not sure of how to do it in Access.
Is this possible?
Thanks
Decimal Point Problems
Aug 7, 2007I am working on a database that tracks things for a welding shop. Because of this I am using heights in millimeters and decimal points are necessary. The page I am using is an input form with a subform tied to a specific record. I can under no circumstance get my decimals to stay put in the input form or in the table. I have tried changing to decimal and putting the decimal to two and the precision to five, long integers with decimals to 2. Formatting with #.## so it maintains it in the text box... but nothing has worked. Has anyone run into this problem?
Thanks
Riley
Single Decimal Point?
Jun 12, 2006When created a query how do you change the decimal point,
There are many and i want a single one.
ListBox Decimal Point?
Apr 14, 2005Does anyone know how to force a listbox to display an additional level of accuaracy in a listbox which displays a value based on an expression in a querry? My querry displays the value to 4 decimal point but my listbox only diplays the value to 2 decimal point.
Thanks!
Hiding The Insertion Point
Nov 17, 2006Is there anyway to hide the insertion point in access?
View 1 Replies View Related2 Fields Point At Same Table
Nov 30, 2006 Quote: I have 2 fields in my table - cityID and offcityID - I want to create a query that
ties the cityID to the city table cityID and
offcityID ties the offcityID to the city table cityID
I am not getting the correct amount of records when I set this up.
Code:SELECT [main changed].lastname, [main changed].firstname, [main changed].address, City.City, [main changed].business, [main changed].offaddress, City.CityFROM [main changed] INNER JOIN City ON ([main changed].cityID = City.CityID) AND ([main changed].offcityID = City.CityID);
Quote: I should have 1898 records - when I have the AND in I get 227 records and when I have the OR in I get 2176 records. Neither is correct
Exporting Decimal Comma As Point
Apr 26, 2005I have a table with the numbers formatted as example 9999,99. My mysql database i'm exporting to uses the point as decimal sign. Can I change my query so it outputs the decimal sign as point instaed of a comma?
In my international setting decimal is a comma and should stay a comma.
Thanks
How To Point A Form To The Current Record
Aug 17, 2006I have a form in access that opens to the first record every time. This form will be constantly updated and i was wondering how i can set it, so that it opens up to a new record everytime you open the form.
Anyone know how to do this?
Decimal Point Issue On Currency
Jan 12, 2007ok.. this is not a hugely important issue, however.. it is a slight annoyance that i would like to resolve if it is possible..most of my currencies will be whole numbers like twenty pounds or five pounds..so i chose to set the decimal point to 0 which displays it like this..£50which is better then setting it on auto (£50.00) which my user does not like..(uneccessary zeros)however.. every now and then there will be a carpark cost of £2.30..if i set the decimal point to 0 then £2.30 will display as £2 which is no good.. if i set the decimal point to 1 then it will display it as £2.3 which is no good..so is there a way to make sure that all currencies display as decimal point 0 values.. eg £34.. £2.. £145 and if a price happens to involve some pence.. such as two pounds 30 pence.. then display it as £2.30 or £103.55... etc....i hope that is clear
View 4 Replies View RelatedLaugh And Point At The Syntax Moron
Sep 15, 2005Feel free to pick on me. I can't get syntax right. Ever. So when I can't figure it out I just try to find an example of what I want to do and use it as a guide. But I've not been able to find a single example (and I looked at a lot of threads and the *shudder* help files) of using "OR" in a DSum within a single field. Here is a simplified version of my statement:
=DSum("[Contribution_Amount]","tbl_CONTRIBUTION","[Employee_ID] =" & Forms!frmNew_Contribution!Employee_ID & " and [Special_Case] Is Null")
This works perfectly. I want it to look like this:
=DSum("[Contribution_Amount]","tbl_CONTRIBUTION","[Employee_ID] =" & Forms!frmNew_Contribution!Employee_ID & " and [Special_Case] = 'stringABC' or Is Null")
But this errors. And I've tried every combination of ' " () & # I can think of and everything errors, unless I completely set the OR apart into a new criteria, in which case it executes but produces results that are not what I'm trying to get. It also works if I add "= 'stringABC'" and remove the IsNull. I just can't seem to have both. Does anyone know how to write this properly?
How Do I Point Form To Table In Another *.mdb File?
Jun 27, 2006I have separated my application logic (forms, VBA code, queries) from my data and am unable to open my form. The form is in file DbAppl.mdb and the table is in file DbData.mdb. Any ideas? Thanks.
View 4 Replies View RelatedHow Do I Point Form To Table In Another *.mdb File?
Jun 27, 2006My .mdb file was getting too large (500+ mb) and taking a long time to compress, so I separated my application logic (forms, modules, queries) from my data (tables) and now I'm unable to open my form because it can't find the table it's based on. The form is in file DbAppl.mdb and the table is in file DbData.mdb. I thought I could point my form in the one mdb file to the table in another by putting ME.RecordSource = C:xxxDbData.mdb in the Open Form event, but I can't seem to get it working.
View 1 Replies View RelatedSetting Your Own Auto Number Start Point
Jul 11, 2006I have read and tried though practice to change my Auto Number Field to a start number I want but for some reason fail each time. Help Someone:D
View 4 Replies View Related