Search results for query: *

From an Access performance FAQ: __________________________________________________________________________________________________________________________ (LDB locking which a persistent recordset connection fixes) When the symptoms encountered indicate that performance is acceptable with a...

In my database, I'm trying to make it so that a user may only edit the records of a table through a data access page (DAP), and not through the table itself. I know that this is already covered in the Access Security FAQ (Item 25), but I'm having a hard time understanding what it wants me to do...

Is there any way to make it so that certain objects, such as text boxes, load before everything else in a report? In my case, I have a text box that prompts an input box and returns a set of values, which the rest of the data in the report depends on. The problem is, sometimes this text box...

I have two queries, SQL is as follows: SELECT DISTINCT GAPS.GAPID FROM GAPS WHERE (((Month([Recieved]))=[Enter month (1-12):]) And ((Year([Recieved]))=[Enter year (yyyy):]) And (([GAPS].[Track])="EDI") And (([GAPS].[Status])="Completed")); SELECT DISTINCT GAPS.GAPID FROM...

Here is the way that my database is set up right now: 1 head guy < admin, access to everything 4 developers < users, access only to their specific reports, + the access page (which requires the edit permission for the table) Right now, the access page prompts the user on opening with a...

I have a report based on a query (from another question I had asked here) - here's the SQL example: SELECT Count(*) AS Cnt, GAPS.GAPID FROM GAPS WHERE *** (whatever criteria) GROUP BY GAPS.GAPID; Because of the &quot;GROUP BY&quot; statement, if no records match this criteria, then opening the...

OK - What I have now is a bunch of queries, a bunch of subreports to count the records returned by those queries, and finally, a few main reports to enter those subreports into. Here's the problem: A given query has a [GAP ID] field and a [BSR] field. Records can have the same &quot;GAP...

...is there a way? Thanks.

&quot;The database has been placed in a state by an unknown user that prevents it from being opened or locked.&quot; The above is the error that I frequently get when some script of mine runs that creates ADO connections. Apparently, the reason is that I'm creating the connection implicitly...

I've ended up having to rename one of the fields in my table. Ideally I'd just work around it, but it ends up creating some big problems down the line. Is there any way to update all of my queries/reports for this field without having to manually edit all 900+ of them? It'll only take me a day...

I know it has something to do with the size of the text box, but is there any way to force it to display 2003 without resizing? Thanks.

In a report, I have a field [SeqNumber]. I also have a text box that counts the number of records returned by the query that the report is based on: =Nz(IIf(IsNull([SeqNumber]),&quot;0&quot;,Count([SeqNumber]))) The above works just fine in this one report, but if I add it to another report as...

I'd like to make a button that, when clicked, resets the view of my pivot table so that all filters have all of their elements selected. The following line does this: PivotTable.ActiveView.DataAxis.FieldSets(0).Fields(0).FilterMembers = Array(&quot;all&quot;) When I click the button that this...

In other words, I have about 15 date fields in a page but definitely not enough room for 15 calendar controls. The way I've arranged them is so that they all surround a single calendar control. I'd like to make it so that tabbing through the fields displays their values in the control (works...

In a &quot;wizard&quot; generated data access page, if I have a pivotTable displaying the contents of my current database table, how do I make it so that clicking on any cell in the pivotTable will jump to the corresponding record for editing? I've done this MANY times, but it was always on...

Since I'm in a data access page and the method currentUser() is native to Access, I'm using the following: MsgBox MSODSC.Connection.Properties(&quot;User ID&quot;).value to return the currently logged-on user. But even though I've already set up a workgroup, the line above (which is bound to a...

MsgBox PivotTable5.ActiveData.Cells.DetailCells(0,0).Value It always gives me an error when it tries to run. Thanks.

...can it be done?

In VBScript, I'd like to make it so that if a selected record meets a certain criteria, then that entire record row will change color. There's so many elements of the table though, that I can't seem to make it happen. PivotTable.??? controls the cell colors? Anyone do this before? Thanks.

Dim db_05, rs_05 Set db_05 = CreateObject(&quot;ADODB.Connection&quot;) db_05.Open &quot;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:\Program Files\Access Pages\gap_db01.mdb&quot; Set rs_05=db_05.execute(&quot;SELECT * FROM dueWithin1Week&quot;) rs_05.MoveFirst '<<PROBLEM The...