How would i set the itemdata from getting just the ID/key of a row, if i didnt k开发者_运维问答now what order it is in on the list
I\'ve got an Access 2007 database on which I have created around 15 SQL queries to process specific data, I have created a main frame navigation menu using menus in Access, I now need to extract all t
I have a table in an Access 2007 database. All fields are of type text. Can the following be done using the where clause? If so how?
I am programming an Access 2007 (accdb, not adp) frontend at connect to a SQL Server 2005 backend. How can I call a scalar user 开发者_如何转开发defined function from my vba code?Dim rst As ADODB.Reco
I know there\'s a way to get a list of all tables in an Access database by using the quering the MsysObjects:
Okay, I need help. I\'m usually pretty good at SQL queries but this one baffles me. By the way, this is not a homework assignment, it\'s a real situation in an Access database and I\'ve written the re
I have created an autoexec macro in MS Access 2007 and cannot find it! I know its there because it runs, 开发者_运维技巧but I cannot find it to delete or modify.I can see other macros that I have cre
I currently have an archaic system of client records that I am trying to improve. For each client i have a directory, in that directory i include a directory for each job. Each job has a spreadsheet
I have a Paradox 5.0 database and want to migrate it to Access 2007. But if I try to import a Paradox table, Access gives an error message: \"Incorrect collating sequence\".开发者_开发知识库 The Help
I have a huge database (800MB) which consists of a field called \'Date Last Modified\' at the moment this field is entered as a text data type but need to change it to a Date/Time field to carry out s
加载中,请稍侯......