Search results for query: *

That fixed it...I appreciate everyone's help in this trivial, yet frustrating problem. Scott

In regards to the cd software setting a flag...do I need to use some sort of cd burning software to "uncheck" this read only condition or use Access. The reason I ask is the only burning software we have is on one computer and the rest can read what is burnt, but they can not burn...

I am not trying to use the database on the cd, I am just using the cd as a medium to move the database. When I copy the db off of the cd onto another computer, it is in read only mode. Did you mean that this can't be done? thanks, Scott

We have an Access database in our office that we are trying to put onto a cd(small database). Everything that has been tried thus far has resulted in the database being opened in read-only mode when executed from the cd. How can we make the cd version of the database open in the regular mode...

It worked like a champion including the start position. Thank you...I didn't think this would ever work!! hats off and giving props to cmmrfrds sdb0812

cmmrfrds, I tried using the instr function but it wouldn't work with the "*". I tried another character that is in my data, which is the "(" and it was found, but the "*" is still eluding me.

Is there any way you can search a particular field in a table and find a wildcard? In my case, there are records that begin the the character "*" and I need to find them all. Everything I have tried thus far is using the "*" as a wildcard and is not searching for the...

Thank you for the response. I think I found the problem. For some odd reason, the text boxes in the report were different sizes and that is what was causing the formatting problems. I manually made all the boxes the same size and then it worked fine. I am going to try your method too. scott

I have a report that looks fine when I view it in Access. The problem I am having is I allow users to email reports and when this is done, the formatting of the report gets distorted. I email the report as an email attachment using the sendobject and formatted as rich text. Any ideas as to...

Duh...lol I have never won a spelling bee and now you know why. You are correct and it works like a charm now!! Thanks a million, Scott

That is what I tried to do early on but for some reason I kept getting an run time error saying, "The object doesn't have access to object or method". The code I used is below: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Dim result As Boolean result =...

How can I make a text box in a report not to be visible to the user if the value is "" or Null?? I thought this would be simple, but I haven't found a simple solution or even a solution at this point. thanks, Scott

Hello, I am trying to pass two date parameters into a query in order to view a range of information in a report. The code below is what I am currently working with. If IsDate(txtStartDate.Text) Then StartDate = "'#'" & txtStartDate.Text & "'#'" If IsDate(txtEndDate.Text)...

I am currently having two problems. The first is the order in which two controls in a subform are being displayed. In design view, I have them arranged one way, but when I view the page in form view, they are totally rearranged. The second problem I am stumped on is with this same subform. I...