Search results for query: *

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...

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...

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. 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...

Hello. I am using the Active X Calender Contol v8.0. The date defaults to a date which is set in its properties/value. I wish the date to reflect todays date. I have tried putting in =NOW() in the value but it appears this is not acceptable and I can only give a set date. So is there a way...

Hi all. When a Table is linked between two databases is the link established via the Drive mapping on the PC or is it mapped via its network path? and On Access 97 is they anyway of editing the link location/destination properties? Thanks in advance Regards John

Hi. I am using the following code to disable the Shift Key on Start Up. Unfortunately when I type in the password the words are visable. I need the words to appear ******** like you can on Tables. Here is the code. Thanks in advance for any help. Private Sub bDisableBypassKey_Click() On...

Hi. I use the following code on a command button to run reports which are selected from a populated list box. The code "me.preview.Value" selects whether the report is printed or previewed if a value is put in a tickbox called preview. Private Sub butRunReport_Click() On Error GoTo...

Hello. I have a FORM attached to a TABLE with several persons inputting fresh data. Each record has a AUTO NUMBER record. I wish to restrict the users to only see the record they are entering and not to see any previouly entered records. I have removed the RECORD SELECTORS but the records can...

Hello. One of our databases has over 100 printable reports each triggered by a button on a form. As you can imagine having over 100 buttons on one page makes for a full page and we have been asked to produce another 25. We dont really want to have multipal forms with buttons. I have seen...

Hi. I am looking for a way to record a users Windows XP logon against an entry on a table. Our current system relies on the user entering their logon/username when entering the database, this has been open to abuse. Thanks in advance for any assistance. John

Hi. My current LAN consists of 2 PC ethernetted to a belkin wireless ADSL router and a laptop connected via wirless. The Wirless connection is a bit hit and miss depending where I am in the house. I have been given another Wireless ADSL router which I wish to site in a location in my house...

Hi. I have a form whos RecordSource is attached to a table. I have created a text box on this form which I want to display results from another table. Is this possibe without creating a subform? Thanks in advance.

Hi. I have a Make Table query taking information from one table and making a new table based on the results. This works fine if there are results to make the table from, but if the query returnes no results then I get the message "You are about to Paste "0" records into a new table". Whilst...