Search results

Is it possible to query using the week number in the year as criteria. For example instead of putting 13/05/05 to 20/05/05 can we use week 12 - the idea is to save on keying info in each time.

Thanks Pat, your help as usual is invaluable.

Thanks Pat, that has resolved the problem - the problem with the structure of the database is that it has been added to over a period of time - peoples wish lists etc but I agree it does need sorting out. I did try using sum but couldn't get it to work. Thanks for your solution.

Is it possible to create a query that will use ingnore null fields when adding them together, I know I can use the Nz function to add the fields together if they are null, but equally if all the fields are null it returns a zero value. What I want to do is leave the fields blank if they are all...

Found the solution, it was the Nz function that was required, the way to apply it to the query is as follows: LS5: (Nz([q14],0))+(Nz([q15],0))+(Nz([q16],0)) The only problem I have is that it returns a zero if there are no values to any of the 3 questions and as I said before zero does have a...

Thanks for the guidance - I have also found out that the current problem lies in the query, I previously said it didn't matter if the data was a number (including zero) or blank and this is incorrect, simply if any of fields for q14, 15 & 16 are left blank then the query will not add them up - I...

I have a query that add up the numeric values in a value list assinged in a combo box in response to each question, the row source for question 15 for exmaple is as follows: ROW SOURCE: 0;"I have no idea";5;"I indicated that I wouldn’t have time today";0;"Was mentioned early on and then not...

Thanks for your suggestion, it appears to be the right solution.

Can anyone tell me how to create a macro that will automate the process of replication. I need it for end users who are not at all familiar with the normal process through the toolbar, much better if they just click a command button.

It is definitely the graph that is causing the error message and I can't alter it as when new data is entered the graph changes. Not a problem as the solution I have is OK, so that's that one sorted and I appreciate your help Uncle Gizmo. I still would like a more elegant way to solving the...

Hi Uncle Gizmo, Nothing happens unless you enter anything, actually I think it is because the data affects changes to a small graph on the form and this may be the culprit as the programm thinks your changing the layout, which I suppose you are. Whatever, the solution works but I still have...

Further enquiries found this solution to the "Changes to this object can only be made only at the Design Master" and it works perfectly. Remember I still have my other problem. This is a form error, it is dealt with by the Form_Error event – go to On Error under the event tab of the form...

I have since found this article: I've found the answer! It seems the error-handling in my vba code was not robust enough, on occasion forcing execution to end in the middle of a transaction. So to unlock the records I type Workspaces(0).CommitTrans in the immediate window. Hope this helps...

I found this on the net for the "Could not update, currently locked by another session on this machine".... and it works which means there must be something that is a bit more elegant to work around this problem... any ideas? Remember I still have the second problem. This problem exists when...

Thanks pono1, As you say the white paper is brutal, but it may be the way to go. It'll take a few days to get time to go through it all, I'll be back in touch.

Your rigfht about setting up seperate tables for each survey, that way I can just send out seperate databases that just contain one survey in which case there would be no confusion at the recopeint end. Then I can simply append the results when I get them back into the main database. The...

2 Problems, both connected with a replica database - I do not get these on the master. The first one is a real problem, I create a new record for a new person on a summary form then I open another form with a command button and the filter is the persons name that I have just entered but as soon...

That is it exactly Uncle Gizmo

The forms are surveys for salespeople, mystery shops etc. So we use each form to carry out the survey which stores the info on one table, this allows ratios etc to be calculated and produce reports that give an overall picture. The surveys are carried out at different times. Up to now it has...

The problem is that the input forms will be done remotely, basically what has happened is that we carry out 3 surveys using 3 forms tied to one table. Now they want to outsource the surveys, not a problem and I have used replicas before and they work very well, the problem is I don't want the...