Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. barrysprout

    LinkChildFields

    Does anyone know how to programmatically set the LinkChildFields and MasterFields properties on a Report/subreport? The help file doesn't provide any examples and I can't seem to get the syntax right. Thanks
  2. barrysprout

    Crosstab Query – multiple row results

    I would like to create a report in a crosstab format that shows sales per month for a range of products but for each product I want the current year row to be followed by the previous year row like so: Jan Feb Mar ….. etc Product A 2007 100 150 200 …..etc 2006 80 120 150 …..etc Product B...
  3. barrysprout

    Obtaining an object name from a run time error

    Does anyone know if there is any way to obtain the name of an object that causes an ‘object exists (3012)’ or ‘can’t find object (7878)’ run time error? I want to create an error handling routine that requires me to know the name of the object that is causing the error. Thanks.
  4. barrysprout

    Controlling the level of zoom in reports

    Anyone know whether it is possible to programmatically set the level of zoom when a report opens. The default zoom in and out are either to big or too small. I want to set my own level but don't want to include any additional toolbars.
  5. barrysprout

    Security: denied permission to owner/administrator

    I have 2 databases, both of which I am the owner and administrator. When I try to copy or import objects from one database to the other, I get a message saying I don't have the necessary permission and to get the administrator or owner, i.e. me, to do it for me. Any ideas?
  6. barrysprout

    Name Conflict - Database Corruption

    I have a database that seems to have got corrupted and is giving me a name conflict when I try to change the name of a report. It won't let me change the name from Proforma1Copy to Proforma1. There is no report visible in the database window called Proforma1. Anyone know how I can fix this...
  7. barrysprout

    Only some things grow

    I have a report that contains an item description and other fields that are numeric. I have set the CanGrow properties of all fields and the section to yes but when the item description grows, the other fields don't grow with it unless they need to. I am using the field border property so the...
  8. barrysprout

    Security - preventing access to Visual Basic Editor

    I am implementing security in a database but when the user clicks on a command that uses visual basic to open an object they don’t have rights to, the resulting message box alarmingly contains a button that opens the Visual Basic editor. Is there a way of preventing this? I thought of using...
  9. barrysprout

    Report won't print

    I have a report whose control source is set with the OnOpen event like so: me.RecordSource = sqlstr The report previews fine but doesn't print. Strangely, if I try to print it from the database window using the right click print command, it prints. Anyone know what's happening here and how to...
  10. barrysprout

    Combo problem re-post. Can't solve. Please help.

    Totally stumped on this one, hence the re-post. I have a combo box on a form whose results are filtered by a parameter that is supplied by the value in another combo box like so: Combo1 = country Combo2 = customers of country entered in combo1 Nothing fancy about this and it works fine but...
  11. barrysprout

    Parameter request with linked combos

    I have a combo box on a form whose results are filtered by a parameter that is supplied by the value in another combo box like so: Combo1 = country Combo2 = customers of country entered in combo1 This works fine but when I close the form using a menu or button (and not the form's default close...
  12. barrysprout

    Visual Basic to obtain the Windows User Name

    I am trying to build some security into a database and would like to restrict data viewing according to the user. If I could access the Windows User Name for this, it would be ideal. I believe this can be done using Visual Basic but have absolutely no idea where to start. Can anyone point me in...
  13. barrysprout

    Double Subquery SQL syntax

    I’m trying to run a query that is based on a subquery that is based on another subquery, i.e. 3 queries in total. I can get the SQL of the first two subqueries to work but am not sure of the syntax for the last query that provides the final result. The SQL for the first 2 subqueries which works...
  14. barrysprout

    Can a second query be based on temporary one?

    I have 2 queries, the second of which simply groups the results of the first. I would like to do this in code without creating any saved queries, i.e. making the first query temporary. Can this be done and if so how? If not, is there another way?
  15. barrysprout

    Database security - data restriction

    I have a database that contains sales data from various countries around the world. I would like to restrict the countries that individual users can view the data of, i.e. the country manager for Germany can only see Germany sales data and not say, France. Can anyone guide me as to how I would...
  16. barrysprout

    Report #Error when summing and no records in subreport

    I have a report that contains 2 subreports, each with a total field. I have a control on the main report that sums the totals from the 2 subreports. This works fine when both subreports have records but if one subreport has 0 records, I get a #Error. I’ve tried using IsNull and IsEmpty to get...
  17. barrysprout

    ‘Enter Parameter Value’ inexplicable request

    I have an extremely annoying problem that simply won’t go away. I have a form called ‘Proformas’ that is opened and closed from a menu. The form is based on a table (also called Proformas) and has a combo box that moves you to the selected record according to the proforma you select . Everything...
  18. barrysprout

    Delete query won’t delete

    I am trying to delete records from one table based on the results of a select query. I have a table called ‘Invoices’ where I want to delete those invoices that are returned by a select query called ‘DeleteInv’. In the delete query design, I have linked this query to the Invoices table by the...
  19. barrysprout

    Date criteria – won’t recognise

    I can’t get a select query to recognise date criteria. I want to select records between Jan 1st and the current date of any given year. The year is referenced from a control on an unbound form where the user selects various criteria. I have used the dateserial function as below to get the date...
  20. barrysprout

    Dynamic Multiple Value Crosstab Query

    I have created a number of crosstab queries which I can join with a select query to produce a multiple value crosstab as per the standard method. The output I want is as follows: Product Country1 Country1 Country2 Country2 etc Sales Budget Sales Budget The problem is that I...

Part and Inventory Search

Back
Top