Search results

thanks missingling. That's not happening on my form, so I'm not sure what I'm doing wrong. I enter the form from another that checks to see if an invoice exists for this record and if not: DoCmd.OpenForm "frmInvoice", acNormal, , , acFormAdd The invoice number is "new" and remains that...

I have a main form and subform. The main form is bound to a table of invoices and the subform to a table of invoice items. I'm picking up the invoice number from the form to save it to the invoice items table, so I need to save the record for the invoice before saving the invoice items from...

Thanks SOS. Got it to work: Me.Textbox1 = DLookup("[LastName] & "", "" & [Title] & "" "" & [FirstName]", "[table1]", "[ID] = " & contactnumber)

I have a textbox on a form (form2) where I need to set the display with vba as it may change depending on the data selected in a combobox on another form (form1). I'm using the following code in the form (form2) OnLoad event: Dim contactnumber As Long contactnumber =...

I'm struggling with how to design my form and any help would be greatly appreciated. I have three tables: Table1: Information about an event Table2: Information about the room(s) assigned for this event Table3: Information about the group/contact person for this event I have a main form for...

Thanks Mihail. It worked to refresh the main from the close event of the lookup form and then place the code to populate the fields in the current event of the subform.

Thank you Pat. Which form event is used to refresh?

I have a main form with a subform. On one of the subform controls, there is a double-click event which brings up a lookup form. The user selects the record and this updates the table and closes the subform. I want to refresh the other unbound controls on the subform when the user selects a...

Now why didn't I think of that!!! Thank you so much

Thanks pbaldy. This makes the control visible/invisible. I want the control to be visible but the data inside the control to not display. I've tried setting the controlsource of the control to "" and then using dlookup to reset it, but not having any luck.

Is there a way to display/hide the information on a subform using a checkbox? So, when the checkbox is checked, the fields are blank but when the checkbox is unchecked, the information displays? Thanks!

I'm trying to delete an Outlook 2007 calendar appointment through Access 2007 with the following code: Dim oApp As Outlook.Application Dim oAppt As Outlook.AppointmentItem Dim oCalendar As Outlook.MAPIFolder Dim oNameSpace As Outlook.NameSpace...

I need to update a table row based on a summation of rows in another table (a mixture of numbers, text, y/n, and date fields). Any suggestions would be greatly appreciated! Thanks

I'm trying to open a recordset in a form using a query (NET_qrytotals) in which I total all records: SELECT Sum(NET_tblReservation.NoParticipants) AS SumOfNoParticipants, NET_tblReservation.RRID HAVING (((NET_tblReservation.RRID)=[Forms]![NET_frmRoomReservationRequest]![RoomRequestID])); I...

If I create a query using the subform recordsource and add a column in the query for each day of the week (using the control source on the form, ie =IIf([txtSun] Between [StartDate] And [EndDate],[Event]," ") ), it results in the correct data. However, it is intermittently not displaying the...

OK here it is. Test 2, 3, 4, 5, and 7 display OK on the calendar. Test 1, 6, and 8 do not. Thank you so much for any help you can give!

Thanks Adam. It will take me awhile, but I'll do that as soon as possible. Thanks again!

I have a form and subform in the format of a calendar. The form displays the dates for the week, the subform the "happenings" for that week. I'm having intermittent problems displaying the "happenings" on the correct dates. I can't seem to find a pattern to the problem. I can show the...

I have a form based on this query: SELECT qryReservationsMC.*, IIf([AddedToOutlook]=True,"*","|") AS Status FROM qryReservationsMC WHERE (((qryReservationsMC.EndDate)>=Format([Forms]![frmCalendar]![txtDate],"Short Date")) AND...

How do I loop through data and get it into the following format: (value, value, value) ...with commas separating the values?