Search results

The TextPriceTotal is a control on a form. It is an unbout text field that calculates values Thank you for the help!

OK! Guys, my VBA professor responded and gave me the Fix: He had me pass the WindowMode argument equal to acWindowMode acHidden It opens the form but I don't see it and I close it before the Exit Sub. That was the only fix for this code to work. Thank you very much for all the help

So is there a way to open that form on the back end? The field [HomeFixtures] is an unbound field within my form that calculates several value and I need to transfer that value into another form.

Good day all my smart people, I need some help. First, please know that I have been working on finding a solution to this all weekend and read ALL the threads on this site on the following subject. Here is the code I have: Private Sub Form_Load() If Me.Dirty = True Then Me.Dirty = False...

Actually I just used the count method and it works but it removes my header and footer in the main form. Why is that?

Hi CJ_London. The form property does not have a recordcount method. Which other one should I try? me.subformname.form.recordcount is not valid Thank you for the help

Good day smart people, I have a main form ExpenseType with a subform Expense. How can I automatically expand the height of the subform based on how much date is in it Right now, I have 4 records in my subform but only 3 are showing. I've created my subform with dialog border style and neither...

Hello All, I've tried reading a few other threads on this subject but I just don't get it and I need help please. I have a form with a multi-value field called BuildingList. I also have a search form with a cboBuildingList and a cmdBuildingList. I would like to a form where BuildingList is...

Hello, I've tried every other format and it was the same and it seems like it just does not take portrait images. When I cropped that same image as landscape it worked. I'll have to do it for all of them :( Thank you so the help

Here you go! Private Sub cmdAddPhoto1_Click() Dim objPhoto As Object Dim strfile As String Dim strfolder As String Dim varItem As Variant Set objPhoto = Application.FileDialog(3) objPhoto.allowMultiSelect = True If objPhoto.Show Then For Each varItem In...

Hell Smart people, I have a form with several photos uploading via a command button. I've made sure the images are already rotated in a portrait position but when I upload them they come out sideways. Anyone can help please? Thank you,

Ok I'll try that. Thank you

Yes I understand, I have a form where certain controls appear if something happen and when those control disappear, I would like to footer to move up so actually I need the detail section to shrink automatically under the last visible control. I hope I make sense :confused:

Good day All and Happy Friday! Does anyone knows of a VBA code to move the form footer up and down based on rather there are objects there or not? I saw the Me.FormFooter but I went through the list and can't seem to find anything Thank you,

Thank you very much for your help! Got it to work with the BeforeInsert Event. Thanks again :D;)

:banghead: On the first form I have: Private Sub cmdOpenDeff_Click() If Me.Dirty = True Then Me.Dirty = False DoCmd.OpenForm "Frm_Deff", acNormal, , "RecID=" & Me.RecID & "" On the second form I have: Private Sub Form_Load() If Me.Dirty = True Then Me.Dirty = False DoCmd.OpenQuery "Qry_RecID"...

Thank you for the response! I did what you suggested however when I go in table 2, it adds another row and take the previous RecID to append it into the the previous row I need them to be on the same row while copying that RecID I hope this makes sense Thank you

Hello Very Smart People, I need some help! I have 2 tables: Table 1 has RecID (autonumber), field, field, field Table 2 has Tbl2RecID (autonumber), RecID(number), field, field, field Form 1 (from table 1) has a command that opens Form 2 (from table 2) When I click on Form 2, I would like...

Ok so I see what you mean and I've set it that way. Now I get the following error message "Runtime Error 3000 and Reserved Error 3201." Here is what I am trying to do, what am I doing wrong? Private Sub cmdSearch_Click() 'DoCmd.OpenForm "Frm_AHU", acNormal, , "EqpmentTypeID='" &...

So I have a form with fields from a table yes. I now have a form with a search command button and a combo box where I can choose an equipment type and subsequently I would like to for the cmd button to open ANY form that have that matches that equipment type and it's records. Here an example I...