Help

Can this Criteria be Added to a DCount Expression?
I was able to glean syntax online for a DCount on a form that counts the number of 'misbehavior' incidents for students for the current day: =DCount("StudentID","Incidents","StudentID=" & Forms! frmIncidentSummary!StudentID & " and datediff(""d"",IncidentDateTime,date())=0"). However, there is another field, ... 21 Jun 2008 09:41

Question about error #2074 - "Operation not supported with transactions"
On Thu, 19 Jun 2008 07:18:15 -0700 (PDT), EManning <manning_news(a)hotmail.com> wrote: The term "transaction" more than likely refers to a database transaction. As in a stored procedure with: BEGIN TRANS --Do Something COMMIT TRANS or the transaction support in DAO or ADO. Is that what you are doing? -To... 20 Jun 2008 10:10

VBA Script Editor Opening
Hi! Just recently, I received complaints from users that every now and then the VBA script editor pops out for no reason. I made sure that the breakpoints have all been cleared before compacting the MDB application. I have tried to performing the linking of tables and compacting before I install them in th... 28 Jun 2008 05:33

query question
I'm a relative noob so if this is the wrong group, please point me to the right place... I have a table that contains events, including a date (date/time field) for that event. I'd like to construct a query that will return all events that happened in a list of years. Something along the lines of select... 19 Jun 2008 13:42

Question about error #2074 - "Operation not supported with transactions"
Using A2003. I'm receiving this error when returning from a "DoCmd.OpenReport..." statement. I have a tab control with a subform on every tab. The user selects an item from a combobox at the top of the main form which refreshes all the subforms. If this DoCmd statement is not executed, then I don't receive the ... 23 Jun 2008 11:41

Can't Add "Mode" to Quick Access Toolbar in MS-Access 2007
I keep selecting and selecting, but it just doesn't show up. I also have no button in the ribbon for this, or any ability to get into other modes via the Office button. It's very frustrating; I had to search online for a keyboard shortcut to be able to access Design Mode at all. I'm sure there is something I'm m... 19 Jun 2008 10:36

Code Doesn't Run some Append Queries
I can't see the wood for the tree's here, I have some code set up to run through a bunch of delete queries, re-append fresh information to local DB tables then run a report. But in the code below the Append queires (stDocName40 thru' stDocName45) don't run (info does not append to the table) when I execute the code... 24 Jun 2008 22:36

linked tables access - sql
Hi, I have succeeded another approach. I've created a local table with the names of all linked tables and I have a startupform which allows the user to create the linked tables based on the data in the linked tables. It seems you cannot relink tables linked to ODBC to .mdb and vice versa. So I added an additi... 23 Jun 2008 19:56

Find the right text in a combo-box list
Dear reader, In a combo-box there a possibility that by typing the right combination the string in the combo-box will grow to the correct combination in your pick list. So far I know is the property setting to achieve this Auto Expand yes. But the behaviour of my combo-box is not what I expect, I can only se... 19 Jun 2008 01:14

Find the right text in a combo-box list
Dear reader, In a combo-box there a possibility that by typing the right combination the string in the combo-box will grow to the correct combination in your pick list. So far I know is the property setting to achieve this Auto Expand yes. But the behaviour of my combo-box is not what I expect, I can only se... 19 Jun 2008 01:14