Is there any way of getting a function from a combo box ?
For example, I know that the following formula will give me the month number for a certain date;
Date: Month ([tblResults]![Date])...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello all
i've a query running since last 5 hours, which should have finished by 4 hours. Upon checking v$session_lops, I found that time_remamining is ever increasing. I had to kill the session...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
hi guys whut i try to do here is to refresh SQL database so that new data that have been enter before will be display in combo box. The problem is i do not know how..
Code:
sqlStr = &...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
guys ive been lurking every forums on the net and i cant seem to find the solution on my project, ok here it goes
i have a two field and i would like to subtract this two fields to get the Downt...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Showing my newbiness with this question,
If I have a table with 100 employees and a record of their activity for each day of the month,
can I total their records and show the summed total in 1 t...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have a stored procedure that takes time to execute.
It is supposed to work properly, but the problem is that it shows the message "Timeout expired" before showing making the results. ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I currently have a table with a lot fields. I was wondering if it was inefficient and I should try breaking it apart and sorting it more accurately?
Fields included are: First name, Last name,...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Which software do you use to administer your sql database?
Software like phpmyadmin or some other sql database software?
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi all,
I'm trying to ultimately create a report which displays the top 3 best-selling products. I've used the TOP function in the query to only show the top three results, however if I have two p...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi, I have a table of the following.
---------------------------------
field 1--- field 2
-----------------
A-----------1
A-----------2
A-----------3
B-----------2
B-----------3
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Here is something I've been pining over...
Let's say you have a database with an Expense and ExpenseDetail table, respectively.
And, let's say that there are two types of data entry forms:...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi all,
In Access 2007 I've come accross an error where all the controls on a form suddenly start displaying in bold, click into a control and it goes back to normal. I have to restart my app ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I cannot get rid of an unwanted design grid no matter what I do. Can someone help please
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Sorry to keep posting, however I want to stop my query giving me a long set of results as is described in the link below.
I don't want to have to use a pop up box to enter the car registration, ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am not sure how to do this?
I have a table>Form that I input a payment. That one payment is on one bill but it represents many various properties. I.E Gas payment=1 bill but applies to 13 dif...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
hi i created a simple subquery but im getting an execution error.
Code:
select parentID,childID, nodedescription
(select nodedescription from tblMyTable order by nodedescription)
from...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have created a projects database (see image of tables and relationships attached) where a project site can have multiple staff with a role or type for each. (Roles cannot be duplicated.) The f...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi all-
I have a form with an unbound text box which the user enters a date into. Then a button is used to run an append query which adds transactions for that date to a table. I want add a crit...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hey guys,
I am not much of an access programmer, but have become one the past few weeks and running into a couple of bumps. Hopefully someone cna help me out.
I have an assignments table for...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am using vb2088 Express edition and I am trying to figure out how to delete a parent record from one table with child records from another table. Right now if I try to execute a delete of the p...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I download two samples files from following link
http://forums.databasejournal.com/sh...threadid=45488 [http://forums.databasejournal.com/showthread.php?threadid=45488]>
after opening them,...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello,
I have a form called lease, on this form I have a subform to input the tenant information that is renting. I setup a query on the combox on my subform to get my tenants name. I made a fie...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi -
I am trying to determine if it is possible to run the DBMS_STATS_FUNCS.SUMMARY procedure against just one partition of a partitioned table. I have a large, range partitioned table in an...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Can someone tell me how to test a Requery to see if it returned any records to the recordset? I want to add a user message explaining the the parameters choosen found no records. Thanks for any ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi all,
I really do require some help for a university project and as you can probably tell from below my knowledge of access is "limited" to say the least.
I am using MS Access ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Browse sub-categories 
