Search results

Appears newest release a few days ago, its still an issue.

Awesome. Thank you all. I was only looking back a few days for updates. I was able to rollback the update and fix this issue for now. Now I have to notify all workers to turn off automatic updates, until I can test the "open dummy report" mentioned in the link posted by cheekybuddha.

I will check the additional items u suggested. I already monitored the memory and it stays around 65mb when I click on a button to create a pdf. I have multiple forms with these create pdf buttons and they all have this error since this morning. I have also Increased page file size from 9500 to...

There wasn’t any updates. Windows or otherwise. I’ve already copied new front end. Also tried all the above mentioned.

Version 2305, build 16501.20196 click to run 32bit

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...

No idea why, but I had to add brackets around the fieldnames

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)" & _...

Private Sub Comments_Enter() Me!Comments.SelStart = InStr(1, Me.Comments.Text, "-") End Sub Private Sub Comments_KeyDown(KeyCode As Integer, Shift As Integer) lngInHouseParts = 927259127 Select Case KeyCode Case vbKeyF5 'QUOTE ONLY' Exit Sub Case vbKeyF6 'REMOVE QUOTE...

I forgot to mention the subform is in datasheet view! I would like a solution that doesn't require adding another field I have PartsID field and PartsComments field I added the ability to select parts that we build in house. When a part we build in house is selected the PartsID is "12345" and a...

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...

Both of your ideas seem like they'll work. I think it would be easier to strip the time from the field in my query. Do I just change the field to NewSelectionDate: Format([SelectionDate], 'm/d/yyyy')

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 had trouble to I had the same problem. I had to modify the batch file code. Apparently my db wasn't closing before the batch file tried to delete it so I changed the code to this. Public Sub UpdateFrontEnd() Dim strCmdBatch As String Dim notNotebook As Object Dim FSys As Object Dim TestFile...

Why me Has anyone used this method and run into this problem? I have to open my db, get the message that it needs updated, click ok, then the program closes and never reopens. I have to open the db and go thru this process several times before it finally completes the update like it should...

I can accept that I do agree, it would not be an acceptable design. I will have to work with the salesmen on the new form design. I would like to know how I could create a report with this format. From what I know about access, I have to have a control source for the textboxes. So if I have...

on-2 So are you saying that it's not possible to lay out a form in the same manner as the posted example?

Aggrevation I figure I will get someone moaning for sure.