Search results

  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?
  16. CIIIHAN

    Excel like checkbox filter

    I've changed the colours of a cell in the datasheet view. (It changes colour depending if a certain checkbox is checked.) But when I try to print the sheet the cells are not coloured. How come?
  17. CIIIHAN

    Excel like checkbox filter

    Awesome! Too bad this is not possible with form view. No eyecandy but it will get the job done thanks spikepl!
  18. CIIIHAN

    Excel like checkbox filter

    Good afternoon all! Is it possible to have an Excel like filter in Access? If so, Can someone help me get in the right direction to start with it? Thanks in advanced! Have a great week all! :)
  19. CIIIHAN

    Hi! :)

    Well,you want the strange side of the story?? Im a huge fan of football.. but I don't support neither Holland nor Turkey.. But I didn't want Holland to win since they didnot deserve it. Any way when it comes to national teams football I support Germany :)
  20. CIIIHAN

    Hi! :)

    Thanks bro! This is your first post? :D So welcome to you to :)
Back
Top Bottom