Search results

When I try and run access97 on XP it comes up saying "there is no license on this machine" and wont run it. All other office packages work. Can any one help?

Got it Have just nutted out the fix myself,sorry to bother you. " Isnt Learning Fun"

I currently have about 15 reports opening through a macro on a daily basis using the =Date() function. This works well. What I would like to is get another set of reports opening, but over a period of days Can anyone help please, cause its currently driving the team leader potty having to type...

Thanks for your replies I shall go and try what has been suggested, thanks to all. It may take me awhile as I have so many DB's to alter at the mo, although this problem is common to all. As for version, I am writing on 2002 then converting to 97, I shall look at the help files at the office...

not so easy as that Excellent idea to save the record, I already do but that doesnt solve my problem. The reason for this is that when finished with the current record I wish to go to the next record (up to 10000 records) that is using the same underlying query. By updating the query I hope to...

Cant find the info I need Have had a look through the manual (cant find anything in the help files) and as far as I can tell I have to do the requery this way , in code, as its the only way to carry out a proper requery of the query. Does this make sense to you ?

I am sure this is an easy fix but it has got me stuffed. I am trying to get my command button to requery a field on my form( OPEN FORM) I need the underlying Query updated before going to the next form. The button is currently running a macro to go to next form with certain parameters. But the...

help? I have a similiar problem to yours that I am trying to solve. Currently Access only warns you on exiting. So far what I have done is used the OnCurrent function in the form to Set Value =1 in a field called form open. If your next user tries to open the record, as long as they have the...

Many Thanks to Brad Thankyou for your help, works well. Thankyou again Caman

thanks for your reply Thanks for your prompt reply, have printed the info you refered me to and shall read tonight. Since posting this problem, I have reformated one 486 and loaded win98. This has cured the problem, so I feel the prob must lie somwhere in win95. I cant run 98 on these machines...

I am using the Date() function to filter records in a query, I am currently using Access97, this function is working well on the Pentiums running win98 but will not run on the 486's running win95 (please dont tell me I need better equ. I know I do) The error I am getting is ' Function isnt...

Solution ? I believe I have the answer for you, I think I solved the prob today, at least it works single user, so I am going to try it on the network tomorrow. I have every confidence that it will work, be back this time tomorrow so if youre interested let me know

re problem Dont know if it is what you want but this is what I do. I assign the button on the switchboard to a macro The macro then opens the desired form, but at the same time it applies a filter (in my case another query) the filter (or query) has only the fields that require editing in it...

Ok I get your point yes you are correct, it is the record not the form that I need to have locked. can you help?

have just been looking at the northwind sample db where they have a module that uses the command isloaded I beleive that this is what I am looking for, is there any way I could use this so that as soon as a form isloaded a Set Value runs thanks for any help

I am currently using access in a multi user enviroment, the problem I am having is that you only get a warning that someone else is in the form when you gp to save it. What I would like is some code that does the following, if form open, then goto next form. The biggest problem is that I am new...

I posted a similiar request several weeks ago and am still waiting a reply. It would appear we are both using Access in the same manner, which also appears to be not very common. As I am not up vb code or anything my help is limited, but I did download something from another board recently, Im...

Hi all, Am having problems locking forms with multiple users, currently Access only notifies you another user has the form open when you go to save it. What I would like is a macro so that when a user exists the form they are on the macro takes them to the next available form that is not...