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

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

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

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

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

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

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

Howdy, I've been teaching myself VBA and I have a question about what I do with an Object after the Sub. I'm wondering if I should always set the Object to Nothing. Below are my two examples. Thanks for any help Public Sub MakeFormIconsListView() Dim lstview As ListView Dim strSQL As...

Howdy, I'm self taught here so if I'm asking a dumb question I apologize. I've created an Access FE with a MSSQL BE. I don't want to have to create an ODBC connection for all the users (lazy I guess) so I found some code on the web that will allow me to not have to have odbc linked tables...

Howdy to anyone who reads this. I have a pivot table pulling information out of MS Access that is created using VBA. There is a form the user will use to select the first week then the pivot table will be populated with that week plus the 3 previous weeks. My problem is it only works up to...

Hello all I have been trying to find information on how I can save the changes made to a List View control after the user reaarranges the column headings to his/her liking. Below was my first unsuccessful attempt and was wondering if someone could help by pointing me in the right direction...

Hello All, This is my first post so after you read this you'll know what my knowledge level is (LOW). I have created an Access database and pretty comfortable with the data entry/update system. Now I'm moving on to creating the reports. I would love to have "drillable" charts and actually...