Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: cfvcf
  • Content: Threads
  • Order by date
  1. cfvcf

    How to set focus to row clicked in subform

    I have a form with a subform. In the subform code on a click event of one of the fields, I have code that grabs the ID of that row and then opens a detail form for that record. But when you click on that field, the record selector is still pointing to the first row in the subform so it opens...
  2. cfvcf

    How to use autonum field and not let it increase when DoCmd.Close?

    I'm sure this is simple and it works on another app I have, but this app - when I code: DoCmd.OpenForm "frm_Household_Inventory", acAdd, "", "", acFormAdd, acNormal The ID is an autonum field, and when the form opens the autonum increases to the new number (30) although when I look in the...
  3. cfvcf

    A question from Thread702-840722 - how to provide the windows drives

    I was reading Thread702-840722, (now closed) and TheAceMan1 gave a suggestion for providing the common windows dialog for locations and file types that is below. I have a form that someone can add a photo from a text box. They can either manually enter the drive etc, but I'd like to give them...
  4. cfvcf

    find a field on form

    I know this seems strange, but how can I find a field named on a form that I cannot see? I have 2 combo fields, combo_Category_Type and Combo38. I want to rename Combo38 to combo_Location_Name and it says it already exists. I have checked all the fields and under images, moved everything...
  5. cfvcf

    question about focus on control on form

    I have a form with a Report button. When it is clicked a dropdown becomes visible and it displays multiple reports to choose from. When it is clicked another dropdown becomes visible and it displays multiple locations to choose from. When it is clicked I have this code: DoCmd.OpenReport...
  6. cfvcf

    Set Focus on a field clicked on subform

    I have other applications that work fine, where you have a mainform and a subform. If you click on the ID on the subform, I want to open the detail record of that ID on another form. For some reason, I now have the same types of forms, but the focus is on the first record on the subform. If I...
  7. cfvcf

    How to display correct records in Subform based on dropdown in Form

    I have a mainform that has a dropdown of "Categories". There is a Subform with a recordsource of detail records, which Category is a field. I want to display only the records in the subform that fit that Category selected. I have done this before where I had built different queries based on...
  8. cfvcf

    How to change the recordsource for a form to include another table

    I have a form that was built with the form wizard, and I want to add another table to the form's record source, because I want to also use a table that shows a date of the last time the DB was updated or accessed. I have an Exit button that I will store the current date/time when it closed...
  9. cfvcf

    Using a form to display new and existing info from 2 different tables

    I'm sorry this is rather wordy!! I have a DB with forms that are operating in the following sequence: Menu form: Button to add organization - this links to form (Org_and_Accts) that displays input fields for the org (name, addr, etc), code is: DoCmd.OpenForm "frm_Organizations_and_Accounts"...
  10. cfvcf

    form with bmp picture button - properties have no tab index or stop?

    I have a form that has a .bmp file that I am using as a navigational button with events, etc. I wanted to add it to the tab order so that when all fields on the form have been tabbed to it then tabs to the button. I don't see the tab property in properties. Can I still update that property in...
  11. cfvcf

    how to hide a subform's ID field

    I have a form that has a subform, the subform has a field called ID, which means nothing to the user, but it does to the code. I have the properties set to visible NO and also when I open the form that uses the subform, I set it to visible = false, but it still displays. What am I missing...
  12. cfvcf

    simple format question about msgbox

    I want to format a message box so that it has separate lines and doesn't just run together. I know this has got to be simple... below is my msgbox: MsgBox "This is either an existing bank or you did not enter (at a minimum)" & _ "the Organization Name and the Name Abbreviation before adding...
  13. cfvcf

    How to make a subform control on a form invisible on certain situation

    I have a form that has data fields in the form header and then a subform in the form detail. What I want to do is use the form that shows a bank name addr etc in the header and then in the detail show all accounts I have from that bank. I "currently" use the form for both new and existing...
  14. cfvcf

    open form with blank fields when adding a new record

    I have a form that is used to add a new account. The menu form has a "add new acct" button that I have the following code: Private Sub btn_Add_New_Acct_Click() On Error GoTo btn_Add_New_Acctt_Click_Err DoCmd.OpenForm "frm_Organizations_and_Accounts", acNormal, "", "", acAdd, acNormal...
  15. cfvcf

    Visible property on a control on form

    I have a main menu that will display a dropdown control if they select a button on that form. I have the following code when the menu form opens, lost_focus, and loads: combo_Orgs_and_Accounts.Visible = False When they click on a button it displays the dropdown control. All of that works fine...
  16. cfvcf

    How to set default date to first of last month and end of last month?

    I have two date fields and want to set one to the first day of last month and the second one to the last day of last month. What would be the code to do that? Thanks!
  17. cfvcf

    Sort a grouped report on a field other than the group field

    I have a report that is grouped on employee id but I need to sort the group ids in an order that shows the employees with a higher total of accounts in the grouping first. The total is derived by totaling the counts of 3 other fields on the detail line. I thought that maybe I could code the...
  18. cfvcf

    Create a report with total line showing group totals

    I'm not sure how to approach how to create a report that provides total counts and percentages of a group of records for 1 person. Example: A record has an "employee id", and an identifier for the "quality of referral" for a particular loan. So I need to create a report that lists by "Employee...
  19. cfvcf

    Is there a way to determine "everywhere" a table is used in the MDB?

    I've inherited a DB and they have asked that I change the names of 4 fields in a table. How can I be sure I fix everything that uses those fields? Thanks!
  20. cfvcf

    How to code a Print button that shows the Standard Print Dialog box?

    Can someone point me in the right direction of what to code on a click event that opens the normal Print Dialog box where you select the correct printer, etc.? Thank you.

Part and Inventory Search

Back
Top