Recent content by CIIIHAN

  1. CIIIHAN

    Search a value in multiple tables

    Thanks jdraw. The previous issue has been solved, this is a new problem. I'll look into the link you send. I understand your worries about my tables. Yet I can't come up with another solution. I just cannot wrap my head arround it. Would you mind helping me out on this topic? How would you do...
  2. CIIIHAN

    Search a value in multiple tables

    Thanks for your reply. I guess I'm not that good with Access. I know how to normalize and stuff yet after alot of pondering on how to solve this problem this was the solution I thought would be right. I know I would be asking alot but, would you like to help me optimize what I'm working on? If...
  3. CIIIHAN

    Search a value in multiple tables

    Its for the sake of different departments here. Splitting up orders is just for the planning departmant while is will only clutter the data for accounting. Say we get an order of 10000kg of icing. It is impossible to finish this in one day So the order needs to be split up in to say 5 bits of...
  4. CIIIHAN

    Search a value in multiple tables

    Hi! I have 2 tables with identical fields. the first one, Orders, contains.. well orders. these orders can be split up, if the batch is to big to produce it in one day. when split 2 records are added to the second table, Splitorders. all orders across the 2 tables have unique IDs called...
  5. CIIIHAN

    Get the next or previous row in listbox

    Thanks guys! The .ItemData function did the trick.
  6. CIIIHAN

    Get the next or previous row in listbox

    Good afternoon all! I have a DB with about 3000 records I've made a form (Form1) where these records are seperated in 17 lists. There are 4 dates and 4 rooms. so 16 lists and 1 list for unassigned records. Verticaly I've got the dates 1st boxes beeing the chosen date and the other 3 beeing the...
  7. CIIIHAN

    SQL Where and Between

    Thanks for the replies! Deleting the second where did the trick!
  8. CIIIHAN

    SQL Where and Between

    Hi there! I'm trying to make an SQL statment which contain both the where and between like this: DoCmd.RunSQL "UPDATE MuhurDB SET location = " & Me.Location & " WHERE Grup =" & Chr(39) & grup & Chr(39) & " AND WHERE muhur BETWEEN " & fromTxt & " AND " & tillTxtI get the error message about...
  9. CIIIHAN

    i need help please

    Something like this? Private Sub NameCmbBox_BeforeUpdate(Cancel As Integer) MsgBox "Are you sure to change current record?", vbYesNo End Sub
  10. CIIIHAN

    Error on other PC's

    Solved it! I did "save as' on all forms and it did the trick! :)
  11. CIIIHAN

    Error on other PC's

    Good morning I've created a database on my laptop it works flawlessly. When I try to run it on another system I get this error. "The expression On Click you entered as the event property setting produced the following error: A problem occurred while Microsoft Office Access was communicating...
  12. CIIIHAN

    Tab control in form

    You done enjoying your self sir? :D Thanks though
  13. CIIIHAN

    Tab control in form

    And vbaInet kills two birds with one stone.. :) Thanks Debug.Print outputs to the immediate window which can be opened through the editor window select view->immediate window Msgbox creates a pop-up right?
  14. CIIIHAN

    Tab control in form

    You should try to use MsgBox to debug your code Then you'll see more quickly where it goes wrong. good luck!
  15. CIIIHAN

    Tab control in form

    Have you tried to use a MsgBox "test" command to see if the click event is handled right?
Back
Top Bottom