Search results for query: *

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...

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...

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...

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...

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...

I’ve got a report where each record has quite a few fields worth of data. What I’d like to be able to do is set up the page to print in two columns. Page Setup/Columns lets me set up multiple columns, but they don’t get expressed (at all) come print time. Is this because each record is basically...

Here’s what I’m trying to do. I have a table full of items called T_Equipment. Sometimes, an item will be a combination of several items in T_Equipment (e.g. a motor + a base plate + some screws, etc). I have a table called T_MakeUps that has this information. T_Equipment has (among other...

It’s easy enough to get the text box on a report to shrink to 0 height if it’s null. No problems. I’m struggling with the label that’s associated with those text boxes. What I’d like to do is get the heights on those set to 0 when the text boxes they label are null (have no data). Labels seem to...

I get the bug on the -->> line. The debugger claims: Type Error MisMatch Dim db As Database Dim rec As Recordset Set db = CurrentDb() -->>Set rec = db.OpenRecordset(&quot;T_AppSegment&quot;) The table exists and it's spelled right. Any clue why I'm getting a type error mismatch? I'm sure it's...

Greetings: This should be easy, but I'm stuck. Table A has an arbitrary number of &quot;Hf&quot; records associated with the &quot;ID&quot; in Table B (which is the main table). What I'd like to do is run a simple SQL statement to sum up all the Hf from Table B, that correspond to the ID of...

Situation: I'm getting an error on a form that gives me the following error: LinkMasterFields property has produced this error: A Problem occured while Microsoft Access was communicating with OLE Server or Active X control. I also get some funky &quot;out of memory&quot; errors if I continue...

Is there a way to tell Access to compact/repair database in VBA? You can do it easily enough when the database closes (tools/options/general), but I'm curious if there's a VBA command that'll do it. Not a huge earth shattering deal if I can't. Just curious in the event I've got a project down...

Relatively easy design question Related to an earlier post. I've got a bunch of input fields. And these drive some non-trivial calculations. A!FlowRate, for example, is a deal breaker. If that is zero, I don't even want to bother calculating anything. Is this appropriate design? Public Sub...

Greetings: I can't quite get this syntax right. A is a form that I'm entering data in. The field &quot;PipeSize&quot; won't have data in it until the user puts in data (from a pull down if that matters). If the cell is empty, that's a problem for the calculation downstream, so what I need to...

Greetings: I can't quite get this syntax right. A is a form that I'm entering data in. The field &quot;PipeSize&quot; won't have data in it until the user puts in data (from a pull down if that matters). If the cell is empty, that's a problem for the calculation downstream, so what I need to...

Greetings: Is it possible to deploy an Access application to users who do not have Access? For those users, should I include search and filtering capabilities on forms and whatnot that is sort of native to users who have access? This is one of those questions I wish I had been smart enough...

Greetings: I've been following the Open Source Code movement for the last year or so. This is obviously a topic than can incur rancourous debate -- I'm of the opinion that open source software is appropriate for some applications and probably inappropriate for others (some banking applications...