Recent content by Twin

Yes i did Ken, worked like a charm...thanx

absolutely righ Pierre, it is in Excel, but not in Access...i know it is going to something simple... thanx m8 Chris

Hi all, i wonder if someone could help me, i have a table based form that is used to enter data and one of the text fields is sourced from the field in the table updated via an update query. i do my testing via a button, but i always get the Compile error 'Argument not optional' when i try to...

Hi There, try following the link, the subject was covered pretty tight... http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=11558

Hi there, is there a error number that is displayed with the message?... Try creating a straight make table query and recreate live table into a static one and use that one as a source for further analysis.(access sometimes has a problem tracking(locking) records if the link is live and the...

Create an invisible text box on your form with source=[your combobox]. Make that text box value a criteria in your append query. On the combo box itself On change propery need to have refresh or requery specified: ex: Private Sub Combo6_Change() On Error GoTo Combo6_Change_Err DoCmd.Requery...

Have you tried to put Format ([your field name], "dd/mm/yy") in your design grid? Then in the criteria you can ask for the prompt [Enter date required] etc.. It works on mine.. HTH Chris

Hi Andrija, if i understand correctly, each of those five queries show total number of records as a single line result...? in which case simple select query with no joins will do the trick...just select the required field from each query and drop it into the result grid and you will get a range...

Hi Stephen, I have attached something you might be interested in...The database contains Macros as well as the same converted into VBA code. Note the setup of On Timer and Timer Interval on Form1 properties. You can leave the database open at all times if it's going to help... HTH Chris PS...

Hi Ryan, could I kindly request the form please, it sounds interesting. TIA Chris

Hi, on the form containing your combo box, create a text box that has your combo box as a control source. Then just use the text box as a criteria for a query. Not elegant, but it works. Chris

Try the following: DELETE Orders.*, OrderDetails.OrderID FROM OrderDetails RIGHT JOIN Orders ON OrderDetails.OrderID = Orders.OrderID WHERE (((OrderDetails.OrderID) Is Null)); Prior to this set the Primary Key in both tables to OrderID field. It worked on my test db. HTH Chris :p

Hi, Create a table with the same fields as your query with the adittion of an autonumber field. Make your existing query Append Query to the new table, and given that the query has descending order sor on points you should get what you want. Now, to have this updated on the regular basis, I...

Hi there, I do not know what is /x switch, but the following works for me: i have several databases running overnight through the scheduler. Upon openning, I have an Autoexec macro running that takes care of everything. Can you tell us more details like what is {ENTER} supposed to do? Chris

Hi, you can select 'Minimize'action for your macro and assign it to the switchboard form button. That will minimise your SW form and by default activate database window. Not very sophisticated, but i think it should work. HTH Chris