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

So the users need to have the front end db and the mdw on their local drive for this to work properly?

Thanks for the great help! I've split the database, so I now have 2 db's, the *_be db and the original on our network, do the other users just make copies of the original (frontend) and place them on their local (c) drives? Do I install the utilities mentioned in this post before I ask other...

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

Thanks for this but how would I modfiy this if I need to return all data for the full week Monday through Sunday?

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: