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!

  • Congratulations bkrike 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: *

  • Users: mbthaz
  • Content: Threads
  • Order by date
  1. mbthaz

    Duplicating Navigation in different webs

    I've got a folder in a web with a database and related asp pages, I'm publishing it to different webs for different groups within my organization. Problem I'm having is the navigation components aren't being copied accross. How do I duplicate the nav component?
  2. mbthaz

    Is it possible to 'package' a frontpage website?

    I've developed a site that touches an access database and need to package the site and database into a form that can be deployed at different url's. any way to do this
  3. mbthaz

    autopopulat text field with current date + 3 'business days'

    I currently have a text box that has <%=Date+3%> for it's default value. Is there anyway to achieve the same effect and account for weekends as well? What I'd like is to 'skip' weekends when counting days. Thanks much Mike
  4. mbthaz

    UserID login validation

    Is it possible to automatically populate a form field or hidden variable with a users NT/XP login name? TIA, Mike
  5. mbthaz

    Strange characters ÂÂ

    Getting some strange characters deposited into the database from a form. Any help on this?
  6. mbthaz

    Grouping Reports

    Anyone have a reference that explains how to group items in a report, in otherwords, I need to emulate grouping in access reports using results from the DIW Thanks, Mike
  7. mbthaz

    Strange characters result from database update

    I have a form that updates via an update query an access database on frontpage 2000. Sometimes I get strange characters in the results. when I look up an updated record sometimes on of the fields will be preceded by the character  Anyone know how to prevent this, or what causes it?
  8. mbthaz

    Userid from NT/XP login environment

    Is it possible to automatically populate a form field or hidden variable with a users NT/XP login name? TIA, Mike
  9. mbthaz

    Dynamic selection of form email recipient

    I have a form in which I want to select a form email recipient based on a combo box result in the form itself. Everytime I try to use some type of variable in the webbot statement however it fails. Can anyone help me get around this? Thanks In Advance
  10. mbthaz

    Obtaining NT User Login Name

    Is there any way to obtain the user id that logged into NT either from an environment variable or some other place? I tried the currentuser() routine, but only returns admin. TIA--Mike
  11. mbthaz

    Browsing File Names for data Import

    I am using a function to import data from a daily excel spreadsheet into a database. Function ImprtData() DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, &quot;Usage&quot;, &quot;H:\Data Collection\c+ usage&quot;, True End Function What I need to be able to do is select a file...
  12. mbthaz

    Retrieve data from previous/specific row in query

    How does one access the value in a previous row. ie. get the percentage difference between the values in the same column but in consecutive rows.
  13. mbthaz

    Accessing different records in a query result

    I have a query that pulls data that results in weekkly grouped results. It pulls data results and averages them to a weekly average. The problem I have is that I must also show percentage difference between the weeks...ie. if week 1 is 20% and week 2 is 45% then there is a percentage increase...
  14. mbthaz

    Date/Week Formatting in Query

    I have a query that pulls daily numbers and averages them by week. That query is listed below. What I would like to do is have the date display the day the week started instead of the week number. Any help with this is greatly appreciated. SELECT (Format([Date],&quot;ww&quot;&quot...
  15. mbthaz

    Conditional Data in Report Charts

    I have a query that pulls specific data based on the manager selected in a combo box. I am trying to creat two reports from this data, one that shows the data in number format(this one works as expected), and one which shows the data charted. When I try to run the chart it give a Jet Database...
  16. mbthaz

    Conditional Data In Charts

    I have a query that pulls specific data based on the manager selected in a combo box. I am trying to creat two reports from this data, one that shows the data in number format(this one works as expected), and one which shows the data charted. When I try to run the chart it give a Jet Database...
  17. mbthaz

    Form Subform Refresh

    I have a form CUID_Lookup and a subform Employee/Manager. I have the child parent relationships set to the common field in each &quot;CUID&quot; How do I get the subform to a) start empty until something is chosen from the CUID combo box in the main form, and b) update when a selection is...
  18. mbthaz

    event code to maximize form

    How would one write code to maximize a from when it is open. We have people using different sizes and resolutions of monitors and are having issues with the forms appearing off of the screen. If I could just force it maximized... Thanks in advance, MIke
  19. mbthaz

    Accessing Form Values Programmatically

    I have a query with criteria that can come from either a form control that is set with data, or from a variable that is culled from the environment by another function. Psuedo code goes like this: If Form.reports.combo1 <> Null Then Criteria = Form.reports.combo1 Else Criteria = Lookname()...
  20. mbthaz

    Displaying Query Progress Bar

    I have a form where I have a command button that initiates 5 different update queries. What I would like to do since I hide the status bar in this database is display a progress bar on the form or in a popup box that shows the status of the query and a name that makes sense for the query...

Part and Inventory Search

Back
Top