Search results

  1. darksniper

    Shameless Behaviour ???

    When I look under my name, I get a red rectangle that indicates "Shameless Behaviour" what does that mean and how can I remove it?
  2. darksniper

    Changin the value in the cell as the whole and not as the word in the cell?

    I have a script that changes country codes into numbers. The issue that I am having at the moment is when I have a cell that contains other words other than the country it changes it too. Also I cannot specify the name of the colum since every excell spreadsheet is different. Example: cell 1...
  3. darksniper

    field list from more than one table?

    ok, then I have a question. I have a form currently to register students. Which puts the data directly into the table. But due to sertain circumferences I need to have an option to choose if the student is a guest or not. I do not want to add an extra field to that table to I have created...
  4. darksniper

    accessing data from subform & continueous form question.

    nice, great link, I love it. Thx.
  5. darksniper

    calendar button?

    ok, what happends is for one language the date standard is month-day-year, for the other is the day-month-year. and even that I directly mention the date format I am still having people that mix them up and when ever there is an issue I am getting bugged. It just got to the point that I need to...
  6. darksniper

    disable an mde file to save any changes to db?

    hmm, I could try that. For now I just have to make the project working. Most likely when I will get to that and get stuck I will see what can be done then. Thx.
  7. darksniper

    disable an mde file to save any changes to db?

    mde file prevent any changes to forms,queries, reports or vb code. (in terms of design) . so I would like to erase all of the data in tables upon the closure of mde file.
  8. darksniper

    disable an mde file to save any changes to db?

    when I create an mde file, is there a way to disable it to save any changes to db. For example when users opened an mde file, he can do what ever he needs to do, but when he closes the mde all of the changes done to the database are reverted back to zero.
  9. darksniper

    field list from more than one table?

    I would like to work on the form with more than one table without having to use a subform. I remember there was an option to have field list of more than one table. Because I need to add a field to a form that has 'one to many' relationship between two tables so that I dont want to modify...
  10. darksniper

    accessing data from subform & continueous form question.

    I have a form that has a sub-form, -if I use "Forms![formUsers]![id]" to get the hold of the id value of the form. then for the sub form "Forms![formUsersSubForm]![id]" would that work? -I would like to make a continues form for product list, to make it easier to go though products. If I add a...
  11. darksniper

    calendar button?

    Looks nice, allthough, it is hard for me to avoid not using it, when I used just a date field, I had french people enter the date one way and english enter it another way, and in the end it was all the mess. And when it came to do reports I had check to make sure the dates were in correct...
  12. darksniper

    calendar button?

    I would like to add a button, that on click it would open a mini calendar with current date, where if I need to change the date I could and then I could click ok and it would set the date in the proper field.
  13. darksniper

    creating a report from current form and subform???

    thx, it worked, You're The Best!!!!
  14. darksniper

    creating a report from current form and subform???

    how do I do that?
  15. darksniper

    creating a report from current form and subform???

    that should not matter if I am doing a queurry and only passing the id of the form
  16. darksniper

    creating a report from current form and subform???

    edit: I found out that I cannot have a form and a report accessing the table at the same time, what can I do about it if I want to preview current selected record? I have been having trouble to create a form with a subform, which after you click a button and it would load up the data of that...
  17. darksniper

    database engine could not lock table?

    Private Sub Command15_Click() On Error GoTo Err_Command15_Click Dim stDocName As String stDocName = "rptlUserInfo" DoCmd.OpenReport stDocName, acPreview Exit_Command15_Click: Exit Sub Err_Command15_Click: MsgBox Err.Description Resume Exit_Command15_Click End Sub...
  18. darksniper

    database engine could not lock table?

    I have created a form, and added a button that would display the current record. When I click on the button I get "database engine could not lock table..." When I launch the report by it self, it open, but doesnt want to open through form button.
  19. darksniper

    make a report from data in the form.

    ok , i'll try that. thx
  20. darksniper

    edit .mdb with microsoft visual studio?

    oh well, microsoft screwd us over!
Back
Top Bottom