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 checked my mail. was there an attachment that was supposed to be with it. I didn't see any queries. THANKS

You can e-mail it to me if that's easier for you. FontanaSandy@Aol.Com THank You

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

But how then do you compare to the current month. I only want to print this report once a month. So I wouls have to check to see if the person owes money this month on the third.

If I am able to only use a query than the better. Here is an example. Say today I want to print a report of all the people that owe me money friday (March 2, 2001) I want to look in the field called NextPaymentDueDate that is equal to 03/02/2001 - Everyone in the DB will have the same date...

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