Search results for query: *

Hello, I am stumped on this issue. 1. I tried to export an Access table to SharePoint. The Table had 27,000 records and 67 fields. The export fails with a MS Access 3981 Bulk update error 2. I then emptied the table and was able to export and link it to SharePoint. I then ran an append query...

Hello, I am running the below code and getting lock violations even though I am closing all forms prior to the update statement. When I grab the code from the Immediate window and run it as a Query I do not get the lock violations. Not understanding the difference. Dim strSQL As String Dim...

Hi, I am trying to use "Set" to assign a form control but a part of the control name is a counter. I would like to use the second line of code where "cnt" is the counter in order to get the first line. Thanks for any help Set Planned_Datet = Forms!frm_Review_Plan1!Planned_Date1 Set...

Hello, I have four radio buttons on a form that allows a user to select any combination of the 4. I have an unbound field "MREALL" that is holding the values of the four radio buttons. I am then trying to filter a query depending on the combination of radio buttons selected by the user. I am...

Hello All, I have a report which is based on a query.The query runs fine on its own. I have a form which builds a filter for the report. When I attempt to apply the filter to the report I get the message "The specified field '[REVIEW_TABLE]![REVIEW_ID]' could refer to more than one table...

Hello all, I have a main form with buttons that when clicked open various subforms in datasheet view. I would like my subforms to open right below my main form and at the same size. The problem I am having is that I have a multi-user database and users have varying screen resolutions...

Hi all I have two forms with the same subform. On the subform I have a button that when clicked opens another form using the filter below. I owuld like to create the filter so that both main forms can use the same filter. strFilter = "[STATUS_ID] = " &...

I have a database that keeps track of cases assigned to my department. Each case may have a dollar amount associated with it. There are three units within my department and cases are assigned to each one. I have created a 12 month dashboard report that allows the user to specify the month at...

Hello all I have a form that allows a user to select criteria which is used to construct a where clause. The where clause is then used to filter a subform which shows in the main form's footer. The criteria on the search form includes fields that are on the many side of a number of...

Hi, I have a form that allows a user to select a combination of criteria to print any one of a variety of reports. I then create a Where clause using VB based on the selection. The format of each report is different, but the Where clause that is built in VB is the same for all reports. I am new...

Hi, I have a form that allows a user to select criteria on which to build a Where clause that filters a report. A number of the criteria boxes are list boxes that allow multiple selections. MY problem is that some of the criteria on which I will like to filter is contained in sub-reports...

strSQL = "INSERT INTO CASE_CONTACT1 (CASE_ID, CONTACT_ID, DATE_ADDED) VALUES (" & Me.CASE_ID & "," & Me.CONTACT_ID & "," & Format(strDate, "yyyy-mm-dd") & ")" I am trying to get today's date into the Date_added field. Using the above I get 6/8/1905. Using below I get 12/30/1899. strSQL =...

Hi all I am trying to include a subform on my main form but the two forms a linked via an internediary table. The main table contains cases that we are working on while the sub-form contains contacts associated with the cases. I have a many to many relationsip between the two forms since any...

Hello Following is code I have that filters a report based on a field on a subreport. The code seems to work because it does not ask for the parameter, but it is not finding any values. For Each varItem In Me!searchownercontributor.ItemsSelected strFilter6 = strFilter6 & "Reports![Report...

I am working with an application that has a backend database and a front end web GUI. It is used for Timesheet capture. I have created an access database that links to all the necessary tables in the application. My issue is, users are allowed to unsubmit a timesheet via the web interface...

Hi I have a report that displays an identified issue on each page. There is a sub-report that shows all individuals who have been associated with that issue. So there is a 1 to many relationship between the main and sub-report. I have written some code that allows me to filter the main report...

Private Sub Command88_Click() On Error GoTo Err_Command88_Click Dim stDocName As String Dim stLinkCriteria As String Dim strFilter As String Dim strFilter1 As String Dim strFilter2 As String Dim strFilter3 As String Dim strFilter4 As String Dim strFilter5 As String Dim strFilter6 As...

For Each varItem In Me!searchownercontributor.ItemsSelected strFilter6 = strFilter6 & "Reports![Query - Contributors2 subreport2]![Contributors] = " & _ "'" & Me![searchownercontributor].ItemData(varItem) & "' OR " Next ' the next bit of code will subtract out the last "OR" If...

If Me![searchstartreviseddate] Is Null And Me![searchendreviseddate] Is Null Then strFilter10 = "[Latest_Date] Like '*' OR [Latest_Date] Is Null" Else If Me![searchstartreviseddate] Is Null Then strFilter10 = "[Latest_Date] <= #" & Me![searchendreviseddate] & "#" Else If...

Hi All I have a field defined as Date/Time and am trying to do a wildcard search. The "*" is not working. I am not sure what else can be used. Any advice?