Search results for query: *

Hello. I am trying to do a count and a vlookup at the same time in Excel. I have a worksheet (info): ID Date Server Leader 1 1/8/2010 EG Leader 3 1/8/2010 EG Leader 1 1/9/2010 GoM Leader 1 1/10/2010 GoM Leader 2 1/11/2010 EG Leader 4 1/12/2010 EG There is another worksheet...

Hello. I have a sharepoint list where I have created a column called 'Expiration Date'. I created a calculated Date column (Calculated based on other columns) that takes Expiration Date minus 30 days called Renewal Date. So if Expiration date is 2/1/2013, the Renewal Date will have 1/1/2013...

I have been working with a database for quite a while, updating forms, queries, tables and reports. This was a Access 2000 database that I opened and edited in Access 2007. It's been working great so far, but today I hit 'Design' on one of my forms and it gives me a Microsoft Visual Basic...

There is a table on the Oracle server that I link to using ODBC, OrderDetails, and another table in my Access Database that I'm using in a query together, Order. i've built this as a Query and as a recordset in my VBA code and it should return different 37 rows but it returns 37 rows that look...

Is there a way to set the Label Type in the OI file. a <labeltype> tag or something? We create many different labels and it would be nice if the physical item already knew its own label type so the user doesn't have to always select from a list. thanks!

I have created a new Physical item, called 'Video' which is not a container. The nickname (media type) is 12345 What is the correct syntax for this type of object? <node type="physicalitem" action="create"> ... <mediatype>12345</mediatype> </node> does not work.

Hello. I have a form for data entry. When a user hits 'new' but then decides to close the form before any data entry is done, I get the error "Index or Primary key cannot contain a null value". There is one value in the form that is automatically populated in the form_current function. Which...

Hello. I'm sure there is a simple solution but I'm out of ideas. I have a form which feeds from a ODBD-linked table (oracle 920 driver). One of the fields is a memo-type 'Comments' field where the user can enter whatever they wish. I want to add a 'timestamp' like Now() to the end of it when...

Hi. I have a simple form which contains a listbox and a textbox. the object of this form is to populate the listbox from data entered in the textbox. The data is barcodes that are scanned by a barcode scanner into the textbox. The problem is that after a barcode is scanned/entered, my code...

Hello. In my Access form, I'm using an ADO connection that I disconnect after I grab the data. The form allows you to filter data. In the filter code, I make a ODBC call again to grab the filtered recordset. On two of the dropdowns, the process status is 'sleeping' once it's done getting the...

Hello. In my Access form, I'm using an ADO connection that I disconnect after I grab the data. The form allows you to filter data. In the filter code, I make a ODBC call again to grab the filtered recordset. On two of the dropdowns, the process status is 'sleeping' once it's done getting the...

I need help executing a stored procedure from an Access form. The stored procedure is already declared in the SQL Server as: CREATE PROCEDURE [spSK_Delete] @recToDelete int AS delete from [logs] where logid = @recToDelete GO There is a button on my form called 'delete_Log' and the code...

Hello. In my Access form, I'm using an ADO connection that I disconnect after I grab the data. The form allows you to filter data. In the filter code, I make a ODBC call again to grab the filtered recordset. On two of the dropdowns, the process status is 'sleeping' once it's done getting the...

I have a query that I use to open a form which is bound by an ADO recordset. I can't get the date range to work. Here's the syntax: sqlstring = SELECT [Folders].* FROM [Folders] WHERE [DateEntered] between #" & dateFrom.value & "# and #" & dateTo.value & "#" It keeps giving me a syntax...

Hello. I have an MS Access Database that contains linked tables from a SQL Server ODBC connection. 16 users have a copy of this database on their machines. 1. When the first form is loaded, a query runs (select * from Userlist where username = login). After I get the username, I close the...

Hello. I'm using an MS Access frontend that looks at a SQL Server database. We have multiple users hitting this database through Citrix. There are two tables, Folders and Documents. The query in question is: SELECT Documents.*, Folders.Shelf FROM Folders INNER JOIN Documents ON Folders.ID...

Hello. I'm trying to write a SQL statement to be used in VBA that will search for a keyword and make sure there are no alphanumeric characters immediately following the keyword. For example: "Business Planning Forms" -> should not be a result "Draft Plan Sheet" -> should be a result "Dock...

Hello. I have a table containing the following: Table 1 ------------- ID Title ------------- 1 Desk Procedures 2 Light Procedure, lamps 3 Bottom Procedures, Fixtures I'm trying to do a query that uses a keyword entered by a user to do an exact match search. My query looks...

Hello. I need to write a SQL statement that will search an entire table's contents by one keyword. For example I have TABLE1: ID Name City Job Employer Qualifications I have a form where the user enters a keyword. I want to check if any of the listed fields above contain that keyword for a...

Hello. I have a form. It has a number of fields in it all bound to a table. I have placed an 'Apply Filter' button it, so depending on which field the cursor is at, it'll filter the dataset by that value. Say the form starts out displaying 100 records and I click on the 'Apply Filter' button...