Search results

Here is my code: Option Compare Database Option Explicit Private xlApp As Excel.Application Private xlBook As Excel.Workbook Private xlSheet1 As Excel.Worksheet Private xlSheet2 As Excel.Worksheet Public Function ViewExcel() On Error GoTo Err_ViewExcel Set xlApp = New Excel.Application...

Hi All, I have a long module that is exporting data from Access to an excel spread sheet. I currently have one long function. I would like to break it up to many functions. I currently pass the excel worksheet object into a second function from the first and work with the sheet then return...

Hello, I've used a bit of visual studio 2005 and on a form you can organize code by using #region and #end region I beileve. Can you do anything like that in access 2007?? Thanks Paul

Hello, I need a second bite at the apple here, I've got the following code that opens a webpage that is google and searches and works well but I still need some help messing with it. I would like the browser to open in the current window. Right now it opens in a new tab. Also if I could get the...

Ok so I came up with this: <Code> Private Sub Command88_Click() On Error GoTo Err_Command88_Click Dim strInput As String strInput = "http://images.google.com.gr/search?q='" & Me!chrReplacedItemDescription & "'" Application.FollowHyperlink strInput, , True Err_Command88_Click...

Did the search... But I'm not finding anything I can use. I downloaded a demo database most of the threads are about something else. Maybe a little detail I'm missing. I thought running a recordset and looping thru it one record at a time. When it goes thru one record it would bring up...

Hi, I was wondering if it was possible to pass values I have stored in my database and open up internet explorer or something similar and insert the value into the field on the web page then hit search... I've been a copy and paste fool and I hope there is a better way to do this. Thanks. Paul

Hello, I used this forum to help me create an access program that works great. I decided to change part of it and now it's doing something differently and I can't figure out how to go about fixing the new problem. I had a button that took a group of fields (all numbers) in a table and provided...

Hello, I was wondering where I should look in order to learn how to program a database in VB.NET. Is there a book I should get? I am currently just trying to make the same database I made in access and I'm running into problems I have no idea how to fix. I would feel awful posting a new thread...

I got it to work. Thank you for your help x0reset but I was able to do it with this code: Private Sub Toggle97_Click() On Error GoTo Toggle97_Click_Err Dim Count As Integer Dim intAnswer As Integer Dim rsProductItems As New ADODB.Recordset Dim strSQLStmt As String intAnswer = MsgBox("This...

Now I'm getting a type mismatch error, Trying to fool around with it but still no go.

Yea, It is a subform but it is set.

My database gets a little upset too when I use that method. I have to Compact and repair after running it.

Getting an error with the filter part. I'm not familar with the filter command so I'm not able to fix it myself. A text box is coming up asking for lngClaimNumber.

Oh but there is nothing in the intSort fields currently. I'm trying to populate the fields (because Some have 1000 records already typed in and would be a nightmare to type in 1 thru 1000) Thanks

I tried to figure out something and need some help. I forgot when I started on this database a field to sort Products on. So I added a field intSort to the table and was hoping to have the user press a button to order the list of Items on a subform by twos. That way when they add an Item they...

Ok I did the following and it worked. Is it correct? AND curPrice = 0;" Just making sure it's the best way to do this. It does work. Thanks again.

Well, now what if I wanted to do that with a currency field? It defaults to $0.00 and will not change any fields. Should I do a > $0.00?

That worked perfect, Such a simple answer. I love you guys. If I had to do that on my own it would have had 4000 line of code and would have never worked right. Thanks again!

I'm hoping to have a button that fills in data in fields that are null. I was wondering the best way to do this. Currently I have a button that will go thru a set of records and fill in for all the records. I'm hoping to only have this work if a certain field is null and if there is somethere...