Search results

ive attached the report needed and the tables that are required. if you open the report you will see what i mean. cant believe i had to zip the file to get it to upload. theres only 3 tbls and one report and it was > 2mb.

hi, yes i did try it with the correct txt box name. ive just tried it again and i get the same error. does it matter where on the report i put it? i did initially think that it was down to me using a DCount in a text box. so i moved the dcount to the report record source

the exact name is txtClientCountVisited

thanks for your reply. i tried your expression and when i open the report i get 'Enter parameter value' txt box i i dont input anything into the box i get a zero in the txt box that has the SUM expression. any ideas?

i have a report and at the footer i want to show how many of the txt boxes i have are >0 i tried =Count([txtbox]>0) i know that this is quite simple but i just cant get it thanks

i think i speak for most people on here. we need an insite into you database. im trying to understand what the numbers are. are they unique id's, are they just a number. what are you trying to do. are you trying to pull a list of lot numbers that are NOT IN USE...

i have just used this code to send 2 emails with a simple text message in the body to try it out. i am wanting to construct a complete email with images etc. is it possible. i have already tried to use the standard html method in "HTML Body". but the vba code screen has highlighted it in RED...

sorry to have 2 threads so close together but i want to hit this from both angles. i have just thought. with the linking tables thing to outlook can it be reversed. ie if i have a table that was linked to outlook outbox would the records form an email just like the emails from my inbox form a...

i have just found out that i can call data from my outlook email files and place them in a table. i started by using the link table wizzard. i now need to know how to refresh the link automatically. i could do it on a timed or open event but i dont know the code to do it. can any one help with...

correct me if i am wrong but you have 2 tables. one table is related to the other by a field. if so then use the relationships in database tools tab. if i am wrong could you please elaborate or attach your database

start by creating your tables. you will need one for your items. one for the suppliers. one you have done that then attach your tables and im sure somebody will help. its very easy to create reports and forms using the wizzard. do you have much knowledge of access?

have you tried changing the settings. file\options\current database

what about taking the event off the hyperlink. im not sure about hyperlinks in particular but it sounds like your are exiting sub when you are clicking end. thus in my opinion not needing the vba.

aaargh. too hasty. now i get the write conflict when i try and save the record. why?

this is now solved. the easiest fix ever Forms!etc.etc..SetFocus no write conflict

is it possible to save a record on another form. i have a write conflict on a main form when i tick a check box on a subform. i was thinking the event could include docmd.runcommand accmdsave "Forms!frmClientSalePaymentScreen". is it possible.

ah, thanks

while we are on this subject, can i ask what the difference is between docmd.runcommand accmdsave & docmd.save

its not your reply that made me chuckle it was the question and how simple your answer was.

sorry super but i did laugh when i saw the first reply. you remind me of me. i love to try and over complicate things. i still cant get around the fact that most things in access are very simple and it is us that makes them very complicated.