Search results

Thanks John, where is this to be inserted, in the target box within the shortcut?

Hi all, I've had a quick search but couldn't find the answer to this. Is there a way that when a user launches the application via my workgroup file, the default login name is always null? Currently it retains the last users' login name. Thanks Kempes

If I have read this correctly, I think all you need to do is include the condition into your count. Try this Sum ({BD_room.Room_area})/Count ({CORE_staff.job_title}, CORE_staff.job_title}) Any Joy?

Sorry RG, didn't notice your fix attached. Good work mate!

Hello again, Try this in the control Source. (Works a treat as a visual aid on the form) =Format(Sum([Timestop]-[timestart]),"hh") & " Hours" & " " & Format(Sum([Timestop]-[timestart]),"nn") & " Mins" & " " & Format(Sum([Timestop]-[timestart]),"ss") & " Secs"

Thanks, I'll have a crack at that. I've not done much loop coding either.

Thanks Ken. I would need to do something like that. What will happen is, the administrator will gain access to roughly 12 forms with different locked options to the every day user. When admin goes in, they will have access to all options on whichever form he/she opens. Any idea on where to...

Hi, Does anyone know if code exists to (unlock or enable or Make visible) all fields in one go rather than keying ??????.locked = False for each field? Thanks Kempes

Not sure if you still need this but you can get the bullet point • by holding down alt then pressing 0149

Hi, Glad to hear from you again. I too have v10. If you go to Help > Report Samples, there should be a host of sample reports you can view. As for events, There is an option under the reports header called Alerts, albeit I have no experience whatsoever with it. (There is a sample report that...

Thanks for the response Doc Man. My db is vastly rich of many forms and controls so there is no way anyone other than admin can get into the back end tables/queries etc. The question was posed more as a quick fix due to the size of my DB. There are many areas that will rely on the rules as...

Hello again, Does anyone know if this is possible and is there an easy way to set it up? My db has many relationships, hence if you attempt to delete a record from the table, it will not allow it if there are related records. This is great, however. My intention is to disable any record...

Quite like the access reports but with greater functionality. Basically, when you produce a new report, it prompts for your db connection. You can connect multiple databases from here. I have have connected an access db to an SQL db and an Oracle db in a single report. You then have your...

It's reasonably easy to use. Just a case of playing with it once you know the basics. What do you need to know? What version do you have?

I also have this problem, and I have no idea how to rectify it!!!!!!

The chances are, you've placed a full stop in one of the events. I've done the same thing before. Find out at what point this message triggers and it will lead you to the culprit.

Thanks Doc man. How do I check my page file allocation?

Add both fields to a new query, right click and choose Totals. Change the Date total to Max from the Drop down list. Leave the other as group by. This should work If I understand your question correctly.

Am I right in thinking you wish for the form to open in add only and not view any existing records depending on where you are calling the form from? If so, you could set this when opening the form by using the above code.

Yes there is. Form_yourformname.yourfieldname.DataEntry = True/False