Search results

Hi All I have a userform that doesnt display the footer when its loaded. I have a button called "Button1" which i press and i want it to make the footer visible. What code can i use for this? Is this the setproperty method? Thanks

thanks Bob, it works great. Just for my own interest, why have you put the [password] and [username] in brackets but you left "tblLogin" in quotes?

Hi All In have a form that request the user to type the username and password before being able to enter the main screen. However, the username and password are located in a table called tblLogin. Im trying to match of the username from the form with the password within the table, and if...

Many thanks for taking the time to reply

Hi All I was how to get the same style and mixture of colors blended together (a gradient effect) as seen in the page header of any microsoft access 2007 template. It seems that the background colors are mixed in i.e. light blue to dark blue and gives it a nice appearance, it also has a...

Many thanks, that was exactly what i was looking for.

Bob, Thanks for the reply, but i dont think you understand my intention. I am trying to create a continous form based on my table. I want to know how create a continous form i.e. i only one text box on my form in design view, but when i press 'Form View' all the record will show for that...

Hi, So how do i manually create one? do i need to group items together?

Hi All I am able to create a multiple items form that is based on a table. The data is displayed in table style format on the form. But Access automatically creates this for me. I would like to know how i am able to do this manually from design view? Do i need to use grouping of some sort...

many thanks :)

Hi All I have access 2007, unlike Access 2003 - I cant undock a new form or table etc on the screen and move it around. It seems to be stuck to the Access Development Environment. How can i undock it so i can move it around on the screen? Thanks

Thanks Bob. I need you expertise for something else, I have a list box with in a form that Allows users to Add and Delete data from it. I have no trouble Adding to it but i cant seem to get around the deleting part. I have the following code, it executes fine except when a user select...

Hi All Im new to Access, but can someone drive me into the right direction on how to let multiple users access the simple database i have created. The database is nothing special, but needs to be accessed by people in Edinburgh and London. Is there a way to do this? Many thanks

Hi All Is it possible to modify the top margin and left margin of a combobox. It allows me to modify this with textboxes but not with combo boxes in the properties section. My form looks uneven in terms of the indent and centre alignment. Many thanks

Hi All 1) I have the following code which add an item to my listbox1, but how can i clear all the items in one go? Listbox1.Additem "Test" More still, how can i delete only the selected item on the the list box? I can assign the code to a button, so that not a problem. Thanks

Hi, Thanks for your reponses. My data is in form view. I have set the scroll bar to verticle but it still doesnt appear. I still cant use scroll to look at the missing information.

Hi All I have a text box that is a summary of the orders made. It can sometimes be a lengthy summary and the text box isnt big enough to view the entire text. Im looking to add verticle scroll bars to the text box so the user can scroll down to view all the text. Is this possible? thanks

Thank you for your help

Hi All Is there an option within access that populates a cell if the user leaves it blank i.e. if i have three columns in a table that defined as ID, Name, Salary - then lets say the user doesnt fill in salary can i have access assign the cell to £1000 if the cell is left empty? Thanks

Hi I have tried your suggestions but they dont to accept data entry or any modifications. Im embedding a two datasheets tables into a form that is linked by a unique column ID. for example, if the first table reads Customer: 001 , then the second datasheet at the bottom of the form will...