Search results

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...

I tried that-I loaded the form but then the text box values didn’t change when I moved to the next record Thanks GasMan - works now!

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...

thanks for that - I know its best practice for the database to be split - would that same advice apply to a single database that hadnt been split?

Hi everyone, I have split up my database the backend is in a shared folder and the front end has been copied onto each users machine (half a dozen users). It may be necessary for the moment to allow all users to access one shared front end, there are not many users, 6 at the most and not...

Pat, sorry just following on from yesterday. Citrix seems a good option . Would I need to look at purchasing any additional software to be able to remotely log in using Citrix? would I need Windows Server ? At the moment (which is bad practice I know) - there are just half a dozen users...

Thanks Pat for that, I'll look at RD and Citrix

Thanks again - I'll research into how to go about point 2. Just one last thing if the DB is on a LAN, Ive written some stuff in VBA for emails inside the DB does that mean I wont be able to send email from the DB?

Thanks for that JMongi - so if the DB is on a LAN and a user wants to connect from another location via VPN does that provide the same risk? Sorry if these questions are basic. I would like a LAN here but with covid the company might need remote access to the DB, I'm not an expert in the...