Search results

Got it working....after all this time, even though the field in the table was "date/time" format as well as the date be supplied, I needed to use CDate to convert both of them to date. This only needs to be done when prompting for the date, not when setting the date as the...

I have a query that uses an odbc table. The query prompt for a date: [Enter Date] After entering the date, I get error: "ODBC Call Failed" Yet...when I set the criteria to the date I want: #01/01/2005# I can retrieve the data, no problem. Any idea why I get the ODBC Call Faile error when...

Thank you for that explanation, ByteMyzer! You are right...there is a function which opens the form and sets the openargs property. I have never seen this before. You have given a very good explanation that will give me a good start to understanding how this database operates with respect to...

I have found a function in an inherited database I am working on. I don't understand what it does. Can someone explain: This is the function: Public Function GetArgs(strArgs As Variant, intNumber As Integer) As String 'Arguments must be separated by a ^ Dim intCount As Integer...

Thanks for the tip, FoFa. I will play with that and see if I can get it going.

So, I just became familiar with the object browser, but it does not quite do what I am looking for. For example: If I have 200 tables in my database, and I need to find one of them so I can make a design change to it, it takes long to scroll through all the tables in the database window to...

In all my years of using Access, I have never used the Object Browser! Thanks for the tip, Ken! :)

I am wondering if there is a quick way to find a database object (table, query, form, report) other than having to scroll through them in the database window. E.g. I have many many queries and when I need to find one to make changes to it, it often takes me a while to find it when scrolling...

I got it working....after searching the internet for this error message; someone came up with this explanation: "Access is probably firing the Open event of the subreport twice. The first occurance fires *before* the main report opens, so any attempt to reference anything in the main report...

I got it working....after searching the internet for this error message; someone came up with this explanation: "Access is probably firing the Open event of the subreport twice. The first occurance fires *before* the main report opens, so any attempt to reference anything in the main report...

As I continue to struggle with this, I have so far determined that it has to do with the SendObject method not working if I dynamically set the recordsource for the subreport. The SendObject method works if I do not set the recordsource for the subreport dynamically. Any ideas yet....anyone??? :(

I have some code, which opens a report containing a subreport. The recordsource for the subreport is dynamically set with the on_open event of the subreport. On the click of a button on my form, the report opens and the subreport displays the correct information as per the recordsource...

Here are the steps the user of the db needs to take to get the report to display the correct employee information: 1. Select Employee from the Switchboard to open the form that displays employee information. 2. On that form the user clicks a button that opens another form for data entry of...

Hi Ken...I just did it the exact same way you explained, and I still get the same error. I don't know what's going on here! :-(

Thank you for your input Ken. I just checked, and I am using the name of the subreport as it appears on the main report. I need to change the recordsource on the fly, because the records for the subreport will be different depending on the Employee record that the user is running the report...

Hi Ken, I just tried your code and now I get the error: "You entered an expression that has an invalid reference to the property Form/Report. The property may not exist or may not apply to the object you specified." BTW....I am using Access 97. ???

I am having trouble setting the recordsource of my subreport using the On_Open event of the Main report. Here is the code I am using to set the recordsource: [Reports]![rptMainReport]![srptSubReport].RecordSource = "SELECT * FROM tblEmployee WHERE Index = " & intIndex & _ " ORDER BY...

THANK YOU EMP! It worked....You are the best!!

Can someone please help me with this...I am spending too much time on this simple thing: I have a DLookup Function that I need to make work using values from text boxes on my form instead of the actual values. This works: x = DLookup("[Index]", "[tblMain]", "[LastDayWorked] = #12/03/2004# AND...

Hi Ken, My referencing is not the problem. I can't even get a message box going on any of these events for the form. :confused: