Recent content by GazzaG

In other versions of Access to embed a photo all I did was to right click on the photo field box on the form and select "Insert Object" then browse for the file and select it, then the photo would appear on the form, but this doesnt happen all I get is a file name? I tried several times and at...

I am trying to insert a photo on a form, I choose a .jpeg from file, but instead of the photo showing on the form the file name shows, wether it is embedded or linked, I am running Access 2003

Hymn that was brilliant, I owe you big time, just one thing I had to insert the "=" sign to start with to validate the expression, thanks once again.

Thank you for the swift reply, and the code looks great, but unfortunately it means nothing to me, is there any chance i could send you my file to view? I would appreciate it, Im new to access VB coding.

I have a form which has 9 fields in which you enter the value of up to 9 items (value1 , value2 etc) how can I incorporate another field which which will give me a running total, I also want to add this to my report which will be the easy part I guess by just including that field in the query...

Thanks crowley but i just put [which report ID] and that did the trick i was looking for. thanks again

Help please I have a table TblFireSafetyInspection and within that a field called ReportID, i would like to create a button on a form that when the user clicks on it it will ask them to select the ReportID and that particular report will open with the information, what do I need to put on the...

how do i update a database which has spaces in tables and columns and change them without spaces, would i need to write some code because if i just change them its going to effect queries and reports isn't it? I must mention that everything is working ok, but I have been told that spaces are a...

Can anyone help me on how to display "height" in a table, ( feet & inches" when in design view I cannot see any format for height, would it come under scientific?

Hi I was wondering if there is a way to change the form background colours in properties to custom colours rather than the inbuilt ones. Thanks

Thanks for that, I just loaded 2003 also and go the same message.

Thanks UPS, I will look into this, I'm not sure what the code is though or how to embed the chart onto the report.

Cheers Roy just what i needed,

Hi, I would like to know how to show a chart on a report by clicking a button on my reports form, at the moment my button opens the query table i then go to view chart which i have already made from the query, but i would like this in one operation from the button. thank you.

Hello All I have a combo box "TYPES OF CRIME" can i Auto update the table field using the "On Not In List" with an event procedure. Im new to this so any help would be appreciated with the code. cheers