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 Mike Lewis 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: laman
  • Order by date
  1. laman

    linksys 10/100 network card

    I need help. I cannot get my linksys nc100 v.2 card to work. Im running dragonlinux with what appears to be the latest tulip driver v.095 which fails with device busy on boot. PNP is disabled. ifconfig shows lo but no etho. The adapter shows irq 10 with I/O oxd800 [oxd801]. It does not appesr to...
  2. laman

    is this expert? opening a db from another, part 2

    Forgot to tell you to make sure you have the "Microsoft shell commands and automation" reference checked.
  3. laman

    is this expert? opening a db from another, part 2

    Copy this function to a new module. Function GetOpenFile(Optional varDirectory As Variant, _ Optional varTitleForDialog As Variant) As Variant ' Here's an example that gets an Access database name. Dim strFilter As String Dim lngFlags As Long Dim varfilename As Variant ' Specify that the...
  4. laman

    printing the last page of a report first?

    The print options dialog box which opens is specific to your printer. If you did not see this option, your printer can not print in reverse order.
  5. laman

    printing the last page of a report first?

    Instead of using the print icon on the toolbar, go to file/print which will bring up your printer options dialog box.
  6. laman

    ENTER PARAMETER NOT WORKING

    There are no differences! As I have already explained, this works in all of my reports except one and don't know why. It,s obviously not the code but something else.
  7. laman

    ENTER PARAMETER NOT WORKING

    I have used the following as a control source for a textbox in reports so the user is prompted to enter the Table No. which works for all my reports except for one. ="TABLE" & " " & [ENTER TABLE #] I get "jet database engine does not recognize [enter table #] as a...
  8. laman

    TOTALS WORK IN FOOTER NOT HEADER

    I have a crosstab report set up with dynamic column headings. The code puts totals for each column in the footer section and works fine. I am trying to put the totals in the header but I get blank textboxes when report opens. If I then go into design view and back to layout they fill in...
  9. laman

    FORCE ROW HEADINGS IN CROSSTAB QUERY

    Is there a way to force row headings (not column headings) in a crosstab query. I would like the same row headings to show each time even though some of them dont appear in the table. There are ten possible headings for the field in question. THANKS FOR ANY HELP!
  10. laman

    NULLS to ZEROS in CROSSTAB QUERY

    Yored The Man! Worked great, Thanks. I never would have tried that but I did try everything else.
  11. laman

    NULLS to ZEROS in CROSSTAB QUERY

    I get a syntax error on left paren after nz.
  12. laman

    NULLS to ZEROS in CROSSTAB QUERY

    Need some help with the followig query. I need to return 0 when nulls occur. Ive tried NZ and IIF and can't seem to get it to work. TRANSFORM count([master].[ID]) AS CountOfID SELECT [master].[SECTION], count([master].[ID]) AS [Total Of ID] FROM master GROUP BY [master].[SECTION] PIVOT...
  13. laman

    ITEM IN TEXT BOX NOT TO BE HIGHLIGHTED

    Need some help. I have a textbox on a form which displays items from a table for information only. The first item is always highlighted. Is there a way to not have any of the items highlighted. Thanks.
  14. laman

    Get Path to TransferText from Textbox

    What's wrong with the following: DoCmd.TransferText acExportDelim, "sdf", "acc", "Forms![sdffiles]![txbfolder]acc1.sdf", False, "" I'm tring to get the destination path from a textbox on a form. The file transfers but always to A:\drive no matter what I...
  15. laman

    FILL TEXTBOX WITH SQL RESULT

    I GET #ERROR in the textbox.
  16. laman

    FILL TEXTBOX WITH SQL RESULT

    How would I use the following statement to fill a textbox on a form with the result. The form is &quot;switchboard&quot; and the textbox is &quot;text1&quot; SQL = &quot;SELECT Sum(IIf(([cl]<>'y'),1,0)) FROM master;&quot; Thanks
  17. laman

    Insert Filename on Form

    I would like to have the current database filename show up in a textbox on a form. Any ideas? Thanks.
  18. laman

    RunCommand acCmdOpenDatabase

    Could you be more specific, I'm new to VB. I'm also wondering why the runcommand doesn't work. I want the user to be able to select which database to open and close the current db. Thanks
  19. laman

    RunCommand acCmdOpenDatabase

    I'm trying to use RunCommand acCmdOpenDatabase from a button on a form. When I click on it I get the message, The command or acion &quot;opendatabase&quot; is not available now. Any ideas, Thanks!
  20. laman

    Copy, Close and Open New Database

    One more question. What you gave me worked fine but when I added it to the code I already had to copy the master an error message comes up &quot;can not find file&quot;. When look in explorer the file is there. I'm new at VB. Dim oFiles As FileSystemObject Dim strSource As String...

Part and Inventory Search

Back
Top