Search results

Question: usually if I open form in design mode, right click a control and select Properties, a panel popups with the properties of the control. However lately this property panel is not visible anymore. Any database. Please advice how to bring it back? I'm running Access 365 accdb

I save copies of my .mdb file daily for a month in a special folder. Database is actively used. Users add new records, queries. However the size of the database in Windows Explorer remains the same. Compact/repair does not change the size. I attach a snapshot of the folder ... Never heard of...

How can I view VBA code of macros? It was easy in Access 2003 but not in 2010. Thanks

I created Access database some time ago (Access 2003) and disabled design mode for users. Now IT installed Office 2007 to all laptops in the system. I want to " unlock" this "no design mode" state but do not know how to do this (Google does not help much). Please, help. Thanks Val

I need to insert department manager signature (we have 12 departments) into report. Depending on the department the signature would be different. I have scanned images of all signatures in the folder located at a remote network drive. How to place an appropriate signature? Can I use a hyperlink...

Our company (~1600 users) has many Access 2003 (mdb) files, that contain plenty of VBA and ADO via SQL Server. Currently they work OK in Office 2007. But the company is moving to Office 2010. Has anybody experience with mdbs in Office 2010 environment? Any problems? Thanks

Our Access 2003 application generates emails by using VBA. The sending part of the code looks like that: Set mMail = appOutlook.CreateItem(olMailItem) With mMail .To = strAddress .CC = strCC .Subject = strSubject .Body = strBody .Send End With Our...

We have a multiselect list box. User can select several items and insert them into a table (two fields, item ID and case ID) using Currentdb.execute "insert into ...". Later, when the user select the case again, how to make items selected according to the item IDs from the table? Thanks

Hi, my form consited of 4 pages and controlled by query (joined 2 tables). I added a new table to the query and another page to the form . This page contains several controls (option, check boxes, combo boxes, text boxes) with source - fields of a new table added to the query. None of the...

This is my query: =============== UPDATE tblMortalityReview INNER JOIN qryInitialUnit ON tblMortalityReview.EncounterNumber = qryInitialUnit.EncounterNumber SET tblMortalityReview.InitialUnit = qryInitialUnit.Unit; ============== Why it is not "updatable"? Thanks

I inherited Access 2003 database with autoexec on startup. It already contained RunCode function - it worked OK. I added a new function - and within the macro it is OK. However the macro stucks at this point with the popup: "The expression you entered has a function name that database can't...

I work with SQL Server 2008 with Access 2007 front end (using ADO). I can easily populate form controls using recordset. It does not look like I can do the same with reports. May be I am missing something? Thanks people

I was working on subreport (Access 2003 or 2007). Everything was ok. Then suddenly it does not open anymore neither in design nor in preview. Instead a pop-up appears: "There isn't enough memory to perform this operarion. Close unneeded programs ...". The data source for the subreport is a...

Access 2003/2007 Application.CurrentProject.Path - returns mapped drive path. Question: how can we get full network path, smthng like \\server\sharedrive\etc ? Thanks

I have Access 2007 front end to SS2K8. I have a local audt table that writes the date/time of user login. When the user closes the db by clicking Exit button the info from this local table is sent to Sql server back end. But ... when the users clicks X button it does not happen. Is there a VBA...

My Access 2003 (or 2007) has linked tables to SQL Server 2008. Forms, reports and queries are, naturally, local. Problem: all data nvarchar(max) fields are truncated in some very wierd way. How can it be fixed? Thanks

My app includes 1) SS2K8 database on the back end 2) Access 2003 front end NOT LINKED, data flows through ADO and stored procedures on the back end. ================= Front End consists of forms/subforms and local tables "connected' to subforms. Data flows that way: Sql server table <===>...

My access application sometimes creates backup files, like Backup Of + original file name. It looks like it happens when some error occures. It is Access 2003 mdb file. It contains a lot of vba codes. All subs and funcyions have error handlers and Error Trapping is set to Break on unhandled...

In my Access front end VBA code opens ADO recordset from stored procedure on remote SQL Server 2008. It worked OK for 2 years and SUDDENLY it stopped working. The code execution stops at line (see below) with popup: Run Time errror '3704' Operation is not allowed when the object is closed On...

Hi everybody! I need: 1) to send a parameter from Access into CR report 2) read the resulting field values in the report I have installed 1) MS Access 2003 2) Business Objects/Crystal Reports 11 ============== Questions: 1) which library should I reference in VBA? 2) which properties of the CR...