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 TouchToneTommy 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: emumaster
  • Content: Threads
  • Order by date
  1. emumaster

    Firebox X10e and SBS 2003 setup

    Can anybody give me advice on setting up my SBS 2003 R2 install with a firebox x10e (actually i have one for each site)? I have atlantic broadband with a static ip. Since the eventual goal is to connect our two offices, this will need to be considered, BUT my first concern is whether to use...
  2. emumaster

    Problem with On Change event

    I have code that has been working fine in access 2002, but in access 2003 it just freaks out by staying in an endless loop. the code is in the On Change event for a textbox. Here's the code: Private Sub txtCityName_Change() Dim db as dao.database Dim rs as dao.recorset dim strsql as string Dim...
  3. emumaster

    New XP Can't Connect to Exchange 5.5

    I have searched thru other threads here, but still am at a loss to solve my problem. So here goes: I have Windows NT 4.0 with SP6 Exchange Server 5.5 SP3 All Ip address's are specified (no automatic dns) I have a mix of windows 98 and xp machines on the network which function. The problem is...
  4. emumaster

    Invoice Printing Questions! Help!!

    My problem is printing an invoice for a single customer that will span multiple pages , because of many lines of detail. I understand(at least I believe I do?!) that i can count the number of detail lines and cause a page break so that the detail area doesn't wack out the info I need at the...
  5. emumaster

    Custom page size for printing checks still need help

    I have to print a custom check 8.5 x 8.5 on a dot matrix printer. The printer dialog doesn't show custom size, just the normal letter, a4, etc. So how do I do it??
  6. emumaster

    Custom Page Size for Printing Checks Help!

    Does anyone know of a way to print a custom size check. My client has checks that are 8.5 inches wide by 8.5 inches long on tractor feed paper for dot matrix printers. I have to use the dot matrix, so for ink or laser. Help???
  7. emumaster

    How do I delete a field using Code??

    How do I delete a field using VBA??
  8. emumaster

    What is the code to see if a field exists?

    What is the VBA Code to check and see if a field exists in a table??
  9. emumaster

    What is the Code to see if a field exists??

    What is the VBA Code to see if a field exists in a table??
  10. emumaster

    Renaming fields with Alter Table Problem!!??

    I have searched and tried everything in the forums and can't seem to get this code to work. ALTER TABLE mytablename RENAME COLUMN oldfieldname TO newfieldname It kicks an error when I try to run this query, stopping at the RENAME every time. I am using Access 2002, no sql server. Any...
  11. emumaster

    How Do I Use VBA to import DBF files??

    I know I can import DBF's by hand, but I have a reason for wanting to use VBA to code this. Any suggestions on how to code this?
  12. emumaster

    Opening more than 1 form problem!

    I have a form open and after a user presses a button, I have the code: DoCmd.Openform "TicketEntry" exit sub My problem is that even though the form is on top of my first form, I can't seem to get any code (like form_open code) to work. I specifically have a Me!firstticket.setfocus...
  13. emumaster

    How do you get rid of rectangle lines around subreports?

    I have a main form with no table associated and two subreports in the detail section. When viewed on screen there is a a rectangle around the info on both subreports. Can this be turned off some how , so it doesn't show?
  14. emumaster

    How do I print data from 4 tables in detail section??

    I have 4 tables with different kinds of information in each. When all the records from one table are done I want the records from the next to start printing, and so on thru all 4 tables. Can this be done??
  15. emumaster

    Limiting Number of Lines on report?

    I designed a screen report to show a customers name and address on 1 line. Can I limit the number of detail lines on a page to say 15? I would then like to push a button on the screen report to get the next 15 and so on. Also my report shows up on the screen so that I have to drag the corner...
  16. emumaster

    Report Questions!! Help!!

    I don't know if there's a way to do this but here's my question. I designed a report that shows a customers name, address, phone#, etc. When it appears on the screen(I am only interested in the screen not printing it yet), I have to adjust the size by hand. I would like to have it full size and...
  17. emumaster

    Problem after using the .Update command

    I have a basic entry form that after pressing F9 to save performs the following code (just a portion): With rst1 .AddNew .Fields(0) = x 'Permno .Fields(1) = Me!LAST 'Last Name .Fields(2) = Me!FIRST 'First Name .Fields(3) = Me!ADD1 'Street Address 1 .Fields(4) =...

Part and Inventory Search

Back
Top