Search results

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

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

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

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

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

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

Hi there hope you can help :) I need an append query to add weekly rent records to the rents table (only properties that are currrently occupied) When the query is run it should promt the user to enter a week ending date and pick up the weekly rents from the proberty list table. The tables are...

Hi there hope you can help :) I have created a form with a subform and has the following information displayed: (Form) Tenant ID Mobile Telephone Number Title Credit Reference Surname First Name (Subform) Date Due Amount...