Search results

i think i can get it to open when windows starts ... where would i put the code on the switchboard form .... Onload ? any ideas how to check whether the email has already been sent , i was thinking of setting it to be sent a certain time on that day , that way it will only happen once ....

Yes i've done some VBA before , i had a button that would send an email with an attachment of a sql query exported as an excel spreadsheet. My VBA knowledge is quite basic , the biggest problem i have is where to put the code so that it will trigger automatically. Also i have the database on...

Hi all I've got a db system linked with webpages that handles rent management and i'd like to set up an email reminder every thursday to tell the student tenants to put the rubbish out for the bin man. I have their email addresses in one table and another table telling them whether its...

hi i've joined two tables and have some null values ..... I want these null values to be 0 to be used in a calculation anyone got any ideas how i could do this cheers Andy

i'm getting an error message can't assign a value to this object .... any ideas

sounds like that could do the trick , would i do that on the button that opens the form or on the new form that is opened ?

hi all basically i want to have a button that opens up a form that links to the record i'm currently viewing. But then i want to be able to navigate to the other records, in access when you use the wizard to find specific data on a form it doens't then let you navigate to the other records...

are any of the tables linked ? maybe its the order they are being deleted in

think i've had the same problem before , basically i'd have the main form linked to the table of customers and then the subform based on the query .... to do this you'll need to create both forms individuall save them and then when you insert the subform into the main form the wizard asks you...

hi all, basically the senario is this , i'm re-writing a segment of a rent management database i use to handle student rent and bills in two houses. even though i'm on version 4 i've never been able to write a section to handle bills that truly works. Bills come in at different times and...

thanks for advice think i may have got a bit muddled with my keys .... basically my tables are such that i use a manufacturers_ID (Man_ID) to tie together three other tables which have information about rebates, discounts and settlements..... i add a new rebate using the open form in add mode...

hello this might be a really easy problem but its one thats got me stumped problem 1 basically i'm trying to insert a new record using the primary key from another form (not that it is a foriegn key in the table that i am attempting to add data too) when i use a button to open a new form the...

hi open to any suggestions but basically i'm trying to create some kind of database and have it on a CD to give out as a catalgue, i was thinking that maybe an access database exported as an exe file might do the trick as it has to be stand alone and not use a server (no asp pages).... but...