It was MySQL but I followed your advice about creating a new field for the date and then using something similar to what you said above but for sql and it worked- so thanks for that
Hi - could somebody help me with this please, I'm new to workbench and Ive just uploaded a table into workbench from an excel csv file. In the excel table
one of the columns had a date value, I loaded this into my table using workbench as a text file as I was having problems importing this file...
Thanks Pat - I will have a look tomorrow - that looks a lot simpler that what I was attempting! Status is a text field, so I just need to introduce a date field in the table, so users to enter the date at which the selection has been made, make the selection - then I can sum the responses for...
Hi Arnelgp,It was the fldChangeDate I kept getting syntax errors with, in the end I ended up using nectorch's answer just because the layout was a lot easier to understand in the SQL query - I was getting confused as to how to put all that into one string, my vba not that good.
thanks - would you know why I am getting 'too few parameters' message with this code below please?, Ive tried it with the SET statement infront of the fldChangeDate as well but then I get a syntax error
dbs.Execute "UPDATE Employees " _
& "SET [ReportsTo]=0, " _...
Hi , Could somebody help me with this syntax please for how to combine multiple SQL statements in vba, to change more than one value in a table
Ive been experimenting with this from the microsoft site but keep getting syntax errors the code I'm trying is below
Dim dbs As Database...
The count needs to be reset daily, there isnt an update date value in the table at the moment. I will move the counter I created into the table which uses the combo for selection, and delete the table I created just for the counter. Is it wise/possible to reset that update value in the table...
Yes it is! When somebody clicks on the combo the selection is stored in a table, there are half a dozen users of this database at the moment so I am trying to provide daily counts for this particular selection, but the counter needs to be reset and I was trying to do that automically with a...
Thanks very much Pat for that reply I will look it again. I have the counter working, with the counts in another table (which I will change from what you say). It’s the resetting the counter now I am trying to make sensible to reset after work hours. Will try to look at it again with your...
sorry ive not used this before, I'm getting confused with the Ontimer and timer interval events. So if i put the code below into the timer event - how do I get this to update at a particular time interval without having to leave the form?
Private Sub Form_Timer()
Dim lngCounter As Long
Dim...
Hi Pat,
I need a way of counting how many times particular selections are made in a combo box on a form to keep track of progress during the day.
So I have a table (tblCounter), and when a selection is made from the combobox a counter is incremented in the table then when the form is loaded the...
Hi - I have created a query that sums the number of times different selections are made from a dropdown box in a form, this accumulates over the course of a year. I was wondering if its possible to display this value in the form as a live running total. So that when other users make a selection...
Hi,
Could somebody help me with this please. I have a form that contains hundreds of records, and the user moves from one record to the next checking/inputting data.
I have a Dmax lookup function in the form that calculates a max value for a field when the user makes a selection from a combo...