Search results

  1. O

    access 2000 with outlook 2003 ?

    I don't see why it wouldn't work. Just take this: [Forms]![claimsreporter]![text8] And put the value of the control in a variable. Here's an example of where I use Bmail: strEmail = Me!frmSubTicketQueueEmpInfo!txtEmail.Value strTicket = txtTicketNumber.Value...
  2. O

    Is there an easy way to Hide/Unhide Control Buttons on a Tab Page of a Form

    Take a look here: http://www.mvps.org/access/forms/frm0031.htm Probably Me.Parent!ControlName would work.
  3. O

    access 2000 with outlook 2003 ?

    I'm not sure why it wouldn't work, but I have never tried this. If for some reason you cannot get it to work, you can use a command-line email tool: http://www.beyondlogic.org/solutions/cmdlinemail/cmdlinemail.htm You can create attachments and such with this one as well. Works well - I use...
  4. O

    Security questions - need to start adding users

    I use a user access table with usernames and rights levels, then enable/disable menus and thing depending on that. For those users I would have a form open as read only. You'll have to implement security for everyone though unless you only limited users if they were in a table, otherwise they...
  5. O

    Dataset

    Another way to do it is in the form properties, under the Data tab, you can set the Recordset Type to "Snapshot" - you can't change it then. It won't update if data changes unless you refresh the form (re open it, requery it, etc.) but you won't be able to do any edits.
  6. O

    Find & Replace (but Replace in a different Column)

    You can do it with an update query. The SQL would look something like this: UPDATE tblInfo SET tblInfo.IAW = "Y", tblInfo.Comments = "Y~" WHERE (((tblInfo.IAW)="GF"));
  7. O

    Formatting dates problem

    ha! I missed that.
  8. O

    Formatting dates problem

    Try this: Format([Date],'yyyymm') Or something like this would work...if not be awfully redundant: dteYYYYMM = (DatePart('yyyy',[Date]) & Format(DatePart('m',[Date]),"00")) This is assuming your field is named "Date".
  9. O

    Making zeros show

    That should work. I just tried it to make sure I wasn't crazy and I put in 0000025 and it stored it just like that. Your data type is a number right? Are you viewing the table directly, or are you viewing the data through a form/query? If on a form, the control may have a different format...
  10. O

    Making zeros show

    It shouldn't. You aren't enclosing the input mask in quotes are you?
  11. O

    Creating a Ten Pin Bowling League Table (NOOB)

    I may end up making one myself...I think I will as I want to put in my own scores and do some year to year trending and such. So if I end up with something I can post a sample so you can get an idea since that would end up with me fleshing out this idea as there are likely some errors in...
  12. O

    linking data between reports

    I would just use a sub report. You will get an error if the report is not open before you open your second report - you can't reference the object if it's parent is closed. So you either have to have both reports open at the same time, or you will need to just use that first report as a sub...
  13. O

    7 Tables in 1 form

    The little square box in the upper left hand corner of the form. Right click, properties. There's bunches of options in there.
  14. O

    How do I get the combo box value?

    Yup - get into that habbit. Text boxes are txtInfo, txtID, etc. I always preface my objects with identifiers. qry, tbl, frm, rpt, subfrm, subrpt, etc. txt, cbo, lbl, memo, lst, cmd, tgl, etc. This way most people looking at code or things - if they don't know exactly what I'm referring to...
  15. O

    Opinions? -- Automatic Database Login

    I don't bother with workgroup secured DB's. I just use a table with usernames and access levels. When someone opens the database, it compares their windows username against the usernames in that table. If not there, it won't let you open the database. If it is there, it continues to check...
  16. O

    VBA Error

    It would help to know what line it errors on. I don't know much about VBA in PPT but I'm sure it may help someone else who has worked with PPT more.
  17. O

    Update 1.74 million records

    Joining the tables using names could cause these issues. I'd have to have a look at the data. Is there any other unique identifier that is the same? I would guess that the names are not unique enough.
  18. O

    Update 1.74 million records

    There's probably a problem with your joins. We'd need more info, can you post the SQL for your query? If you right click on the title bar of your query you can select SQL view and copy/paste the text here.
  19. O

    How do I get the combo box value?

    well if your combo box is named cboName then: cboName.Value should work
  20. O

    How automate the logging into computer

    You may need a command-line email program: http://www.beyondlogic.org/solutions/cmdlinemail/cmdlinemail.htm You can run that with a shell command and it *should* work if your computer is locked/not logged in, but I'm not positive. I don't think using Outlook will work, and I really doubt you...
View older results
Back
Top Bottom