Search results for query: *

Hi, I have a table that holds different rating categories in a single field - comma separated (table name: scale). Each rating has a value relative to where it is in the list (first_item = 1, second_item = 2, third_item = 3 etc). I want to be able to run an SQL query in MySQL to split the...

Hi, I have been trying to generate a pivot table in MS Excel from an Access query without success. I can get the data into excel however cannot create the Pivot, keep getting error: Run-time error '5': Invalid procedure call or argument Private Sub cmdPTable_Click() Dim ExpCheck As...

Hello I have designed a database to capture detail of revision session for students. The database can detect if there are clashing sessions and generates a report (query) I want to create a cross-tab to identify which subjects are clashing with each other however I cannot get the output to...

Hello, Does anybody know a way (perhaps using JavaScript) to merge PDFs together based on their filename? I have created several PDF files (extracting from a large file) with student timetable on it and named the files with their student ID and page number (some are 2 pages and some are only...

Hi, I am having some trouble joining two tables together that exist in seperate databases. In PHP you can connect to one database but not two?? I have a database that contains customer and their login (they log in with email and password). I wanted to link this to another site (a helpdesk...

Hi I am trying to redirect from one domain to another without changing the URL address. I have a url which is: http://www.MusicStore.co.uk This domain is hosted however has limited functions. The files for this site are actually stored on another domain that has phpDatabases, more space and...

Hi, I need help using mod rewrite to change the appearance of a URL. I am running a virtual shop (for educational purposes only) and hosting this on my own web hosting account. I have a domain for this educational shop and this points to the actual location of the index file. I need not to...

Hi, I need help with a redirect and mask of url using PHP. I have created an online store to use within an educational context (the store is only a simulation - there is no live payment processing). I have hosted this on my own webhosting server that I use for a different site. I have...

Hi I need to create a database button that will save the content of the clipboard (a screenshot) as a JPEG. This is for students to create screenshots as evidence for ict coursework. I originally was going to paste the pictures into access, however the bloat with this made the file size huge. So...

Hi, I am trying to use crosstab queries to devise a weekly shift schedule for employees. I have a tblCheckIns that has fields: *employee name *payroll number *date *start time *end time from which I have 2 queries running on this: qryStartTime qryFinishTime I have got the date as...

Hi, I am trying to import images from the web onto a form. I want to if possible store these in an OLE object to save on the database. I have successfully added a Web Browser to a form and used VBA to navigate to an image, eg...

Hi, I am trying to import images from the web onto a form. I want to if possible store these in an OLE object to save on the database. I have successfully added a Web Browser to a form and used VBA to navigate to an image, eg...

Hi, I am trying to write a loop to capture pictures accessible on the web and copy these into an OLE object. Employee pictures are on a web server and other that manually opening each one in a web browser and copy and pasting manually I cannot transfer these over. I have tried adding a Web...

I have a subform that has a datasheet view. I want to be able to select the record upon the mouse being over this record. CODE docmd.RunCommand acCmdSelectRecord only selects the first record as this is where the record selector is. I want to move focus to which ever record the mouse is over...

Hi, I have created a list box on a form that can have multiple values. I have managed to create a text box that calculates what the Criteria in a query should be. This referes to keywords. If the keywords "apple" "orange" and "pear" were in the list box, the text box would read "apple" or...

I have a table called "Resources" that has a field "Reference". In another table called "Authors" I have "reference" also with another field "author" this links the 2 together. From a form I want to open form "frmResources" and filter to an author that I have selected from a unbound combo box. I...

I have a subform that has a datasheet view. I want to be able to select the record upon the mouse being over this record. docmd.RunCommand acCmdSelectRecord only selects the first record as this is where the record selector is. I want to move focus to which ever record the mouse is over (then...

Hi, Does anyone know a way of setting the page margins of a report when it loads in VBA? Everytime the report opens on a different machine it resets the margins to the defaults. Is there a way to change these values using VBA ?? Thanks, Gary.

Hi, Does anyone have any kind of software that will allow you to select which version of office you want to run a file with? I use Office 97 & 2000 as some files in 97 I use with work and they don't have office 2000. As default the PC opens files with 97, therefore when I run an Access 2000...

Hi, I have written some code from Excel to interact with attachmate and select all, copy and paste into excel. This appeared to be working yesterday, however everytime I try to run now I get this runtime error. My code is ... -------------------------------------------------------- Sub...