Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JoeMicro
  • Content: Threads
  • Order by date
  1. JoeMicro

    MVC Single Model Two Dialogs - with PyQt

    Hi, i am trying to use a single dataModel for two different forms in hopes that when the dataModel is changed in one form it will effect the other as well. but that doesnt work. i built two forms: Form_1: has two views set to a model class. Form_2: has one view connected to the same model...
  2. JoeMicro

    One Before Max

    Hi, is there a way i could get in vba one before the max of a field? ex. Column 2500 3200 1500 5700 so i want to able to get into a variable 3200, and then 2500, etc.. basically i should be able to specify how for backwards from the max i want to go.. i hope his makes any sense. Any ideas...
  3. JoeMicro

    Access 2007 Ribbon Edit Box

    Does anybody know how to clear an editBox from callback of a different Control? I have a button on the ribbon which does an opens a form with a recorded which is indicated in the editbox by the user, but i couldn’t figure out how to clear the editBox after the callback from the button is done...
  4. JoeMicro

    Inserting Data To Access From DataGridView

    Hi, i m trying to build an application where the user could enter data in a datagridview and it should be inserted into an Access Database (or to SQL Server which ever you will advise me to use) i know how to create a DataSet, i tried creating a new DataTable in the dataset and bind that to...
  5. JoeMicro

    Refresh report wirth vba

    Hi, how do i refresh a report in access with vba. my problem as i m calling a report in acViewReport, and the report is bigger then the screen but i dont get the side scrollbar only if i refresh the report manually. i tried me.refresh but it doesen't work thanks Joe
  6. JoeMicro

    Reference Application title in VBA

    Hi, is there any way to get the application title from another file (for instence my database file) in a msgbox or txtbox? thanks, joe
  7. JoeMicro

    Run VBA Code Upon Opening Access File

    HI, is there any way i could run some code (not a macro) when ever a user opens an access file Thanks Joe
  8. JoeMicro

    Data in one field based on another field on subform

    HI i have got a few questions but let me start with one at a time. i have got a subform Field1 = RecordID Field2 = AccountNo Field3 = Group i would like to have a button that gives to each AccountNo a Group no., meaning that if there is a few of the same AccountNo's it should all have the...
  9. JoeMicro

    Add or Update Records

    Hi Guys, Does anybody know the best way, to loop thru records (in an unbound access Sub form)to check whether it’s already recorded or not. If its already recorded Then update the changes, if not then it should Add new? Thanks Joe
  10. JoeMicro

    Error 3061 Too Few Paramters

    Hi People, i have got this code: Dim ReportName As String Dim strNadvan As String Dim i As Integer Dim rsQry, Rs As Recordset Dim SQL As String Dim QDF As QueryDef Dim QRY As String With CurrentDb.QueryDefs("OpenBalance") .Parameters![What] = "P Or...
  11. JoeMicro

    Form doesn't show Records from Table

    Hi, i have a form with a sub-form on it. with a click of a button Records form a record table should be appended thru an action query into another empty table which is tied to the sub-form, so normally when i open the form i should see all the records from the table, but the problem is i...
  12. JoeMicro

    Array Formula

    I Posted This In the VBA Forum http://www.tek-tips.com/viewthread.cfm?qid=1448196&page=1 Hi: i have got a sheet that looks similar to this 101 102 P1 102 P2 101 P3 101 P4 103 P5 kl 0 P3 0 P4 0 P5 0 P2 0 i tried this array formula...
  13. JoeMicro

    Array Formula

    Hi: i have got a sheet that looks similar to this 101 102 P1 102 P2 101 P3 101 P4 103 P5 kl 0 P3 0 P4 0 P5 0 P2 0 i tried this array formula =MATCH(0,IF(Sheet2!A15:A19=A6,IF(Sheet2!B15:B19=Sheet3!A1:A5,Sheet3!B1:B5,"P")),0) to do the following. it should look up in the first range...
  14. JoeMicro

    DTPicker Control

    Hi: I M trying a 2 DTPicker Cohtrols on a user form to filter a sheet, but for some reason it filters for the date 1/0/1900, i did use DTPicker control already a few times an it works well, in fact on the same sheet i have got another user form with a DTPicker control on it and it works great...
  15. JoeMicro

    set worksheet variable based on user input

    HI: The user selects a value from a list, the code will then lookup the value on another sheet which has an offset with the sheet name, and sets the variable to that sheet. Dim vOurResult As Range With Sheet12.Range("SheetName") Set vOurResult =...
  16. JoeMicro

    For Each Copies Only Last Row

    Hi Everyone i m trying to do a For Each Statement, for Ex: for each row it should paste some cells to another sheet, but it does the command only for the last row. This is the Code: Sub EnterIncome() Dim rcrdRow As Long Dim pstRow As Long Dim shAccount As Worksheet Dim...
  17. JoeMicro

    Grid On User Form

    Hi i m trying to create a UserForm where the user will be able to enter several lines of data, and it should be analyzed with some code and posted to the appropriate sheet. Would anybody know what is the best control to use for this? Thanks Joe
  18. JoeMicro

    'Overflow' Error when looping through listbox

    hi: what i m trying to do is as follows: i have got a user form on an excel sheet, where i could select several lines, for each line sheet1 is being filtered, criteria1 is the line criteria2 is a textbox, copied onto another sheet and printed out, deselect the line, and move on to the next...
  19. JoeMicro

    Copy Rows To Sheet Based On Cell Value In Range

    HI: Could anybody help me i need a macro button on my excel sheet that should do the following. i have a range (Ex: A3:E46) which is being continuously filled, i need to transfer the information to another sheet depending on column "E", (Ex: if "E3" = "A" paste row to sheet2 if = "B" paste row...
  20. JoeMicro

    Copy Rows To Sheet Based On Cell Value In Range

    HI: Could anybody help me i need a macro button on my excel sheet that should do the following. i have a range (Ex: A3:E46) which is being continuously filled, i need to transfer the information to another sheet depending on column "E", (Ex: if "E3" = "A" paste row to sheet2 if = "B" paste row...

Part and Inventory Search

Back
Top