Recent content by DaleFromEngland

Hey folks... Can anyone help with this: I have many forms that force the users to enter dates. I have created a button, that once clicked, will automate this procedure, ie enter the date automatically.... Is there any code that FORCES the user to enter the date in DD/MM/YYYY format, ie if they...

Why dont you set your FIELDS to LOCKED, then create TWO buttons. One to UNLOCK the FIELDS and another to LOCK the FIELDS. To do this, set the FIELD's that you want locked to YES. Then create a button that unlocks the field, Call the button UNLOCK (LOWERCASE). On the ON CLICK event procedure...

Hello people. Right, deep breath...................... here goes. I have a main form (switchboard) that has a combo box. When the user choose's their name from the combo box, each other form picks up the users name. FINE. Right, i have a form that displays all the users call's, only if the...

Why dont you just create a Data protection on the button. (password prompt) This way you have all 5 users seeing the buttons, but if they dont have the correct password then they wont be able to access the button. You could try this: Dim strPasswd strPasswd = InputBox("Please Enter your...

IRIE, Thanks for answering my question, but where do i put the [Forms].[mainform] and so on expression. Thanks.

Hi folks This is my question: I have two forms, ONE is a Main form linked to a query. It has Fields for Diagnostic/Action Taken - IT SUPPORT NAME - Time Of Call Close - Date of Closed. The SECOND form is a subform that has the above fields but with other fields. This subform has been...

Hello folks! This is my question, I have a command button that opens WinPopUp when the form loads. Now this is fine, but i cant figure out how to close the application once the user exit's the form. Has anyone got any ideas? Also, it it possible to minimize WinPopUp once it has been run...

Good morning folks (Well it will be if i can figure this out!) Right this is my question: I have a table called Help_Desk_Problems_Subform. This form allows the user to enter info about a computer problem, Date of call taken, date of call closed and so on. What the user does is that they...

This is my query! IS it possible to create some code that would allow the staff in an office to know if a user has entered information into an access database, via e-mail. So for instance, if a user filled in information on a Webform , once the information has been sent to the database, i want...

Thankyou very much, i have now completed my database. The drinks are on me (Well not really, but cheers) Dale

Hi people, This is my problem, what i have is a form with user names. Now i dont want the users to be able input or change information into these fields, unless they click on the add new user button. Can anyone give me a bit of info on this... Thanxs

The time and date has just been imported using the insert option on the toolbar. This is fine as it gives the date and time, but i want it to display the time contniusiously, like a clock. So the page dosent need to be refreshed all the time? [This message has been edited by DaleFromEngland...

Hi... Fairly NEW to VBA programming, i hav done Visual Basic... Well i will stop talking daft... Here goes.......... I have a CMD button on a form, that has been set to a macro. This marco does a append and delete query in one.. So records from one table will be sent to another table (TO STORE...

Hi, i know this might sound stupid, but here goes..... I have designed a database for work, (that was simple enough!)Now i know that you can search for records using the FIND button, but everytime the find box pops up, i have to change search for records to ANY PART OF FIELD. Now, the people...

Hello folks... Can anyone help me.. I have designed a query that will only show blank fields, so for instance, all telephone calls that have not been closed will show up as NULL, YEP... Right i have entered IS NULL in the criteria field, but when click on the total function in the query, the...