Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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