Search results

I am having the weirdest issue and I don't know if its related to MS Access or MS Outlook. Here's the simple scenario. I have a sendEmail Function that works.. what I mean is the code sends the information from MS Access to Outlook and saves the item as a draft. That part works fine...

Hello, I've been wrecking my brain on this issue: I have a report that includes 4 sub-reports. Each individual report is based on a crosstab query that includes totals. The report previews correctly when I open it. If I choose to export the report manually to a .pdf, the pdf gets created...

Hello, I hope someone can assist me with this. I am simply trying to find text on a Web Browser Control htm page. Using MS Access 2003, I have a form that includes the activeX Web Browser Control. On load of the form I initialize the web like below: Dim strURL As String...

I hope this is the right place for this question. My issue is simple to explain. When I copy data from Outlook or MS Word that contains bullets or other HTML formatted text, into MS Access text control, the HTML tags are displayed in the tables. The memo field in the table is set to Rich...

Hi, Is there a way to prevent special characters from being converted into symbols when copying and pasting text into a textbox control on a form? For example: If I copy and paste the below bullet item into my textbox, Access will convert the bullet into some weird symbol. How can I fix...

I am trying to link to oracle tables using VBA. I can link to the oracle tables manually but when I try to use the TransferDatabase method it doesn't work. Here is my code: DoCmd.TransferDatabase acLink, "ODBC Database"...

Hello, I hope this can be achieved. I have 2 database files. database A has a button (buttonRun) that when clicked, it opens database B and runs the autoexec macro. In database A, there's a label control (lblRun) next to the buttonRun that has its back style property set to transparent...

Hopefully this is the right forum. From MS Access, I connect to Excel, I copy a chart then I would like to paste the chart into a Word document. I have been able to successfully connect and open both the Excel document and Word document from Access. I'm also successful with copying the Excel...

Hello, I am trying to connect to excel from Access database. Once I make the connection I want to delete data from a range on a specific sheet. There are 4 columns on the spreadsheet but i wouldn't know how many rows. So for example, A1:D50... but I may not know what the last row is. How...

I am trying to provide the user a custom search feature. They want to enter a keyword or phrase and search 3 memo fields and filter the form base on the records found. they also want to be able to search the whole phrase or any part of the phrase. I have a like expression for any part of the...

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

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

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.

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