Search results

Is there any way to receive notifications here as soon as a new thread is posted to a forum?

I'm trying to create a file, save it, create an email with a link to the file in it, and send the email. But the link in the email doesn't work if there are any underscores ("_") in the file name or file path. The folder that I need to save the file in and link to in the email has underscores...

I have a report with 2 subreports on it. One of the subreports does not show on the report preview unless I set a breakpoint in the report's code. Set a breakpoint in the code (for no other reason), hit the breakpoint, continue, and the report works fine from then on, until you close the...

Since moving from Windows XP to Windows 7 and Access 2007 to Access 2010 I get the following message when I close a database Your network access was interrupted. To continue, close the database, and open it again. I have been able to find some discussion on the message but only in other...

Anybody know why I'm getting an Error 3167 Record is Deleted error on my passed recordset when I reference a column in the recordset? I'm trying to pass a recordset as a parameter to a subroutine in a loop. The recordset is created before the loop. This is to replace recreating this recordset...

I have a function that I use in queries to convert numbers into dates. If a number is not a value we are looking for, then the function should return a null. The dates come out correct. The numbers that do not qualifty come out as 12/31/1899. This is the function: Public Function...

Has anybody heard of a situation where a left or right join on Access tables linked to an Oracle database doesn't work? I have a query that hangs if I change INNER to LEFT. The LEFT version opens up fine as a saved query. But the same code when part of some vba append code hangs. Change it...

When I click on the combobox on my subform the listbox on the main form blinks. The table on which the combobox is based is part of the listbox's query and I guess this is the reason why. I could copy this table but is there an easier way to get rid of this blinking?

I want to create an Excel spreadsheet from Access. It's just a dump of some data from a table. Can I do this using either Doocmd.transferspreadsheet or Docmd.Outputto without specifying a file path and without having a save as dialog box popping up? Currently I'm using Excel object code to do...

I have an Access database which is reading tables in an Oracle database using linked tables and pass-through queries. I have one query that has me puzzled. It has a WHERE clause that selects from a table based on one column being greater than a specified numeric value. The thing is when I use a...

As you know, continuous forms do not allow subforms. If you have a 1-to-many relationship you have to combine the many with the 1 on the main query. Repeated 1 values are displayed on each line. What is the best way to suppress the additional displaying of the 1 values on a continuous form...

Is there any way in Access to make the cursor look like a hand? I think this is called a hotspot. (Not sure.)

This is the first time I have done this. I have a chart on a form. It is a line chart. When I export it using the code below as a jpeg file the lines are in the .jpg file but the scale at the bottom and along the left side are not. Is there any way to fix this? Me.GrphProb.Export "H:\My...

I'm trying to get to appear in my references. (vba code, Access 2007) (This is in relation to putting an image into the body of an e-mail.) I have run the download from here http://www.microsoft.com/download/en/details.aspx?id=3671 But I don't know what to do next. Can anyone point me in...

I am trying to create a image from an Access report. This report has a chart on it. My Docmd.Outputto code doesn't seem to work right. I've tried DoCmd.OutputTo acOutputReport, "rptNode", acFormatRTF, "C:\My Documents\rptNode.rtf" and DoCmd.OutputTo acOutputReport, "rptNode", acFormatHTML...

Is it possible to put an Access chart in the body of an e-mail? I cannot find an example of this that works. I have a chart that can be dropped on a form or a report. What I want is to put it in an e-mail programmatically. I want to put it in the body of the e-mail, not as an attachment. Can...

I am a newbie with XML to Access. I am trying to import some data from a website into my database by simply copying a line of code from another database. Here is the code: Application.ImportXML DataSource:=http://website/Engineering/Tech%20Ops/RepeatTC.xml (I have changed the name of the...

I'm a newbie when it comes to putting Access databases on network drives. I thought if you put a database on a network drive that more than one person could open it. But that is not happening with a database I put on one. Is there some property I need to change?

I have 2 queries scheduled through Windows to run early in the morning. The first one deletes the records from a table and the second one (a pass-through) puts records into the table from another system. I need a way to confirm that this ran successfully. The problem is the table date does not...

When I run an insert query from the database the table's date modified is changed but when I run the query with Windows Scheduler the table's date modified is not changed. Is this possible? Any suggestions on how to get around it?