Search results

Howdy I keep getting a missing operator error when I try to execute this SQL string. I've looked at it too long and can't find the issue. Can someone with a fresh set of eyes take a look? strsearch = Nz(Me.txtsearch.Value) strsearch = "*" & strsearch & "*" strSQL = "SELECT * FROM...

My apologies guys, I don't post a lot of code on the forums. Sub Run_Comparison() Dim lrowold As Long Dim lrownew As Long Dim lrow As Long Dim lcolold As Long Dim lcolnew As Long Dim cellold As Range Dim cellnew As Range Dim r As Long Dim c As Integer Dim nw Dim ol...

Howdy, I've written some code to compare data and it takes approximately 13-15 minutes to finish. I have a few problems though. If I left click the screen while the program is running the program stops If any notifications popup (Lotus Notes notifications) the program stops If the...

I am running a comparison program that takes close to 10 minutes to analyze all the data and our my pc goes into "login" mode after a certain amount of idle time. Even though the the program is still running and the status bar is changing the system stops running the program and I need to log...

Howdy all, I typically use the R1C1 reference style in my Excel spreadsheets but my coworkers do not. For some reason when they open a new workbook the columns default to R1C1. I know how to change under Tools --> Options --> General but am unsure how to make A,B, C the default. I have tried...

Hey Bob, I deleted the form, recreted it from scratch and placed this code into my Module. It works. When I didn't add the ".Object" I got a Type Mismatch error. Again, I'm not sure what really made this work but it does so I'll move forward. I am somewhat of a rookie at this so I'm not...

Hi Bob, Still getting a type mismatch. Changed it to Set LView = Forms!frmcapacitysettings.lstview Hmmm this happens every once in a while. Hmmmm any other thoughts? Thanks for the quick response!

Howdy, I've made several listviews (Microsoft Listview Control, Version 6.0) and now I'm getting a type mismatch error. When the form opens I am calling a sub in a module to create and fill the list view. I highlighted where I am getting the error. Am I getting this because I am trying to...

Howdy all, I've been working on adding check boxes to my ListView control. I thought it would be a bit more straight forward. Below is my code. I'm also not sure why I'm only getting 1 line of data because when I loop through the code it appears to give me the correct data but when the form...

Hey guys, sounds like some poo is starting to be thrown. Sorry for sparking a debate here. I am using the "+" because I am writing information to MSSQL 2005 not MS Access. I am using Windows XP and both connection strings have worked. As far as the other problem with the type mismatch, for...

Thanks for the reply ByteMyzer! Added what you suggested and I'm still gettimg some issues. I took the timeout out as I'm not sure what that should be (I'm a noob). Here is the code in all it's glory. Again, any suggestions are appreciated as I'm trying to teach myself and obviously that's...

Hi All, I haven't posted in a while so I thought I'd bug you guys. I have data in an Excel document (from SAP) that I send to MSSQL and it works great when I'm at work. The problem is when I travel it's a hit/miss sort of thing for getting the information updated. Sometimes I'll get around...

Thanks Ken but it's a no go. Good idea though.

I've written some code to send emails using Lotus Notes and an end user was wondering if I could make the category bold. I'm not sure if this can be done. I've seen a few posts about rtf but I'm not sure if/how that would apply to what I'm doing. Any information would be great! Here is the...

Thanks John!

I'm sure this is a simple/stupid question but how can I copy a list in Excel then have the user push a button on a form and populate a subform with that list? I tried using DoCmd.RunCommand acCmdPaste but I keep getting an alarm saying "The command or action 'Paste' isn't available now. Any...

Found the problem, I was missing a comma between the two fields. ],[Reason][Approver],[ Thanks for the responses though!

Hey Paul, nope still getting a Syntax error. Thanks for the reply!

Howdy, I'm trying to send information to a table that the user wants deleted. I just want to make sure I save the data to a different table before he/she deletes it. I keep getting a syntax error but I'm not even sure if I can perform the transaction the way I'm doing it. If anyone can give...

Thanks for the advise, and my apologies for the hard to read code. I'll make sure to include the brackets in the future.