Search results

zipped file attached

Please find attached a copy of a spreadsheet I'm working with. I've removed unnecessary columns, but column E or last column is the Time column. I've also removed a second tab that merely referred to instructions for use. The spreadsheet is first generated from Access and saved to a...

Error checking time in Excel is one big pia. A correctly entered time value in Excel is read by Access as a numeric value. I can work with that, even if somehow a date is included. How do I distinguish an incorrect time entry? I'm trying to cancel out the situation whereby a user...

Thanks again for the tip, I'll certainly implement the collection error routine. Also, setting the cell address to a range and using the range. I assume it appears as e.g. D5 or similar, haven't tested it yet.

Thank you, why didn't I think of that, it's so easy.

Preamble: Users will be able to fill in a spreadsheet (that is downloaded from the Access application), and eventually import the data from the spreadsheet into a temporary table and then eventually into the live table on the network. I'm still in draft/development mode with this feature. I...

Sorry for my absence, anyway I'm back. Where is the Volitile function/button?

The returned string will be different, so yes, the cell data should change.

In a cell I have the following: It's a simple example. =WriteExhibit(A5, A6, A7) Function WriteExhibit(strDoc as string, datDate as Date, strRequestedBy as string) as string Dim strReturn as string strReturn = "The following document is: " & strDoc & " created on " & datDate & " and...

I'm working on an Excel sheet, have created many functions that return strings to the cell(s). After applying all the VBA functions to the cells (1,000's), if I make a slight change to a string within a VBA function that obviously changes the return string to the cell, how can I automatically...

Debug.Print "Show this message" Will merely print, "Show this message" in the immediate window. It is a very useful tool when trying to debug code. Debug.print strMsg will display whatever strMsg holds. Can't check your db at the moment, still at work, will check later.

Something to try and without any other changes the result should be the same. Run the subform directly (not as a subform). Does the double-click event work? On the same subform, create another textbox control, add a double-click event, code a simple message or a debug.print statement, just...

Yep, I picked up on that just after posting. Damn, forgot to read twice, submit once.

I can't see how in your immediate window you got the result you posted, what I highlighted in red above. (I don't normally use the end of line _ character to continue string building on the following lines, but I assume that is set up correctly.) Did you actually directly copy the result of...

Have you made sure that "Event Procedure" is selected against the relevant textbox control? If it's not selected your double-click event will never be activated, even though you can see and modify the code. Sample image for clarity:

Make sure that "Event Procedure" is selected in the Double Click event property window.

Try the code snippet that The_Doc_Man has supplied, that should see you right.

In the form you are attempting to open, check that the field names are correctly spelt. Does your field name have spaces in it, if so, that is the reason for the brackets surrounding them, if not, brackets are not required. Check your recordsource of the form to be opened, the searched field...

Try this: [Internal Unit Code] = Also, I think you may need to surround your search string in quotes.

Have you checked the docs? I supplied a link in an earlier post, all the information is in there. I haven't got access to Access at the moment but check out 9.