Search results

Hi. I am not very familiar with using recordsets in VBA, but I think for this problem I am going to learn how. I have an append query that I want to run as part of a backup routine. I have designed an append query that uses a simple select query as the data source. I seem to have a problem with...

Not often I fix something but don't know why it fixed the problem. I have a table with 320,000 records. When I tried to construct a query with criteria to filter by BETWEEN dates, I only got records showing with the first date in the range. I was going nuts, when I finally decided to index the...

My workplace is moving to Skype for business for telephone calls. Initially it will be for internal communication, but the next stage will be to use Skype for VOIP calls for all phone communication. I would like to set up a command line to be able to click-to-call phone numbers directly from...

I have a combobox on a form that has many items to select from. I would like to set up navigation buttons that navigate through the combobox one item at a time. Am I right in thinking that this needs to be based on an "apply filter" command that selects the records based on the previous or...

Thanks Pat and co. Yes it turns out indeed that I was chasing a rabbit down the wrong hole. I have abandoned the structure and instead incorporated the necessary fields in the main form. I was trying to update a field in the subform that had the same name but different source to the field I was...

In this case the records are in different tables, with the Master and Child based on the same client ID. There is only one subform in this form. sbfServiceContinuity is the name of the control, not the subform itself. The reason it is a subform and not simply part of the main form is because...

Just wondering whether I should use a DoCmd.SetProperty method instead?

Seems correct. I've tried both the container: sbfServiceContinuity and the subform itself frmServiceContinuity as the control reference but both return a runtime error. I've triple checked the spelling, and it is correct. This is frustrating. There is something basic I'm missing here. :(

Tried that too. Still an error.

I know this has probably been asked and answered several times, but I just don't seem to be able to get it right. I have a main form frmCallSheet, with a control Answered. This form has a subform control called sbfServiceContinuity, which contains a form frmServiceContinuity, which has a...

I found a solution, thanks! It is to do with a timer running on open sheets in the background. I find the behaviour stops when I close the affected sheets. Cheers!

I don't know if there is already a solution posted for this one. I have upgraded to Access 2016, and for some reason now when trying to edit code in the VBA editor I have to fight some strange behaviour as I type. Often the options such as the ac... options just flash up and then disappear, and...

Thanks Doc for this solution. I played around with this kind of thing on the weekend and actually found a YouTube video taking very similar approach. I think this will suit my needs quite ok. The very rare situation where there may be a power outage of forced shut down of Access will not...

Ok, now I have a choice. Arnelgp, your solution seems to be the best way to track TRUE userlogs but there are big slabs of code here that I don't fully understand. That always makes me nervous, in case something goes wrong. On the other hand The Doc Man's solution is much simpler but less...

I'll do that if I don't work it out by the end of today.

I tried all of these and I keep getting an aggregate error. Apparently I can't aggregate both of these criteria in the WHERE clause. ??

Thanks CJ. You are always so ready to help. I really appreciate it! So the syntax in SQL would be: WHERE (COUNT([Activity] MOD 2) > 0) ?? I'm still a toddler when it comes to SQL syntax! This is what I have so far: SELECT tblUserActivityLog.ID, tblUserActivityLog.TimeStamp...

Hi all. I have a table that records user activities based on a public function that is called when logging in. The table shows a list of users who have logged in and logged out, but in some cases the user may have logged in and out several times in a day. I am looking to generate a list of...

Thanks for that. Very helpful. I am thinking another option might be the number of repeats. For example have a small table with a range of options between 1 and what ever number is practical, and by selecting this, the after update will apply that selection to add the person to the roster that...

I have a staff roster that I would like to add a feature that will allow the user to roster a member on a regular basis, either weekly, every 2 weeks, once every 4 weeks etc. as well as the option I have now for selecting the next roster date. I would like to have a combobox with options...