Threads Replies Last Post 225 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   Input Mask Hello! Is it possible to add a field in an Access table together with it's input mask. I mean using an alter table query. Thank you. Torrio... 3 29.09.2006 08:32:02 How to know wich are the dictionaries installed ? Hi, How to know which are the dictionaries installed in your PC from Access (by code) ?? I mean the spelling corrector dictionaries Thank you -- Message posted via http://www.accessmonster.com ... 1 29.09.2006 14:21:06 Editing a flexgrid Hello, I would like to edit a MSHflexgrid in Access 2000, as I've done many times in VB6, using a floating Textbox. However in Access, my textbox always appears BEHIND the FlexGrid control, and so it is always hidden, even if I bring it to front in design view. And there is no Zorder method in Access as there is in VB. Is there a solution? -- Phil... 4 29.09.2006 14:44:01 Read-Only Linked Table I have a front-end that links to tables in a back-end database (plain and ordinary MS-Access). For various reasons I can't just mark the back-end database as read-only (which would easily solve my problem). I do have a query-based solution that I can use (but I'm still not entirely satisfied with it). I do a total query grouping by all the fields in the remote table. This will show all ... 1 29.09.2006 14:13:02 currentdb.execute returns zero records but manually opening query I execute a number of update/delete & append queries from a module using currentdb.execute Most of these execute correctly however a few of these return zero records affected. If I manually open the query in the database window then the query executes correctly. If I use a macro to call the queries then they execute correctly. I have also tried ADO command.execute with the same res... 3 29.09.2006 11:58:19 button wizard I need to open a form from a subform and have it find records based on the table from the subform, rather than a field on the subform. Is this possible?... 2 29.09.2006 09:10:03 AddNew batch updating help What I'm trying to do is Batch Update the database instead of update it every time. I run a pass-through query to another database and put the results in a recordset, then I want to dump that recordset into a table. My question is how would I implement UpdateBatch? If I keep both rstTable.Update and rstTable.UpdateBatch commented I still get updates? Is there any way to turn that off s... 2 29.09.2006 08:09:34 File Sharing Lock COunt Exceeded Issue gday all Scenario: Access v11 SP2 (Office 2003) 2 Access tables in application database (not linked) Table1 has approx 450,000 records and Table2 has approx 310,000 records 2 subs each the same but processing the 2 tables. The first one works AOK, the second returns the error: Error# 3052 was generated by DAO.Recordset File sharing lock count exceeded. Increase MaxLocksPerFile re... 5 29.09.2006 06:11:02 getting combo box to work in a subform Hi all, I have been working on this code for many hours but I cant get it right. Hope somebody could help a desperate here. This is my problem. I have 3 combo boxes in subform. The second combo box row source will depend on the selection of the first as well as the third will depend on the second. All works fine when opened as a main form but when it is being called as subform, I g... 2 29.09.2006 04:30:16 Embeded Word document in Access Failed to attract a response after 2 weeks under forms coding. Trying here... I have Access 2003. I'm trying to programmatically load a Word document into Access via OLE. I have a table with a field called Reqmnts. Its data type is OLE Object. I have a form with a bound Object Frame to the OLE Object. The field has an "OLE Type Allowed" of Either. If I use drag-and-drop of a ... 2 29.09.2006 02:35:52 Run-time error '429' I am using an excel file which has macros in it, when ever i click the command button its gives the msg that Run-Time erroe '429' activex component can't create object. can any body help me on this, waiting for the replay ... 2 29.09.2006 00:38:01 Access VBA When I open my form I want my combo box to drop down and show the records somewhat like a list box. VBA code? ... 3 29.09.2006 00:11:02 access 2007 worst yet If you cannot come out with a Access interface similar two Access 2002 then count me out. I will not purchase this joke. Who ever came up with this managery should be fired. I waited five years for this. this is insane I could not be more disapoiunted If somthing works leave it alone. your form inteface suckes. I dont want to click and scroll to find a query or form or table. There was ... 10 28.09.2006 23:11:35 join two fields in a question i know how to combine two fields in a question to get for example name and surname together, but i can't get a spacing between the name and surname ex. this is the way i want it... olle andersson this is the way i get it: olleandersson ...... Uttryck1: [name]+[surname] ... 2 28.09.2006 21:49:27 Userid/Password Restrictions, Are there any? If you are storing the User Id and password in a table. Is there any restrictions (like special characters?) that you cannot use? Or does MS Access 2000 care?... 2 28.09.2006 20:52:52 Expresson Problem I have the following expression that takes the last name and inmate number and combine them. It works however if the field is blank I get ,0 int he field. I just want it to be blank. =IIf(InStr([IN_NAME],",")>1,Left([IN_NAME],InStr([IN_NAME],",")-1),False) & ", " & [IN_INMNUM]... 3 28.09.2006 20:08:20 Can't open more databases When I am going throu my Access App. I receieve this error message from time to to time. I press the End Button and it continues working as if nothing had happend. What is it? Thanks a lot, Lina... 7 28.09.2006 20:06:02 Executing the import table wizard Hi all. I'm trying to enhance the functionality of a MS Access application. I want to give the user the capability to import a MS Access or MS Excel table into the application *without* having to execute the Import Wizard herself. Q1: So i'm basically looking for the VBA statement that will invoke the Import Wizard (the equivalent of right-clicking in Tables view and choosing: Im... 2 28.09.2006 20:01:53 copywrite/title form default that opens mainform I open with the Tools/Startup default of copywrite/title form, database is hidden. I want to display copywrite/title form while mainform loads and displays in the background. I want to use an ontimer event to, at time end, close the copywrite/title form. How do I do this. I appreciate suggestions. -- Thanks for your help, Chris... 3 28.09.2006 19:58:02 Save SqlString as a query I am generating a SqlString based on various inputs and want to do a SAVE AS to save the final SqlString as a query. I will use this as a sub query to generate a scatter plot. My sub query would be named Q_Sub I will need to overwrite the Q_Sub query each time I run it. I then need a line of code that will update the chart with the Main query -- Q_Main -- instead of the SqlString, ie ... 2 28.09.2006 19:25:17 Len VAlidation Rule I want to Why this validation rule dont work? Len([Text0])<8 And Len([Text0])>10 ... 2 28.09.2006 19:10:02 Looping with VBA I'm a novice with VBA. I need to design a "PRINT ALL" button. Right now, users can select an office from a combo box on a form. A macro is set up and functioning that gathers information and prints a report for that office. I need to use VBA to loop through all the possible offices one by one and print the reports. I would normally set this up so that a user could leave the control ... 3 28.09.2006 19:08:02 Detect user idle time Hi, I have lately used the microsoft detect user idle time coding in the access database I'm having and it works excellent if you just log in without moving through forms or adding any data because as soon as you do that and you walk away from the computer and the code detects that you are idling, instead of closing the database - I have a form where you can cancel if you want to continue ... 1 28.09.2006 18:56:46 Executing Add-In from a custom form I am sure I am not the only one to ask this, so hope someone can point me in the right directions. I have a working add-in developed with Access 2003 and VBA. I can connected in to a database va Add-In Manager and everything works great. I would like to link the startup function of the AddIn to a custom form so the user doesn't have to go thru the menu prompts each time to get to the a... 2 28.09.2006 18:55:15 Error Handling - Call another Function Hi, I have a module called SendTrades which first checks conditions to send an email, if the conditions are satified, it calls another module, EmailTrades which will then put together an email and send it off. It then goes back to the SendTrades function which then launches an update query which updates which records have been sent via email. If my mailbox in Outlook is full, currently... 2 28.09.2006 18:42:02 225 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>