Recent content by bluetongue

Another siyuation which can generate this message - if you have multiple users using a networked database that is not split into front and back ends then any user who hits the save button will lock the rest out.

When attempting to convert the database on my work PC I received several "File not found" messages from VBA. When attempting the conversion on my home PC there were no "File not found " messages instead I received a message stating "The database cannot be opened because the VBA project...

I used the Linked table manager to relink the files. The problem occurs during the conversion of the form - VBA displays a number of "File not Found" messages in rapid succession.

I have a database in Access 2003 format with the backend on a network drive and the frontend on individual PCs. I converted the backend to 2007 format. then converted the frontend and relinked all the tables. The code behind the forms no longer works giving a 'File not Found' error when...

Petros You will find a lot of good information and examples using Outlook and Access at http://www.helenfeddema.com/access.htm

The Access Archon articles at http://www.helenfeddema.com/access.htm contain several examples of linking Access to Outlook

I have used this code to restrict the functions users can perform: I have a table (tblUser) - if the user's ID is in the table they are able to edit data otherwise they can only view. The code is on the load event of the startup form and is only sufficient to keep out users with minimal Access...

Perhaps you could try making the Excel workbook a shared workbook.

Why not use two tables witha a form and subform? This code on the afterUpdate event of the subform, will detect when the student attempts too enter more than six choices. Private Sub Form_AfterUpdate() Dim numRecs As Integer Dim fred As Variant numRecs = DCount("CourseID", "Enrolments", "key =...

oops Mystr = Right(" " & Format(5459.4, "##,##0.00"), 9) ignoore the comment6 ' Returns "5,459.40".

try something like Mystr = Right(" " & Format(5459.4, "##,##0.00"), 9) ' Returns "5,459.40".

Is it possible to format a textbox with 'Cam Grow' - yes with a hanging indent?

If you do not specify the column headings in a crosstab query then any column with no data will not appear. This can be a problem if you have a report based on the crosstab query or if you want to use the crosstab query as the data source for another query. It is often easier to paste your SQL...

Thankyou for your replies. It seems to me that a better layout could be an item for a wish list.

Is it possible to permanantly change the layout of the query design window? keeping a larger upper pane, total window height and table image size. There was a similar unanswered query in 2006