Search results

We have an accdb database developed in Acc2010 on an XP PC. On a new Win7 PC with Acc2010 the database worked fine for UserA, but UserB on the same PC got the error: Function is not available in expressions in query expression "Ucase([MyField])..." (Ucase() is the only function in the query...

We have a split ACC2010 database, with the back end on our server and 5 front ends on 5 client PCs. I hadn't run a compact/repair on the back end for months. When today I tried, I got the 'database is locked' error. The lock file showed 'Admin' logged on at all 5 clients. The front-ends had been...

I've followed How To Create a Shortcut Menu for a Form... to create a shortcut menu bar. At the moment my shortcut menu just has buttons, e.g.: cmbRightClick.Controls.Add msoControlButton, 21, , , True Now I'd like to add the advanced filter menu (FilterAdvancedMenu) to cmbRightClick...

In Acc2010 we are experiencing this error with a simple one-to-many updatable query, with the following message: The current field must match the join key '?' in the table that serves as the 'one' side of one-to-many relationship. Enter a record in the 'one' side table with the desired key...

A recent mysterion. Users running Windows XP or Windows 7 Pro could run my Access 2010 split database perfectly, until the recent Office SP1 update. Now XP users are still ok, but Windows 7 Pro users experience a "Microsoft Access has stopped working" crash with one particular form (the other 40...

My recordset is based on an updatable query that includes four parallel left joins. Basically what's happening is a shopping basket. Items are added en masse (in code) and then we go through each item (e.g. avatars) in code selecting the attributes we want (black hat, blue jacket, red shoes...

Can anyone steer me to the best way to link a table in an access database hosted on a remote server to a table in an access database on a local PC? A data access page on my website (created in FrontPage2003) is collecting names and addresses for mailings, now I need to harvest that data onto my...

My ACC2000 form has some controls that on the OnCurrent event are conditionally made invisible. I also need to adjust the page margins programmatically. In ACC2000 this must be done using PRTMIP which necessitates loading the form in design view (DoCmd.OpenForm frmMyForm, acDesign) setting the...

In ACC2000 on a PC set up for UK time/date format (DMY) how should you include a VB date variable in a SQL criteria statement? I'm finding that when dteTestDate is 12May it is evaluated in "SELECT * FROM tblMyTable WHERE SourceDate = " & #dteTestDate# & ";" as 05Dec. I've now learned that...

I have a strange bug in Acc2000. For any main form with a subform, when I am designing the subform within the main form and I alter and save the datasource of the subform, the datasource of the main form mysteriously changes to the same datasource. :eek: Drives me nutz. Has anyone else seen...

I understand that Jet 4 has a 2048 limit on the number of TableIDs which if exceeded leads to this error. My form uses 1 bound table, 2 recordsets in code, 1 clone (opened, closed and nothinged in 10 lines) plus a 5 x25 array of combo boxes whose sources are 14 x25 tables (as part of queries)...

My objective is to display rows of data on a form in the 'page' format, with each 'page' within the form showing a fixed number of rows, just like a Google seach page for example (or this forum). (If anyone has seen this done successfully in Access then please let me know!) Mostly I need to...

On MyForm I have a group of controls that are populated programmatically from MyQuery which includes a criterion using one of the forms' controls: ... WHERE MyField = Forms![MyForm]![MyControl] The recordset for the controls that are populated programmatically is loaded on the form's OnLoad...

A tricky question. In Acc2000 I've got a combobox control on a continuous subform which refreshes on the OnClick event so that the user can select a value for that row from a small number of choices. Often/usually there is only one choice, so my users have the unentertaining task of clicking on...