Search results

Sorry, I'm not quite following your suggestion. My temporary table does not have any records in it when I'm creating the spreadsheet, but the field names of the empty table are the row heading names of the spreadsheet. On import the same temporary table is populated with the data from the...

Thank you everyone, all your responses have been appreciated and are of value. Ok, so now I'm backtracking to the creation of the spreadsheet. The spreadsheet row headings are extracted from a temporary table, and correspond to the field names. By default the temporary table will have zero...

I did first trial with locking the first row (headings row) and password protected the sheet. The users then didn't have the option to resize any of the cells and that was a pain. I'm all ears if the spreadsheet can be locked but the users still have the ability to resize the rows and columns.

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.