Recent content by matethreat

Hello, What I am attempting to achieve may not be possible without code, but here goes anyway. I am trying to find a function that will tell me which row on a worksheet is currently selected. For example: If I am currently on worksheet "X" I would like to know the row number on worksheet...

Hello Everyone, I am having a problem with Excel 2003. When I enter a formula into a cell, quite often the formula is displayed and not the result. Is there something I need to do to have it always diplay the result. I have never seen this before. Thank You, Aaron Destiny Is Not The Chances...

Hello, I don't know if there is a way to solve this problem but, it's worth asking. I have a table the holds procedures to complete jobs that our company produces over and over. I have a second table that allows me to schedule people to jobs. What I would like to be able to do is run a...

Hello, I am sure the question has been covered in the past, but the search engine on the website is not allowing me to do a search right now, so I thought I would just ask the question again. I am using a box (rectangle) over my command buttons to allow me to use colors for my buttons. What I...

Could you not just start typing the name you are looking for in the combo box. It should take you directly to the name you are looking for. You should not have to set up a seperate search. Destiny Is Not The Chances We Take, But The Descisions We Make.

This might be a litte longer a solution then some of the others, but you don't need to create a query. If you place this code in the OnClick event of your command button you will get the same result. Dim cnn As ADODB.Connection Dim rs As ADODB.Recordset Set cnn = CurrentProject.Connection Set...

Hello, In the query for your combo box add an additional field with the following info. Expr1: [tblname].[fld1]&"_"&[tblname].[fld2] Then in the format tab of the properties box for the combo box change the Column Count to 3 and you Column widths to 0cm;0cm;5cm Your combo box display during...

I have a form with 2 Active X Calenders. I use these calenders to view information about jobs between 2 dates in several reports. What I would like to be able to do now is create a temporary table that creates a unique record for each date between the 2 dates selected in the calender. I then...

You cannot perform calculations on calculated items. But, if you put the following formula in it should work. = sum(quantity * price) Aaron Destiny Is Not The Chances We Take, But The Descisions We Make.

I have actually solved my own problem by splitting the database. Keeping my tables on the network and the forms and reports on each users desktop. Thanks for your reply. Destiny Is Not The Chances We Take, But The Descisions We Make.

Hello, I have a database that I have placed on our network and I would like the ability to have multiple users in the database at the same time. My problem is that once one user opens the program it locks out all other users. The following error is displayed when a second user attempts to...

Thank you for your responses. I was able to get it to work by creating a seperate query and then using that query as the source for my subform. For some reason it works this way, instead of having my subform with it's own internal query. Aaron Destiny Is Not The Chances We Take, But The...

Ken, Thank you for your efforts. I created a query seperate to the subform and used that query for the data in my subform, rather then direct from the tables, and it works. Thank You Aaron Destiny Is Not The Chances We Take, But The Descisions We Make.

Yes It Is. Destiny Is Not The Chances We Take, But The Descisions We Make.

PH, With " Like '*" & [Forms]![Scheduling]![Combo8] & "*'" I Get No Result If I Modify It To Look Like This Like "*" & [Forms]![Scheduling]![Combo8] & "*" I Get Only Exact Matches This is a tricky one. Destiny Is Not The Chances We Take, But The Descisions We Make.