Search results

Thank you...Wish I would have posted that earlier....I tried for two hours. ________ AdorableBrina

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 "'*" &...

Explain The instr function works, but could you please explain what its doing. I know the instr function returns the position number the first occurrence of a string is found....but I don't understand what this update query is doing. Thanks, Kacy ________ Suzuki tu250

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

Thanks, I think I have a pretty good understanding know thanks to all the posts...Thanks to everyone. ________ Homemade vaporizer

Makes Sense In the combox property though the bound column property is 0...that is what Access defaulted it to when I created the combox....It bounds the FieldID that is invisible. ________ Herbal Shop

Please Explain I have the bound column property of my combo box set to 0. However in my code before I run it I have to set the bound column to 1...otherwise the itemdata returns null. When the record is saved it does use the 0 bound column. I'm wondering why would I have to set the bound...

Got it figured out for anyone that cares...it was throwing a fit b/c my recordsource of the cboSiteManagers did a concat on two fields..(...id, fname & lname). It didn't like that my column width property was only "0";"1" instead of "0", "1", "1"... ________ Fix ps3

the itemdata line of code returns null when the bound column property of the cbo box is 0. It returns data when the bound column property is set to 1...However I need it set to 0... any ideas Dim i As Integer i = 0 For i = 0 To cboSiteManager.ListCount - 1 If cboSiteManager.Column(0, i) =...

Working IF... I got it to work if I changed the bound column to 1 instead of 0...However it should be 0. If I try to change the "Limit to List" property when the bound column is 0 I get this message....Microsoft Access can't set the LimitToList property to No right now. The first visible...

I've been trying to think of a better way to explain what I'm trying to do...basically when 1 combo box is selected i want another combo box to default to a certain value. Below is the code i'm trying...I'm using 173 to test with...normally this would be a variable. I'm wanting to default on a...

its in an afterupdate event of a combo box....ideally depending on what they choose from this combo box it will run a query and default another combo box to a particular value based on the first combo box But for now I'm just trying to get a msgbox to display the info of a particular record in...

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

stumped on itemdata I'm trying to test the itemdata function but having no luck... I have a combo box ("cboSiteManagers") that has the 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...

I'm actually getting the error in Excel...any ideas? ________ SICK FROM PAXIL

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

Will try a query instead...I'm not familiar w/ dlookup, but that is good to know. ________ Slow Deepthroa

A bit more information... the cboEventCounty the row source for this is SELECT DISTINCTROW [tblCounty].[ID], [tblCounty].[County] FROM [tblCounty] order by [tblCounty].[County]; So there is actually two columns in this cbo...would this make a difference? ________ Waterbongs