Search results

I have used this line of code for several years to output PDF reports. I output multilple reports with this same method and it works on all but 1 PC. I have one pc that has the PDF Complete app installed as there primary pdf viewer. This is the only PC where this code fails. Has anyone...

I have a form with that has 3 listboxes on it. Each listbox displays a list of items that are missing on an order. lstBox1 displays missing items that are standard on a particular model lstBox2 displays missing items that are standard on a particular conversion lstBox3 displays missing items...

I've been using this database for years and all of a sudden I am getting an error. I have not made any changes to the database. Here is the error. "There isn't enough memory to perform this operation. Close unneeded programs and try the operation again. " I believe I have narrowed it down to...

I have a form that always used to mousewheeel scroll and now it doesn't. I can drag the scroll bar but the mousewheel won't scroll. I even checked FrontEnd versions from last year to make sure it wasn't just a corrupt form. I am using Office 365 Click-To-Run Version 1707 Build 8326.2073 Can...

Access 2010, Tabbed documents are enabled. I know the caption of the form is what is displayed as the tab name. So if I open multiple forms open, ex. Orders, Purchasing, Inventory. I can easily select a different tab. This being said, sometimes the tab names are shrunk to a few letters...

Can someone please help I am using windows 7 64 bit with Access xp. I am getting and error 3134 from the following code. Private Sub Form_AfterInsert() Dim strsql As String On Error GoTo Form_AfterInsert_Error strsql = "INSERT INTO tblOptions (CategoryID, Option)" & _...

I have a textbox called "comments". In this field I have text already entered. I want to allow users to add to the text I already have without erasing my text. Ex. if the field contained "48 inch side door" I want to evaluate the string. If thr is no hyphen then add one and move to the...

I have tblOrderDetails.SelectionDate field that has a default value of 'Now()' So my fields include a time stamp along with the date I have a query with the following: ((tblOrderDetails.SelectionDate) Between [Forms]![frmDateSelection]![Calendar0] And [Forms]![frmDateSelection]![Calendar1]))...

I have attached a copy of an excel sheet that my company has been using since the ice age. I would like to set up an access db, so as to eliminate the multiple files and make it easier to create new orders, rather that saving as a new file name all the time. However, does anyone have an idea...

What am I missing. Can someone please tell me why my msgbox is being displayed twice. For example once I click on ok it pops up again and I have to hit okay again to make it go away. Also is there a way to make the msgbox a double line instead of one long line of text? Private Sub...

I have a frmVendors with a subform frmpartssubform, the subform is displayed in datasheet view. I am trying to use conditional formatting but when I use the expression is feature, the database opens and states it has encountered and error an must close. The wierd thing is that after I...

I can't seem to find any threads pertaining to future dates in queries. I have attached a db that I need to have the query show the most current date that is not a future date. I tried using the max function but I am getting multiple records. I am not understanding the other threads about...

Could someone please look at this db and tell me how I can possibly make the subform pull only the latest price that is not newer that todays date. I know I can use the max function in a query but then the subform becomes uneditable. I need the subform to be editable. I thought about storing the...

Could someone please take a look at this db and tell me why I am having the problem of the report showing id values instead of the names related to them. I have tried everything I can possibly think of and I must be missing something very little. Thank you in advance.

I am stumped on how I can enable a command button while typing in a field I have frmunits that has 3 fields Year, Model, Vin#. I want the cmdwarranty button disabled unless there is something entered in on of these boxes. I currently have this If Not IsNull(Year) Or Not IsNull(Model) Or...

Calculated field on subform problem I have a frmOrdersSubform which I use to enter order details ex. order date ship date productid currently the form uses a sql string as a recordsource. I calculate the 'amount due' in qryamountdue however I can't seem to be able to add this field to my...

Please help... I have a form that seemed to be working fine and now everytime it is opened, it is filtered. However all the properties are set to no filtering and I have tried erasing all the code behind the form temporarily and it still filters on its own. I am opening the form from the...

Could anyone maybe explain why I would be getting this error. I have been using this db and made a couple of changes and now I get this error when I try to compile it. Private Sub addtocustomer_Click() DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Dim...

by reading several posts I came up with the DoCmd.RunCommand acCmdSelectRecord to highlight a record in a subform in datasheet view. My question is, is there any way to adapt a gray background color to the selected record instead of black?

Everything was great until this. I have a form which the recordsource was built with the sql, query builder option. My form worked great and I could add or change anything I wanted to. But I had to have a way to keep track of price changes so I add a table. Then I had to use a make a query...