Search results for query: *

I have a bunch of append queries running from a command button on a form. I would like to automatically bypass all of the pop-up messages that ask if I would like to update a table and then append records. At this point I am clicking the yes option over 50 times. I am wondering if there is a...

I am trying to link an access project database to outlook to create a shared calendar report for the company to see. I have no clue how to get this set up. Any help would be appreciated.

Actually I would like to keep everything in Access. The issue is having the eps images linked in the report similar to the way that everyone else is linking bitmaps or jpegs in their reports. Everything is running right now on bitmaps, but the eps images would be really clear.

I have a report that I would like to print EPS(Adobe Illustator) images on. In the help files it says that I need a special filter to access these images. It also says that I need a special filter for jpegs as well. Could someone please point me in the direction of this filter.

Now I am also noticing another problem: When I open the form on its own and try to add a record, the subforms are not visible they are just grayed out boxes. How can I get the forms to stay visible.

I have made all of the index numbers enabled and locked but the same error occurs. When the form first opens "(autonumber)" is written in the field [LeadID]. After the first field[CompanyName] is updated the field has a value[LeadID], but the subforms do not contain the value in the...

This is the error that I get when I open a form in data entry mode: "You tried to add a new record but didn't enter a value in the field that contains the primary key." The primary key that i have on the form is an autonumber which in not enabled. there are two subforms on this form...

I don't quite understand how to go about this. Could you provide some syntax for this, or point me in the right direction to find out how to write this. thanks

Index or primary key can't contain a Null value. (Error 3058) This is the message that I get when one of the forms that I have opens. The code that is associated with the command button that opens the form is as follows: Forms!frmLookup.Visible = False DoCmd.Close , "frmLookup&quot...

I have a letter that I would like the current date to appear on the top. I inserted [=Date()] in the default value for the field it was working fine and now it asks for the date parameter as the report is brought up. My question is that I would like the date to appear at the top of the letter...

Code to open form: DoCmd.OpenForm "frmLead2", , , , acFormAdd I wrote in the on enter property of the subform to 1)go to a new record and after that did not work 2)to got to the next record. Both of the operations told me that I had an error and I was at the end of the recordset...

I have a subform that I want to be in data entry with only blank records showing. This is a form for a new order by an existing customer(all of the order information is in the subform. the main form only holds the ID field relating the order to the customer). I have both the main form and the...

then what is the "name" field in the "All" tab.

in the properties menu it lists strDollarVolume as the control source. everything is visble enabled and unlocked. I don't know why it won't reference.

ok I have switched the focus to a yes no box and it works. The strDollarVolume is a listbox. I Don't understand the difference in refering to one control versus the other. I guess that that is now my question. And is there a particular way to refer to list boxes that is different than other...

this is how I referenced the control in the main form from the subform after the last control on the subform loses its focus. Forms!frmChangeContactInformation!strDollarVolume.SetFocus I in turn get an error of:"Object doesn't support this property or method" what does that mean...

I am having trouble setting the focus from a subform back to the main form. I need some type of code that I can reference. I have no clue how to reference back to the form. I have tried using the gotocontrol function but it returns the current value in the control that I want to reference with a...

I have changed that and am now getting an error saying: "There is no field named '[whatever value is in the list box at the time]'in the current record." What does this mean

Attached is the code that is placed o the last field of the subform: Private Sub txtSpecifyMicroIrrigationFrequency_LostFocus() On Error GoTo txtSpecifyMicroIrrigationFrequency_Err DoCmd.GoToControl "[Forms]![frmChangecontactInformation]![lstDollarVolume]&quot...

The problem comes when trying to set the focus back to the main form from a subform. I have used the .GoToControl action after the lost focus event to have the person go directly into the subform. exiting the subform I tried to do the same thing,but I keep getting an error saying the field is...