Search results

I am trying to connect to an access database format 2003 from my access 2007 database. I would like to create a recordset from a table in the 2003 database and bind it to a listbox in my 2007 database. What would be the best method? I tried to the following code that didn't work. Dim...

I have 2 databases (accdb). Both databases have a loading pop form. Also both databases include the following line of code when the loading form opens: docmd.runcommand acCmdAppMinimize This code works great when I open the databases individually. but my problem is that I have a label on...

Hi I am trying to connect to oracle database and add data to a MS Access table via append query. I was able to connect to oracle and create a recordset just fine. But now I need to add the data from the recordset to an existing local table. Here's what I have so far: Public Const dvcon$ =...

Yes. there is a reason to my madness :-) .. I have 40 different tables that I need to pull data from so I'd rather just create subsets from those tables. I didn't wanna have to physically link 40 tables to my database.

Is there a way I can execute a make table query from oracle data? Basically what I wanna do is select data from oracle and create a table from that recordset simply by executing a make table query. I was able to make the connection and create the recordset. But I don't know the syntax to...

Ah yes.. that's the physical way. I know how to do that. But what I need and want to do is something like this: SELECT [table].[field1],[table].[field2] from C:\Desktop\SomeFolder\OtherDb.mdb I want to select from other tables without physically linking the tables because I have 45 tables...

are you able to specify the location of another database that you want to select data from? For example: I want to do something like this: SELECT [field1], [field2] from C:\DesktopFolder\MyOtherDatabase.mdb\TableName Is this possible? Can someone assist me with that structure or syntax.

thank you mdlueck I still can't seem to get my code to work. here's what I have: Dim server As String Dim username As String Dim password As String Dim mcon As String mcon = "Driver={Microsoft ODBC for Oracle}...

Hello, I have connected to on oracle database thru ODBC connection via VBA. The connection works. I have an oracle select script that I want to use in my vba. I basically want to make an access table from the oracle sql. What would be the most efficient way to do this? Can I use oracle...

Hi there, I have a MS Access 2007 table that includes an attachment field with some documents. When I import the table into another database, the attachment field can not be imported. Is there a way to get that data into the new table without having to re-attach all of the documents again?

Hi Access Forum, Is there a easy way for access to look in a string and find an email address? Basically I have 1 field that may include an email address in the value of that field. I want to extract the email addresses and put them into 1 field. The problem is the field is formatted...

Hi, I am new to MS access 2007 but not new to Access. I am trying to open a form in the design view but that option is disabled along with other menu options. I checked the Ribbon and it appears to be a custom toolbar. I deleted that out of the box but I'm still unable to view the design of...

I have a database that I want to open via a batch program. I want to schedule the batch file to run daily. So, I have scheduled a batch file to run daily using the Windows System Tools>>Scheduled Task. below is my code for the batch file: start /d "C:\Documents and...

I'm trying to run a simple query (MS Access 2007) where I need to format the date column to a short date. My expression is returning an error "Undefined function 'Format' in expression". I don't understand the issue since this is how I've always done it in Access vs 2003. Has the syntax...

I want to restrict users from deleting records from a table each time the table is created. So here's my scenario.. I have created a table using the CreateTableDef Method, see below. What I want to do is: after the table is created and data has been added, I want to make it so no data can...

PERFECT!!!!!!!! .. That worked like a charm .. I get it .. Thanks so much.

I have a query that uses criteria from a form. I want to filter a numeric column named [STAGE] by what the users pick from a combo box on a form. The combo box is named [cboFilStage] and its values are "1,2,3,All stages". If the user selects "All stages" then all records are returned. In...

Hi, Is there a way to capture the current user if the user is making updates directly in the table?

I don't understand and I don't wanna quit but I can't find any help on this. I even tried google.

:( Thanks but that didn't work .. when I put in the -#00:30# .. it converted the expression to : =HoursAndMinutes([TimeOut]-[TimeIn])-#12:30:00 AM# which resulted in #Error