Search results

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 don't particularly care for not having the option of date only or time only.

Thanks all for the posts. I had the function defined as string at first. I had this idea that it would be better to return a date. I should have left it as string. As ChrisO suggested, I changed Date to Variant and vbNull to Null. That seems to be working and maybe I'll just leave it at that...

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

This is the query code that takes so long: strSQL = "DELETE FROM tblWork_OrdersTEMP" CurrentDb.Execute strSQL, dbFailOnError strSQL = "" strSQL = strSQL & "INSERT INTO tblWork_OrdersTEMP ( WONROV, WONUM, [WOCU#], [WOCO#], [WODV#], [WOFR#], WOTYC, WOEDT, " strSQL = strSQL &...

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

Forms have an order by property. If you're opening a form, you could set that instead.

I am not requerying the listbox. The data are displayed in the listbox to inform the customer what the sales category is and the data are displayed in the subform because that's where the field is entered into the service code.

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

Everything seems to be working fast this morning. I'll get back later when it starts happening again, which I'm sure it will. Thanks for looking.

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

It doesn't work there either. I get A form with a subform object can't have its DefaultView property set to Continuous Forms.

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

Thank you, I'll give it a try.

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

The chart is working just fine. (See attchment graph02.jpg). It's just when I try to save it as its own file it doesn't have all the information on it (graph01.jpg).

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