Search results for query: *

Ok...I'll do my best to describe the situation. I have an Access Data Project that connects to a SQL server. In my code, I deal with all the of the data with ADO Recordsets. I have an issue with users in remote locations connecting to the SQL server over the WAN. On occassion, there forms...

Thank You!!!!

I have created an .ade file in Access 2002. I have the database window hidden by default (setup in the Startup options). It works when I first open the application. If I jump to another application (Word, Internet Explorer, etc) and then go back to my application, the Database window is...

Thanks for the post Bandit, you just saved me some money on aspirin!

I found out why it was doing this! It's a bug in VB6 with listbox controls. I'm not using CE, but this solution helped me out. I added the code: If me.listboxname.listcount -1 <=0 then Exit Sub End If It works! I posted the article below: FIX: An Empty ListBox Generates a DoubleClick...

Thanks for the response. Here are the three main procedures that come into play, as far as I can see it. If I'm missing any pieces to the puzzle, I'd be happy to post. Private Sub lstNotes_DblClick(Cancel As Integer) If IsNull(Me.lstNotes) Or Me.lstNotes = &quot;&quot; Then Exit...

I am wondering if anyone out there has ever run into a situation where a listbox &quot;remembers&quot; the last value of the bound column from a previous record. Example: I have a listbox which lists &quot;notes&quot; attached to a member's profile. If I double click on the entry it opens...

Your welcome. ;)

Thanks for your help Wild007!

Nailed it. Here's what I did: If vForm.fraRosterMemberStatus = 1 Then 'Show Current Committee Members .RowSource = strSQL & &quot; AND CommitteeStartDate <= GetDate() AND CommitteeEndDate >= GetDate()&quot; End If If vForm.fraRosterMemberStatus = 2 Then '...

By the way, ignore the Date + 365 in the code. That was an error and I removed it.

Hello, I'm using an Access .adp against SQL Server 2000. I have a form in which I am showing a roster of committee members in a listbox(lstCommitteeRoster) when another listbox is clicked on. I also want to have an option group (fraRosterMemberStatus) that will filter out Current(1)...

Thank you very much!

I am using an Access adp which connects to a SQL server. I am trying to write a SQL string that will be the row source for a listbox on a form. I want to combine City State and Zip into one column. I've done this a million times using access data. I can't for the life of me figure out how to...

Hello, I'm using an Access adp in Access 2002(XP). I am creating recordsets against a SQL server. When a user logs in, I am dimming a global variable in a module's declaration area (Global vUsername as String) for that username (which I then feed into the connection string. I also use that...

I have a menu on a form in VB6. When I click on the report name in the menu, I would like to open a report based on the record's primary key that I'm currently viewing. I am using the Data Environment. How do I go about passing that parameter to the query? I am new to VB, so any and all help...

Have you tried looking at the joins? I have had a similar thing where two almost identical queries were different. It all came down to making sure the joins were set up correctly. I don't have time to elaborate, but will check back.

Have you tried putting a me.refresh behind the statement in the form current? I know that has worked for me in the past. I have a book at home that talks about this and will try and research this example, because they site this exact problem. I won't be able to post until later tonight or...

You know...when I read this, it sounds like I've posted in the wrong area. Let me clarify. I want to create the public Outlook Calendar item from my ACCESS FORM. I guess I wasn't clear when I wrote that. Sorry. I need a button on my form that will generate the Outlook calendar item in the...

I want to design a button that will allow the creation of a calendar appoint in the PUBLIC, not local Outlook folders. An example would be if I wanted to remind myself to change a person's preferred address back to his po box after one month, I could hit this button, it would create a new...