Threads Replies Last Post 363 Pages: <<  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  >>   Code help please Hi Any ideas/suggestions on how to achieve the following would be appreciated: Have a Search form that has various tick boxes which list client criteria & on clicking on a command button the code behind searches a client table for clients that meet with the selected criteria & produces a recordsource which is then used as data source for a mailmerge to a selected document. That field... 3 03.09.2006 10:50:17 Field on Form I have afld on a form I call slsamt. I have a defult vale of 0 in he field. I set the valdidation rule to >0 validation text to Amt Must Be GT zero. When I execute the form, If I enter a zero in the field the validation rule works fine, but when I tab past the field and exit the form the validation rule does not work. Is there a way to force the user to put an amount GT zero in thi... 6 03.09.2006 03:49:17 Copy all contents of a recordset to clipboard How do I use VBA code to copy all contents of a set recordset to the clipboard. I want to then be able to CTL-V the data into a spreadsheet application. Optimally, I'd like the recordset field names to NOT be copied with the data (I only want to paste the data into the spreadsheet). Thanks in advance... 5 03.09.2006 02:58:41 A Better Way for Select I have this Select Case statement that works but I was wondering if there is a better way to code this. I have ten of these on a number pad, one for each number 0 to 9, It takes the first number and places it in a phone format (000)-000-0000 in the first digit as such (100)-000-0000 Then takes the second number and places it as such (110)-000-0000 So on and so forth. After it places the ... 10 03.09.2006 01:49:41 Validating emails Hi I have this problem that client users enter emails incorrectly due to type and either the domain name is invalid (Microsot.com instead of Microsoft.com) or the syntax of the email (user'domain.com instead of user@domain.com). Is there any way to ensure a) email syntax is correct and b) reverse dns or any other check to highlight invalid domain names? Thanks Regards ... 3 03.09.2006 00:42:01 How To Filter Form I Am In I have a form: MainForm I have a blank unbound text box on the form: findwo I have number field:WorkOrder I have a command button:Find I would like to run a macro for the click event of the find button to apply a filter to find the record that matches has a WorkOrder value that matches the unbound textbox value. Please help. Thanks ... 4 02.09.2006 23:56:25 A way to get to a particular switchboard page Hi I am after a way to load a particular switchboard page from my main switchboard. I already have 8 buttons (limit) and have now started putting the few additional ones down the far left edge that I need on all switchboard pages. These are mainly opening forms or compacting database which is fine but I need one to go to my 3rd switchboard page and can't find a way to do it. I have tried t... 1 02.09.2006 21:39:44 One form to another I have a form which lists all the records in a table. What I would like to do is to be able to select 1 record or double click it or something which would then open up another form just with that one record for edit. Is this possible? and how?... 4 02.09.2006 19:34:18 addressing a table from a form Rather than have a checkbox or similar control on a form, I have found that I can address the field in the table directly, like If Me.CompleteStatus.Value = True Then where the field is called CompleteStatus in a table bound to the form. This works fine on my pc, but when I tried to run it on another pc, I got errormsg "method or data member not found" at this line. Both pcs are runn... 3 02.09.2006 18:12:45 .FoundFiles.Count ".Filename" Error I'm getting an error in access 97 using the * wildcard in the .FileName, I'm showing the variations I've tried Private Sub Command123_Click() Dim fs As Object Set fs = Application.FileSearch With fs .NewSearch .Lookin = "C:\Records" .MatchTextExactly = False .FileName = "note.txt" 'Works to find files count .FileName = "*.txt" 'Error: Invalid Procedure Call or... 2 02.09.2006 10:28:12 Primary Key Issue Between Forms I have two forms in which to update data. The first form where I enter four fields. Date, Last Name, High School and Region With a Command button I call a second tab format form. Three fields make up the Primary Key. Date, Last Name from FormA and District ID from form B. I have used this approach to help eliminate errors, as this has to do with expense accounts for the dist... 6 01.09.2006 21:02:43 Auto Populate Column Hello All! Say table "ZOO" is about to be updated with an update query. Within has column "CAGE", there are an infinite number of variables that will populate this column. Post update query there are null records in column "CAGE". Here is my question, how do I auto-populate those null fields with "NOCAGE". Your assistance is much appreciated! -- Message posted via AccessMonster.com... 5 01.09.2006 20:59:39 How to enforce security on hiddent objects? I have hidden all tables, queries, macros and modules. I would like to setup some security so that only an admin can access all these. How can I achieve this? Note that I am using the sql server security, I don't have any access security. Thank you, -Me ... 9 01.09.2006 20:37:04 Adding 'scores' using text boxes I have a survey I'm using to determine engagement levels in a project. It has several questions in a combo box and the 'score' each question is given. I have a query pulling the score into the text box next to it (I have it in the "On Mouse Move" event procedure - any suggestions on which one I should use, or if this is OK? It working, but seems a little awkward). Now I need to total tho... 4 01.09.2006 20:13:02 Problem with "Autocenter" vertical position. Hello ! I have many forms defined with the following properties: Popup : No Modal : Yes AutoCenter : Yes <-------- Autoresize : Yes The first form, which is a menu, is opened from the autoexec macro (standard mode). Then from this menu, the following form is opened with the following statements in the "cmd_Click" procedure of the menu buttons Dim frm As Form Dim str A... 1 01.09.2006 18:20:14 Emailing Subform Hi, I am hoping someone will be able to help me with the issues. I have a Form that show the [Rep], [order_id],[customer_name], [customer_account]. I use a combo box that sort by the sales rep and shows the line items for the order in a subform, currently i copy and past the information in the subform in the email. What I would like to do is have the information in the subform added ... 1 01.09.2006 17:38:02 Copy one field to new record I have a bound form with several fields. I need to copy one field value of the current record to a new record when one is created using the navigation buttons, not a command button. How can I make the default value for a new record = the Model# field in the current record? I've tried several things, the latest of which is: Private Sub Form_Current() If Me.NewRecord Then [Forms]![N... 5 01.09.2006 17:29:02 Object Set? Hello! How can I know if an object is set or not except from generating an error because if I try : if myObject = Nothing then ..... I get an error. Thanks for any suggestion ... 3 01.09.2006 16:57:02 Converting Number to Date It seems from my research that I cannot simply use an expression to convert a date such as 20060831 in an excel file from a number to a date format in Access without first converting the number to a string then breaking out the different componenets of the date Year, Month and Day then somehow recombining them back into one field and somehow formatting them to a date format. If so I need... 4 01.09.2006 16:55:10 Changing Date format I have data I import from and an excel file that is in the following format: 20060831 My problem is that I want it in this format: 08/31/2006 in my database. How do I do this? -- Thanks, Dennis... 4 01.09.2006 16:36:35 Get a Single Record From a Form/Query to a Word Document. Ok Easy right. I guess I'm using the wrong code or something. I created this test database with 4 fields, ID, FirstName, LastName, PhoneNumber. ID is the Primary. I have a Query caled Testing Query. My problem is that I want to take the data displayed on the Form at that particular moment, which uses the Query, and export it to the Word Document via Mail Merge. I got the Mail Merge... 2 01.09.2006 16:28:13 ListBox - Default Value = Max in box I have a listbox that is populated with the following query. SELECT [tbl_Plog_CR_Import].[CR Number], [tbl_CR_Costs_Schedule].[CR Batch] FROM tbl_Plog_CR_Import INNER JOIN tbl_CR_Costs_Schedule ON [tbl_Plog_CR_Import].[CR Number]=[tbl_CR_Costs_Schedule].[CR Number]; How would I go about setting the default value to the max number in the listbox. I realise I could do this by putting som... 4 01.09.2006 15:49:43 Add a new record to related table on opening subform I'm not sure how to title this, but the problem is straightforward enough - I have a main project table (with an autonumber field as the primary key) and several related tables that are linked together referencing that project number. I have forms that I use to enter data in these related tables - they had been sub-forms, but I had to break them out as they were getting too large to be u... 7 01.09.2006 15:16:02 Using Form Data to Create Batch File Hi All, Is there a way to create a DOS Batch file from information the user would input on an ACCESS form? Or Edit an exsisting BAT file from a form. Reason- I have a legacy software program that I can run BATCH files to extract data. I need to change the parameters of the Batch file to extract certain. Rather then creating hundreds of Batch Files it would be great if I could have Ac... 4 01.09.2006 15:11:52 Synchronized combo boxes I have two synchronized combo boxes, with the second set to table/query based on the selection in the first box. cboCategories is bound to my Categories field, and cboSubcategories, is bound to my subcategories field. Everything works great. The only problem is that I've realized for certain entries I need to make more than one selection in the cboSubcategories and have both selections r... 4 01.09.2006 14:55:05 363 Pages: <<  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  >>