Search results

I've always like the regular menubar form older access versions. Of course with the ribbon in Ac2007 we don't have this anymore. I don't like the space that the ribbon takes up. So I've tried to combine a button with a listbox that unhides and hides. Then I use the listbox items to run a...

Okay, thank for the input.

I guess I wasn't quite being clear on what I wanted to do. I have a db2.form2 that I want to use. I'm not sure I can successfully import it into db1 to use. So I want to open db2.form2 from a button on db1.form1, and then fill in the pertinant info from db1.form1 on db2.form2 and run...

I'm wondering how to code opening a different database, then fill in some fields in the other database. I can use ShellExecute to get the other database open but I'm not sure how to fill in some fields on the newly opened DB. Can anyone help me?

The funny character actually represented an extra space for some reason. So I actually subtracted or added an extra space/postion with I did my InStr() and Mid() calculations. And this seemed to work.

That's a great suggestion. I found a work around and I'm afraid to put it back so I can test your thoughts. Next time I start having this problem, I'll remember your ideas. Thanks so much.

I've worked on it more and it seems to be associated with the Line Feeds, vbCrLfs. But I don't feel comfortable saying that the line feeds are the problems in every case. Thanks for helping me mull this one over.

Here is another example (FunnyChar2 attached) and I've included the entire code this time associated with this. The code that produces the line in question is at the end Forms!ChartPrescription!nNote = "Rx CALLED: " & Ph6 & " - " & PTF and seems to be 'Ph6' after I isolated it from...

I've posted 2 lines of of code. This one produces the funny char: fIP.Note = fIP.PreNote & " #" & fIP.tempSite & fIP.PostNote & fIP.tempImplant This one does not: strInsert = vbCrLf & vbCrLf & "********** " & Date & " POST-OP VISIT - #" & Me.ImpHeader I've attached a picture of the...

Here is what it looks like if I cut and paste directoy from the field. #4 4/17/2009 IMPLANT PLACEMENT - #11 , 12 , 13 , 14 - Astra I've also attached the image to this post. Have never attached a file here but it's called 'FunnyChar.jpg'. If you can't find the file, I can email it to you...

Here is the line of code that is producing the funny character. fIP.Note = fIP.PreNote & "#" & fIP.tempSite & fIP.PostNote & fIP.tempImplant The funny characters mentioned comes after the "#" and seems to be associated with Ampersands. But only the ones before and after the 'fIP.tempSite'...

No Just A2007 and the runtime that comes with it.

Has anyone gotten unexpected characters in runtime? I'm using A2007 and this does not cause or display any funny characters. But when I bring up the same record in runtime, I have a few extra characters displaced in a field. I'm not sure what these characters are. On of the ones I get often...

It worked on all my workstation except 1. I haven't yet figured out what the difference is yet.

Works Great! Thanks a million.

Boblarsen - I didn't notice the (1) either. Also good solution. Thank you. Raskew - I think you are right. I changed the ElseIf line from: ElseIf splitNumbers(i) > splitNumbers(i - 1) Then to ElseIf Val(splitNumbers(i)) > Val(splitNumbers(i - 1)) Then And it it seems to work. I...

Raskew - I think you are right. I changed the ElseIf line from: ElseIf splitNumbers(i) > splitNumbers(i - 1) Then to ElseIf Val(splitNumbers(i)) > Val(splitNumbers(i - 1)) Then And it started working. I haven't tried it extensively but it seems to work for a short list of numbers...

Gemma - there can be up to 32 numbers no including repeats Boblarson - your solution seem to drop the first number Here is what I think is the solution Public Function RemoveDblNums(strNumbers As String) strNumbers = SortDelimitedStringOfNumbers(strNumbers, ",") 'Sort Numbers first...

The problem I have is that If I fix the code to accept the highest number that repeats, it drops the lowest number that repeats. It seems I can't have both. Perhaps I've been working on this one too long.

I'm pulling my hair out and need help. I have a string of numbers separated by commas. I'm looking to remove any number that repeats. Examples: 1,2,3,2 returns 1,2,3 3,4,5,3,6 returns 3,4,5,6 3,4,3,5,3,6 returns 3,4,5,6 This all works fine, but when I try 8,9,8,9 I get '8'. but I want 8,9...