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 gkittelson 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: *

  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

    OK, Actually everything in this code works ok, the problem i am having is trying to get an access form to attach. i have tried several things to reference the form, and every time i do i get an error message that says object required or it is an activeX action and i can't do it. so i guess...
  3. 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...
  4. 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"...
  5. bw2601

    report with query

    I got it, in the form i just altered where it asked for the ID number and made the ID number of the form Equil the ID nubmer of the Report. Thanks for all of your help
  6. bw2601

    report with query

    OK, I kind of see where you are going with this. How do you Get the report to Link with the ID field of the form? For whatever reason i thought reports were only based off of tables or queries.
  7. 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...
  8. bw2601

    Date Problem

    you guys are the best, i ended up using a combo of both. and it does exactly what i wanted it to do. thank you for the pointers, you saved me a lot of time and frustration.
  9. 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...
  10. bw2601

    dlookup help last value

    Thank you so much, worked like a charm!!! you rock!!!
  11. 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...
  12. 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
  13. bw2601

    Simple 'Onclick' request

    I am having a problem hiding some buttons when i click on them, and i have no idea how to work around it. can some one please help me. this is the code i am using: Private Sub Save_Click() On Error GoTo Err_Save_Click DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, ...
  14. bw2601

    runtime error 2166

    Dude, you rock on so many levels right now. i don't know how i am going to be able to thank you enough. you are awsome everything works great.
  15. bw2601

    runtime error 2166

    ok, I have a question for you then. Because it is not possible to lock the field after something is entered, is it possible to lock the whole form after it is saved, so when a user goes back into it after it has been saved, they would not be able to make changes to it? and if this is...
  16. bw2601

    runtime error 2166

    i am going to try to be specific: i have a form that when a user enters information and hits tab or click to another field, i want the field they were on to lock after they enter the information. this way if they try to go back and change something on this form, they can't. i hope this helps...
  17. bw2601

    runtime error 2166

    Sry that did not work. I still get the same error, and depending on where i place the code i also get this error: runtime 3101, Microsoft jet database engine cannot find matching field(s) "fieldname" any suggestions?? please?
  18. 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...
  19. bw2601

    having trouble writing query

    The ID is a number, and i would like the result to come in the form of a message pop up with an ok button. I am in the Process of learning VBA. so please be gentile.
  20. bw2601

    having trouble writing query

    here let me be a little more spcific. i would like to be able to enter data into a box such as a user name (text) then would like to have it return the ID. Now if i enter an ID instead of user name I would like it to return the User name. the user name and the ID are taken out of the same...

Part and Inventory Search

Back
Top