Search results

Normally this is exactly what we try to do, but a few customers don't 'want' to do this, it might also be that they are running on Citrix workstations or a similar setup Ok one of the reports is based on a query which in turn is based on another query and a tmp table, that query is based on...

1, wont work, they only have one copy of the program and the backend, these aren't normal tables remember, the contents gets deleted. 2, can I store the resulting query?

Some of our users run our programs in the following setup, one program on a server but multiple (though few) users using it. Now this leads to problems where the program uses temp tables. I've sorted the problem for most cases ie when they are used in code or as a simple report query, but I've...

brilliant it worked, thanks just had to sort out my table naming. Now all I've got to do is come up with a string search and replace, because the record source might change!

ah:) I mean tables that are local to the front end, and not in the backend. I normally use them for complicated reports or forms.

If you have multiple people using the same problem you have to be careful of temporary tables, as access won't handle it for you. What I've (just) done when a temporary table is needed it creates a copy with a unique name based on the windows username.

mmm weird its now complaining: Error:2451 The report name 'MonthlyUpdate' you entered is misspelled or refers to a report that isn't open or doesn't exist. Well its not misspelled and it does exist, but how the hell can you alter the record source when its open?? stDocName = "MonthlyUpdate"...

1) probly isn't do able because of conflicts with different users 2) seems what i need but how?

I have a reports record source that I need to change via code. The record source currently points to a temp table, and this temp table changes name (but obviously not structure). I've no idea of the possible table names so I can't create a report for each name, so I need to change the record...

We would like to be able to provide our customer a database where they can create queries and reports but not get at our internal code...is this possible?

thanks for the help...eventually came up with this: Private Function ValidateForm() As Boolean 'validates the form fields based upon the required setting of the field 'returns true if ok, false otherwise Dim myDB As DAO.Database Dim myTD As DAO.TableDef Dim myFD As DAO.Field Set myDB =...

Some fields are set to required in our backend and if you try to save the form with out filling these in then Access brings up its defualt, not very clear, error message. Is there a simple way of intercepting this and replacing it? Or if not then is it possible to loop through the fields...

it helps...and brings within 10% of the goal:) the last problem is also have code that needs executing after a succesful save...but that might be easier to do...depending on the event order. after before update what comes next? Is it after update? If it is then I could put the code there...but...

yep the data on the form... unfortunatly its nessacery because of some extra code that needs to be run before the save, some of it validation some of updating recordsets else where. plus the users are pretty stupid, need a save button and a confirmation and the ability to undo their mistakes.

I'm trying to work out a save routine that works however the user uses the form. I started with a simple button (and some extra validation code) but thats no good if the user hits the exit button or the 'x' So then I started using the form_beforeupdate event which was good because it seem to...

thanks, thought it might be something simple using an event...just didn't know the check for new records thanks again!

I want to fill some fields when a new record is created, and these fields can then not be altered afterwards. I have a new button on the form which works, but because I also have record navigation I have the new button on that which doesn't run the code. Can I disable the button on the record...

no one has this problem?? in that case how exactly do you install access 97 then office xp? I use the method in the various kb articles.

In Access 97 some of the built in help isn't working. If for example I highlight .openrecordset I get the error: Cannot find the c:\...\DAO\dao360.chm file. Do you want to find this file yourself? If I click yes and look for the file it doesn't list .chm files (probly cause they didn't exist...

Is that the only way? going through every control and locking it? and then unlocking the others? Damn...any quick way of doing the above?