Search results for query: *

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...

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...

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...

Hello, I am trying to filter a subform that is based on an item selected in a combo box. What I have is a Combo box that lists job numbers (with a text format) and a subform that lists all the people who worked on that job. My problem is that in the Job Number field of the subform an...

Hello, I am trying to filter a subform that is based on an item selected in a combo box. What I have is a Combo box that lists job numbers (with a text format) and a subform that lists all the people who worked on that job. My problem is that in the Job Number field of the subform an...

Hello, I have added a .jpg image as the background on one form. The file size of the picture itself is only 116Kb, but when I add it to the form it increases the size of my database by 5Mb. Does anyone know why this happens. Destiny Is Not The Chances We Take, But The Descisions We Make.

Hello, I am having troubles getting my math functions to work in code. Text 1 is just a number someone enters. Then I have a calculate button that is pressed and I entered the following code in the OnClick Event of that button. Me.Text2 = SQRT(Me.Text1) This is just an example. Does...

Hello, I am trying to create a report that moves text boxes depending on what is selected on a form. Details: I have a form with 18 check boxes. These check boxes represent an item that can be visible on a report. I have no trouble setting up the report to make items visible or not if the...

Hello, I have a picture of a sandy beach. What I am trying to do is draw lines in the sand, as if it had been actually drawn in the sand. Does anyone have any ideas?

Hello, I have a report that diplays entries. One of the fields is a date field. I can't seem to order the information by the date. I have changed the query to sort the information in ascending order by date, but it has no effect on the order of the data. I am not sure what the problem is.

Hello, This might be a fairly straight forward question, but I can't seem to come up with the solution. I am looking to copy the contents of a calculated cell. I just want the values in the cell copied and not the formula used to derive the number in it. So that the number now stands on it's...

Hello, Currently I have a table re-create every morning by importing information from an excel spreadsheet. I first run a delete query on the table then I run the macro to import all the up to date information. All of this works a charm. What I want to be able to do now is using the job number...

Hello Everyone, I have a combo box that looks up Job Numbers from a table. The problem I am having is that the same job number appears many times in the table and I would like the combo box to just show each unique number just once. Is this possible?

Hello, I want to look up a value in a table with the DLookup function, but I am a little unsure of how to write the criteria. DLookup("Price", "[History]", "ItemNumber='" & Me.ItemNumber & "'") in this code I want it to find the price of that item the last time it was completed. So I will...

Hello, I have a form which I enter information about a job. One piece of information is an Item Number. After I enter that item number I want the form to look up in another table the description of that item number and display it on the form. Both tables contain the item number. For...

Hello, I have a form with 3 unbound text boxes. I want to be able to append the data to a table when I exit the form. I get the following error each time. User-Defined Type Not Defined (This error is on the first line of my code) Dim cnn As DAO.Database Dim rs As DAO.Recordset Set cnn =...

Hello Everyone, I have a subform problem that's got me beating my head against a wall. I will try my best to explain it and hopefully someone can help. I have a subform who's data is controled by the value of a text box, which isn't my problem. This subform is meant to give the user the...