Threads Replies Last Post 363 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  >>   datasheetview-get values programmaticaly hello i have a subform which opens in datasheetview. all the columns/textboxes in datasheet form are unbound. so i have to save them manuully using insert query. so can anyone please tell me how to programmaticaly get the values in iterations in all the rows in the datasheetview ?... 4 28.09.2006 15:07:58 Calculating order totals I posted this in the Query section but I think it really should be here. So here's the short version. I track photography orders. Photos has one record per order, PhotoList has one record per picture order (based on pic # and size). Price of each pic is based on the TOTAL number ordered of that size (we give a discount for 6 or more photos ordered of the same size but NOT necessarily... 4 28.09.2006 14:56:02 limit characters in text box - unbound password format When I use Allen Browne's code for limiting text box length for an unbound text box in a form, I get an error message if the format for my text box is "Password". Access can't get the value of the text box. Is there any way around? Thank you!... 1 28.09.2006 14:18:02 Calendar Field Overlap I have a calendar popup on my form which pops over several fields however one field stays on top. How do I force the field into the background when the calendar pops up? thx ... 1 28.09.2006 14:18:01 Continuous form combo issue I thought I had successfully done this before but apparently not!! Hi Groupies My main form has a continuous subform with two combo boxes. The first combo is a category selector, the second shows the items in that category.....no problem there. The issue is that when I move to the next record in the subform and select a value from the Category combo, it changes the value in the first ... 4 28.09.2006 13:44:42 Combo Box Properties I have a form with a Combo Box. The options in the Combo Box are either ‘Yes’ or ‘No’. What is the ‘Validation Rule’ I need in the ‘Properties’ box for the user to either enter ‘Yes’ or ‘No’? Also, I want the default value to be ‘Yes’, but when I put the word ‘Yes’ in the ‘Default Value’ field in the ‘Properties’ box, the form shows -1 instead of... 4 28.09.2006 13:36:02 Translating a label into another language Hello I have designed a section in a report to divide by months and the result is august 2006 ..., june 2006 How could I change this in order to translate it to another languge? I mean, sth like: if month.text = "august 2006" then month2.text= "agosto 2006" else if month... Where should I write this code? I have started on the open form or load but this label, month label doesn... 6 28.09.2006 13:36:02 Can you close the relationship(s) window programatically? Hello People, Is it possible to close the relationship window programmatically? If so how? Thanks in advance. Nick ... 9 28.09.2006 13:07:24 Emailing From Access I have a few buttons on my form that run some VB code that create an email in outlook. all the emails are created in plain text and not html. Is there a way to change this automatical. also i have to select which account to send the email from can this be selected automaticall Thanks Simon ... 1 28.09.2006 12:53:15 Adding data to a Form from a Form that's being closed I have a 'MasterForm1' that uses a combo box to list a set number of users from another table 'UserNames.' If the user who's entering data into 'MasterForm1' doesn't see his name in the combobox, there's an "ADD NEW USER" button to open up a form (with Data Entry set to 'Yes') so a new person can be added to the 'UserNames' table. Once the user's name (text box) has been defined, I have a ... 2 28.09.2006 12:48:31 SQL Problem I think, rather I now this SQL statement's Syntax is wrong, because I keep getting a message stating so, any help correcting it I would appreciate. Thanks DS NEWHOUSESQL = "INSERT INTO tblHouseCheck " & _ "SELECT* " & _ "FROM tblChecks " & _ "WHERE tblChecks.CheckID = Forms!frmCheckPayment!TxtSalesID & " & _ "And tblChecks.ChkHouse = -1 ;"... 2 28.09.2006 12:28:14 Filtering using drop down list I have a form which select the [Meeting Number] from table [Meeting Details] and this is passed to the subform. The subform is used to enter meeting heat details and one field needs to be able to select (via drop down) the list of [Riders] from [Meeting Details] that have the [Meeting Number] from the main form. Any ideas? ... 1 28.09.2006 10:40:02 Subform Problem Hello, I'm kind of new to access, but I cannot seem to find the solution to this problem in any books. The problem is that I have "individuals" who are each part of different "groups." Individuals can belong to different groups. My solution is to have three tables: Individuals, Groups, and table that simply has the linking information: Group1-Individual1 Group1-Individual2 Group2... 2 28.09.2006 04:26:00 Command Button For Number Input I am trying to create a system for a touch screen where a user would walk up to the machine and punch number on the screen. Each number is a command button and I’m not sure how to make the command button equal that number that will be placed into that field. I have the on click command set to fieldname=1 or 2, but that will only input one number into that field not multiple numbers if the ... 6 28.09.2006 02:49:10 Recordset (table) exist? I am trying to open a recordset using the following SQL statement and would like to display a message if the table (record Source) IGFY07Q1 does not exist. How do I test for its existence before invoking the OpenrecordSet command? Set rst = db.OpenRecordset(stSQL) stSQL = "Select IGFY07Q1.[territory number], IGFY07Q1.Measure, IGFY07Q1.revenue, IGFY07Q1.Goal" _ '& " From IGFY07Q1" ... 3 28.09.2006 02:34:02 Update Memo field using VB in a form I have a form that opens a record to edit based on the recored selected in another form. I am trying to set three fields in a form prior to opening the form. One field is a date field, one a text field and one a memo field. The date field and the text field are updated when I open the form but the memo field does not get reset to the value I am trying to set it to until I put my mouse... 2 28.09.2006 02:08:57 Default Value in field I have 3 fields in a Form: Env #, Pledged Amount and Amount Received. I have used a Value Expression in the Default area of Properties to automatically show the Pledged amount, which can then be overtyped depending on the Amount Received. However, the Default amount continues to show zero for each record, not the Pledged amount as required. Any help would be appreciated.... 4 28.09.2006 01:31:20 acFormReadOnly doesn't display one subform I have a tab control that contains 7 tabs, each with a different subform- Employee Info Personal Info Training Testing HR Records Uniforms Performance I also have a couple switchboards set up, the first lets the user enter the managment view or the admin view. in the management view the manager can click the Employee Views button to view the tab control in read only mode. Here is the... 6 28.09.2006 01:14:28 Setting fields to automatically fill in a date. Is there a way that I can get a field to automatically fill in a date based on another date field? I need something that can track when visits are due; if I put in today's date, I would like 3 more dates to pop-up to give me 4 quarterly dates. Please be as detailed as possible in your answer as I am still relatively new to some of the features and functions of Access. Thanks!... 4 28.09.2006 00:16:15 Highlight Row In my Access 2000 datasheet, is there an easy way to highlight the row the cursor is in? I don't want to select it, but I'd like to change the color to a light gray. When the cursor leaves the row, I'd like to change it back to it's original color. The goal is to easily see which row the cursor is in. I don't want to have to go to each field in the row and adjust its color. I'd like... 8 27.09.2006 20:35:01 Code to disply tomorrw day i need some help with some code that will display tomorrows day for example if its 'Wednesday' it want it to display 'Thursday' If its Friday, Saturday, Sunday i want to to display 'Monday' If any one can help this will be great Simon ... 7 27.09.2006 20:31:20 creating a filter with a form I have created a database for tracking hours worked. I now need to create a way for users to sort through the data. I have four fields that I need to sort through using a form with combo boxes. The only problem that I have is how do I use a wilcard character, *, in the combo boxes so that if the user wants to select all the information in one or more of the fields how do I do that? I post... 16 27.09.2006 20:11:42 ControlTipText in continous form I have researched this and the response always seems to be "Leban's Continuous Forms Current Row" example...and then people say simply set the ControlTipText rather than the text box named txtcurrentrowdata. I can't figure out how to do that. Could someone simply take Leban's Code and modify it so the txt.code.ControlTipText shows the data of the txt.code. I would really appreciate it. ... 6 27.09.2006 19:13:55 Crystal Crystal, About a month ago (8/25/2006) you answerd a question about "clearing check boxes" for Matt. I need to do the same thing on my form but was wondering if it was possible to add code to my print command so that after the report prints, the check boxes are cleared with out any buttons or interaction from the user.. I am a newbie so I really need things spelled out simply.... 2 27.09.2006 18:47:42 move controls with form resize This may sound silly, but for fun I built an anolog clock on a form. The hands and number locations and size are based on the forms size so it can be moved and resized. When I resize the form by the border nothing changes but the border do I have something I don't have set that should be?... 5 27.09.2006 18:05:01 363 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  >>