Search results for query: *

Hi there, I have a large table (FISHERY) where there are a number of fields with boolean data types. I am trying to figure out how insert those values into one field in a new table's (GIS) field named species that is a text data type. Example would be if FISHERY.Halibut= true then GIS.Species...

A week ago i used my personal laptop at work. I had to map to a network drive. Since then I have disconnected that drive but ever since then the Broadband Connection wants to continuously connect. It interrupts my internet connection all the time. I've attached a screenshot of the error msg...

Hi again! I'm trying to create a field in a table that will increment by +1 each time. However the value of the first row has to be a number other than 1. I retrieve that value through the function Get_Location_No. Here is my code: Dim strSQL As String Dim tabName As String...

Hi everyone! I'm trying to assign the last value in a field (location_no) to a variable. I am using a recordset and trying to get the value of the last recordset. I can get the recordcount but dont know how to use that to get that value from the cell. which method/ property will return the...

I'm running a bunch of sql statements in the background when user clicks a btn. I'd rather not have 8 msg boxes automatically show up saying "you are about to update 427 rows" etc etc. Is there a way to programmatically turn them off? Apologies if this is in the wrong forum and the answer is...

I have a field [new_time] that displays full date and time like this: 15/05/2006 12:20:00 PM I'm trying to parse it up and insert it into new columns. I searched the forums here and found this thread: http://www.tek-tips.com/viewthread.cfm?qid=1257953 I've tried to incorporate the year...

In my table I have 2 columns with x,y points and I need to remove any rows where there are 'wacky points' (basically points that are obviously not in synch with the rest of the points in the table). I'm trying to construct an SQL query that calculates an average for each column and then removes...

Hi everyone. I'm trying to do something in vba that i know is easy in VB.NET. I'd like to find out the length of a variant (array) in vba. I'm loading a text file line by line into the array and then inserting it into a table. I have something like this: dim Line as Variant Line =...

Hi everyone! I'm create and update new date and time fields from an existing date and time fields. Basically converting from one time zone to another. I've tried to set up the new fields as ShortDate and ShortTime but when i update the fields both time and date display in each. I just want...