Search results

Hello, I am looking for some guidance on the following sql statement which I am using as a record source of a form. I am not sure if I can use the DLookup in this way. Some of the issue is the comma after the Dlookup. when I have the comma is indicating error "3141 the SELECT statement...

Hi, Any input will be greatly appreciated I have a form where I open another form using the Open Args. The form opens the correct record without any issue. I noticed that in the form that is open, there is a combo box that is displaying no value or blank value even thought the primary key...

hello all, I am looking for any thought regarding an unbound check box in a form that is not working. The box can not be check or uncheck. Any thought will be appreciate

Hi I am trying to bookmark the position on a recordset to later return to the same position and the bookmark codes is returning no record. I have not used this before but any help will be greatly appreciated. The problem is when stepping to RSBookmark = rs4.Bookmark the rsbookmark has been...

Hi all; I am having a hard time adding a zero to a calculated value to a group of fields on a table. I can not add this property under the table because I am deleting and creating the table often. I tried NZ and Format and I was not able to see default zero when there is not value. Any help...

I am looking for some guide from this great community. I am creating a filter form to run different reports based on the criteria selected on the form. The Where condition on the onclick event is working fine. The issue that I am having is when I call the runreport procedure, the value created...

Hello All. I am breaking my head trying to find the way of handling this null value on the following expression. when I add the companyid parameter will give me syntax error 3075 of missing operator and I ran out of options base on my limited knowledge of vba. The code breaks when I add : "...

I need some advice regarding this code that is erroring out on the not match statement. It is giving up error 3021 on the rs2.findfirst line and I can not figure out what is wrong. I am just trying fill value for each month. Like a crosstab report On Error GoTo ErrorHandle Set db =...

I have the following code which I am trying to pull out the quarter for the current date. I have a variable for the current date and it is storing the date correctly, the issue is when I got to the select case for the quarter today's date turns in 01/03/1900. Any guide will be greatly...

I will gladly apricate any help from this forum regarding this code. I am passing various value from one from to another. The first part of the SQL works fine by when I adding another value it does not work. I tried the value with a variable and still I get the mismatch. Private Sub...

I have the following code and it is giving me the missing operator error and I can not figure out how to fix it. Any help will be greatly appreciated. Option Compare Database Option Explicit Private Sub Form_Open(Cancel As Integer) Call taskschedule Me.AllowEdits = False Dim SQLDataSource As...

I not un expert on VBA and I am looking for some advice regarding this code. I have two recordset and I am trying to find a combine value. I am not sure if this concatenation is a good way to look for this value. I concatenate value from three columns and I am looking to make sure this value...

I would like some guidance on running a procedure or function base on schedule. Something like first day of the month or the 15 of the month

I am looking for some help from this community. I copy the following code to filter a list box and various combo boxes. I am having a hart time adding more code to the STRWhere statement. When I select items from the list box and also select an item from the combo box, the information is...

I have the following code where I am trying to copy the value of one table to another and for some reason that I can not figure out, the code is not working Option Compare Database Public Function taskschedule() Dim DB As Database Dim RS As Recordset Dim SQL As String Dim Descr As String...

Hi, Can someone please check this code to and give me some input to see why it is failing. I am filtering a form for entity and cocode and the codes is selecting the block for entity, benefits and cocode Private Sub btnfilterdata_Click() 'On Error GoTo Problem: Dim FilterData As String Dim...

Can someone please check this function and give me some advice regarding fixing this mismatch. Public Function MonthlyAmt(FLNo As Integer) As Currency Dim MthDate As Date Dim MonthNO As Integer Dim YearNo As Integer Dim MatchAMT As Currency Dim STCreteria As String Dim FMTest As Form Dim...

I need the help of one of you regarding this function. I am creating a form to pull value from employees for each month of the year and I want to create a function to pull those values from a table. the function is giving me a mismatch error and I can not figure out. Thanks in advance...

Hi As you can see I am new on this. I have a form with monthly data for various year and I want to create a combo box to filter the data by year. I have this event after update on the combo box but it is giving me an error and I do not know why to fix it. I create a query with every month but...

What could be the easy way to create a cross tab report for every month/year that I can change without using the default access option