Threads Replies Last Post 396 Pages: <<  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  >>   Syntax error in my form By clicking on command button, I am updating field 'Type' in my table. But i have wrong syntax in my code. DoCmd.RunSQL "UPDATE Test SET Test.[Type] = strPath" Please show me what syntax should i put around "strPath". Thank you for help.... 4 14.09.2006 16:37:01 I need a template for adding a new signor to our account? I would like to create a Template for our office that allows me to add new signors when needed on our business accounts. ... 1 14.09.2006 16:16:01 id number used more than once good morning all! this might sound like a dumb question so im sorry in advance....i'd like the user to be able to delete a record if the id number is used only once...if the id number is used more than once, it cant be deleted...does anyone know how this may be written? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200609/1 ... 3 14.09.2006 15:38:14 filter buttons can someone pls help me out with filters - ive never used them before and know what they do but am totally clueless where to start to program! i have a form with a subform (continuous). i have buttons on the parent form which will act as filters so if the user presses btnOrange, it will send a filter to the subform and display all users who are in the 'orange' sector. would someone pls be ... 1 14.09.2006 15:37:23 Option Buttons - 3 options I have 3 option buttons set up. I have the option values Canada (-1) United States (0) and Other (?). I have tried using values 1, 2 ,3 & 0, 1, 2. None of those slections let me select an option. Only when I use (-1) and (0). Does anyone know what the problem is?? Newf -- Newf ~Everyone needs a NEWFIE as a friend~ Message posted via AccessMonster.com http://www.accessmonster.com/Uw... 5 14.09.2006 15:11:01 Avoid Re-Typing Information I need a little help with a form. My form is based on a table with the following fields: ID Stager Door Store # Trailer # Open Date/Time CLosed Date/Time Seal # # Licenses We are keying entries off of a log sheet that contains the same information that is filled out by a warehouse worker. Each person could have 50-100 entries on their sheet. Currently, the form is set up so ... 3 14.09.2006 15:00:02 Possible Corruption I have recently place a DB on a shared drive. I am the only user to work on this. I worked on this DB on the shared drive for about 7 days, when something strange happen. When I open a form from the switchboard, instead of opening into the edit mode it now opens to the add mode. Any ideas ... 1 14.09.2006 14:08:02 Tab Control/Subforms I have two subforms on different pages linked to the main form by a common record number. The two subforms share a source, and have a control with the same data. This is used to identify the record entry. After entering data in the first subform, I want to tab to the second and find the common control already populated. This happens only when I close the record and reopen it. Is there ... 1 14.09.2006 13:55:02 alert me when entering duplicate names in an Access form how can I set this up in an Access form? I do not want to prevent the data from being entered, I just want to be notified. does anyone know of an expression I could use for this?... 4 14.09.2006 12:48:01 Checking if form is hidden i have a form that is sometimes hidden and sometimes visible. i know you can use "CurrentProject.AllForms("frmWorkOrders").IsLoaded" to see if a form is open, but even with the form hidden this code returns a TRUE. is there a way to see using vb if a form is hidden!... 3 14.09.2006 12:46:02 Default Value Question Hello all, Is there a way (module or something), that will Set the Default Value of a Certian Field to a Value I assign to it? Specifics: 50 Forms in Database. All Forms Have a Field [SeatNumber]. I would llike all the Forms to be Static i.e: SeatNumber=5 (for all 50 Forms). Right now, I have to Open the Control Properties for All 50 Forms to set the Default Value. I cant set t... 2 14.09.2006 12:01:07 controls flickering during mouse-over Hello, I have an unbound form which host a tab control with 6 pages. On any of this pages there are many controls eache of them unbound and with some labels NOT joined to the controls that will receive data (this is due to the need to design the form to look like the paper form). In form view I noticed that when the mouse-cursor goes over the un-joined labels all of them flicker a bit ( q... 2 14.09.2006 11:50:08 Full Screen Forms Hi I created a database where I have a Menu called QUERIES menu . I made the database full screen and everything runs well except the queries menu. When I click on the command button to run the query, it prompts for the parameter and when entered the query opens at the background. Is there any way that query pops up on top of this form. Thanks Mahesh ... 4 14.09.2006 11:32:01 Different colors in a subform of MS Access Hello, I want to paint rows in different colors in a subform of MS Access. I have 2 problems: 1 - I have used the conditional formatting to change the color of different rows but I can use only 3 conditions. I need any solution to use more colors. 2 – If I use the conditional formatting in a subform, this works properly, but when I change the recordsource of this subform, the colors ... 1 14.09.2006 11:07:01 Forms problem... Hi people, I have the following situation - three tables: TrOrders( TrOrder_id, troDate, troAgency, troTotalPages...) one-to-many relation with OrderedTranslations(Ordered_id, ot_tr_id, ot_trName, orAgency, orStatus....) one-to-one relation with Translations (Tr_id, trName, trPages, .....) I receive the Translation table with data ( with periodic updates) OrderedTransaltions is empy ... 1 14.09.2006 10:08:10 Text box Colour I have a form in access 97 which has been created in a table format, what I need is to be able to change the colour of one box if it is greater than the value in another box. seemed simple enough used an if statement and this worked but it coloured all of the boxes, so I put the statement in the on current event of the form and this did not work either. I believe I may need a loop to ch... 2 14.09.2006 09:16:37 Numbered scale spaced by interval defined by nos in column I have an Excel chart of two columns of numbers. One column has angular values (from 1 degree to 45 degrees) that are to be spaced by intervals specified by numbers in the second column (1.3 inches to 14.1 inches). Is there a program that will place numbers specified in the first column by the intervals spcified in the second column. For example, say that the numbers were: deg inche... 6 14.09.2006 04:43:53 HTML in a unbound text box Hi, i'm trying to put the following html code into a unbound text box on a form so it can be copied into a bound text field on the same form. <p class="normal"><a href="www.mylink.com">This is my link</a></p> When I run the form I'm getting #Name? Has anyone done anything like this and if so how?... 2 14.09.2006 01:31:42 Sync Main FORM with SubForm I have two tables in a one-to-many relationship as following: Table1: [ pkeyColumnID, ProductType, Factory] ……..One Side Table2: [fkeyColumnID, ProductType, Factory, Status,……..] ………..many side Created main form based on query1 that lists ProductType and it’s location per factory The ProductType and Factory are ComboBox and are non-bound Created Submain form based on... 4 14.09.2006 00:23:02 please help me Hi! can somebody help me here is my query date fielda fieldb balance opbalance 9/1/06 100 50 50 0 9/2/06 50 25 75 50 9/3/06 100 50 125 75 now my report is on daterange so can i put on field in my report header it show opbalance for beginging date which i put in date ... 4 13.09.2006 23:35:02 Tool Tip messages I have six command buttons on an Access form. Four of the six buttons display the tool tip message when the mouse pointer is over the button, two of them only display the message when I tab to them and place the mouse pointer on the button. The properties all appear to be the same. Does any one have any suggestions why the contols are not responding the same? ... 3 13.09.2006 23:10:02 Removing data from drop down Hello all, I have unbound combo box for parking spaces and when I assign someone a parking space I would that parking space to become unavailable to the combo box. I also have a expiration date that when it reaches this date to put the space number back into the database. If there is no date I have a check box when someone leaves that when it is checked needs to also put that space back int... 3 13.09.2006 22:11:02 Error Message: Embedded image moved to file: pic27529.pcx I have a multi-user db that displays this message on opening the db for one of the users. As I understand it (I haven't seen it), only one user is getting it. I'm using the standard switchboard for the db. There is a logo that is a bitmap embedded picture. I also have buttons around the edge with custom pictures that are bitmap embedded. I created the pictures using Picture Manager ... 1 13.09.2006 22:00:02 Variable value Hi. I have a field in a continuous subform called [No_ID]. This is a numeric field and the user enter manually «1», «2», ... My question is: is it possible to define a variable «a» as the value entered in the field [No_ID], only by having the mouse cursor on the field? (I need to define a variable «a» in order to export it to a Word document as an order number). For example, if ... 2 13.09.2006 22:00:02 empty date field query This is not a repost but a slight variation on a post from a few days ago. I have a main form that populates tblCUSTOMER with many different customers. That form has a subform that populates tblHISTORY tracking the purchases of each individual customer by date. Both tables are linked by AUTO ID. Sales that are not yet finalized are entered into tblHistory without a date. I want to run a q... 3 13.09.2006 21:37:28 396 Pages: <<  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  >>