Search results

Again thanks for replying :) but I did figure it out, it was due to the the fact that the machines that worked had office service pack 2. I have updated the other machines and they are now working fine but thanks for all your help :)

Please somebody help!!

Thanks for replying :) ...did the above but still no joy :( Below is sql view of the query that I am running, I wonder if you can see something that I can't SELECT tblCorrectiveActionLog.[Audit Number], tblCorrectiveActionLog.CARRef, tblAuditInformation.[Lead Auditor]...

Hi I have been looking all over the web and have not had much luck. The problem is that on some machines in the office a parameter query will not run properly. On mine and a couple of other machines the query runs perfect and picks up the right information. On the others, the query runs but...

What do you mean?

Still only increments by one on all records at once so they still all have 60 in the field. The above works if I append each record one at a time

I would use autonumber but I don't want the user to abandon/cancel an append query and the sequence going out of alignment. With regards to the field this is numeric, I have a unbound textbox on the form that picks up the number and adds a leading zero. Below is what I have picked from the...

I am using Dmax + 1 at the moment but if I append say 10 records in one go it won't work it just appears as a blank field.

Hi All Hope you can help, I have been looking on the forum but with no luck. I am trying to design an append query that adds any number of records to another table but need one of the fields to increment by one for each record, so for example; I append 10 records and the other field increments...

I have attached the database I am working on I've Got the general layout on how I want it to work I just need your help on the command button. On (frmAuditQuestions) I need to be able to save selected questions that have been ticked and placed into the parent form (frmAuditInformationQuestions)...

Hi hope you can help Having real problems and I don't know if am over thinking about the problem :confused: :confused: What I need is a subform to display 60 questions but with the option of entering and storing more questions if needed so the user can scroll down the list of questions and use...

Thanks ghudson worked like a dream once I had seen that...many thanks mate :D :D :D HITC

Hi there Not to good at VB but it's something i want to learn so I hope you can help me. I have attached a database I am working on, i have designed a form (roughly for now) and managed to modify some vb code as to be able to browse files on a pc and select the directory path of the folder...

Hi all I would like to know if there is away of making ONE bit of data to go horizontal and not vertical. So I have the following; Name: Mr Arrow Number:0134 Date: 28/2/06 Policy No: PC01, PC02, PC03 Etc Cheers

Hi there thanks for all your help on the last problem got it working now. What I need now is 2 crosstab queries to become one, example below on how I want it to look: Created By-----Total Of Date-----Total Of Date Taken-----Policy Name Type (eg Breakdown,Caravan going across counting Date and...

Cheers for the reply but maybe am doing this all wrong is there a way of doing the following: The query that am trying to design is to pull records in 2 ways as follows: The first is to pull records from the [Date] field for the month of November. The second is to pull records from the...

Hi there hope you can help again :) I am try to write the following multiple iif statement (Badly!!) that will be in the [Date] Criteria of the query. I hoping that one of you could be kind enough to re-write it for me and be able to finish off the FALSE part of the statment as I don't know...

here is the sql view using the max function SELECT tblProspectDatacard.dcSource, tblProspectDatacard.dcCompanyName, tblProspectDatacard.dcDatePassedFromMarketing, tblProspectDatacard.dcRnlDateCombined, tblDiary.diComments, tblProspectDatacard.dcExecutiveDealing, tblProspectDatacard.[dc£placed]...

Cheers for that but I don't understanded access that much. The query does work using the "last" function until I put a new date with a new comment in. I then run the query and it won't pick up the most recent comment an example is below: 28/11/2005 - Also A Datacard (It will pick up this...

Hi all hope you can help..please I have a form with a subform (poorly designed by somebody) and need a query that pulls certain information (which I have done) but I also need it to only pull the last record in the subform (the subform is like a dairy entry, a date followed by a comment). I...