Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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"...

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...

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...

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...

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...

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...

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...

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!

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...

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...

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!

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.