Search results for query: *

I have the follwing code in access to find a record based on a combo box that the user picks: strSearching = "MovieName = '" & [MovieNameComboBox] & "'" Me.RecordsetClone.FindFirst strSearching Me.Bookmark = Me.RecordsetClone.Bookmark It works unless the name they are...

I have the follwing code in access to find a record based on a combo box that the user picks: strSearching = "MovieName = '" & [MovieNameComboBox] & "'" Me.RecordsetClone.FindFirst strSearching Me.Bookmark = Me.RecordsetClone.Bookmark It works unless the name they are...

Can I connect to SQL using Windows 95? I can do it using Windows 98 and Windows NT, but on the computer that has Windows 95 I am getting a problem?

I have two combo boxes on a form that the lets the user pick a value from each one. There is a command button that says find and when the user clicks on that , it takes the two variables in the combo boxes and finds that record and displays it. The following code keeps getting a syntax...

I am trying to sort some rows in a worksheet By Column I and then by Column L. There could be any number of rows when the person runs the macro. So that is never constant. I have the following code so far and I keep getting the error - "object doesn't support method." - The A6 is...

Here is the problem. I want to sort rows of information by a column using a macro. The only problem is that there is no set of rows. One time there sould be 4 rows, another day there could be 45 I have the following code so far...

I would like to pull out all of the records that have the month = current month The field I am checking for that is called NExtPAymentDate and it is a date/time field. I only care if the month is equal to the month it is when they run the query. I have tried : LIKE Month(Now()) Like...

I have a macro that I want to run that will loop through records (in a particular field) in a table and look for any that have the date MM/03/YYYY, where the month and the year is the current month and year, but it has to be the third of that month and year. I have tried it with the now()...

I have the following code to assign the value of one cell to another (in a macro): Worksheets("LOG").Cells(Counter, 5).Value = ws.Cells(iRow, 1).Value The problem is that I want to assign the cell reference to the Log worksheet cell so that if someone changes the contents of the...

Can you have an autonumber in an access table (that is also the primary key) that starts at 1000 instead of one? I have looked through the properties and can not find a way to do it! THANKS

I use the following code to open up a workbook in a macro that I created: Workbooks.Open "E:\DBTest.xls" Set wbTemp = ActiveWorkbook The problem is that if the workbook is already opened, an error occurs. IS there a way to use an IF statement so that if an error occurs, I send a...

I open up a workbook in Escel using the following code in a macr: Workbooks.Open "D:\DBTest.xls" Set wbTemp = ActiveWorkbook I then want to minimize the workbook. I have tried the following but they have not worked: ActiveWorkbook.Windowstate = xlMinimize wbTemp.Windowstate =...

I have the following code in a macro in an excel workbook: Set wbMaster = ThisWorkbook Workbooks.Open "E:\DBTest.xls" Set wbTemp = ActiveWorkbook For Each ws In Worksheets Select Case ws.Name The problem is that when I do the for loop, I want it to look in the wbMAster file...

The problem I am having is exporting information from one workbook to another workbook in excel. The way I have it set up now is using a macro. The macro is in the workbook that I get the information from, and opens the workbook that I want to put the information into. The code below works...

I am trying to assign the value Y to a row (iRow) after I import that information to another worksheet. (made a macro). I use the following code to assign the field a Y value: ws.Cells(iRow, 9).Value = "Y" The problem is that it assigns the Y to the right place during the execution...

I was wondering if it is possible to get information from another file. For example, I am trying to create a macro, and would like to get the values of certain cells from a worksheet called "CONTRACT BRIEF" that is located in another file called MAster5.xls. THe file I am creating...

I have multiple sheets in my workbook that will be used in a macro. I have the part of the macro that takes info that I need from one sheet and puts it on another sheet completed. The problem is that i need this same information from multiple sheets. I found code for...

Hello. I have two worksheets in excel. One worksheet is where i will input rows of data. Each row represents a record. When I run the macro that I want to create (but haven't yet), I want the macro to take that info that I typed in, and copy it to the other worksheet. The only problem is...

Hello. I am trying to create a macro in Excel that will copy some fields in multiple pages (the fields are the same in all the pages)into fields in one other page. The problem is that the pages I am copying from are not a fixed number. I could have four worksheets, or two worksheets, etc...

Hello. I want to use a macro to update certain fields on mutliple pages. (They will be the same fields on all the different pages). The problem is that the number of worksheets I will have will change everyday and the names of the worksheets will also change. The one thing that will not...