Search results

I looked over the forum and could not find this specific issue... I have an Access 2003 db on a shared network that has been running fine for years. Some users are now updating to Office 2007 (Access 2007) so it is now a mixed bag of Office 2003 and Office 2007 users. We are finding that some...

Good day all! Question, does anyone know of VBA code that i can put on a report that will allow me to display pictures from a web server? I am using this code and a Web Browser Control to have the pic display on a form but it does not work for a report. If Len(Me![ImagePhoto]) <> 0 Then...

Hi all, I searched and couldn't find an answer to this question. I am using access 2003 as a frontend and Sharepoint 2.0 (web) as a backend to store tables so that users can access the DB outside of the network by having the FE installed on their laptops and its linked to the tables on...

Hi all, I have an issue that really has me puzzled. In short, i have a memo field where the cursor automatically moves back to the start of the field everytime i start typing additional text into the field. I changed the cursor behavior to automatically move it to the end of the field by going...

Hi all, i am aware of the method used to move a control to the left or adjust its height/width but is there a way to move fileds down to a specifc location using VBA? I've looked everywhere but couldn't find an answer. Thanks.

Hi all.. the answer is probably "no" but i'll pose the question anyway. Is there a way to add extra grouping on a form like you can on a report? For instance, the form (as well as the report) has a header and footer grouping; however, the report also will allow you to add grouping based off of...

hello all, I've designed a database and i want the capability to provide demos via CD but i want to maintain the security setup so that the veiwer would need to know the password to view the demo. Is there a way to dynamically point the DB to a security file that is located on the demo CD...

Hello all, I have a report where i'm trying to get an average from three fields using: =Avg([Profile Accuracy]+[RA Accuracy]+[RC Accuracy]) However, it keeps returning the total. Any ideas? I.e. 3.4+2.0+4.6 to give me an average of 3.33 but what i get is 10.0 Thanks in advance. Ray

Hello All: I searched the forum but could not find the exact question or answer i was looking for. I have a form named Contract_Profile that is used for data entry, for this example the field name is Contact_Name. Form2 also has a field named Contact_Name that auto populates the value from...

I have a table called tbl_Profile and two queries, one for the frm_Profile and one for a report. When i try to run the report i get error 3211 "The database engine could not lock table "tbl_Profile" because its already in use by another person or process." I am the only one using the database...

Good day all: I have a form letter generator setup in my database and when filled in and i click an email button, it transfers the text of the letter to a MS word template i have setup with various fields encoded. The text appears in its appropriate field after the merge but i'm noticing MS...

Search the forums and did not see a specific question/answer to this inquiry. On the form, if you have Record Lock set to Edited or All Records, access alerts the user with a beep if two or more users try to edit the same record. Is there a way to add a message box to the beep that actually...

I have a button setup on a helpdesk ticket form that should save the record in the original helpdesk table and then open an Append query to add the record to an audit trail table to keep track of when we've updated info. The issue is it sometimes saves the updated info in the append query/table...

Good Day! I have a form setup with mutiple fields: Deliverables 1-35 (text fields) Results 1-35 (Combo Boxes) Comments 1-35 (Memo) All fields are necessary for this form but depending on the circumstances, we may only use a few as oppose to all 35 for any given record. So what i've done is set...

Good Day! Anyone know a reason why VBA procedures would stop working once a database is converted from a .mdb file to a .mde file? I thought the only difference in the two formats is the .mde will not allow changes to the design. Thanks!

Happy Friday! One lingering issue i hope an expert can help me out with. I did a search but didn't find this exact problem/solution. I have a database setup with a procedure on the Load event and module that locks my mouse wheel so it does not scroll to another record. It works fine for me and...

Hello all, i have a strange issue i hope someone has seen before. I have a main form with about 20+ controls on it, one of which is an Audit Trail filed using a combo box and a Module setup on the BeforeUpdate Event to check and list any modifications to the saved record. The audit trail gives...

Good morning, I have a multi user database setup with a FE and BE. The BE (with tables)record locking is set to no locks and i have installed a copy of the FE (with queries, forms, reports, etc.) as a mde file on each of the users C drive with a shortcut to their personal FE on their desktop...

I have a database setup where the main form produces an autonumber which i use as the ID field to identify the record. There are also several other forms that i tie to the main form with the same ID number and the relationship is set to One To many to keep each main record and the subsequent...

I have multiple users getting the message "Unrecognized database format:" and it gives the location of the mdb file. Does anyone know what this means?