Search results for query: *

Hi all, I havent messed around in access in a while and I think I am bit rusty. Anyway, I have a button that filters a list box. This is fine to do except when I have to do it from another form. For Example: Dim strDept As String Dim lst As ListBox Set lst = Form.frmMain.List22 (problem)...

Hi all, Main form and Subform data is taken from the same table. The subform is a grid used as an index for the main form in the same window. I have a number of filters which I want to filter the subform and Main form. When I select a record in the subform, I want to go to that record in the...

Hi all, Main form and Subform data is taken from the same table. The subform is a grid used as an index for the main form in the same window. I have a number of filters which I want to filter the subform and Main form. When I select a record in the subform, I want to go to that record in the...

Hi all, I want to filter a subform by a date. Can someone give me a few pointers. What I want is to filter a date in the format 01/08/03 by the month being 08. Me.subform.Form.Filter = "[Date] = '##/08/##'" Me.subform.Form.FilterOn = True Any sugestions? thanks s.

Can someone tell why this is not working? On a form I have a subform, 2 text boxes and a button. One of the fields in the subform is a date field. I want to filter between 2 dates. this is the code I used for the button. Me.subform.Form.Filter = "[Date] between #" & Text36 & "#...

Hi all I have a table and the numbers are going in and automatically rounding off. IE: If I enter 7.5 it will round up to eight. How do i turn this off. The field properties are set to Long Integer with 2 decmil places. I have messed around a bit but cant find what is wrong. Thanks S.

Hi all How can I compile a datbase so that it is stand alone? Do I need to add extra tools? For example I want to put a database on a PC that does not have Access. I cant find any results from my search. Maybe I am looking searching for the wrong thing. Can someone point me to a thread...

I have a goodish idea of VBA but I have ever only worked with it in Access. How do I get the autoexec module to run on start-up in Word. Thanks S.

Hello all. There is a vb6 application used in the company I work with. It works perfect on all machines except winXP pro machines. The developer has not had time to look into this problem but it works fine on his mcahine which also uses WinXP Pro. The Problem is that on some screens when the...

Hi all this should be an easy one. Bit out of Practice! If subform.Fieldname = "Word" then blah blah blah What is the properway to structure this? Thanks Sadukar

I am copying a a range of cells and pasting them depending on a value in a range. For example If a cell contained a "R" then My code would move up one cell and one to the right and copy as far as the end of range. (be5) It would then paste to cells to the right of where "R&quot...

Hi All, I have an "Output to Action" Macro which outputs query result to a xls spreedsheet. How can I specify to output to a particular sheet in a particular .xls file without copying over the .xls file. thanks S.

Hi All I have an Access db. I want to export data from a particular field in a table to excel. For example: I want to place field 4, from record 10, into Cell A1. What code do I need for this? I was thinking something along the lines of: Dim oApp As Object Set oApp =...

I normally use VBA in Access. I have just started doing a projet in Excel. How do I use VBA in Excel? For example: I want to check if a range from c4:z4 has a value of "1". If yes I want to change the value to 2. If not I want to delete the value in the cell. I tried Command 1...

Hi all I have 3 different sorts for a subform. They work like this: Me.Subform.Form.OrderBy = "[Type]" Me.OrderByOn = True etc.... My Problem is that when I open the form the sort will not work. If I right click on the subform and do a sort acending/desc etc.. the sort works. Then...

Hi All I am trying to filter a form by using 2 different values. I tried: Me.Subform.Form.Filter = "[Interval] = '3M'" Or Me.Subform.Form.Filter = "[Interval] = '2M'" Me.Subform.Form.FilterOn = True Didn't Work. I also tried using And insted of Or. Didn't Work either. Any...

Hi All I have a button with a large amount of code attached. It is giving me an error that there is too much. I need all this code. How can I split it up so it will run. I was tried seperating in half and attaching half of it to verification box 1 and the other to verification box 2. Then...

Hi all How do I total fields in a report depending on there section For Example From a query like this. Section M/CCode Hours Elec M/C1 2 Elec M/C2 1 Meca M/C3 5 Meca M/C4 2 Prod M/C5 3 I want to total the hours by the section. For...

Hi All, Bit stuck with this. I would appreciate any suggestions. I want to say if txt box1 = yes Then table2, record number 14 has a value of -1. If txtbox.value = "Yes" then What code do I need here?????????? Else End if Note: table2 is not the data source for the form which...

Hi All, Cant figure this out! If a verification box is checked then I want to ask if "you want to Print again" I want a yes or no, yes being print again and no being end. (Ie yes goes to Else) I need the print code after ELSE so I can print report as normal if they are not checked...