Search results

I am using an on-click event on my form to call up a report for the current record. It has been a while since I've used the form to call the report, but I always remember it working correctly. Today when I try to call up the report, it opens but no record is being pulled up so the report...

Beautiful, that worked. Thank you

I have button on my form that uses a selected record in a listbox (non multi-select) to run code that updates a table. The code itself works great so long as there is a record selected in the listbox. If no record is selected an error is thrown. I'd prefer the end user not to ever see that...

Hi cronk, thanks for the suggestion, I'm not sure how to do that though?

I'm using the following code to clear selected records from a listbox after a button is pressed: For i = 0 To lstProducts.ListCount - 1 lstProducts.Selected(i) = False Next The code works great except that it leaves the listbox scrolled all the way to the bottom...

I figured out what was wrong: i had to add a column number after .fields I changed: Me.txtHTDetails = myRecordSet.Fields to Me.txtHTDetails = myRecordSet.Fields (0) And it seems to be doing exactly what I wanted it to now.

Hi Spikepl, Thanks for responding to my question... I must be lacking some contextual background because I don't understand what you're asking me to do. Can you explain what you mean by "fields Collection" and "docs"? I haven't come accross these terms before, is this something I do within the...

I do something similar with my listboxes. This is the code I use on the "on dbl click" event: DoCmd.OpenForm "[Form Name]", acNormal, , "[PrimaryKey Field]=" & Me.[Listbox Name].Column(4) make sure the column number refers to the column in the listbox that will identify the...

Why not use the unique ID as a primary key so that duplicate records can't be created?

Hi Hassan! Welcome to the forum :)

My table: tblHeatTreatment - HeatTreatmentID - PK - HeatTreatmentDesc - Text - HeatTreatmentDetails - Memo My form has a listbox (lstHeatTreatments - Multi-Select disabled) that displays Heat Treatment descriptions and an unbound textbox (txtHTDetails) that I would like to have display the...

Ok, that's kind of along the lines of what i was thinking, so it's nice to know I was at least on the right path :) I haven't ever called a procedure before like you describe... it's one of those things things I've had on my "to learn" list for a while now... It looks like this will be a good...

I have a specification database that collects size information of a given product. Sizes can be entered as an integer into min / max fields, or they can be classified as "Varies" with a yes/no checkbox. On my form, I'd like to disable the min / max fields when the Varies check box is clicked...

I thought I had tried that.... but apparently i had made another tweek between trying refresh and requery as well. That worked perfectly. Thank you!

I have an close button on a form that is supposed to Refresh the subform of a different form and then close the form with the close button. frmOperations - no refresh / requery subfrmPlants - Needs to be refreshed / requeried frmPlants - Needs to be closed Currently the button effectively...

No worries. I'm always appreciative for your insight. I wouldn't have been able to figure the rest of it out if not for you pointing out why it was breaking in the first place. Thanks again :)

I just figured out how to do this: I changed the form property: "Pop up" under "Other", to yes. I can then set the open form code to acNormal instead of acDialog and I still get a windowed view of the form. Thanks again for pointing me in the right direction pbaldy :)

ah I see, are you aware of a way that i can open the form in dialog mode and still manipulate the control visible property? There is a combobox at the top of frmManagers that acts as a record selector. If the form is accessed from the main navigation form I want the user to be able to see...

I did something similar to this once... don't you need an image with a .gif extention?

I have two forms: frmOpeartions frmManagers frmOperations allows the user to assign a manager to an operation by selecting the manager record from a combobox. Occasionally the user may need to setup a new Manager record if one hasn't been setup already. In this case there is a "New" "button"...