Search results for query: *

I have a class with many fields in it. I renamed all of the fields using the 'edit properties' for each field. It's a derived table. Now I need to add a new field and can't see a way to add that field to the class. I don't want to drag the whole class over again because I'll need to rename...

The below code opened a form and displayed the next sequential number on the form. The form is based on a table with an identity seed. If bolTest Then DoCmd.OpenForm "frmVoucher", acNormal, , , acFormAdd, acWindowNormal It worked in Windows XP, but is not displaying the next id in...

If there is no location in the Records table that matches a location in Records_Locations, how do I make a message display to indicate that? I though below would work, but obviously I'm off. SELECT DISTINCT Records_Locations.Location_Code, Records.opendate, Records.tkloc, CASE...

I'm upsizing this access db to SQL and migrating the site code to work with it. do you know of a way to convert queries to stored procedures automatically?

I'm upsizing this access db to SQL and migrating the site code to work with it. do you know of a way to convert queries to stored procedures automatically?

I'm upsizing this access db to SQL and migrating the site code to work with it. do you know of a way to convert queries to stored procedures automatically?

Anyone have experience using Fuzzy Lookup in SQL Server 2005 Integration Services? Is there a standard to use to return reasonable matches? I'm wading through 250,000 rows, the great majority of which are too 'fuzzy'. I've got a lot of partial word matches, of, inc., and, the... What about...

I want to learn to program using Java. I did some online tutorials just writing code in Notepad. Am also reading a book. I'm trying to get my home computer set up and am having a hard time even knowing what to download. There's so much information that it's overwhelming. I can't even tell...

I'm populating a database field and text box on an Access form with a url address. I can cut and paste it into the address line in the browser and it works. But double-clicking on it in the Access form doesn't. Should that work? Thanks.

I've put STOP on the On Click event of a command button in order to step through the code. When I click on the button, I'm not stepping into the code. I haven't worked with Access 2007. Is something different? Thanks.

If I have spreadsheet with data: FirstName Middle Name Last Name Mary Anne Smith John J. Brown is there a way to export it to text as FirstName Mary MiddleName Anne LastName Smith FirstName John MiddleName Jay LastName Brown Thanks.

Maybe a dumb question: I would like to output data one field per row: Instead of Select Last, First, Middle from Names and returning Smith Mary Anne I need Smith Mary Anne Possible?

select old_case, old_case + SUBSTRING(reference_text, 5, LEN(reference_text))+ '0' AS 'Matter' , reference_text FROM... is returning old_case Matter reference_text F1234- F1234-0147 0 207-0147 instead of the desired old_case Matter reference_text F1234-...

Can I strip the left four characters from a variable that I'm setting from a combo box? For example: Dim Resolution as String Resolution = Me.cboResolution However, I always want to strip the first four characters from Me.cboResolution Thanks.

I want to select value 'name' from fieldname instead of value '1) name'. Can someone point me in the right direction? Thanks.

Is there a way in SQL to return instances of a field horizontally? For instance: SELECT id, index FROM table WHERE id = 'CC093509' returns: id index CC093509 103773 CC093509 103774 CC093509 103775 CC093509 103776 CC093509...

I'm outputting a file to .txt for use by a label software package, which prints labels. I'm using the below code, which worked until we came across some data that wasn't consistent in length. (I'm creating equal distances between each piece of data). Is there a way to account for data of...

I think this is a dumb question, but I'm stuck. I need to select part of the value in a field. I need to start at position 1 and only select to position 50. My attempt, which is wrong: SELECT left(fieldname,1,50) as newfield FROM table Thanks.

I have data values = 'D5000-5'; sometimes D5000-05. I need to update them to be zero filled on the right side of the dash, so that I always have five digits on the right side of the dash, e.g., D5000-00005. Can I do that in a right function?

Can I search for specifics within a string and parse out the data? For example, where, in the first 12 positions of a string, this appears - ###.###.####, I need to parse out ###, ### and ####. Thanks.