Search results for query: *

Hey hey all! I have some data in a table that contains two types of dates. 1) Just the date 2/6/2004 00:00:00 2) Date w/ time : 2/6/2004 11:15:04 When I run this where statement against the date it will only give me back the date if I use a single date for @BEgDate and @EndDate. WHERE...

Hello all! I am having trouble figuring out a way to search data and there really might not be a way. Here is the problem. I have a database that I made for my department. It has customer information in it. My company has a different database that houses customer information, and new sales...

Hello all, I have a form that has reservation code on the On_Dirty event and I have code that takes of the reservation in the After_Update event of the form. Basically it puts a value in a table when the form is dirty. When the user is done editing, the after_update code takes it out of that...

Hello all, I have just started learning about Output Parameters. I have a stored procedure that appends some data to table1. Then I want to get the identity of all the new records I just appended to table1 and append them to a another table along with some information from the first table. I...

Hi all, I have some code that is going to make a new record in a table thus generating an autonumber. Then I want to take that autonumber and append that with some of the original data and paste it into another table. Whats the easiest way of doing something like that? I know I can do it the...

Hello all, I have a problem where Access 2000 is openin completely minimized every time I open a database. The entire program is scrunched down to as small as it can get. Has anyone else had this problem? Any way to disable this? Any help is appreciated! Chris

Hello all, I am doing a cleanup project that has got me kinda stumped. I need to attach a sale to an app that doesn't have anything connecting the two. Here is what I have. I have an application that was "split" at the time of creation. We will use ice cream as an example. If...

Hey all! Heres a quick question on autokeys. I have a form, there is a button on the form called cmdSearch. From anywhere in that form, I want the user to be able to press the F12 function key and have it be the same as if they had clicked that button. Any ideas?

Hello all, I have some code that runs on a subform from the SubForms On Dbl Click event. Runs fine when there is data in the subform. If however there is no data at all in the subform I get an error based on what my code does (Tries to update another field with data from the row in the...

Hello all, This should be an easy thing to do but I am having a tough time trying to figure it out. I have a table that can have duplicate people. I have another table that houses status on those people and it has duplicates as well. What I need to do is to update the first instance of a...

Hello all, I am using a recordset to open a table that has nothing but numbers in it. I then take and use that number as search criteria in a comments field of another recordset using Like. It seems to work fine, except for the second recordset containing the search criteria. I can use the...

Hello all, I have a function that I am trying to write to sum a field in a table and pass that number to a form (Call the function from the form) My function looks like this: Function GetDays(StartDate, EndDate As Date) Dim strSQL As String strSQL = "SELECT SUM(BR_DT.[#ofWorkDays]) AS...

Hey all, I have a simple form/subform. The form is not bound to anything and the subform is bound to a query. I have a combo box on the form that when a person is selected, it filters the subform/query with that persons data. Occaisionally, a person has no data but I would still like it to...

Hello all! I need SQL to be a backend for a database that I have. The number of users I will have will not be more than 50 but will be reliably 20 at any one time. I do NOT have a server to place SQL on. I have computers using Windows 2000 professional edition. The users will also be using...

Hello all, I am testing out an Access Project hooked to a SQL Server 2000 Database. So far, everything works great except for the number of concurrent users. It gets locked out when I get somewhere around 12. The version of SQL server is Personal Edition and I am using Access 2000. I don't...

Hi all, I have a wierd problem where on the current event of a subform it goes out and sets the value of a Parameter for the main form and then requeries the main form. However, it jumps into a wierd loop. It keeps going back to the same procedure again and again. Here is my code...

Hello all, I have some code that seems to corrupt my Access Project everytime I execute it. Everything in my database runs fine before I run the code but afterwards, every button I have gives me a "You can't carry out this action at the present time." Am I not declaring something...

Hello all. I am working in an Access 2000 .ADP file (Access Project) They are very similar to Access .MDB files. I have a form (MainForm) that has a Subform on the left hand side. This subform is a search subform called Search_List. What I would like is for the form to come up with the Server...

Hi all, I am new to using Access projects and I am trying to write a stored procedure that will act as the recordsource for a form. The procedure is called GetRecordSource. Here is the code: Create Procedure GetRecordsource ( @DECustID int ) As SELECT * FROM Data_Cust WHERE CustID...

Hello all, I have a query that looks up Applications by people. For every person I find, I also need to find the number of applications booked. I can do this fine and it comes up similar to this: Name PersonID Appp Bkd John Doe 12345 100 200 John Doe 12345...