Recent content by craigorama

I created this extremely long query that still needs some more lines added but works so far. It will grow because I have to do a large amount of where statements for InfoType and Gear fields as well. SELECT POLYGON_ID, "Halibut" AS Species,"CO" AS Interviewer, PARTICIPANT_ID, GEAR FROM...

Hi duane, I tried out your statement and it works great and solves one of my issues - that of how to get yes/no fields into a text field. However I am having higher level problems. I am a little rusty on SQL so bear with me. I need to get information from certain fields in my Fishery table...

Yes if there is more than 1 value that is true then i would like to create more than one record in the new table. I still have to figure out a way to copy the values from the rest of the record onto the next row. just a quick thanks duane, i will try this out later today.

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...

I also get this msg while trying to connect. I'm unsure of what settings to change to make this stop.

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, Thanks for all your responses! fneily, I tried to search but I guess I wasnt using the right terms because I couldn't really find something that answered my question. I'm still pretty new to this so odds are the answers were there but I just couldnt understand them. Plus I was...

Alex, I'm pretty new to this but i'm not sure if that applies to my situation. The article you linked to discusses how to reset an autonumber field. I just want to create a new field that starts at '572' and counts up from there. One of my initial problems was that i already had one...

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...

thanks! the next task is to update a field in a table with an incremental number starting at the value. where value = rs!location_no. ie if value is 548 i need the first record of Location_Number field to be 549 and +1 to each row. is there a way to do this with an sql update stmt? or is it...

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...

merci PHV.

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...

Ahh, I see now. Thanks very much. All is fixed now and I am parsing the data in the insert query. -cjo

Hey Alex, That is the answer, Thanks! I formatted the loc_year field as an integer instead of date. The reason i need to split them is because I need to (eventually) insert the data from this table into an existing table that has fields for loc_year, loc_day, and loc_month. O f course, all...