Search results

Hi all I have extensively searched the forum to try and find an answer. Im trying to develop a Project tracker database which will track the progress of my ongoing projects, does anyone out there have an example or another link to get me started. I know MS Project would be the answer but we...

Hi everyone. I am trying to e-mail a report or form from my Access database. However the following message keeps coming up "SendObject isn't available now" When I try to send it 'manually' via File then Send the options are greyed out. Am I missing something settings wise or am I missing...

Hi there. Is there any way to get a Form or a Report to show a radar (or spider) chart in Access without going through MS Excel? Thanks

Hiya, Ive tried searching on this forum but cannot quite see what i am looking for. I have a form with say 500 records in it, when a user performs a query search it finds say 250 of those records. I would like the form to display something like this: "Found 250 of 500 records" ( This is similar...

My word !! Has anyone come across this before? I had an end user press and hold down "CTRL" and then press"," ( the comma key ) then the form opened up in design mode. I did not know this was possible, I have disabled the Shift keys etc and all other back door routes ( or so i thought ! )...

The problem:- I have a form with a combo box with the values 1,2,3,4,5 in the drop down list. I would like a user to select one of the numbers 1-5, lets say number 2. I would then like access to Add the corresponding number of records to a table ( in this case add 2 records ) Can this be...

Sorry good people, I got a reply to the following topic from FoFa a while ago and I thought I sorted out the problem but Im not sure where to put the text that FoFa suggested. Sorry for being thick but im a newbie. My problem:- I have to produce a report showing only the initials of a person's...

Hi everyone. Not quite sure how to go about this but here's the problem:- I have to produce a report showing only the initials of a person's surname, and just the first 4 digits of a person's postcode. The 1000s of records which are currently in the database at the moment are as follows:-...

Hi Everyone. Im sure one of you out there knows the answer to my bugging problem, ive looked through ( and through !! ) Access help with not much luck. I have a series of check boxes as follows: Part A, Part B Part C etc etc. What I would like to happen is that when a check box is selected (...

Sorry if this sounds a daft question but i have tried looking everywhere on MS Access Help but with no luck. Is there a way to have the fields below as checkboxes that when selected add up the sum of only those parts chosen. Part A = £52.00, Part B = £85.00, Part C = £41.00 etc etc. Ie -...

Is there a way of sending an automatic message or displaying a popup box to other users when a record in a form has been created? Thanks for your help

Hi all I am trying to run a code that picks up the username to show on an Audit Trail, however the following message has now started appearing and i can tfor the life of me work out why. Im very new to Modules etc. UserName = Left(lpBuff, InStr(lpBuff, Chr(0)) - 1) it highlights "Left" as the...

Sorry Guys and Girls but im very new to this VBA lark. Anyway i have a message that comes uo with "Compile Error, variable not found" I am trying to run a code as follows. Public Function LoginName() sUser = DLookup("UserEntered", "usersentries", "[colin]") End Function I am using this...

I am stuck with a bit of code that i have used to create an Audit log of users changes on a form. At the moment the code uses the "currentuser ()" to tell me who has made these changes. ( see below ) 'Set date and current user if form has been updated. MyForm!Updates = MyForm!Updates &...

Ive copied the following script from the Microsoft Articles on how to keep an Audit Trail of changes to records in a form. It works perfectly however, i dont not want it to record blank values, only changes to a record. At the moment it is recording every field that is blank. I just need a...

Bit simple question this but i really cant make it work...... I have 2 tables one called Company Database the other called Company History. I have set up a relationship ( one company database to many company history ) When using Company Database, I have used a lookup wizard and asked it to look...

First time asking for help, but i dont think it will be the last !!! I have been browsing the Forum pages and found loads of tips on other subjects so thanks guys and girls, anyway to the point.... When printing out reports ( from forms etc ) is there a way of exporting this "one off" report...