Search results

Hi All When I added the ID field to the table that inadvertently messed up the controls on the form. Even modifying them to be bound to column 2 did not help. I ended up using this code on the GotFocus event and all is good. That is after deleting and recreating the control Dim FirstTime As...

So I tried that and got an error stating the code was incompatible with my version of Access. I am using Access 2016 64 bit Here is the code, modified for my project Dim FirstTime As Date Dim IntervalType As String Dim Number As Integer IntervalType = "h" FirstDate = me.cboStartTime...

Ok Thanks to all who helped in my last issue. Never would have dreamed that not having a dedicated id field was the issue On to my next problem Same form. I need to take the value from one control box and add 1 hour to it I think the code should be something like this for a new record...

Yup and it works great. I had one problem in that I had to bind the control to column 2 but after that it all works. Now I have to fix all the other forms that use that table. Yikes

Still the same. I have attached sample database

Just did that. No change. I used the assign method to set to 09:00 AM I the clicked the pull down on the control it started at 12:00 AM For giggles and *&^%$ I navigated to an existing record. It also started at 12:00 AM even though the entered value was different than that

That does not work either. Once the value has been set in the control the pull down always starts at the top

That assigned the value. But when I click the pull down to change it to say 09:15 the list starts at 12:00 AM instead of 09:00 AM

I have a combo box that lists times for an entire day at 15 min increments. 12:00 Am then 12:15 AM and so on Most of the time the user start time is after 09:00 Am, but not always. I have tried DefaultValue and while it does set the value when I click the pulldown on the control the list starts...

I am afraid this is way over my head. I don't know how to do this. I have some knowledge on how to get data from an open form but what you are suggesting is way above what I know how to do. Can you point me in the right dirrection

Here's a thought. I just discovered that by doing ... docmd.gotorecord ,,acFirst I can pick up the value in the first record. So here is what I am thinking. How do I use docmd.gotorecord to go to the record with the check box checked. That will work perfectly

Is there not a way to capture the value in the record that has the check box ticked based on some kind of where statement. I can't us Dlookup on the underlying table because there are many records that have the checkbox checked. In the form there is only one

Hello everyone I am having a complete brain fart today and would really appreciate some guidance. Here is the scenario. I am trying to take the value of a field in one for to another form that is open. The form the value is coming from is continuous but only one of the items is current based on...

Ok i'll bite. Whats the simple solution

The form is already open on the clients tab. It just returns to the first record when returning to that tab from one of the other tab

Hi Everyone I have searched for this with no luck. Here is the scenario. I have a new database developed in Access 2013. In this I used the Navigation Form that has been around since Access 2010. I have four 'Tabs' set up each with it's own subform for various parts of the database. I'll use...

These were not recognized either

I am referenced to Microsoft Office 15.0 Object Library. My guess is the took out CommandBar and CommandBarButton

I have created a rather extensive Application in Access 2013. I do not want the ribbons or navigation panes showing. The good news is with a lot of research I have been able to accomplish this. There however is one bad side effect and that is my reports. With the Ribbon off there is no way to...

And it reports that Forms![frmMain]![frmEmployers] is the correct reference. BUT it does not work on any of the places I have tried.The only thing that does work is Forms![frmMain]![NavigationSubform] Go figure!!!!