Recent content by andm

Hi there! I'm using Visual Basic. I can get my Excel workbook to appear. I just can't make it read-only when it appears. Do you know the line of code that would do this? Here is my code so far... Set xlBook = GetObject(EXCEL_PATH_LASTTRADEDATE) xlBook.Application.Visible = True...

Hi, I'd like to give the user the ability to choose their own file. I know that it's called a "Common Dialog Control" in Visual Basic, but I'm wondering how to create the same behavior in Access? I want the user to click on a button that will give them access to all the files on their...

Hi there! In my VBA, I calculate variables with various values. Afterwards, I'd like to display these different values in a report. But it seems like reports only want queries or tables. I want to put specific variable values into my report. Is there a way to do this?...programmatically...

Hi there! I wrote earlier. Your reply sounded great, but when I tried it, it said: "User defined type not defined" Do I need to declare something first? This was the code in your suggestion: Option Compare Database Public dbs As database Public rst As Recordset Public Sql_Str As String...

Hi there! On a form, I would like for my user to click on a button and then be able to select the file (and directory) from which they'd like to import. I know in VB this is the Common Dialog Control, but I'm not sure how to do this from a form in Access. Can you help? Thank you!!!

Hi there! I am just trying to connect to a table in my Access database. I want to do it from a module that is in that database. My goal is write SQL queries and work with the a recordset within the modules. But I have to figure out how to connect to the tables first! Can you help me...