ms-access-2007
Preset the "save as type" field while using Application.FileDialog(msoFileDialogSaveAs) with MSAccess
I searched all over for a way to do this. I want to open a Save As dialog box so the user can choose the location to save a file. But, I want the \"Save as type\" field to be preset with \"comma sepe[详细]
2023-04-13 05:57 分类:问答VBA: List of RecordSource in Form
I want to scan to all Rec开发者_如何转开发ordSource in my ADP Forms. One of my Form might call in the wrong View. It usually sets in RecordSource Property. The problem is there are about 300+ forms in[详细]
2023-04-12 08:59 分类:问答Connect MS access database in JSP pages
I would like to ask you how can I connect a MS access database in JSP pages?Do you kn开发者_如何转开发ow any ready class which I can use?I am using Netbeans to create JSP pages!Ancient question, but I[详细]
2023-04-12 04:01 分类:问答Access 2007 Forms - displaying combo box without the drop down arrow
Using a combo box makes it much simpler to show lookup values from a table, but I would like the drop down arrow to not show up.If I 开发者_如何学JAVAchange them over to a textbox, they only show the[详细]
2023-04-11 16:56 分类:问答How to create form that contain data from 2 tables and save data to one table
i have 2 tables: Employee: ID SalaryPerDay Name (unique) ..... ..... Schedule: ID EmployeeID Date Attending(boolean)[详细]
2023-04-10 19:27 分类:问答MS Access 2007 Append query trouble
I have an append query that is trying to append some records to one of my tables. However, I am getting an error that says “didn’t add 1200 records due to key violations.” 1200 is the total number[详细]
2023-04-10 00:54 分类:问答Parameter query run hyperlink & open webpage, for tracking UPS package
I have a parameter query that looks up the tracking # for a given customer_order_ID and outputs the tracking#as a website link, as a single record. Please advise me how I can have the link run aut开发[详细]
2023-04-09 18:59 分类:问答Access 2007 vba How to link a query to a button that will fill a field in a form?
Since everyone has been so helpful to me as a Access/SQL/VBA newbie, I thought I\'d try another question.I\'m building a system tracking form for some of our information assurance processes and I\'ve[详细]
2023-04-09 11:52 分类:问答Is this query possible SELECT * FROM mytable WHERE ([myExpression]);
i\'v got a question about sql in access 2007. it\'s possible to generate a query like this: SELECT * FROM mytable WHERE ([myExpression]);[详细]
2023-04-09 06:44 分类:问答Font size mismatched between embedded Word object and text boxes
I\'m developing a new Report (actually a standardized letter) in an Access 2007 db.The majority of the text in this report is static and was provided to me in a Word doc.Because this text is relativel[详细]
2023-04-09 06:37 分类:问答