Recent content by kellielewis2872

Thank you so much Cronk. That fixed my issue and I found and fixed the other issue you brought to my attention.

Cronk, The form with the issue is frmCalendar. Thank you for any assistance you can give me.

Thank you for responding pr2-eugin. What I am trying to do is make a calendar form. It has text boxes named text0 to text 41 and list boxes name list0 to list41. The text boxes hold the days of the month and the list boxes will hold the information of the things scheduled for that day. I...

Can someone help me with my Runtime Error 3075? I have attached a copy of my database. I am trying to make a calendar form with the list boxes having two columns. It works fine with the strFieldID and strFieldName but when I try adding the strDone I run into the error. Thanks in advance for...

I have a database with a calendar form that keeps up with a schedule of maintenance on units. I would like for the item in the calendar to show up a different color when I click that it is completed in the frmPMSchedule. I have uploaded the file so you can see what I am working with. If...

I got it to work. I just took out the = sign and it worked.

Thank you for your response. It now accepts the Like part but still says syntax error missing operator.

I am having trouble with the correct syntax in the line that is using the Like statement. Here is the complete function. If someone could help me I would greatly appreciate it. Function BuildSQLString(sSQL As String) As Boolean Dim sSELECT As String Dim sFROM As String Dim sWHERE As String...

I am working on a project working with valve recession readings. I have a table that I am inputting the valve readings in. I have another table that has the original valve readings which I need to use to calculate the total recession of the valves and store that value in another table. 1. I...