Search results for query: *

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

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

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

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!

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

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

Is there anyway to put a file open control in Access. I need to let my user open a file and I don't them to type in the directory the file is in.

I am very new to Access. I am trying to create an Access application that will be used by 10 users. I will put the design master on the server and replica of the Access Application on the clients machines. I will use the database splitter (on the design master before I do the replication) and...

I want to make a login screen to my Access application using the windows username and password. I know I can retrieve the user name by .. Environ$("UserName") Is there a way to retrieve the windows password, just for verification? Is this even possible to do this with a Access VBA application?