Search results
-
X
Export Table to Excel Increases Range in Formulas
I have an Excel spreadsheet linked to an Access database. On one worksheet I have some formulas that include ranges to calculate some of the data from the import. However, each time I refresh the data, the upper cell named in the range within the formula has increased. E.g. $A$2:$A$10000 could... -
X
Last Value in Fixed set of Table Columns
This works perfectly, thank you. How, though, would I show the query result for a record in textbox on a split-form? -
X
Last Value in Fixed set of Table Columns
Thanks for this reply. Yes it is part of a larger database but for ease I made a smaller one to post here. The fields are only numbered by dept to track the movement of a document between departments so, for example, Dept1 is the originator, Dept2 is where it is next referred to. So each... -
X
Last Value in Fixed set of Table Columns
On a form I want to have a field which will display a value that is the last in a defined set of fields of a record in a table. I've attached a simple example db. I want to look across the four fields (Dept1 to Dept4) of each record and find the last value enteredand display that in the... -
X
Report - Count Current Location
Can I do this with a table that is already in use and records all fields. What I mean is I have a working db that has one particular table that records all fields of a record. Would I have to split that? Also, it has many fields but adjacent to each location field it has a date field... -
X
Report - Count Current Location
I need to create a report to count vehicles at a current location but I haven't got a clue how to create this, or if it's possible. In the attached simple db each vehicle can be based at different locations and I want to count the number at a specific CURRENT location. For example... -
X
On Click - Error 424 Object Required
I have the following code in a module and I can't remember why it's there. The "cmd" on line one is puzzling me as it doesn't appear in any of the opther On Click event codes. Can anyone explain this to me please? (sorry for being thick!!!!) Private Sub cmdAddToday1_Click() On Error GoTo... -
X
On Click - Error 424 Object Required
Just tried that and in the new db I'm getting error messages ("You can't assign a value to this object") when clicking the button on other forms now too. -
X
On Click - Error 424 Object Required
Both the above codes work, thanks both for your help. My concern is what's causing this one form to not accept the same VB code as all other forms. As a test I've just created a blank form in the database, added just a button and a Ref1Date textbox, added the original On Click code but... -
X
On Click - Error 424 Object Required
It's hidden, sorry. I forgot to unhide objects before attaching. -
X
On Click - Error 424 Object Required
Attached. The form I'm having a problem with is Improvement. -
X
On Click - Error 424 Object Required
I'm confused then because Error.Description works in all my other forms. And when I alter the code to Err.Description I get a "The value you entered isn't valid for this field" error even though the textbox is set up as a date field with no default value assigned. -
X
On Click - Error 424 Object Required
I've added Option Explicit and compiled it but it's still not working and I still receive the 424 error. Below is the only code I have attached to the form: Option Compare Database Option Explicit Option Compare Database Option Explicit Private Sub Command3209_Click() On Error GoTo... -
X
On Click - Error 424 Object Required
I edited the code from Error.Description to Err.Description and the error message went from a VB error 424 to an access error message stating "The value you entered isn't valid for this field". -
X
On Click - Error 424 Object Required
No, there's no default value assigned. -
X
On Click - Error 424 Object Required
No, there's no lookup and the field is referenced in other forms without a problem. -
X
On Click - Error 424 Object Required
No, it doesn't point to the msgbox it doesn't appear to be a VB error, I think it's an Access error. Me.Refdate1 is a date field in my table that is referenced in a textbox on the splitform where I want the button to input today's date. -
X
On Click - Error 424 Object Required
Really? Though Error.Description is working perfectly on all buttons on all other forms. And I've just edited it to Err.Description for one of the buttons on the form I'm having a problem with and I get a new error message stating "The value you entered isn't valid for this field". -
X
On Click - Error 424 Object Required
In a split form in my db when clicking any button I keep getting the 424 runtime error and can't figure out why. The split form was copied and pasted from another one so not sure if that is the issue, though I have copied and pasted others with no issue. The debugger shows the below with...