Search results

Hello, Looking for a criteria to pull data that will be expiring in 3 months from every 5th of the month. All that I find is to pull past data: Between DateAdd("m",-3,Date()) And Date() If I do: Between DateAdd("m",-3,[EndDate]) And Date() Will pull data from the end of may 2019...

Hello, Hope you can give some ideas, because I have tried to find one and no success. I have to Subforms (A, B): I have data on SubForm A I want to pass to Subform B but this is how: 1) SubForm A I have a combo box which filter the data I wan to pass to SubForm B 2) after filter data in...

Hello, Hope you can give some ideas, because I have tried to find one and no success. I have to forms (A, B): I have data on Form A I want to pass to form B but this is how: 1) Form A I have a combo box which filter the data I wan to pass to Form B 2) after filter data in Form A, It has a...

Hello, Hope you can help me to figure this out, had tried everything I know and nothing works, keep giving Nulls, It was working before, but then start giving nulls. Private Sub Form_Current() If Me.NewRecord Then Me.lblRecordCounter.Caption = _ "Record " &...

Hello, I am trying to update a date in the field AttendDate, that field contains the data for the whole year from 1/1/2018 till 12/31/2018, what I am trying to do is a query where can update is that field is missing a date per example date 9/24/2018 is not in that field. I was able to retrieve...

Hello, This is a long code I am trying to submit/ add data when click on the Add button, need help, very new at this Rest API with access, I using an API from JAMS which is a Job Access and Management System tool to schedule and create jobs. The only thing I got is to get the parameters in...

Hello, Hopefully someone can help me with this problem, I an trying to add data in two fields on a subform call "B" from a subfrom call "A", but it 's no creating an "New" on ID field when I filter the data to be add it in subform "B" Please, help. Thank you. Private Sub...

Hello, I am trying to pass a value from one form (comboBox) to another form (ComboBox) where the value is on frm_BankHolidays and the combobox that I need to add that value from the other form is Based, the form name is frm_Register_New_Employee. I am not sure if I am using a wrong reference...

Hello, I am trying to disable save button when the cboYear is not <> currentYear, right now the code I have is disabling all the years including the current year when I filter the cboYear, Do I need to add this code somewhere else like on Load or Current? Or Am I missing something else? Please...

Hello, Can you please help me to figure why is giving me this error: Syntax Error(Missing Operator) in query expression '()' What I am trying to do is when user clicks Save, the system will firstly remove all bank holidays in the holiday Flatfile table (for selected country) and replace with...

Hello, Could you help me to figure out how can I filter by month not only for the current year but for past years as well? I have tried but without a solution. Thank you. Private Sub cboMonth_AfterUpdate() Dim dates(1) As Date If Me.cboMonth = 0 Then...

Hello, I just can't figure out how to grey out the combobox when value chosen is "closed". combobox is set to have a value list in the resource type and the resource is "Open", "Closed" If Me.[Position_Status] = "Closed" Then Me.[Position_Status].Enabled = False Else...

Hello, Could you help me please? I have a problem with a if sentence and a query: I need to pass the POSITION.OldValue to another table but it is getting the new value instead. Private Sub Position_BeforeUpdate(Cancel As Integer) Dim str As String If Me.POSITION.OldValue <>...

I have a question on how can I filter fields from Subform to a form in a query, also does anybody know the format to use as numeric field in a query, like # for Date? Please help. Thank you. ID is a numeric field that is in a Subform called subfrm_GCDS_Operations_Positions_Fills_Log_New1, The...

Access 2010, I am trying to disable "Give back" if I select it from the combobox, but is not working now, before it was because I was using a List, but I am using a query now, any help will be appreciate it. If Me.LeavingGroupProfile.RowSource = "SELECT tbl_LeavingGroupProfile.LeavingGroupID...

Hello, Private Sub TimeSpentFI1_Click() Dim number As Integer Me.TimeSpentFI1.Text = Format(number, "0.00") End Sub I need help on this one, I need to be able to insert a number 1 or 30 and the textfield recognize it as time like 1 - 1hr spent or 30 = 30 minutes spent, any help will be...

Hello, I am trying to check on duplicates if I enter the data again, but it only works if I enter Both values but if I enter just one it take it as new entry and not recognized that single value already exist in Table, Example: if I have the Vendor and Code it will tell me that value already...

Hello, I had this code in different buttons to search record on each table and when does not exist to add the new records on each tables using forms How can I search two tables at the same time with one single button instead of two button for each table? Table: tbl_CDS_DRA_Key_Legend...

Hello, I am trying to bring two values in a txtfield from one form to another form using a combo box to select the option I want, then when populate the values I want to see but it is not the option I want I have a clear button that does not work, when I choose the option on the combo box and...

Hello, My name is Ivonne, I am new on Access VBA, I am on a learning process, so from time to time I have questions and I need to resolve them. Thank you in advance for all the help you can bring. Cheers!