Search results

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...

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...

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...

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...

Thanks guys! The .ItemData function did the trick.

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...

Thanks for the replies! Deleting the second where did the trick!

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...

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

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

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...

You done enjoying your self sir? :D Thanks though

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?

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

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

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?

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

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! :)

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 :)

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