Search results

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

But you do not provide that service for free. You are being paid.

I don't follow. That's what I'm doing, isn't it?

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

A decompile appears to have solved the problem.

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

It's strange. Very small databases don't seem to have this problem. I have databases with linked tables on the network and ODBC-linked tables. I have databases without any linked tables. And they all cause this message. Except databases that are really small with only a few tables...

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