Search results

no equivalent in word 2007's save tab that I can see...

Hi Recently when using MS Word whenever I save a document a 2nd dialogue box pops up containing summary info with a button to view document statistics. Basically it asks for title, author, date etc etc. Anyway I assume this started because I opened and saved a document which edited my...

I once had a similar problem when installing another OS onto a PC except it was caused by the install media being corrupt...had to get a new disk. I would guess it is over heating though - very likely in this scenario

hi, Why do people use these? I normally (not being an expert) would just type: docmd.openform "form name" , , ,"criteria" Is it easier in larger projects to define these 2 values in variables ? or is there other benefits I havent seen.

Hi thanks Ill look into it -im no expert but I see the bits that could be useful for me. Alex

thanks - however I am trying to output a report to email. At the moment the users are required to click a button, type the username in to generate the report, then once the email is open they have to type the username again into the address bar. Your code works (except If I don't send it...

Hi I want to email a recipient from a button on a form - the recipient is to be the person whose details are held in the form - say in the textbox txtemail...how do I get those contents and add them to the "to" on the email? I am using the sendobject action in a macro!?

OMG I got it working by myself... My first piece of VB code created without looking at anything and it works (3rd time lucky i guess)... I use this to link the 2 fields : Dim app As String app = Me.txtApplication DoCmd.OpenForm "frmContacts", acNormal...

add the action "runcommand" with "saverecord" as the argument. You could always close the first form which should also save it...if this doesnt work I doubt I can be anymore help.

just execute the macro from the "on click" event from the button. have 2 commands in the macro - 1stly save the record then 2ndly open the form. i am no expert but I use these simple solutions sometimes.

are you using a macro - if so you could just add the line "runcommand - saverecord" before you open the 2nd form. If not someone will know the vb code to do the same thing.

Hi, I thought I knew a little about Access but I think I have lost touch. I was hoping someone could provide me with examples / tutorials to gain a better understanding of this. My DB tend to have 1 key table with multiple lookup tables. however I am trying to practive by creating a database...

has anyone got an example!?

Probably a common query but I have 1 form and i want to open a 2nd form with 1 text box automatically populated.... I did try google/search but not had luck yet edit - whats the code to open a form in add mode...i cant find it

ah well you live and learn. At the minute the table only has 1 row with 1 column containing the password. Without creating another table and just using the same code what do I add to the criteria of Dlookup for it to look into the 2nd row of the same told!? Thanks Bob EDIT - I figured it...

could be the file types!? if someone converted it for office 2007 use any previous version of access wouldn't recognise the new file type.

Sorry about another post but I have uploaded a word document containing a screen dump of the error I am recieving and the code I am using.....please note the password choice for the example - i like fruit.

Just in case you need it - here is a link to data normalisation in wikipedia. An understanding of that is important http://en.wikipedia.org/wiki/Database_normalization

Hi, I have changed what I can - I am not going to change the original table names/queries because I didnt create them and without going through every form in detail - basically I don't have enough time at work. I did change form names/reports/macros/module names where it was needed. However...

Yes unfortunately there was no naming convention used at the creation of the DB. I added 3/4 so but haven't edited the original forms/table...i may go through it and try and sort it out but it will take a while... ill get back to you later on if it doesnt work once I have edited it