Search results for query: *

Each cmpy_num has a net assets and net income. But not all cmpy_num reports net assets

I am sorry. I left one column out. I didn't think it mattered, but I see it does now. The tables should be -- raw_data_info raw_data_id -- raw_data_name 1 -- net income 2 -- net assets I have another table called raw_data raw_data_id -- report_date -- cmpy_num --- amount 1 -- 2/28/2000 --...

Thanks for you response. I tired this.. SELECT I.mdy_raw_data_name, D.amount FROM raw_data_info AS I LEFT JOIN raw_data AS D ON I.raw_data_id=D.raw_data_id WHERE report_date=#2/28/1999#; and it returned me only the values that were in the raw_data table. I need null to return for all the...

I need help with a outer join. I have a table called raw_data_info .. raw_data_id -- raw_data_name 1 -- net income 2 -- net assets I have another table called raw_data raw_data_id -- report_date -- amount 1 -- 2/28/2000 -- 50 I need to write a sql statement that will return the below...

Thanks! this worked great!

During a process, I am creating a logfile to capture all the errors. After the process is done, I would like to display the logfile to show the user. I am able to write to the file and append it when neccessary, I am just not sure on how to open the file to display it to the user. Do anyone...

This worked. Thanks so much for you help

Is there any way to stop the form from closing, if you hit the close button (the X on top of the form)

What is the event that controls the close button (the X button on top) on a form. I have an exit button on the form and I want that to behave differently then the close button. Thanks for you help.

This more of curiosity question. and just to let you know, I am new to VBA What is difference between global and public variables? I am working on a project that has multiple forms and modules. The variable needs to keep its value, once assigned, throughout the project. I noticed that the...

I am pretty new to VBA, please help. I need to pass this database variable to a function but I get "Type Mismatch" Error. Below is code: dim MasterDb as DAO.database set MasterDb=Opendatabase("C:\test.mdb") fTest(MasterDb) function fTest (MasterDb as DAO.database) end function

I can use your other functions also. Thanks so much.

How can I tell the name of the current file I am working with. I would like to know the name of the Access file I am current working on. I want to do this in VBA Thanks!

I am new to Access and I am setting up the archeiture. I will have FE (mdb) and BE (mdb) on the Network. I would like to distrubte the FE as an MDE file to the user. Reason for import module or forms: When I make a change the FE (mdb file) on the network, like add a new form or add a new...

Can I import a module after I complie the file as a MDE file. Reason for the question: I am going to set up a design master file on the network. I would like the users to import any new modules, forms introduced to the application. Any help or suggestions would be appreciated

Thanks for you idea. I really appreciate them. Both are great solutions.

I am new to VBA and I doing this is my first Access project. I get a response from a user all the time as "USA ...". I really need to put "USA" into the database. How can I do this in VBA? I am used to the c programming language where I can loop through the string array looking for ".". Is...

I having problems linking to a Sybase Database via Access. I keep getting "Reserved error -7778, there is no message for this error". Does anyone know anything about this error? Is there any way for me to link a table through, VBA code? I was able to connect to the database using ADO...

I am using office spreadsheet 10.0 in an Access application. I am using the spreadsheet as a form for entrying in data, or correcting data already in the database. After I upload all the data from the database into the spreadsheet, the user can change or insert new data in to the spreadsheet...

Thank you all so much for you responses. These are great solutions that I will present to the user. Thanks again!