Search results

I heard its possible to create a windows scheduled task to execute a macro in a db at a specific time? Can someone explain how to do this? Thanks. bluke

I've been asked to create a report that looks like below: Region 8/3/2009 8/2/2009 8/1/2009 etc… Department 8/3/2009 8/2/2009 8/1/2009 etc… SalesPerson 8/3/2009 8/2/2009 8/1/2009 etc… The Date is one field in the base query but used multiple times (repeated) in the grouping. If...

I built a report that gives a summation for the entire data range specified by grouping. Sum([Sales]) for each group. This totals the entire data range, for example April 1st through april 30. what expression can be used in addition to this one on the same grouping level to give a summation...

I want to install use this tool: http://www.btabdevelopment.com/main/MyFreeAccessTools/tabid/78/Default.aspx But the instructions first say to make the db an mde. I tried to do this but get an eror saying that it cannot make an mde file because the max number of unique tableID's is reached...

I'd like to create a form that looks up info in a query that has three fields (date, department, sales volume) The form would have a combo box to select department, text field to enter the date and the third box would automatically populate the volume based on the criteria in the other 2...

I've created a rather extensive database with security that about 15 users in various global locations across our network will use on a daily basis. The problem i'm facing now is that as this database is ever changing (thanks to my boss who always wants different things added) when I go to make...

I have a query with 3 fields, department, date, TotalSales. I need to build a form where the user can select the department from a combo box, enter the date in a text box and based upon these criteria, display the sales volume in the 3rd box on the form. I guess you could call it a lookup, but...

Could someone provide me with an expression that would always return data from last week? I've been playing around with serialdate and datepart but can't quite figure it out. Appreciate the help! B.

I have a form which is ultimately a filter for various reports, Currently, I have 3 different fields by which to filter the report, start date, end date and region. I need to add more options by which to filter (i.e, employee, department, etc. Here is my issue. How can I make the filter in...

I've been asked to create a typical report with data from a database but add a section for notes via a popup form. Whereas the user with click the button to run the report but first a form would popup to enter notes and these notes would be returned to the report. I've never encountered this...

Does anyone know of a way to create PDF reports in Access? I'm looking to export reports using a macro. It would be nice to have PDf file as an output format? Thanks. Bluke

Does anyone know of a good resource to mull through all of the built in functions and learn their syntax, uses, etc? Thanks bluke

Does anyone know of an expression I can use in a condition to run a Macro when new records have been added to a table? i.e., when record count increases, run macro... Thanks a mil. bluke

I need to create a filter in a report for all data within the current quarter, does anyone know of expression that will do this without using parameters? Bluke

a request came accross my desk to find holidays sales in relation to the same days of the week for other weeks. For example, Thanksgivings sales compared to each of the 2 thursdays prior and the 2 thursdays after. Anyone know of a way of pulling this data so I have it all in one query -...

Does anyone know a report filter or expression that would always return all the data from the current Quarter?

Does anyone know a query expression that would always return the date of the first day of the week (a Monday) for the week after next?:confused:

I created a report that due to a criteria is generated for one certain day, for example (06/21/06). I can run the report for any day, any department except for 1 department. When this one department is selected I can only generate one report for 1 day. When I attempt to select any other day...

I need to change the primary data source table in my DB to a different table. The new table is an external linked table so i cannot just change the name. Is there an easy way to update all queries and reports to reference this new table?? Thanks.

I created a report where is lists sales volume by day. I was asked to create a table where data can be excluded from this report. The exclusion table consists of only three fields: Date Department and a check box What do I need to do in the query to have it exclude the data listed in this...