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 Wanet Telecoms Ltd 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: bw2601
  • Content: Threads
  • Order by date
  1. bw2601

    Creating a profile in different location

    I would like to find out how to have Windows CREATE a user profile in a different location. At my company we work with a software called deepfreeze which locks down the hard drive to any changes. We have a partition of the hard drive which is not locked down which is where we store our user...
  2. bw2601

    Send Form as Attachment

    does anyone know how to send a form as an attachment using this code? Option Compare Database Sub sbSendMessage(Optional AttachmentPath) Dim objOutlook As Outlook.Application Dim objOutLookMsg As Outlook.MailItem Dim objOutLookRecip As Outlook.Recipient 'Dim...
  3. bw2601

    Send report as body

    Does anyone know how to send a report in the body of an email. this is the code i am using currently, but it will only send the report as an attachment. Private Sub Mail_CallDescription_Click() On Error GoTo Err_Mail_CallDescription_Click If Me.Emailed = True Then DoCmd.GoToControl "Call ID"...
  4. bw2601

    report with query

    I have been racking my brain for the past two days and i can't figure out how to do this. I have a report that is tied to a query, so when you open the report it asks you for an ID number so that it will open a particular "Call record". Now I also have a form with the same data in it, that is...
  5. bw2601

    Date Problem

    I have a form in which i need to enter information the day after it happens for the day before. so Tuesday i would enter on Monday's date. I did this by entering Date()-1 in the Default value under properties. now the problem i am having is Monday. I need Monday to go the the previous...
  6. bw2601

    dlookup help last value

    I am trying to look up the last date entred into a table. the date is the primary key. i want to compare the last date entered with the current date, and then display a message box if they match. i have the message box done, that was the easy part, but now i seem to be having a lot of...
  7. bw2601

    Set up users and groups

    hi i am very new to MACs and need to know how to set up users and groups on a MAC running OSX panther. It is being used as a fax server running faxstf server. any help would be greatly appreciated. thanks totally clueless
  8. bw2601

    runtime error 2166

    hi I am trying to lock a field in my table so after a user enters data it will lock. This is my code: private sub fieldname_change() if not isnull(me.fieldname) then me.fieldname.locked = true else me.fieldname.locked = false end iff end sub when i try to test it i get a runtime error...
  9. bw2601

    having trouble writing query

    i would like to write a query that will return a value when a user inputs criteria. for example if a user name is entered i would like it to return an ID #. I am having troubles doing this using the iif function. does anyone have any ideas on how i can get started. this is what i have...
  10. bw2601

    message box

    Hi, i am kind of new to VBA and I am wonering how the get query results to display in a message box. can any one help me i am having trouble getting started even. thanks
  11. bw2601

    getting a message box to display query results

    I have a IT Helpdesk database, and I have a query right now that i can type in a name (either first or last) or a system ID # and get a return. i would like to be able to put in the system ID and get the name of the user and vice versa. i would also like the return to come out in a message...
  12. bw2601

    word template macro

    I am trying to Create a Macro For a template that will auto update every time you open the document, the problem i am having so far is that i would like to have the dates in this macro be placed at the top of every page, and whn you run the try this macro, it puts all of the dates at the top of...
  13. bw2601

    OpenPrintCloseExcel in access

    I am trying to write a module that will open excel, print the file and close the program by just pressing a button on switchboard manager, however i am having a really hard time getting started. can someone please give me some ideas and pointers thanks

Part and Inventory Search

Back
Top