Hello twinnyfo
I know it's missing as rstAllocated, I am trying to simplify this exercise, but it's getting a mess for me. Thank you.
ivonsurf123
Last Activity: Feb 14 '19, 08:26 PM
Joined: Nov 22 '17
Location:
-
The error message is gone now what I am receiving on line 34 is "Object variable or With block not set.Leave a comment:
-
Save Button
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 what's in the list (selected country). Thank you.
...Code:Dim Response Dim rstFF As Recordset Dim rstAllocated -
Thank you for your approach NeoPa, I tried it as well, but it did not even filter, the first code I submitted at least filter all the months of the current year, just need to figure out how to do it for past years, by the way these are two of the many codes I tried with the Month() function or the Format() function with an "m" parameter.
...Code:Private Sub Form_Load() Dim strItems As String Dim intI As Integer
Leave a comment:
-
I tried that way, but did not filter at all
this is how is set:
...Code:Private Sub SetUpMonthFilterCombo() Dim tmp As String Dim i As Integer With Me.cboMonth tmp = "0; < Clear >" For i = 1 To 12 tmp = tmp & ";" & i & ";" & MonthName(i) Next .ColumnCount =Leave a comment:
-
Combobox filter by month
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.
...Code:Private Sub cboMonth_AfterUpdate() Dim dates(1) As Date If Me.cboMonth = 0 Then Me.subfrm_Invoice_Tracking.Form.Filter = "" Me.subfrm_Invoice_Tracking.Form.FilterOn = False -
I was able to do it with a conditional formatting instead, it worked perfectly, thank you NeoPa
In Form Design View:
- Right-Click on the Combobox
- Click on Conditional Formatting
- Under 'Condition1' select Expression Is
- In the next box, enter [Position Status] = "Closed"
- Now click on the 'Enabled' icon...the one on the far right (to turn the Enabled property off)
- Click on OK
Leave a comment:
-
Thank you NeoPa, but did not work...The one I submitted does it, but it does not stay gray out(Disabled), it just flash it and go back to showing the field with value enable again when I change to another record. Thank you for helping.Leave a comment:
-
Gray out combo box base on value list
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"
Code:If Me.[Position_Status] = "Closed" Then Me.[Position_Status].Enabled = False Else Me.[Position_Status].Enabled = True End If -
how to pass an old value field to another form
Hello,
Could you help me please? I have a problem with a if sentence and a query: I need to pass the POSITION.OldVal ue to another form but it is getting the new value instead.Thank you.
...Code:Private Sub Position_BeforeUpdate(Cancel As Integer) Dim str As String If Me.POSITION.OldValue <> Me.POSITION.value Then str = "INSERT INTO tbl_GCDS_Operations_Positions_fills -
I apologize did not know about the zip file.
This is where I need help with: 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_Ope rations_Positio ns_Fills_Log_Ne w1,
The main form is this query, Main form is called...Leave a comment:
-
how to filter a subform from a form
Hello,
I have a question on how can I filter fields from Subform to a form, attached is the database I am working on, also does anybody know the format to use as numeric field in a query, like # for Date? Thank you. -
You are awesome! Thank you.Leave a comment:
-
data type mismatch in criteria expression
Hello Everyone,
Could you help me to find out what is wrong with my query, please? The problem is on the [Date of Change] which is a Date field
...Code:Me.RecordSource = "SELECT tbl_GCDS_Operations_Positions_Fills_Log.* " & _ "From tbl_GCDS_Operations_Positions_Fills_Log " & _ "WHERE (((tbl_GCDS_Operations_Positions_Fills_Log.[Date of Change])='" & Me.cboDate.Column(0, -
For Sure, I will if I have more questions and post the final result as well. Thank you.Leave a comment:
-
Hello twinnyfo,
Thank you so much! That's a start I will continue from here.
Cheers!Leave a comment:
-
Hello Twinnyfo,
The calculations is to create a table where the data will be save, but also a form to introduce some data like employee name and ID, start date to start calculating first on how many days of vacation that employee will be starting with and depends in the country adding 1 day per year or for CostaRica if you see is different, you will have 12 days per year for the first 4 years and after that it will be raised 2 days for...Leave a comment:
-
Vacation Time Off Accrual in MS Access 2010
Hello,
Really sorry not to bring a code, but really I do not have any idea on how to start this calculations, if you can teach me on how to do it to learn I will appreciate it. This are the requirements for each country:
UK:
Base leave = 22 days when start a job
For first 3yrs add 1 day per year till Max 25 days
Year runs January to December
France:
... -
That's almost correct but it won't let me if: "MsgBox "You have selected a National GCN." & vbCrLf & vbCrLf & "Therefore, you must enter valid client codes against this record before saving.", _
vbCritical, "Missing Information"
So in other words if I enter a GCN (Global Client Number) and the DB recognize it as "National" and If It has client codes will go ahead and deactivate,...Leave a comment:
-
1- the code works fine
2- I just need to add a second condition where accept to inactive a schedule without the need of having client codes, the code at this moment what it does is inactive a National schedule only if carry client codes but how about if it does not how can I do that statement, do I need to to a Dlookup first to find if that specific schedule that I want to deactivate carries any client code in other words having or not client...Leave a comment:
No activity results to display
Leave a comment: