Search results for query: *

thank you for your reply.. I used the following in an append query to convert my raw imported data in text format to date format in the destination table: DateSerial(Mid([DateField],5,4),Left([DateField],2),Mid([DateField],3,2)) & " " &...

Howdy folks... How does one convert a text field in a table to a date field? e.g., my date field has 06012007 123120 stored as text, but I'd like to convert the field type into a Date/Time field. I know its easy, but I can't figure it out... must be late.

Thanks Duane! A co-worker said I needed a weekend to refresh my mind to figure out my problem... I thought about splitting the query up into pieces this morning, and then you confirmed it. Works great, thanks again! Mark

Hi All, I have read the previous posts on creating passthrough querys with parameters, but for I just can't seem to make it work for me. Here's what I want to do... I have a form where you select from a list box that queries from a table. When I click a button on the form, I want to use the...

Hello, I have a MS Access Form that has a date text box which is used in a number of queries for a report. The criteria used in the queries was similar to this: Select [Date] From tblblah where [Date] Between [Forms]![Process]![txtDate] And [Forms]![Process]![txtDate]-13 The txtDate variable...

Thank you for your reply.... I'm still struggling. :( I checked that the environment variable exists. I even changed it on the working computer to 'bob'. I was surprised to see that when I re-opened the db, my username was displayed instead of 'bob'. I checked for missing references, but...

I've tried all the fixes I could find here and on MS, but I still get this error. I checked that the environment variable "Username" is set. I have two computers, both running Windows 2000 and Access 2000. It works on one, but not the other... I have =Environ("Username") in a forms and...

Thank you, PH! I do have import specs... You pointed me in the right direction for investigation though. It turns out the corresponding field setting in the specs was set at Long Integer instead of Double. Problem solved. Cheers, Mark

Hello, Could anyone help me figure out why I get Type Conversion Errors when importing? I am importing csv files into a table. The field in question is a number field set a Double in the target table. It appears that when the number in this field hits ten digits (e.g. 3,223,322,624) it...

FYI val("&H" & [hexnumber] & "&") forces positive numbers. Otherwise hex numbers begining with 8 thru F will return negative decimal numbers.

This will return negative values for hex numbers like: B44E. How do I force positive numbers? I tried using Val("&H0000" & [hexnumber]) after seeing on this converter that adding zero forces a positve number. http://www.eclectic-web.co.uk/awr/hex2dec.php?num=0B44E

Hi all, Can anyone recommend a good training course for Access. Online or on CD would be okay. If anyone is local to Bellevue, WA any classes I should sign up for? I'm already using Access, picking it up as I go. I also have help from a friend who knows Access inside and out. I just need...