Search results

On Click The code is in the On_Click event...I just tried it on the afterupdate event and I receive the same error...any suggestions? Private Sub cboLocation_AfterUpdate() 'look up address txtEventAddress = DLookup("Location_Address", "tblLocation", "Location_Name = cboLocation ")...

The following code below is producing this error.... "The macro of function set to the BeforeUpdate or ValidationRule property for this field is preventing Microsoft Access from saving the data in the field" I know its blowing up on setting cboEventLocation.text But I don't know why. Any...

I have my mail merge working...however when my query result set returns more than one record the mail merge stops on the first record..how can i get it to do a merge for every record? I'm using bookmarks in my word document..Thans in advance. Private Sub Command0_Click() Dim strSql As String...

Document.Open vs Document.Add? Thanks for the info...I've got it working w/ your sample code of using "Document.Open..........", but why wouldn't it work the same way with "Document.Add..........." ________ Macumba Dicussion

I have all my code working...However I wanted to set a password to a word document to open. I want to be able to pass the password in my code, but can't figure it out...Here's my code... With Appword .Visible = True ?????supply the password here to open document...

Thanks Got it working..... ________ Ipad cases

I'm wanting to write this query that looks at both tables and only returns records that don't match...not for sure how to do this.. SELECT tblCombined.DLID, tblCombined.DUP, tblCombined.QRYRAN FROM Susp_Master INNER JOIN tblCombined ON (Susp_Master.DUP = tblCombined.DUP) AND (Susp_Master.DLID...

Thanks Thanks for the suggestions....I didn't realize when you declare a Public variable it had to be in a module...I were declaring them as public within the forms itself...thanks again.. Kacy ________ PiercingsPussy

I'm attempting to pass a variable from form to form...I'm having trouble doing it...I checked the forum and read a little that the form I'm passing it from must stay open...is this correct? I have my variable as: Public strUserName as String. It does work fine if I leave the form open then I...

NeverMind I've got it....for any of you that are curious... =Format(DateAdd("yyyy",-65,Now()),"yyyy") ________ Herbalaire Review

I'm trying to add a txtfield that the control source is 65 years prior the current date. So the control source should come up with "1940". I've tried the datediff function, but not having any luck...any suggestions? Thanks. ________ Mexicocity Hotel

I'm attempting to use this piece of code... Set rstMerge = CurrentDb.OpenRecordset("qrypopulate", dbOpenDynaset) My query "qryPopulate" has two parameters SELECT ..... FROM qryEventInfo WHERE Location=[Enter Exact Location] AND Event_Date=[Enter Event Date mm/dd/yyyy]; However...after the "set...

I would like to use this bookmark code below, but instead of using the form fields use the result from a query...how would I do this? ''move through each bookmark in form .ActiveDocument.Bookmarks("Name").Select .Selection.Text = (CStr(Forms!applications_staged_development!FullNa me))...

Below is my code I need help with...when I hard code the values in for the bookmarks it works fine (like the date)...However...I want to be able to run a query and use the field names for the bookmark values...Please help...thanks. Dim objword As Object Set objword =...

I want to set a variable within my Access code...My code opens up excel and I would like to be able to keep the variable that I set in access, but I'm having trouble...Is there any way to set a variable in Access and have it carry over to Excel? Thanks, Kacy ________ Granny Webcam

I have a combo box that gets its data from a seperate table...In the table I have "Location_ID" and "Location_Name". When I save my form I want the "Location_Name" to save in the "Events" table, but its putting in the "Location_ID". How do I get it to save the "Location_Name" instead of the...

Thanks Pat, I understand about adding the "Contact" table nine times...I'm unsure on what you mean by adding a 3rd table with the data that repeats...Would you clarify please...I want to do things the right way....Thanks. Kacy ________ Rare Disorders Advice

There can be many contacts in one event. That is why I have them all linked. So: Event_RoR_Contact Event_RoR_Contact2 Event_MDU_Contact Event_MDU_Contact2 Event_Vision_Contact Event_Vision_Contact2 ....is all linked to the Contact_ID. They are all different contacts. Hopefully this makes...

I have two tables..."Contact" & "Events". I can have many contacts per Event. I want to write a query that lists everything in the "Events" table, but instead of using the Contact_IDs use the Contact's name corresponding to his own Contact_ID. Please help with me writting this query...I've...

The "Event" form is a pop up...I've found a workaround. I created another form and used a subform for the queries result set. I set this new form up as a pop up and it works fine. One more step, but it works. It would be nice to show the query results as a pop up though as well. Thanks...