Hi I have two tables, each having a text column with this value "P01_V0041_U0000.YC0". Using = returns nothing. Using Like returns more than I need. Is it...
93370
rkulez
Oct 1, 2011 4:47 pm
John, I am not good with vb, must I write the code like?: Private Sub Form_AfterUpdate() 'On Error On Error GoTo Err_Handler 'Purpose: Requery the combo that...
93371
John Viescas
johnvmvp
Oct 1, 2011 5:51 pm
Terry- Clearly, one of the two values doesn't exactly equal the other. Is there a blank at the end of the string in either table? LIKE should work as long as...
93372
John Viescas
johnvmvp
Oct 1, 2011 5:52 pm
rkulez- You didn't include the previous message screen nor all your code, so I have no clue what you're talking about. I handle dozens of messages a day, so I...
93373
Graham Mandeno
grahammandeno
Oct 1, 2011 7:26 pm
Hi rkulez (Please sign off your messages with your name – it’s much friendlier that way :-) What John meant was not to add another ‘On Error line, but to...
93374
Graham Mandeno
grahammandeno
Oct 1, 2011 7:35 pm
Hi Terry Further to what John said, if you have a problem with leading or trailing spaces, then you can use the Trim() function: WHERE Trim(Table1.Column) =...
93375
nkpberk
Oct 2, 2011 3:49 pm
Hi Group; Back with more near impossibilities :-) Expanding on A.D.'s faux continuous form (the color box thing) I also have a field in my "trains" table that...
93376
rkulez
Oct 2, 2011 6:21 pm
Dear John, excuse me please. You are right, I didn't included my previous message. My problem was: I have a pop up form with the code below and when I run it I...
93377
rkulez
Oct 2, 2011 6:27 pm
Dear Graham, thank you very much explaining John's message. I got it. English is not my native language and sometimes I make mistakes. Actually my e-mail...
93378
John Viescas
johnvmvp
Oct 2, 2011 6:44 pm
Do this: Private Sub Form_AfterUpdate() On Error GoTo Err_Handler 'Purpose: Requery the combo that may have called this in its DblClick Dim iErrCount As...
93379
djsdaddy531
Oct 2, 2011 8:16 pm
Great Day, I have a subform that allows the user to select a vehicle to be serviced. The user selects the vehicle from a combo box. The combo box has five...
93381
Duane Hookom
dhookom
Oct 3, 2011 3:03 am
Place a break point in the code and step through the code one line at a time to find out the values. If you don't understand how to add a break point or how to...
93382
amy_hollows
Oct 3, 2011 8:01 am
John, That is exactly what I want to do but when I went down that road I couldn't figure out how to get it to work. (=newbie) My search criteria are 3 data...
93383
John Viescas
johnvmvp
Oct 3, 2011 8:23 am
Amy- You have to build a dynamic filter string in code. Let's say your Listbox Row Source is: SELECT AutoNumber, Directorate, SAG, MDEP FROM MyTable; .. where...
93384
frank_guasp
Oct 3, 2011 3:42 pm
Hi Bill, Thanks. At this point I'm willing to try anything. I can append edit and delete within SharePoint. and sporatically via the Access Query. What...
93385
Bill Mosca
wrmosca
Oct 3, 2011 4:05 pm
Thanks, Frank. We'd appreciate the update. Bill...
93386
mrsgoudge
Oct 3, 2011 7:45 pm
Thanks John!...
93387
mrsgoudge
Oct 3, 2011 7:50 pm
Thru code in Form1 I am opening another form (Form2) and entering data into a combo box. This part is working correctly thanks to help from John. What I am...
93388
John Viescas
johnvmvp
Oct 3, 2011 8:14 pm
Connie- If the user updates the combo box on Form2, the AfterUpdate event should fire just fine. If you're setting the contents of the combo box from code in...
93389
mrsgoudge
Oct 3, 2011 8:33 pm
Thanks once again, John. I am deeply indebted to you and all who make this place such an awesome site....
93390
michael simpson
saccity101
Oct 3, 2011 9:03 pm
Hi there - Working on a drop down combo box for tenants on a work order form. At the moment I am getting multiple records when a tenant has more than one...
93391
Robin Chapple
d9790
Oct 3, 2011 9:16 pm
I have a series of reports that I print to PDF. The reports are based on an Access design that provides alternate shade to the lines. How do I control the...
93392
Robin Chapple
d9790
Oct 3, 2011 10:02 pm
I have a statistical report delivered as a CSV file which shows an error, - #Num! , in a limited number of cases, 7 out of 811, when linked to Access. The CSV...
93393
Clive
horastacatto
Oct 4, 2011 12:22 am
Hi Robin, Make a copy of the .csv file and open it with Excel. If you can't see anything wrong with the numbers then try using the Excel TYPE function in an...
93394
Robin Chapple
d9790
Oct 4, 2011 1:01 am
Thanks Clive, Excel is a new planet for me! I found "Insert Function" but TYPE was not listed. Can you describe the method please? I have visibly checked in...
93395
Graham Mandeno
grahammandeno
Oct 4, 2011 1:13 am
Hi Robin You will get the #Num! error if the field is defined as numeric, but there is non-numeric data in the cell. Are you *certain* that this is not the ...
93396
Graham Mandeno
grahammandeno
Oct 4, 2011 1:13 am
Hi Michael Do you mean you want to show each name only once, with any one of the related phone numbers (if there are any)? Try using a subquery to get the...
93397
Robin Chapple
d9790
Oct 4, 2011 2:32 am
Thanks Graham, To test my theory I edited the CSV file and deleted the content. I them added the figures. The result was the same. Cheers, Robin...
93398
liznewhome
Oct 4, 2011 2:43 am
Greetings! I have a report that I need to limit. The problem is that I need to limit by two fields, looking for the same value: I need all the entries where...
93399
John Viescas
johnvmvp
Oct 4, 2011 7:36 am
Liz- Just write it out as a WHERE clause: WHERE ([Hiring Manager Name] = [mgr1]) OR ([SAP Requestor] = [mgr1]) If you're on the query design grid, put [mgr1]...
