Search results

I'm attempting to do a LIKE statement from user input on a form. So basically the user would put part of name in a text box and do a search on it. I can't get the like statement to work. Please help. SELECT dbo_COPYWORK_INFO.* FROM dbo_COPYWORK_INFO WHERE dbo_COPYWORK_INFO.NAME LIKE "'*" &...

I have an sql that runs.... UPDATE ProblemLog SET ProblemLog.Status = "Pending" WHERE [Problem Number] IN (([Forms]![frmPendEm]![txtProbNo])); Problem Number is autoGenerated primary key. When I put in say...26, 27 it updates 0 records. Put 26 or 27 by themselves and it updates 1 record at a...

I have an insert query that works fine when all fields are entered: INSERT INTO tblMaster (Fname, Lname, Address, Address2) Values ('Cozmo', 'Kramer', '1Main', '2Main'); BUT...if I have Address2 as blank b/c its an optional field I get a validation rule error...even though there is no...

The following query works, I'm just wanting to add a date parameter (below)...When I add the data parameter it seems to ignore that criteria. I just want to add this: Event_Date Between [Enter Start Date mm/dd/yyyy] And [Enter End Date mm/dd/yyyy] WHERE...

I'm trying to test the itemdata function but having no luck... I have a combo box ("cboSiteManagers") that contains ID, Fname, Lname I've tried the following code msgbox cboSiteManagers.itemdata(3) But I get an error that says "Invalid Use of Null"...there are around a hundered entries in...

"File Error. Some number formats may have been lost" I'm receiving this error when Access executes the w/ the following code... DoCmd.OutputTo acOutputQuery, "qryRoRWebUpdates", acFormatXLS, "RoR_Web_Updates.xls", True However the data within Excel looks fine... Is there a way to avoid the...

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...

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...

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...

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...

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...

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...

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...

Is there any way to have a query result set be a pop up? I have a button that opens a calendar on the "Event" Form...from the "Calendar" form you can select a date and click "check availability" which closes the "Calendar Form"...the result set is under the "Event" form...I would like the...

"Find" Code I have a "Find" button on my form (code is below)... I would like to write some code after the record is found that displays a label on when the record was last updated. My problem is I don't know where the code runs to after the "Find First" button is pressed. Please...

When I click a tab (table,queries,reports or module) I receive an error that says (" isn't an index in this table. Look in the indexes collection of the TableDef object to determine the valid index names). Please help. Thanks, Kacy ________ P