Search results for query: *

Bingo! Thanks Cherio and Hymn!

The vertical bar disappears in design view, which is why I'm posting.

Greetings: On a data entry form (one record at a time), there's the default vertical bar to the left. When the form is first opened, it has a |> looking half-arrow at the top. As soon as the user types in any data, the icon shifts to a pencil looking thing with three periods. By...

Bummer. Is there a trigger to "push" data to that excel file instead of the excel file "pulling" data when it opens?

Greetings: An excel sheet pulls data from Access using ODBC. If the access application is closed, no problems. If it's open, I get the following: "The database has been placed in a state by user "Admin" on machine xxxx that prevents it from being opened or locked." The access file is set...

Microsoft Access is unable to load database properties." Anyone know what that error means? Thanks in advance! Chris

Greetings: We've got a quick and dirty CRM solution at beta out there on an Access file. I've just been told by an IT guy who I don't know well enough to trust/distrust that it's not a big deal to migrate and upsize an Access database to MS SQLServer. His recommendation was to keep beta...

One other thought: I'm not convinced tek-tips is frequented by the Unix community that much. You might try looking at openoffice.org's site for the forum they identify as informative. Also, you might poke around freshmeat.net and/or sourceforge.org. Both are sort of big in the open source...

PHV's solution worked great. Thanks!

In a previous life, I used 1.1 for production use. I now work at a MS shop, so it's not really feasable. The word processor is MUCH better if for no other reason it handles graphics and formatting much more intelligently. The spreadsheet is not quite as good as Excel (but let's be honest, Excel...

I went with Roy-Vidar's suggestion ultimately, but let the record show PH's worked too. Stars for both. Thank you both. CP

Syntax...ya mean they tax that too?? Greetings: I am trying to write a subroutine that gets triggered by clicking on an area before a "quote number" is filled in. Trouble is, my subroutine is coughing on the notion of "null", and I can't seem to get the syntax right. The line If J!QuoteNumber...

Inelegant as I thought that would be, it worked. Thanks for the help.

Greetings: The +/- symbol can be typed using <alt>+0177. The Not Equal Sign (= with a / through it) is a unicode symbol (U+2260). Short of the copy/paste silliness, is there a quick way to keyboard that symbol in a Word document (Excel for that matter). A minor thing, but kind of annoying...

Works like a charm. Thanks Ace!

Situation: ->Query 1: Asks for user, which drives Form 1. ->Form 1: The records that USER "owns". It could be many. Form 1 is basically there to give a list of the records that they are working on. Sort of an open items list. ->Form 2: The main data entry form for the rest of the work. ID...

Given a report. Fields are: Customer Name, Customer PO Number, Date. I'm grouping (in the report) by customer name. I'd like to have it give a new page every time I get a new Customer Name. Each customer name will have several Purchase Orders. Is this Possible...and if so, how do I implement...

Yeah, makes sense. I'll give that a try. Thanks. How do I &quot;Trigger&quot; that code? I am under the impression that access is all event driven. I appreciate the help, seriously.

Right. What happens is that the column break never happens. When the report's information hits the bottom of page 1, column 1, a new page starts (page 2, column 1). Column 2 never &quot;happens&quot;. That would have been nice to know. SOrry 'bout that. Thanks for the help.

Yeah, I was afraid of that. In my perfect world, the labels disappear with height 0 if the text box (that the labels are...labelling) has a null value. The two approaches that come to mind are: a) Blow away all the label boxes, and create text boxes. Have these look at the text boxes with...