Search results

Client upgraded from office Access 2013 to office 365 and the Cloud. The program was created on Access 2007. The program works fine on current computers. Client purchased new computers with Access 365 on it. The program now shows an error coming from a module. The References in Access 2007...

Need help in finding out how to unhide a module. When the code reaches the statement "Call PersonalCalandarRead_AddN2" it gives me this error message that says: Compile error in Hidden module: Form_frmPersonalCalendarOutput_22_2Opening. This error commonly occurs when code is incompatible...

Problem with A2013 running an A2007 database: After installing an A2007 db (created in 32bit system) on the clients computer 64bit running A2013. The A2013 removes all the VBA and Macros when opening the A2007 database. Before I installed A2007 to the client's computer my computer crashed...

Having problem with loops. The inner loop updates a table. The outer loop pulls the record number from the "tblChangeOrderTable_Edit_Count" and is assigned to strRecordID . The inner loop uses strRecordID to find the right record. I keep getting errors like (Object variable or With Block...

I have a union query that combines three queries. I'm using Access 2007. Every time I run it I get an error message "Data mismatch in criteria expression." I checked all queries and they work great. Then I ran the union query with the first group (Select) and first Union Select. This worked...

I have a query to count the number of rows in a field that contains number data. The problem is when there is no data at all, I can not get a count of 0. This gives me problems with other queries that uses this data. I am using Totals in the query with the field count to count the records...

I have a textbox in a report that shows both positive and (negative) numbers. The negative numbers are displayed as (10). My problem comes with alignment: 100.00 (50.00) I tried to adjust the positions of the textboxes with the following vba code using twips in the Detail section. When this...

I am trying to create a Word document using WordApp in a class module. I copied code from an Access program that works. I am using Windows7 and Access 2007. I am lost. what Reference do I need to use WordApp? what call statement do I use. I am using Call CreateChangeOrderReport and it...

I have a combo box that is driving me mad! I am using A2007 and this one combo box is returning the first record of a query no matter what record I pick. My other combo boxes are working fine. When I pick a record the "after event" works fine by placing the data in the proper text boxes and...

I have an Access 2000 dB with permissions. I need to convert the database to Access 2007. When I open the A2000 dB in A2007, I get an error message saying I do not have permission to open it. I do not have A2000 on my computer along with passwords. How do I convert this A2000 program to...

I have the problem with margins while Printing #10 envelopes. In an Access 2010 stand alone version; after selecting envelope from page setup, the left margin is .65 inches. No mater what I do, the margin defaults back to .65 inches. How do I get it back to .25 inches? A 2007 works fine but...

I have a computer that is using a stand alone Access 2010 with Office 2003 in Windows XP. I installed a program that manually inserts an image, bmp, into a textbox with the property of Ole Type Allowed = Linked. When right click the text box and insert object..., the image is selected and when...

I have a query to show all data for a set of many criterias. As long as I do not compound them like ( 1., and 2. and so on), the below query (1.) works great. This works great: 1. like "*" & [forms]![frmfindTransaction]![text32] & "*" I want to mix the above with the following so I...

:(I am working with Access 2010 and all of a sudden I get this error message when I click on an Event procedure to edit the code "Microsoft Access has stopped working." I have the protection code turned on with a password. Since I cannot turn the password off and cannot get the code, I can't...

I am in a subform and trying to put the selected record's workorderID into another form (frmworkorder) and then populate all the the related text boxes in the frmworkorder. The workorderID is put into a combo box, this works, but the combo box after update "event procedure" does not run. I can...

How can I open Paint using vba or macros? I want to click on the bound object frame and have Paint open up so the user can make a drawing. I also want to double click a drawing in the bound object frame and have Paint open up in the edit mode. Thanks for any help. Richard Iam still looking...

I have created Outlooks Tasks and Appointments in Access 2007. It worked great. Then I had to replace the computer with a new one and some of the Outlook dll libraries were missing. Old computer was running Window XP & Access 2007 New computer running Windows 7 pro & Access 2007 My customers...

Hi everyone, I have the below code working to build a Word document from Access. It works, but I want to justify/distribute the text in the Do loop. I have not found an way to do it on the WEB or the forum. I figure that the code would be like word.App.selection.distribute = true/false. Can...

Pulling my hair out!:confused: I am trying to inport Outlook 2007 Contact list into Access 2007 table. Running debug, the code stops at the RED text rs("olfirstname") = .FirstName. I get this error message "Invalid or unqualified reference". I find a lot of Access contacts to Outlook on the...

:mad: Pulling my hair out trying to update an appointment in Outlook. The code I am using stops running at this line. Set objAppointmentItem = objAppointment.Items.Find("[Subject]=" & Forms!frmShowAllOutlookTasks_fromPopup_1!OLSubject) this line and gives me an error code of -2147352567...