Search results

Hi all, I would like to sort my table before I export it. I'll want my table sorted Ascending on Column 'Time'. How is that possible? To export the table, I use this code: DoCmd.OutputTo acOutputTable, "LogTable", acFormatXLS, , False Thanx!

Hi all, I'm a little familiar with Access. If you have 3 possible values for a field, u can use format property text and add as validation ="Value1" OR "Value2" OR "Value3". Is there a way to do it with a checkbox who has 3 values? The checkboxes Yes/No, True/False, .. have only 2 values. Any...

I have a form to update records in a table. The problem is that I only want to put the new values into the table when I click a button. Now, if I enter 'man' into a textbox, it automaticly add this value in the table when I leave the textbox. Any suggestions?

Is there a way to disable all the hotkeys in Access ? And is there a way ot activate them again? thx

I have some code, working in Access 2007. I want it to work in Access 2000 also. The export from a table works fine: DoCmd.OutputTo acOutputTable, "Data", acFormatXLS, , -1 The export from a query does work in Access 2007 but not in Access 2000: DoCmd.OutputTo acOutputQuery, "Temp_N°_Code"...

Hi all, I have a table called Customers. In a form I have a list with inputfield linked to this table. If you type in a word in this list, and the word is not already in the table, is there a way to put it automaticly in the table? If tried with the next code when 'If not in list' : Private...

Hi, I have this query. SELECT * FROM Data WHEE Volume = [Type Volume] Then there appeares a parameter box where you type in the value. Is there a way to pass this value into a variable? Sorry for bad english, I hope you understand it :) Thanks!