Bob- When I did this the VBA editor read the skinny bar as a carraige return, so your example above turns out looking like this:
vSearchFor = "i
"
x = ReplaceEmbedded....
Argh. A little bit of exploring and experimenting though has led me to chr(10) as the representative of the...
Bob- Thanks very much. This works well except for one problem: it seems that a number of the memo fields have a different kind of carraige return that shows up in the textbox as a lower-case "i" followed immediately by a skinny bar. It looks approximately like this: i|
This...
Hi-
I have a table that I need to distribute to people who do not have MS Access, so I am exporting it as a comma-delimited text file. Pretty straightforward, EXCEPT for the fact that one of the fields is of type MEMO. There are numerous records that have carraige returns in that MEMO field...
Woo-hoo! Today is exactly 15 months after the original post. I just set this up and it works great. Thank you guys-- you've provided a valuable service.
Woo- hoo!! Thanks, Junior. I was opening it in add mode but didnt realize it because there is another button that opens the same form in add mode, but the 'view' button doesnt specify the mode, so it must have just kept the previous add mode. Whew. I never would have thought to check that...
Hi- I have a form that used to work just fine but I must have dropped it on its head recently while I was tinkering in my db and now I just cant seem to fix it!
Form: Documents
based on: a query that pulls together three tables: documents, people, and links. (people and documents have a...
I'm sure this has a shamefully simple answer- but I just cant seem to get it.
I would like to declare a variable strongly enough that I can reference it from another application.
"Public X as single" doesnt seem to do it. How do a give a variable the kind of scope I need?!
Detail...
Quehay-
Thanks for your thoughts.
No there are no others users, no network-- just me.
I tried the FE/BE split a little while ago and it seemed to slow things down, but I wasnt having the freeze-on-compact problem then (I wasnt doing the auto compact, just manual, so I must have just been...
Hi - I have an Access 2000 database (~5 MB) and ever since I checked the "compact on close" box a couple weeks ago, the application freezes about 50% of the time I close the db. This happens after all of the open forms are closed, but before the compaction occurs.
Eh?? Anyone know...
Hi,
First....
THE QUESTION: How do I get a continuous subform that displays LINKED images based on a [filename] field in the underlying table??
Second....
THE BACKGROUND:
I have two tables:
1. Vessels
2. Images
and two corresponding forms:
1. a main form that displays vessel information
2. a...
Thanks for the help, Nancy2--
I've gotta run now but I'm going to try it out first thing next work day (Thurs)-- Looking at the VBA code: I feel a good learning experience coming up!
Andy
Nancy2, Of your 2 suggestions, I think the second is better--
Why?? I'd like to sin as such, not necessarily for data entry reasons, but because I'm pulling this info from someone else's DB. My 500+ existing Vessel records have this sort of information in a more narrative form in the Notes...
I have two tables, simplified here:
1) tblVessels
1000+ records
fields: Vessel_Name, Incident_Date
2) tblProblems
2000+ records
fields: Vessel_Name, Incident_Type, Incident_Severity, Incident_Cause
*There's a one-many relationship from tblVessels to tblProblems. Ex:
tblVessels: Titanic...
Thanks for the suggestion--I just checked out MapPoint at microsoft's website and it looks pretty neat. The problem with applying it to my mapping task is that I need to work with my own maps. I'm cataloguing shipwreck data so I have some images of coastal areas that I want to stick...
Hi,
I have received helpful tips from people at this site, so: Thank you!
What I'm working on now is this: Each record has a map (as bound object image) and coordinates describing its location on the map. I'd like to be able to -- in a form -- place a dot on the image according to the...
Hello-- I'm trying to find a way to use the date() function and OnClose-like events to automatically fill a field for "original input date" and "last revision date" (the first date 'sticks' when record is created, the second is revised with current date every time the record...
Hello,
I'm working on a form--a portion of which has two fields:
City:
State:
I'd like to write some VB code that would automatically fill the state field when the user enters a common city in the city field. I have a separate table with the same two fields and records like this:
1 Boston...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.