Recent content by [nateobot]

  1. N

    Table sizes?

    Does anyone know how I can find out the breakdown of how much diskspace my tables/queries/forms are taking up? Thanks -Nathan
  2. N

    Access & Excel

    http://www.mvps.org/access/modules/mdl0006.htm http://www.mvps.org/access/modules/mdl0007.htm
  3. N

    Weekday function problems Access

    I guess I don't know what your question is. If you are trying to find the day of the week from a date you can use this in code: [code] Format(YourDateHere, "ddd") [code] ddd gives you the first three letters of the day. dddd gives you the whole name of the day.
  4. N

    Export to Excel without opening File

    Not that i know of. You could always set it to false so that the user does not see Excel being opened. DoCmd.OutputTo acReport, "rptTest", "Microsoft Excel (*.xls), RptPath, False
  5. N

    Completely stumped... (kinda long)

    OK I have a big table. It has a few fields but that is not the problem. This big table links with another table on two fields (2 fields on the big table (TableA) can link with one field on TableB. I know not smart (I did not design and am not allowed to change this fact). So TableA can...
  6. N

    Removing duplicate records...

    I just had to do something similar to this. I created a new table that had the same field names, field structure etc... I added the primary key on the fields that had to be unique. Then I ran an append query from the old table to the new one. Worked like a charm. Don't know if this is what...
  7. N

    Force input into form's fields

    You could set the variable when the condition is true. Set it to false if the condition is false. As you can see on the code below it is for the Unload event "Private Sub Form_Unload". example: If IsNull(Me![Reason for Modification]) Then iLetFormClose = 0 Me![Reason for...
  8. N

    Worse case scenario

    Do a search on this forum for password. I think on page 2 or 3 there is a thread with some solutions.
  9. N

    SQL in BUttons

    2 things i jumped out at me. 1. There is no space between * and From 2. You are selecting from table Product yet your criteria says tabel Products Edit: third problem 3. strWhere = " WHERE (((Products.TagNumber) Like Me!TagSearch)) AND ((Products.CategoryID)=Me!CategorySearch));" should...
  10. N

    Force input into form's fields

    I have something similar to that I needed to do. I have a change password form and if they have to change password (various reasons) then this form pops up. I have a global variable that is set to 1 in this instance. If this variable is 1 and the form is attempted to be closed then it prompts...
  11. N

    Creating multiline textbox in code

    try using vbCrLf
  12. N

    OCX Files

    http://support.microsoft.com/default.aspx?scid=KB;EN-US;q209898& ^^Try that one out. I did a search on google for: treeview MS Access Got quite a few hits. most all were 97 however. Sorry I don't know much of anything about the treeview control.
  13. N

    Appointment Scheduler

    One of your fields could be how many 15 chunks of time the appt takes?
  14. N

    database shorthand

    In the code window go to Tools | References then find it in the list.
  15. N

    Importing and retaining zero value

    In Excel fi you change the property of the cells to custom and type in "00000000" then it will add 0's to the beginning of the numbers that are less than 8 digits.
See more
Back
Top Bottom