Search results

  1. K

    Updating Form Open Or Closed

    I have 2 forms, one accessed by password for entering data, the other for data searching and is for general use. When I update the input form with new data and the search form is closed, when I open this form the data is there. Should I input data while the search form is open, this form does...
  2. K

    Option Group Frame

    I am using Access 2000 and trying to make an option group frame for sorting records. When I use the below code, I receive an error message, “Object does not support this property or method” when the code reaches line .RowSource. I would appreciate some advise as to how fix the problem. Kevsim...
  3. K

    Maximum Records In A Database

    I have a database written in Access 2000, then converted to Access 97 so others can access. All data input was working OK from all users, until I reached record 7690. The record selector is then Grayed out, if I delete one record, all is OK until I reach record 7690. The database file is 1650KB...
  4. K

    Option Group Filtering

    I have a form which is based on a Table called T_Product. There is an unbound ComboBox where I can select a Product record, this works OK. I have now added a field in the T_Product table called ProdComp. The idea of this field, is when I enter data in the product form, I can separate Products...
  5. K

    Export To Excel Is In Version 5.00 Format Not 97

    Using the code below, I transfer a Query to Excel, except it is in Excel 5.0 format, How can I change this for output of Excel 97 or 2000. I would appreciate any assistance. DoCmd.OutputTo acQuery, "Q_FinalData", "MicrosoftExcel(*.xls)", "C:\My Documents\WagesTemplate.xls", True Kevsim
  6. K

    Filtering A Query By Start And End Date

    I have asked this question before, received some answers, but still can not fathom how to write the code in VB, everything I tried failed. I have a query and want to filter the data by “Date Done”, and using a text box to enter the start date and another to enter the end date. I would appreciate...
  7. K

    Sorting Data By Date

    Using a form with 2 Text boxes, one for Start Date and the other for End Date and a Command button, I wish to sort and view all records when I press the command button after the start and finish dates are entered into the text boxes associated with the query. I would do this using the on click...
  8. K

    Excel Adding Alternate Rows

    I have row C3, then row C7, row C11, row C15, row C19, there is a space of 4 rows for the rows I wish to add. If I was adding all rows C3 to C19, the formula would be =Sum(C3:C19), if I added a row C23, this would automatically adjust the formula making it =Sum(C3:C23). To add the odd rows the...
  9. K

    Graphic Program

    I have developed links in my database, so when pressed it will take you to a particular graphic. My problem is, most of the graphics were developed in MGI PhotoSuite and when the graphic is selected, PhotoSuite opens to display the graphic. I have selected the graphic in the file, right clicked...
  10. K

    Copying Records

    I have a database where some of the records are very near the same as other records and it can be quite tedious when inserting the data. To save time when typing in a new record, I choose a record close to the one I want to type in, then press a command button for the data to be copied in the...
  11. K

    Checkng For Broken Links

    I am working on a database with 6 tables, where broken links are showing up. This would be where the continuation of data input has been aborted. Is there a way within Access 2000, where a check can be made for broken (or incomplete links) and be repaired or reported to correct the problem? If...
  12. K

    Form Detail Missing In Form View

    I am a litle desperate, I am not sure what I have done, my problem is as follows- I have a large form, it views correctly in "Design View", however when I switch to "Form View" the form header is there but the contents of the Detail is missing, I switch again to Design View, all is still there...
  13. K

    Form - Free Text Search

    Kevsim I have a form based on a query. How do I go about setting up a "Free Text" search function for one or more fields on the form. Do I need a dropbox to select the field I require to search? I would require to view all results of the search and what controls are necessary and the coding...
  14. K

    Updating Table With Dummy Combo Box

    I have several tables, when I want to check if a record exists in a particular table before making any updates or additions, I select an item from table 1 with a combo box, (combo 1), then select the item from table 2 with (combo 2) that matches from combo1 and so on. These combo boxes are not...
  15. K

    Unable To Change Image Format

    I want to place an image in a form, while in Windows Explorer I set the image to open with “Imaging” (Start/Accessories/ Imaging) and when I click the image it opens with that program OK. When I bring the image into the database with Insert Object, Create From File and then Linking, it will only...
  16. K

    Updating Data Between Form Controls

    I have 2 forms, Form “A” and Form “B”. I Update data in Form “A” while Form “B” is closed, when I open Form “B” all the updated data is in the controls. If I try to update the data in Form “A” while Form “B” is open, the data does not appear in the controls of Form “B”. I add the following code...
Back
Top Bottom