Search results

this macro atm..

nop... still opens a record which already exists.. i need for it to open a blank form =(

i got this: Private Sub Command23_Click() Dim lngcombo2 As Long Dim strOpenArgs As String strOpenArgs = Me.Command23 lngcombo2 = Me![Command23] Me.Command23 = Null DoCmd.OpenForm "FRM_ShopContactsAdd", , , , , acDialog, "New#" & strOpenArgs...

your code isn't working.. maybe its because yours involves a combo box, where as mine involves a button which just opens the form (which should be blank, ready for a new record with the correct foreign key in place)... so how can i fix this?

there must be some easier way of accomplishing this for example via a macro? im no good with this code stuff =/

not really helping to be honest with you =(

How can i make a form open, with the default correct foreign key from a previous form, so that i can enter a new record? i tried the "Open form" macro, and set "where condition" to equal the foreign key ( [ShopID]=[Forms]![FRM_Shop]![ShopID] ) and that didn't seem to work.. any ideas fellers?

but i need to dispay it in a query :( so that i can see all 707 of them.. and maybe able to create a callendar similar to ListContracts Query =( i take it its unposible to do it in access, as it only shows subcontracts as last resort..

after i deleted those recrs which your query identifyed, the result of the ListContractsWithSub's query remains the same.. it still doesn't project the 707 contracts but instead just the 316 contracts with their sub's.. =/ what am i doing wrong? i followed your instructions and my db had let me...

okay.. im not quite sure i understand the problem, but how may i fix this?:o

i have attached parts of the whole system, to try and show the issue, as in ListContractsWithSub's, i need the whole list of contracts as i tryed to explain before.

I tried that, but then it only shows 317 records, and doesn't display the other contracts without sub-contracts. Any ideas how i might be able to make it show all 707? (i had also tryed creating a blank sub-contract to every contract, but that results no structure and looks messy as hell)

Hi fellas, how do i combine two queries in to one? As you may have noticed, i seem to run in to problems frequently, due to trying to accomplish too much at once. As per usual.. i have my contracts table (with 707 records) and my sub-contracts table (with 317 records) with ContractID as...

those are both great ideas, however, when i add a new sub contract, the stupid things starts to duplicate contractID in the query which i use to create a form where the inflation is calculated and the whole thing is more visual, as you can see in my attached screen shot, ContractID 2 appears...

i need to record all of the values for every month =/ and it's the worst thing, but the user requires to know the history of each contract..

Right.. I have a table with all of my contracts, with main items being StartDate, EndDate and Price. All of those values are used in a query to show how much the client must pay (due to inflation, the prices vary every month, and the formula is fairly complex, one being: March2012...

so what do you think i should do? im a little confused... if there's a hole lot simple way of achiving the same result, what should i do?

Galaxiom... you are a genius! what i will try to do, is adapt your idea in to: creating a table: InflationTbl (with no primary key) 01.12|02.12|03.12|04.12|... _____________________ x% |y% |z% |w% |... Then create a query: InfltionQry SortID StartDate EndDate Today: Date()...

That's a good idea! However, i need to take into considoration that the inflation changes every month.. so i can't use "to the power of" idea.. any other posible thoughts? im open to all ideas...

i have two dates: StartDate EndDate I also have a contract made with a cient so that he pays me one sum on the first month, and that sum multipies every month (due to the inflation, which figures are stored in another table), and i will need a cost at the current month, even if its between the...