Search results for query: *

Hi All, Anyone heard of this before? A user is generating a excel spreadsheet from a query using the Tools>Office Links> Analyze with MS Excel function in Access. She manipulates the file a little, then attempts to save. Excel crashes and auto-recovers the file, then she can save as...

Is there some way to make the "enter" key produce a carriage return in a text box, rather than advance to a new record? I'd like this to happen in a text box or memo field. I'm also concerned about truncating the memo field to 255... is a carriage return formatting? Thanks so much for your...

Hi All, I'm trying to open a report chosen from a combo box when the user clicks a button. I have a table with 2 columns, the display name for a report, and the actual name. I created a combo box with this info, set the column property for column 2 (actual report name) to 0, and made a...

Hi All, I've got a quick-add form for employee info. Using a button onclick event, I do a little validation before I refresh and add the info to the table, then show a button that takes them to the full reccord. The validation works, but it keeps breaking on the refresh command. Can someone...

Hey all, I'm having trouble opening PDFs using followhyperlink. Does it not work for PDFs? FollowHyperlink Me!pickname.Column(2) This worked for word docs, not when the documents were changed to pdfs of the exact same name. There aren't any spaces in there or anything. Acrobat reader...

Can someone tell me what "Call passthroughrecordset" is doing here? I've never seen this before, and I can't find any references or anything. I'm trying to figure out how this button does what it does. Which the end result is that it places a new record in a table, based on the customerid of...

This is driving me nuts! I have a button that opens a MS word doc, but I have to enter the string, like so. Private Sub Command0_Click() Dim HWordDoc As String Dim oApp As Object HWordDoc = "C:\Whatever.doc" If Dir(HWordDoc) = "" Then MsgBox "Document Not...

I've written a bunch of help files for our database, all in word documents. Now I have to make them available from within the database. I'd like to find some way to have the values in a linked table and use them from there to open the documents, so I don't have to release a new form every time I...

I have several forms that are opened with a switchboard, all of which contain between 4-10 subforms. Each form stays open when you navigate away from it. There's also this one misfit form (M), where I've put all my little fixes and user helper things. I'll update M, and the only way that...

Hi there, I have a feeling I'm missing something quite obvious here. I've got a simple update query that I'd like to use a form to control. There's a combo box on the form with days of the week(taken from a table), and a button that runs this query. UPDATE __updateweday SET weekendday =...

I'm really hoping this makes sense to someone. I have a combo box in a form. It displays an address based on number. The number has five digits, each representing one address. If you want the address to display in the box, the corresponding number is 2, if not, the number is 1. So, for...

Hi All, I'm just getting back into sql/access after a 5 year hiatus. I feel like I should be able to solve this problem by myself, but I'm stymied. I have a query being run by values entered in a form, like so: SELECT Txns.InvoiceNumber, Txns.SkillCode, Txns.EmpName FROM Txns WHERE...