Search results for query: *

I think I have solved my own problem... The subfolder names in my table were abbreviated. My hyperlinks are working properly. Hefly

I am able to open the root folder using the hyperlink, but cannot open the subfolders. For example, in the immediate window,the following folder will not open (10033.73 is a folder name): Application.FollowHyperlink "\\MyComputer\Project\_00000\_Check Requests\10033.73\" However, the root...

I have created a hyperlink field in my table (tbl_ChkRequests) using hyperlink datatype. The field shows the blue hyperlink but clicking on that field does nothing. I manually added # sign both before and after the sting which allows the hyperlink to function. Hovering over the field with...

Yes. The query as above written returns truncated records. Hefly

the field that is truncating is description. My form and reports derive its data from the query. I find that if I export to MS Word, all the data, including a record with more than 255 characters, is exported. I just can't see it on the form or report. Below is the field "description"...

I have refined my problem... The memo field is not truncating. I base my form off of a query. It is the query that is truncating the data in the memo field. Is there a way around truncating memo fields in q query? How do you access the data in your memo field if a query truncates it? Hefly

How do you change the default value of a memo field. Apparently the default value is 255 characters. If you change it to a greater value than default, will that delete the data that is already in the field? Thank you. Hefly

Yes PH. That works. Thank you! Hrfly

Problem: The field [PermitTerm] contains nulls. Where the field [PermitTerm] is null, all the queries I try only return nulls. I need to add PermitTerm to LeaseTerm and get a number answer. I need to change nulls to zeroes so I can use PermitTerm as a number to add to other numbers. I...

I figured this out!! Simply change the field properties in the query! Thanks. Hefly

My table stores the date in the Now() format. I need to run an aggregate query to count the number of times the record is stored by date, i.e. the number of times a record is intered on any given day. How do I convert? Thanks Hefly

Thank you! How do you set the data source? I changed the name of the data source to my appliction but it "reds out." E.g. I changed "Data Source=c:\Northwind.mdb" to "Data Source=F:\ReconApp.addcb" Hefly

How do you capture the users who are logged into an Access 2010 backend? Thanks Hefly

Duane. Yes, it was working before. Promted by your question, I went back and started changing the field names and the error re-appeared. What I found was I could resolve my problem by using expressions to use the original field names on a table with different field names. That worked! Thank...

My access report suppresses text and in lieu of the text I get the error message: #text! What does this mean? Thanks Hefly

Gentlemen: Thank you again for your attempts to solve the problem. Sorry I wasn't more specific. I was hoping to learn how to strip characters from either end of a string using a delimiter. Let's just simplify and focus on stripping just the first characters from the string. Let me...

The code stops at ParseComp3 = vData(1) Function ParseComp3(MyString) As String Dim vData As Variant Dim strMySeparatedString As String ParseComp3 = vData(1) vData = Split(MyString, ":") End Function

Thank you for trying to answer the question. The Function stops at strMySeparatedString = vData(1) Option Compare Database Function ParseComp3(MyString) As String Dim vData As Variant Dim strMySeparatedString As String vData = Split(MyString, ":") strMySeparatedString = vData(1) End...

(1) So I can have a string in a separate field that looks like: 1-60 12-60 13-66 (2) And a field which contains strings that looks like 14 1 22 (3) I also need to (a) strip the leading charaters before and including the : And (b) strip the end of the string that starts with SEC 14 SEC...

I have a variable length string. The beginning of the string begins with text followed by a colon. I tried to parse this in excel. I exported into an excel spreadsheet, but it converts the sparsed text into a date. Not a text string. Beginning of the string is as follows with the : as a...