Recent content by rmacleod

All that just because of the color...man thats dumb :) thanks for the help.

could someone tell me how to get rid of the Grey around the sides of this Tab Control? I set the background of the Form to White...but the sides of the Tab Control are the original color..how can I make them white so it blends in with the Background? Thanks, Rod

I just used the Security Wizard to add user level security to a database I created. the Problem I have is that I can only open the Database if it is located in the location it was when I created the Security. Could someone tel me what I have to do so i can move the Database to another location?

thanks..but SendOject uses outlook. I would like it to be able to send automatically through a specified SMTP server.

I have 2 list boxes that each contain the total of a query. I have another Text Box that is set to = List1/list2 Inorder for the Calculation to work in the text box I have to actually click on the two List boxes to select their values. I have tried using this code to to automatically sellect...

Anybody know of some code that could be used to send a report Via E-mail. without using Outlook. just via an smtp server. I have a little Task database and we would like to be able to Email a task to the person it is assigned to by just clicking one button and that is it.

Actually I found the problem...I had to set Scroll Bars to Neither.

could somebody tell me why when I make the Background of a form a different color from the default.....when I view it the the bottom and right sides are not the new color?? eg.

you could make them Listboxes and put the query to calculate the sums in the Rowsource.

Ok...I understand it now...but it is not working for me If I do this: Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[fldInDate] = #" & Me.LstSearch.Column(1) & "#" If Not rs.EOF Then Me.Bookmark = rs.Bookmark it has no error If I do this: Dim rs As Object...

I have a form that I am using a list box to goto a record. in the List box I am selecting the Serial number of an item to go to a repair record for that item. the Problem I have is if that Serial number is in the table more then once. It only goes to the first record. The Primary key is a...

Actually it is happening for me in Access2k3. I will try it in the load form event instead.

thanks, but when I use that and open the form it seems to lock things up. I can not do anything in the form. It wont let me select any other controls on the form.

How would I make it so that a List box defaults to the first value available in its list? I need to be able to make a Calculation based on the value in the listbox...but by default no value is selected. So my calculation does not work until the value is selected.

as I said..I am Rather new...and if there is a better/easier way of doing it, i would like to know. correct me if I am wrong ...but to use Text boxes...I would have to create all my query for each total that I need..then I would have to create one master query that contains all the other...