Recent content by johnwiseman

Feherke, Thanks you so much, works a treat. John

Hi, I use the code below to change automatically two images on a webpage. I want the images to be hyperlinkable when they appear. I have tried to put the href in a couple of places but it dont seam to work. Can anyone help please. <style type="text/css"> body {position:relative; z-index:0}...

Hello. I have code which disables the shift key to prevent unauthorised access on MSaccess2003. I have imported it to a new database but it refuses to work with a vba error highlighting the line - db As DAO.Database and the message "Compile Error - user defined type not defined" Can anyone...

Hi. I receive a .csv import file where the text in one column is all in uppercase. e.g THE HOUSE ON THE HILL This column is imported into an Access table. Once in the table I need to convert the words so they appear as follows. The House On The Hill Can this be done? Thanks in advance...

Hi, Thanks for look into this. All 25 tables contain different column headers and contain different data, the only thing they share is a key as below, each line being a different table. 1, John, Smith, 28/01/2000, Male 1, 11, Road Avenue, London, UK 1, 0111, 0555555, Director, CompanyA, Sally...

Hello. I have twenty four tables in MS Access which I need to export to a text delimited file. I have no problem with exporting to create twenty four seperate files using DoCmd.TransferText acExportDelim,,"Table1", "Location1.txt" DoCmd.TransferText acExportDelim,,"Table2", "Location2.txt"...

Hello. Running the following code delivers the required results unless [qry Staff Task Volumes.[sumofvolumes] is "0". This is due to [ActualMinsPersTask] divides [sumofvolume]/[sumoftime] and if [sumofvolumes] = "0" you cant divide the [sumofvolumes] figure by "0", you get an #error in...

Hello. I have three columns. "Below98","above98" and "result:[Below98]+[above98]". The first two columns contain figures which I wish to ADD togther as a sum and display in result. i.e.[25]+[25] =[50]. What I get in the "result:[Below98]+[above98]" column is 2525. If I change the + to * I...

Hi. I am running the following query. It is pulling in over 2000 results, I only wish to produce the first 50 results which is sorted from the [qry Analysis - Total Errors]TotalErrors desc. How do I limit the results to the first 50? SELECT [qry Analysis - Total Errors].Branch, [qry Analysis...

jadams0173 Cheers for your responce. That was the very method I tried. When a user tried to access the FE they get a VB msgbox "Invalid password". This dosnt let then even access the tables in the BE. The BE can be locked in the same way, (disable by pass key ect) but that dosnt stop them...

Hello. I have locked a database to stop users accessing the database tables. The Shift by pass key has also been disabled. This leave them with an input form with no delete function. I have discovered that you can still access these tables by making a LINK from another or new database. Is...

Hello. I have a subform [frmCalculator] and a form [frmresults] with a text box [txtresultz]. [frmCalculator] makes a calculation and the results appear in a text box [txtsubresult]. How do i get the results from [frmCalculator].[txtsubresults] to populate [frmresults].[txtresultz] Thanks in...

Hi PH. Thanks for your time but it still will not return a result, if the [qry Site Audit MSC - Checked] returns no result. I have taken a step back to tried to get the [qry Site Audit MSC - Checked] to return a result as follows. SELECT Count([tbl Main Input].[Database Reference]) AS...

Hi. SQl as below. You will see that field names are slightly different but you will get the idea. SELECT [qry Site Audit MSC - Checked].[Site Location], [qry Site Audit MSC - Checked].[CountOfDatabase Reference] AS [MSC Checked], [qry Site Audit MSC - Audit OK].[CountOfDatabase Reference]...

Hi. Wondered if I could get some assistance. I have 3 querys. 1. qryAUDITED CountofReference ¦ Operator ¦ Date 2. qryAUDITEDOK CountofReference ¦ Operator ¦ Date ¦ Auditok (criteria -1) These two feed into qryRATIO unlinked 3. qryRATIO...