Search results

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.

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

Thank you for the response. Your answer is very beneficial. I have read about the case statement but not enough to implement it. This looks terribly easy compared to all the if then elseif that I have done. Thanks Again. Maybe that will correct my msgbox being displayed twice. Fingers crossed.

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

Thanks for the response. I will try all you suggested.

I don't know what I am doing wrong I have tried - me.frmpartssubform.currentlyused = false - this returns no response I have tried - [frmpartssubform].[currentlyused] = false - this doesn't return any response either If I use [currentlyused]=false then it works but, when I close the db...

no its not I have two txtboxes that I want to apply the conditional formatting to base on a checkboxes value. The problem is when I enter an expression as a condition the error occurs and I can't get rid of the error unless I remove the expression. Both textboxes are in a subform and so is...

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

vba maybe I am not a vba person by any means. Everything in my db has come from reading and the help of you people on these forums. I was thinking how powerful vba is, and, wandered if anyone has ever written any code to work around this issue? Maybe a module that finds the latest cost and...

jon k Rebuilding the forms won't fix this problem. You are not accomplishing what I want to do. Please refer to the original question. -Quote- Could someone 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...