Search results

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

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

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

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

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

Here it goes, my first thread :) I have just started to use access in a more advanced way if I may say so myself. Using VBA and macro's. First of all the company I work for has a non-english license of Office so I try to translate things in hope it will be understandable, bear with me. When...

Hi there, Recently discovering the world of VBA changed my view of the office suit. Seems like the possiblities are endless, well if you don't know how stuff works everything you try seems like an endless ride. That's where this forum comes in :) I'm born and raise in The Netherlands, maybe...