Search results

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

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

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

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

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

So I have been working on this project for about a month now. It is almost done. During the course of it's development I have created about twenty tables whose sole purpose is to house data for use in combo and list boxes. They have no other purpose. I am now in the process of creating the...

I am creating a database in Access 2013 I have created a Navigation form using the Navigation form tool and called it frmMain I have added two forms to the tabs on the navigation form called frmClients and frmEmployers On the frmEmployers form there is a command button (cmdNewRecord) that opens...

I have a form that has a control to search the table for a specific record See code below that is on the AfterUpdate event of a Combo Box Set rs = Me.Recordset.Clone rs.FindFirst "[ClientID] = " & Str(Nz(Me![cboName], 0)) If Not rs.EOF Then Me.Bookmark = rs.Bookmark...

I am looking for someone that lives in Alberta in Canada who would be willing to assist me with a database. The work has been done by two people, myself an one other person. The other person wrote a massive procedure that I need modified and that person is no longer around. I am willing to pay.

I have a report that is causing me some grief. There is a main report that has about 7 subreports in it. Each one of these subreports is based on a query that does a count on categories or codes and reports the number of each based on counting an ID field. Here is my problem. If the one of the...

I am about to rip my hair out. How do I stop the report footer from printing on a separate page. I have seen several suggestions here and othe places and nothing seems to work.

I have been using mousehook.dll for years and it has performed perfectly. Until now I have a database that has a very long form and need the user to be able to use the wheel mouse, but only to scroll through the form not the records Any ideas

Ok I think this is a tough one. If not please smack me upside the head for being dumb I am using Access 2010 on an Access 2003 Database I am creating a elaborate search form. Let me explain The is is a continuous form and the first field is called TableName. There is combo box control called...

I have a continuous form in my database that depending on the criteria used will display any number of records. Each record has a check box so the user can select a record for printing. Quite often the user wants to select all of the checkboxes. My question. Is there a way to do that in vba...

I need to be able to set the Enabled and Locked properties of all fields in a form based on someones security level I know I can do this If Forms!frm_LogonStorage!SecurityLevel > 51 Then Me.FirstName.Enabled = True Me.FirstName.Locked = False Else...

I swear my brain has left me for a trip to China or something. There are two forms invoolved in thi pfrm_AddClientPrimary pfrm_AddClientDuplicateCheck On a command button in pfrm_AddClientDuplicateCheck I have the following code. Private Sub cmdAddNewClient_Click() DoCmd.OpenForm...

I have a form with three text boxes and one command button I want to hide the command button from view until at least one of the boxes has data in it. I also want the command button to return to hidden if the data is removed So far I have tried this on the after update event on one zof the...

Ok let me see if I can lay this out Forms Involved: frm_MainMenu with a subform sfrm_Clients pfrm_AddClientDuplicateCheck So pfrm_AddClientDuplicateCheck is opened from a button on the sfrm_Clients subform. The frm_MainMenu and sfrm_Clients remain open but in the background. There are three...

I have several database that I have created. Three of them always print to the bypass tray no matter what computer or what printer is connected. Does anyone have any ideas.

I have a report that has a couple of fields that I wish to use criteria to pull from a text box on a form The first field is called EnteredBy and has the following text in the criteria line of the query that loads the report Like "*" & [Forms]![frm_MainMenu2]![frm_Reports].[Form]![cboCdc] &...