Search results

is there a way of automating a method to paste in data from an imported table? I know all about paste append queries etc and make table queries, but the idea is that the database has one main table and with each new survey the data is pasted into the one table with variables added. please...

ta! cheers for the link Harry, I'll give that a go. many thanks John

i know snapshot works with 2000, but is there anyway to email a report as an attachment (or save the report and then email manually) and keep the formatting? rtf discards my fantastic artwork!!! any hints? as far as I can tell, I can only save it as a rtf file. ideally I could use acrobat...

of course! thanks, that makes much more sense. I'll give that a go. ta John

I am building a database which will add additional tables automatically via spss. the user will run a make table query and that will add the new table. it will share a common field with the other existing tables through pupil id. my question is, is it possible to automate a new relationship...

I will have a table brought in from SPSS which I will use to update existing tables in a database. some of the fields will already exist within the database, some will be new additional fields. is the some VB code or routine I can use to paste append or update data into exisiting fields, and...

I know this is a bit of a weird posting, but I have a SPSS routine which builds a Access database and puts in the table, variable headings and labels. but the data does not come over within this routine. does anyone know of a way to automatically capture the spss data, (no headings or...

re-install Access! I had this problem in Access 97, our IT team put in down to me making a change to the database somewhere, whilst a user was also in the database. whether this is the reason it happened I am not sure! anyway, the way I found to solve it was either to make a Autoexec...

no change is a good thing! cheers! think the developers idea is the best, as I dont know all of the users and like you say change is indeed a bad thing!! to some! so I will explore the form resizer option. will reply again once I have had a look. many thanks for this. ta John

I have noticed that my database which is used by a variety of users has different page settings depending on the pc. for example. reports which show up fine on my machine span two to three pages on other peoples machines, and the size of the forms which fit completely on the screen for some...

I have a simple form with a combo box. the user selects the project code from the combo box and the form shows the details one record at a time. so I have put navigational buttons on the form so the user picks the project code, then navigates through the instruments for that project. the...

success! cheers Gina, that worked perfectly. much obliged. John

no that is really useful. many thanks I have the email link all sorted. using a MS exe patch, it was the disabling of the message boxes that I needed to solve, thanks for the help. I'll give that a go. ta John

I have a make table query that populates a email list in a table from MS outlook. I need a way to automate this so that every time the user opens the database or once a week etc, the query runs and the table is updated. so... 1. I need a way to do this automatically. 2. I need to find a way of...

I have a field which the user puts in a diretory path eg x:\eic\eic file.sav I am looking to have the "x:\" in the field already so the user just types the rest of the path without typing in the "x:\" section. have looked at the input mask helpfile but it is not very useful! any tips...

I have a completed code 1 to 5 which tracks the progress of a project. I have 5 text boxes each called, date of stage 1, stage 2 etc etc so each time the code is changed the text box is inputted with the date, (so we can keep track of the time a project takes etc) is there a way to e.g. user...

compiling method well, tried the compiling idea, sorted out the activeX problem, made a module complied and saved the modules, but unfortuatly no conversion. so am back to building all my forms again, joy! think my plan of action will be to strip down the database and hope that the bare...

to all many thanks for your help, the actual problem is affecting one of my colleagues databases, so I will give him your pointers and see how he gets on and get back to you all if no joy. thanks John

thanks, ran that and helpfully Access said tht I dont have a Active X control registered, but did not tell me which one. so am working my way through the list of those to see if that solves the problem. many thanks John

how to.... sorry, can you explain how to run the compile method? thanks john