Search results

here is a trimmed version of the database so far i do have a working version of this -- but found that to create astock control i have had to go back to the beginning hope you can help

but the combo box is in the subform - do i select the combo box from the table and then select textboxes from the query??? ive tried - Control source for product descrition = [tblProducts]![ProductDescription] then for control source for Cart Number =[qryPopulate]![CartNo]...

i need textboxes within the subform to populate in relation to whatever i choose from the combo box - each line of the subform will be a different item from previous (i have had it working where, each time i change one line, the other lines follow that change)

i have a table that contains data on products tblProducts holding ProductID, ProductDescription, Price etc... i have a subform that has text boxes relating to these fields. the ProductID being the unique number and ProductDescription being a combo box i want to select a product from the combo...

i used DoCmd.SendObject to email a report - unfortunately i seem to have outlook and outlook express so i deleted outlook - now it wont send at all and if i try sending manually from the right click menu i find that the option is disabled. im not sure if this is an access problem or an outlook...

my program has a textbox that contains cattle id - this is a combination of letters numbers and spaces -- unfortunately there are 14 different combinations of this i want to be able to insert the id without spaces ( its not always clear how many there are) then refer the result to a list of...

i understand that - but that way you have to already have an image to load -- the program i currently use just has a command button that seems to bypass everything and take a picture using the camera software - point the camera at the person - click the command button and the picture appears in...

i think ive read everythnig here regarding images. im lookingto take pictures of account holders within a table rather like the employees in northwind. i have seen a program that does this just by clicking a button which allows you to take the pic then keeps it with the record. unfortunately i...

thanks so simple when you know how -- thanks fro the rapid response - worked perfectly

i have a query that contains two tables one contains the member details the other their transactions. the query is to show all members and transactions however if there is no transaction then the member details do not show - -the query only shows members with transactions . the query does...

now i have a new problem - this doesnt work when i use the form as a subform??

i tried both ways and they work - although they seem to give 2 extre records in both cases i.e. if i put 7 in the code they produce 9 records -- but im sure ill live with that - any explanation for it? thanks for your help

i tried the code you suggested but got an error Runtime error 2505 An Expression in argument 4 has an invalid value it seems not to recognise 'TotalRecords' was i meant to use it directly in that way or define it first in some way?

when i take the "last record" option for a form it does just that - shows the last record as the top line - as it does with a "New record" i want the last or new record to be at the bottom of the forrm so that i see the last few entries - -the length of the form determining how many entries show...

im not sure i explained myself very well - im not looking to update final balances but to have a form that looks like a bank statement Date---Debit--Credit--Balance ------------------------------ 1/1----------------- 1000.00 2/1-----50 --------- 950.00 3/1-----------50----1000.00...

mine is a general question im trying to create somethig simillar to a bank statement that includes a debit credit and balance column my problem starts when i look towards passing the previous line's old balance to become the new lines new balance - i manage it roughly with some code -- but...

i have a query that contains full addresses in one box. i want to viewall addresses hich contain the same first 3 digits through a criteria -being able to insret the required post code manually . is this possible or will i need to put he post code in a separate box

so i can have as many aggregates as i want in a report? for as many levels as i want? --presumably only in the report footer - can i inport data from a multiple of queries to obtain these aggregates?

thanks for your input now i have a problem if i want to use the resulting ansewr in another aggregate witihn a query --such as Grant Total of Units --and if i want to add vat onto that--- the problem carries on ad infinitum another difficulty i find is that if i use a total or grouping within...

on creating an aggregate this leaves a variable as an answer --the variable cannot be used again in another aggregate within the same query -it seems a very fundemental request but i cant get around it without using further queries to change the variables to a constant - i can get around this by...