Search results

RG. That worked like a charm. THANK you for all of your help Detrie

Yes... exaclty...

Hi RG THANKS... that did it! However, for the sake of the posting, I used "MSG BOXES". I thought I'd be able to look the code and insert the code I actually need. Unfortunately I cant. I'm sorry, I thought I was being helpful I need to insert: If "InputBox" = Me.lstMyGroupsThen...

I have a form with a command button btnEditRecord. Also a listbox lstMyGroups The listbox (column 1) lists all the groups the user is a member of. This code will search the listbox(Column 1) for the entered "Group Number. If it exists, a message "You are free to edit this record". this part...

Hi All, I have a series of bound combo boxes on a bound form. In an effort to load the form quickly, the GotFocus event is set to get ROWSOURCE for that combo box. This part is great. My issue is when I open the form, because the ROWSOURCE for the combo boxes are not available until they get...

Hi Paul tblCampaign is a part of the live query... I removed the fields to save on space for this post... I was not getting any records returned.. BUT I think I solved the issue... I used upsizer to migrate into SQL Server. I had (BE.mdb) a yes/no field. Upsize made it bit length 1.... Part of...

Pul. Here is the actual SQL.. SELECT tblProjectSegment.chkCreativeServiceNeeded, tblProjectSegment.strStatusID, tblProjectSegment.dtmScheduledDate FROM tblCampaign INNER JOIN tblProjectSegment ON tblCampaign.lngProjectCodeID = tblProjectSegment.lngProjectCodeID WHERE...

Hi Paul... Thansk for your reply. I am using linked tables... However, I could only get it to work when I remove the *****Is Null Or Between [forms]![frm_reports]![from] And [forms]![frm_reports]![thru]***** Do I need to reword it? Detrie

Hello All, I have an mdb front end hitting an SQL (2005) back end. I have a form "frm_Reports" that lists reports and 2 controls "From" & "Thru" The user selects a report, enters a "From" and "Thru" date and clicks "btnPrintReport" The recordsouce on the Report is a SELECT query that...

Hello All, I have a form with a sub form The sub form contains +- 20 fields. The primary field is “S_Code” The records in the sub form always contain 1 “S_Code” value of Pendxxx (Pend223) After a new “S_Code” (new record) on the sub form is created, I’d like to use the data from 15 fields of...

Hello All... I could use a jumping off point. I have a table “tblResrvations” I have a table “tblEquipment” I have a form “frmReservations” with a subForm “frmSubEquipment” frmReservations includes 2 fields, FromDate and ThruDate “frmSubEquipment” has a ComboBox “cmbEquipment” When I create...

Hi Rural. At first glance this 'seems' to be a great jumping off point... I will take a closer look & post the results. Thank you Detrie

Hi Rural... I guess this where I'm having the trouble... I am able to bring the data together... The trouble I am having is getting "multiple Records" (with the same ID) into one new record. Detrie

Hi Guys, Thank you for your responses. I was only using the data within my application I would be fine but... The end result of this is exporting the data into Excel. From Excel, the data will evenetually be imported into othere non Access applications. Detrie

Hi All, I can use some help with a jumping off poit. *Please see attached file* I have 2 tables tblSFDC and tblTheCall tblSFDC (contact information) includes CustID (primary key) and a memo field "Notes" tblTheCall (call information) includes CustID (relates to tblSFDC) and "activity data...

Hi Rural.... Thanks for your response "What happens when I use...strBuild = Trim(me.cmbProjectCountry) & "Q" & Me.cmbNewQuarter & Right([cmbNewYear], 2)"????? IT WORKS PERFECTLY!!!!! Thank you Can you tell me why I needed to add "Trim"??? Detrie

Hi All, I just upsized my mdb to SQL server. I have a command button that is supposed to concatenate into one field. It worked fine in my mdb but is adding multiple spaces in my adp... The result of this string should be ... USQ107 Instead I'm getting ... US Q107 Can anyone see...

Hi Bob, Thanks for your response. I tried recreating the rowsource. When I enter the [lngProjectCodeID] criteria "[Forms]![frm_ProjectData]![frmSourceCodeInfo].[Form]![lngProjectCodeID]" Access complains with 'Unicode Literals' support not available in this server version.

Hi All, I just "upsized" an mdb front and back end SQL Server Express using the upsize wizard. I have a sub-form with a list box that does not seem to work. Here is the recordsource: SELECT tblProjectSegment.strSourceCodeID, tblProjectSegment.strEventCodeID...

Hi Bob, THANK YOU for the quick reply. That nailed it for me. The delimiter DOES indeed get placed for a blank field. I tested with a blank field and it all worked great! Thank you again