Search results

  1. wizcow

    Limit Page Advance

    Hi I have set up a database for printing invoices. I want to use a dot matrix printer with tractor feed. The invoices are carbon copys. 5 x 7.5 I have set up a report wich prints the information properly, but.... after the print job is done, the printer shoots out what it thinks is a 8.5x11...
  2. wizcow

    Carriage addvance

    Hi I have a tractor feed printer. I have some invoices that are about 5 inches long. When I print an invoice, the carriage addvances as though it had a 8.5 x 11 paper in it. I want the carriage to stop at 5 inches, not 11. Where would this setting be? Thanks Tom
  3. wizcow

    Load 3rd part app from C: with vb6

    Hi I have vb6. I am trying to build an Installer Console. You know, the ones you get with, say a new printer. You insert the cd and the Installer Console pops up and asks if you want to install all kinds of other stuff that you don't want. I want my Installer Console to work like this.... 1...
  4. wizcow

    Using Flash

    I am trying to build a switchboard in flash. I would like to have buttons on the page that can open another program. example: The flash page opens. The user clicks a button, then flash closes and an Access Database opens. I can build the buttons but I don't know how to get the button to open a...
  5. wizcow

    Installing Help in your database

    Hi I have a little help program that I made with ccviz/Helpmaker. (its quite a nice program) Now I would like my users to be able to open it from a menu inside my Access database. Where do I start? Thanks Tom
  6. wizcow

    Label Flicker

    Hi I have the access window minimize in the start up. The form has several labels on the form. When I move the mouse over the form, the labels flicker, even when they are set to visible = false If I maximize the access window, this stops. I also tried changing the labels to texboxes with the...
  7. wizcow

    Between [startdate] And [enddate]

    Hi In the criteria line I have entered... Between [forms]![frmSwitch]![StartDate] And [forms]![frmSwitch]![EndDate] This works except; If startdate is 9/7/04 and enddate is 9/9/04 I only get results from 9/7/04 to 9/8/04 No results for 9/9/04 Why is this? Tom
  8. wizcow

    Invoice hour checking by date

    Hi As I enter tickets into my invoice, I enter the ticket date and the straight time hours. I would like to have access check to make sure I do not enter more than 8 hours on any one day. I think it should be something like this.... If straighttimehours < 8 (for this date) then msgbox "You...
  9. wizcow

    Option Group Reference

    Hello I have an option gruop on my employee form. I select what type of employee from the option group. eg: Practitioner or Therapist The Practitioners need an Association number, Therapists do not. I want my form to display the Association text box only when 'Practitioner' is elected in the...
  10. wizcow

    Syntax Help Please

    I have made a query that does what I want. I have coppied it from the SQL window. SELECT *, [CustomerLast] & ", " & [Title] & " " & [CustomerFirst] AS SoldToCustomer FROM Customers; When I insert it into my code it doesn't work. I think I am haveing some trouble with the " and the , Dim...
  11. wizcow

    Another SetWarnings Question

    I can't get rid of the "No Current Record" message. My form runs this code in the 'On Current' event to get the last stock take date. If there has not been a stocktake done for this record I get the above error message box. Dim db As DAO.Database 'Type of reference Tools>>References...
  12. wizcow

    VB result into a Query

    I have a bit of code that calculates the InStockQuantity of a part. This works okay in my parts form. On my Invoice form I have a PartNo combo box that is fired by a query that looks up the part information. The pull down list has several columns, PartNo, StoreNo and Description. I would like...
  13. wizcow

    Replace A Deleted AutoNumber

    My invoice form is based on my invoice table. The invoiceID is an auto number, wich is related to the invoiceSub. I have deleted an invoice (9066). I still have 9065 and 9067. Is it possible to replace a deleted autonumber? I would like to put 9066 back in.
  14. wizcow

    SQL results in VB

    I am trying to get the results of this sql statement into a msgbox. I just get the statement repeated in the msgbox. What I want is the result of the sql statement. Private Sub cmdCalc_Click() Dim strSQL As String strSQL = "SELECT TOP 1 Inventory.StockTakeDate" & _...
  15. wizcow

    Db Unstable

    I am running ms Office 2000 on Windows 2000. I have quite a number of different dbs that I have been working on, all on my C: drive. As of late I have been getting odd problems. If I import a form from one db to another, I get errors. Code that works in one db, will not in another. Parts of...
  16. wizcow

    Check Please (my code I mean)

    This is a peice of code I adapted from Jack Austin. My form has an unbound textbox where I enter search criteria. (txtSearch) The search is performed on a memo textbox called (Notes) The problem I have is that it will only search with in the record that is open. Jack Austin's Access97 demo...
  17. wizcow

    Search a Memo

    I have a large memo box that I would like to search. The memobox will have data similar to this... I want to be able to hit the return key and enter another line in the memobox. When I do a search on this field, the top value can be found, but not the values after the 'enter'. eg: Above I...
  18. wizcow

    Count files

    I would like to have a message box pop up after 15 entrys have been made in the subform on my Invoice form. How do I count the entrys on a subform? Thanks Tom
  19. wizcow

    Images On Continuous Forms

    Images On Continuous Forms Is it possible to have linked images on continuous forms? And have each file have its own image? Tom
  20. wizcow

    Update query

    I am trying to repair a db. The Invoice table has the Customer's name stored, but not the CustomerID. I would like to repair the tblInvoice table data. I'd like to have a query that looks up the customer name, then enters the proper customerID in the customerID field. The customerID will have...
Top Bottom