Search results

Hi Guys. Firstly, thanks for your replies and suggestions. Ghudson: the space doesnt make a difference as access removes it when you close the object properties. I downlaoded a couple of the other environ databases in the thread given and they seem to work fine. Im thinking its definately...

sorry i should have been clearer in my original post. Access 97 on all networked PCs Windows NT

does this work with access 97? just tried it and gives a blank message box?

just tried all 3 sugestions without any success. i can get the date and time to show but still showin #name? for the username

i have a menu which recognises a user by using the environ function. the problem i am getting is that with a small number of users the environ function isnt recognised by the system? it gives them a #name# instead. the crazy thing is that it also happens on simpler functions such as =Now()...

Hi, Thanks for your replies. The field was defined as General number whereever it was mentioned. I have fixed the problem by defining the field absolutely in the query by adding CDbl to the front of the field. Problem solved! :)

hi, I have a couple of queries which churn out some sales figures based on customer. The output query is descended by sales - so presumably the highest sales are at the top. However - the query is oddly sorting by the first digit only making the results appear in a odd order. e.g. 90 is...

Thanks Brian. Did the Trick! 1. Query Created to find the Max date 2. Second Query to find max date where not equal to Max date in Query 1

Hi, Need some help with a query im working on please! At our company, we record a customers name with a date every time a particular event occurs. I need to find out the difference between 2 dates for a customer and present the number of days. The two dates to be subtracted are the most...

Hi, I have a macro which runs when my database is opened. basically, the macro runs several querys to create a new table. The problem is that i only need the macro to run once a day - so for only the first person who opens the database that day. At the moment, everytime the database is...

Hi All, Ive searched the forums for a couple of days now trying different solutions to my problem but cant seem to figure it out.. im trying to find out which users are currently logged in to my database and then send them all a message. I've got as far as sending a message within access to...

hi all, is it possible for me to prompt a user to connect to a database as soon as they open my Access Application? my access app uses linked tables and the user is prompted for a password and username one they enter a form that requires linked data. it only asks the user to enter the password...

Thanks for the Audit trail GHudson. Invaluable! Quick question - When i look at the table view the first line in the audit trail is always blank so i have to use the cursor arrow on the audit trail field to check which records have been edited. Is there anyway to remove this blank line at the...

just been looking at the security section. unfortunately i cant use user groups to set access rights as all users have admin access. i have created a database for the company but need to make sure none of the other users can go into the datasheet view of the table. is there a way to create a...

hi, Is it possible to password Protect a table in Access 97? I need to limit who can actually go into the raw data table as even though it is hidden, a user can easily unhide if they knew how. any ideas?

colin, could it be because my form is showing records in continuous form view?

thanks alot for that. one other question.. ive tried making the field bold by: if me.txtFieldname > 0 then Me.txtfieldname.fontbold = true end if without any luck? any ideas?

Is it possible to format fields conditionally in access 97? I am trying to change the font colour and font weight based on the value in the field? Thanks in Advance

How would i go about giving a user friendly message to the user if a new record they were inputting already existed? Thanks in advance

ive just restructured all my tables based on the Double and Auto properties for numbers. The tables are showing a lot of additional decimal places for all records but i have begun manually deleted additional digits. i tried a query and it worked so just a lot of clean up to do :) thanks for...