access 2010

Hi, I have a VBA code that deletes some old data from my database and uploads the new data into it from some excel files. The thing is that the macro stops in the middle and brings me the error that the database reached it maximum capacity but when I click the Compact and Repair button the DB...

Hi, I am trying to create a macro to automatically import several Excel reports into my data base in Access. The names have some similarities (I use this similarities for another macro I use that depending on the file name it gives the proper format to the file) for example dependig if the...

Below is the sql query that I am running. Currently, if a user has 0 open for the number of tickets, their name is removed from my list. I need them to show with a 0. Otherwise, I do not realize they have no work. Thoughts? I am relatively new to this so any and all help in lamens terms is...

I am struggeling to make a relationship between these two tables in Access 2010. To get the same value of the column on the first table I need to concentate two colums of the other one. I have two tables. Table "Orders" "FirstnameSurname" "John Smith" "Tom Jensen" Table "Costs"...

This is the content of my file testAI.csv Common Date,Week,Status,Business Unit,Assignee 2014-08-18,2014 Week30,Closed,Tech Rep,Paul Smith, When I try to import it in Access 2010 I get the error: As suggested from an article from Tabelousoftware (source: Resolving "Field separator matches...

Is there a way to set the colors in a pie chart without having to manipulate them everytime I run a report graph? I have 6 different categories that are counted and I want each category to not vary from month to month in color. Lost = Red Found = Green Obsolete = Yellow, etc. Can I assign...

I have three pic charts for three different facilities containing 6 different possible categories. Each chart contains the exact same information but is filtered by the facility in the chart. Because of this, some facilities will have 0 for a category. This causes the categories to have...

I have built several graphs in Access and would like to export them into power point. I have built these using forms and can print these out into reports. Is there a way to export these into a power point presentation or import them into the presentation? This would be great if it could happen...

Hi, I have a multi-user database, as an internal function that only i have access to i would like to see who is connected to the database, i do currently have a form and code being used which successfully shows me all the computer names connected. The code then populates a list box, the colomn...

I am trying to make a running totals query by month. I have the prices of jobs by day and would like those to be totaled up to a monthly total and then do a running total as the year progresses. Month Monthly Price Running Total Jan. - $1,000.00 $1,000.00 Feb. - $500.00...

Good morning, I have a union query that identifies if a part is a L2 or VW part. Each part has a price in the cost field. How do I add up all the L2 parts and the VW parts in a query or form or report to show the totals for each? Example: L2: $2,000.00 VW: $1000.00 I need this so that I...

Ok, So according to the internets, I'm doing this right. However, I am not getting the desired result. I am using a crosstab query with the added stipulation that I need to only extract data between 2 dates. I put the parameters in like so: Between [Start Date] And [End Date] l...

I have a query that returns a Null value if it is empty. I want the field to have a zero in it if it is null. Can I use the Criteria field to write an expression to create that? I need the field to be 0 if it is empty. I have tried IIf(IsNull([Current Month]),0) But that makes my query return...

Hi, I have got a table that has numerous columns, i then have a query that looks at a form where you can type in parts of the data and it will use the query to search and give you all the results on a form. (i hope that makes sense first of all) On the form with the search results on the user...

I have recently switched over some of my reporting to Access from Excel and would like to know if I can use the same characters to display positive, negative and no change numbers. I currently display negative numbers as a green circle, positive numbers as a red diamond and no change as a yellow...

Hi, So far i have managed to link access to outlook via a hyperlink on the email address, click it and it brings a blank email with just the 'To' field populated. What i want to do is have a generic email template, so when the email address is chosen (via a form which looks at a table) then it...

Hi all, I have basic understanding of Access and VBA so be nice :) I have created a db that is nearly finished but what i desperately need is a login form, i have created so far: tbluser - (this has 3 coloumns, EmployeeID, Employee Name and Employee Password) frmlogin - (This has a combo box...

(Access 2010) So I think I may have found a way to purge the active cache that builds up in the Virtual Memory and causes the 'System Resource Exceeded' issue on 32-bit Office, but I'd love to be able to audtomate it in the background for my users. I got the error today, then went to 'File' >...

Hi, I have begun getting an error message when i open the relationship window. The error message says "Duplicate output alias 'Expr1'". When i click ok it allows me in but there's only a handful of tables and no relationships are shown. Is there anything i need to do to solve this problem? Thanks

(Access 2010) I'm getting 'Too Few Parameters: Expected 1' from VB. Usually, when I'm trying to get OpenRecordset to work in VB and it fails due to 'Too Few Parameters', I have a debug.print spit out the SQL String, plug the string into a Query and get a better, more precise error message to...