First  |  Prev |  Next  |  Last
Pages: 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Sum & Count on Form.
i had a form on which i had created a combo box that contain several employees. I want the amount earned (Currency Format) by each employee to be displayed on the formin the text box. Other fields in my table are; Empid,Empname,amount earned.etccc please tell me how to solve this. ... 21 May 2010 01:56
Conditinal Format Not Working
I am trying to get a field to turn red if the condition is "High" I tried using the conditional formatting and it does not work. I also tried using the below vba code and this does not work either. I tried it in the after update procedure and the on current procedure with no luck. Could this be an Access bug?... 18 May 2010 19:15
Combo Box - cursor automatically inserted instead of scrolling thr
I have a combo box of names. A user can start to type a persons last name and it automatically scrolls through the list. One user is encountering a problem that when they start to type the cursor gets inserted into the field and disables the "type and scroll" feature. For example, we have someone named "Dil... 19 May 2010 09:21
Forms not saving
Johnopal, I had the same issue, and your solution did the trick for me also. TYVM! "Johnopal" wrote: Well I didn't try all you suggested, but your post did lead me to a solution. I must have had some VBA code attached to these forms somewhere along the way and it didn't convert. I opened the form in d... 18 May 2010 14:48
Filter by form search field showing non-distinct values in pull do
Howdy. I'm using Filter-by-Form for searching. For each field, when in FBF, the pull down shows a list of distinct values for that column. One field on my form, though, is showing a list of non-distinct values, so the list has over 200,000 entries, many of them duplicates (in this case, NULL or zero length ... 21 May 2010 13:56
Create datasheet in MDE
My application creates a datasheet on the fly. Users make a selection from a set parameters including column names, sort order, etc and the code populates a querydef with the set of columns selected by the user. This works fine in an MDB. The equivalent MDE crashes - "That command isn't available in an MDE dat... 19 May 2010 18:17
Microsoft Word Table design in Access 2007
Is there a method for inserting a table (not an access table, but a word table with columns/rows/header, etc...) in a description field in a form or below the description field? I'm creating a database for development business rules and sometimes a business rule needs a table to explain or identify the heirarc... 27 May 2010 17:04
How do I populate a subform field with a value from the main f
How does the table know who the record is for when running reports? For example the ContractsAndHours subform was created from the ContractsAndHours table. If I do a query on the ContractsAndHours table information and there is no name field how do I sort by employee name? Thanks for the reply it is very much a... 18 May 2010 22:32
Auto number
Dear All Can I make the start auto number from a value that i choose?? like the auto number starts from 95?? best wishes -- Message posted via ... 18 May 2010 08:10
Combo box values for existing and new records
Hello, I don't really know how to formulate question, so I will try to explain problem shortly: I have created small invoicing application in Access 2007 for renting business - there is table of customers, table of invoices and table of devices we offer for rent (there is one type of devices, total number - a... 18 May 2010 08:10
First  |  Prev |  Next  |  Last
Pages: 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24