Search results

Got a report which i email in HTML format from Access, and i want to put the company logo on the report. When you email in HTML format any images are lost. Is it possible to have a http// link to an image from a web site in a report? Cheers Kevin

Thanks RuralGuy, fantastic, it works and it keeps its formating when converted to HTML. Nice one :D KevinG

RuralGuy, yes i did that first, but the report is exported to HTML and it gets lost on conversion. Thanks

I have a field on a report i want to change the forecolor if its value is 0, the field is a number field. I have the follwoing code in the on open section If Nz(Me!Txt1, 0) = 0 Then Txt1.ForeColor = RGB(0, 255, 0) End If When i open the report i get Run-time error'-2147352567 (80020009) You...

Keith, thanks for reply. i started with if startdate = 10:00 then T1000 = "F" T1015 = "F" T1030 = "F" T1045 = "P"......etc these would be written back to my table but it would have been loads of code as i would have had to do above for each possible start time every 15 mins from 10am to 6pm...

Thought i was being clever here but hit a brick wall i cannot get around. This is a party database for a Playcentre. The table has a field for every 15 minutes starting at 10am to 6pm And there a 3 differant areas, so when a party is booked and a start time is entered i want the form to...

THanks for advise, will give this a go.

I have had 1 experience with Vista and a friend could not load Office, it turned out to be user rights, administrator is not good enought, but i cannot remember how i resolved it, it involved turning something off in control panel and users i think?

Hi Can anyone point me in the right direction. I have a databse which consists of a front end and back end which holds all the data. This was written in Acess 97, upgraded to 2000, and now on of our users is trying to use in Access 2007 on a Vista plateform. I know i should get rid of the...

Thats good, all the fileds i need to add are yes/no fields, thanks for advise

Got it, removed the 'dbsLSG.TableDefs.Append tdfNew, i assume the loop was doing the work, then this was trying to do it again. Many thanks all.:D

Nice one, almost there, i open the remote table and make sure the new fields are not added, close the remote, then run the code, i get an error ' cannot append. An object already exists in the collection.', when i open the remote table it has added the new fields, does this mean the loop is...

Hi, thanks for reply, the table is not in the current database its in a remote database, when i exicute i get error 'item not found in this collection' i also tried Set tdfNew = strDataPath.TableDefs("members"), but it did not like it. strDatapath being the full path to the remote databse.

Hi all I need to write some code to add fields to a table in a remote database, i have come accross the tabledef command, but i do not want to create a new table and add data, which i cannot get around. This is the code i am using and i get error table already exists, which is correct, but how...